Skip to main content
All CollectionsWhat's New
August 2024 Updates
August 2024 Updates

Unpivot all fields, Huge SQL queries, Concat with line breaks, Parquet files, Azure Synapse boost, Snowflake with OAuth

Updated over a week ago

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

Connectors Refresh

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

File:Snowflake Logo.svg - Wikimedia Commons

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.

Did this answer your question?