Savants are always improving and their tools should too. That's why we're constantly releasing new features and enhancements every week. Here are the highlights from this month:
Unpivot Everything
Ever had a wide table and you want to unpivot EVERYTHING? With absolutely no fields kept unpivoted?
We've just added an easy button for this to the Unpivot tool. Simply use the Keep Fields option and select no fields...
And π₯ Boom! You've unpivoted everything. It's now that simple.
Run HUGE SQL Queries
You've always been able to use Savant to run custom SQL queries against your databases and business apps.
Now we're happy to announce we've tripled the SQL query size with support for 30,000 character queries.
Enjoy the power up!
Concat Super Powers with Line Breaks
Savant's CONCAT aggregator has always been a lifesaver for analysts needing a quick and easy way to combine multiple values into a single list value.
Say you have a field with Employee Names and you want to aggregate that field into a single list of Employees Names.
You could use the Transform, Summarize and Time Series tools with the CONCAT aggregator to create that Employees Names list in just two clicks. You could even specify the delimiter - like comma, space, pipe, etc - to format the list exactly how you need it.
Well, now you can also use a line break as your delimiter! Simply enter \n
in the Delimiter setting and create a line separate list, all in the same cell.Refreshing the Way You Connect
We're pleased to announce the refresh of our Connectors page, designed with you in mind. With over 250 connectors now β and counting β we've reorganized them into intuitive categories that make finding the right connection easier and faster than ever.
π Easier Navigation: Quickly find connectors in the category that suits your needs, including:
Files
Databases
Sales
Marketing
Supply Chain
Finance & HR
Communication
Engineering & IT
Analytics
π Simplified Search: Our new connector family groups make it a breeze to locate specific tools, like:
Microsoft
Azure
SAP
Oracle
Salesforce
And more!
π Expanded Reach: With 268 connectors, our platform connects to virtually every tool you need.
Parquet Files for Faster Read and Write
Savant now supports reading and writing Parquet files with systems like S3, Google Cloud Storage, and Azure Blob Storage.
Parquetβs efficient columnar storage format allows Savant to deliver faster file reading and writing, especially for handling large datasets.
With this enhancement, your big data workflows just got a major boost in performance!
Azure Synapse Performance Boost
We're thrilled to announce that we've boosted the write performance of our Azure Synapse connector by nearly 20x, enhancing larger and faster analytics workflows with Azure cloud.
This significant improvement allows you to handle massive datasets effortlessly, dramatically speeding up your data processing time.
Experience smoother, more efficient analytics automation, and elevate your projects to the next level!
Snowflake OAuth
We've made another great addition to our popular Snowflake connector for read and write.
Now you can connect to your Snowflake database using your company's OAuth for more security control and governance.