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:

Ready to speed up your data prep by letting your database do the heavy lifting? Let’s push it down—literally! With Savant’s new SQL Pushdown feature, you can now push filtering and summarizing tasks directly to your database before the data even touches Savant.

By using the 🔻 Pushdown Filter and 🎯 Pushdown Summarize tools, you offload the computational work to your database, making it a breeze to handle huge data volumes. Instead of processing everything within Savant, let your powerful databases like Azure Synapse, SQL Server, Snowflake, and Redshift crunch the numbers first. Chain them together for even more efficiency, and cut your time-to-analysis in half.

Say you're working with terabytes of sales data in Snowflake, and you want to filter down to just Q3 2023 sales before bringing the data into Savant. Simply use the Pushdown Filter tool to send that filter directly to Snowflake. Boom! The database handles the heavy lift, so you get only the relevant data without loading unnecessary gigabytes into Savant.

🙋‍♀️ Want in on the beta? Contact your Customer Success Manager for early access!

Ever wished you could send your data to Google Drive and have it automatically split into multiple workbooks and tabs? Now you can!

With Savant’s new Dynamic Workbooks feature, you can partition your output based on specific fields, and our Google Drive destination will handle the rest. Whether you need to split data by regions, products, or time periods, you can now create custom workbooks and tabs effortlessly.

📚 Imagine you're running a sales report for 10 regions, and each one needs its own tab in a workbook. Simply select the region field as your partition, and Savant will generate a Google Drive workbook with separate tabs for each region. Sharing with the team has never been this easy!

Stuck with flat files that aren’t in the default UTF-8 encoding? No worries. With Savant’s new encoding support, you can load files with any encoding under the sun. Just select the encoding you need when uploading your file, and let Savant handle the rest.

🛅 Say you’ve got a legacy CSV file in Latin-1 encoding. Instead of spending hours converting it manually, you can upload it straight to Savant, choose Latin-1 in the encoding options, and proceed with your analysis seamlessly. Voilà!

Whether you're working with Latin-1, ASCII, or something more obscure, we’ve got you covered. Flat files don’t always play by the rules, but now you’ve got the power to load them in any language—or encoding, to be precise!

The classic GREATEST() and LEAST() functions just leveled up. Now, in addition to numbers and text, you can use them to compare dates and datetimes across multiple columns. Need to figure out the most recent order date or the earliest project deadline? GREATEST() and LEAST() are here to help, making it effortless to find the date that matters most.

You have three columns—Order Date, Ship Date, and Delivery Date—but you need the latest of the three for your report. Just use GREATEST() to pull the most recent date for each row, saving yourself a headache and keeping things accurate.

Picking the best (or worst) date has never been easier. No more playing favorites—let GREATEST() and LEAST() do the deciding for you.