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:

We’ve supercharged the Dedupe tool! In addition to making your dataset unique, you can now create a separate output for the removed duplicate rows. This gives you a snapshot of potential data issues without tossing the baby out with the bathwater.

🛠️ It’s perfect for auditing data quality or troubleshooting why duplicates might be creeping into your system. And don’t forget, the Dedupe tool already lets you choose between deduping by Distinct Rows or applying Prioritization Rules for more control.

Why it matters:

Key benefits include:

Suffering from messy data? Give our new and improved Dedupe tool a try today!

Ever wonder how long that analysis took to run? Now you don’t have to! The Run History now displays the duration of each run, giving you an at-a-glance view of performance.

Keep track of how efficiently your analyses are running without digging through logs and doing mind-numbing datetime diff calcs in your head. Whether you're optimizing a massive dataset or just curious about your workflows, the Run Duration feature keeps you informed with precision.

For example, you’ve just optimized a workflow and want to know if it’s running faster. Simply check the Run History, where you'll see your latest runs clocked in at 15 minutes, 10 minutes, and—bam—your final optimized run at a swift 5 minutes!

Security-focused enterprises, this one’s for you! Analysts can now connect directly to Azure Synapse using Microsoft Entra ID / Azure Active Directory OAuth. It’s a simple way to keep your data connections secure and compliant with the highest standards.

OAuth ensures that only the right people are accessing the data they need, keeping sensitive information safe without sacrificing usability. Azure AD’s robust authentication keeps your enterprise data locked up tighter than Fort Knox, while still offering analysts the smooth, seamless access they need to do their jobs.

The same peace of mind for SQL Server users! You can now connect your Savant analyses to SQL Server databases using Microsoft Entra ID / Azure Active Directory OAuth. This is a game-changer for enterprises that prioritize security and want full control over data access.

Enterprises love OAuth for its token-based authentication, meaning passwords are a thing of the past. No more worrying about rogue credentials or outdated authentication methods—just fast, secure access that scales with your enterprise.

Say hello to your expanded Salesforce toolkit! The SFDC Connector now supports Entitlement, Pricebook, and PricebookEntries objects, giving you even more power to pull in crucial data for a complete customer view.

This means you can now bring entitlement tracking, pricing catalogs, and detailed pricing entries into your workflows—allowing for better insights into customer support, sales opportunities, and revenue management. It's never been easier to integrate these key Salesforce objects into your analyses and reporting.

Say you’re building a customer performance dashboard and want to include both entitlement data and product pricing information. With the newly supported SFDC objects, you can now pull Entitlement to track support coverage and PricebookEntries to display detailed product pricing in a single, cohesive report.

💪 We’ve leveled up the HASH() by adding support for SHA2.

Why does that matter? SHA2 is more secure than its predecessors and widely used across modern cryptographic applications. For those who care about data integrity and security, this upgrade ensures your hashed values are stronger than ever.

🎉 New Function Alert with Contains() – The Power of Precision in a Snap!

Ever wish you could just search for a snippet of text and instantly know if it’s in your data? Well, now you can! Introducing the new Contains(text, part) function in Savant.

The Contains function behaves just like the magic of SQL’s LIKE statement but is packed into an easy-to-use formula. This means you can find “needle” within “haystack” (or any string) effortlessly! Use it to:

👋 Wait, there’s more! We’ve also made the everyday life of analysts easier by introducing intuitive function aliases. No more head-scratching when you want to extract parts of text.

Now you can use MID(), LEFT_PART(), and RIGHT_PART() to take sections of text easily and naturally, with their former engineering-style names now a thing of the past.