We’re excited to announce the release of Coginiti 23.9! With a blend of data engineering and AI capabilities, this update focuses on streamlining your SQL workflow and query optimization. Use our new Explain Plan to pinpoint costly nodes and make immediate improvements. Try the new Anthropic Claude integration with our AI Assistant along with the new “Explain Error” auto-prompt which turns SQL troubleshooting into a stress-free task.
Optimize Redshift Queries with Explain Plan Visualization
Ever found yourself scratching your head, trying to figure out how to make a query run faster or cheaper? With our new Explain Plan Visualization now available for Amazon Redshift, you can immediately identify cost drivers, pinpoint optimization opportunities, and execute tweaks in real-time. Eliminate full table scans, optimize those pesky joins, and more!
AI-enabled optimization suggestions are coming soon, along with support for additional platforms.
AI Explain & Fix Errors: Quickly Understand & Resolve SQL Issues
Errors are a fact of life, but they don’t have to derail your day. Some errors are obvious; for the rest, you can now click the new “Explain Error” button beside any SQL error message and let our AI Assistant guide you through the underlying issue(s) and recommend fixes. Talk about a stress reducer!
Introducing Anthropic Claude to Coginiti AI Assistant Options
This release brings a powerful new option to Coginiti’s AI Assistant: Anthropic Claude AI. Claude comes with a far larger context window, making your AI Assistant sessions more relevant and effective. Claude’s extended memory is especially valuable for building and optimizing complex, multi-block queries through an iterative back-and-forth process.
You can now choose from OpenAI GPT-3.5, GPT-4, Claude, and Claude Instant to enhance your SQL workflow, with more model options to come.
Email Notifications for Scheduled Code Blocks
Stay on top of your data orchestration events, even when Coginiti isn’t opened. Team and Enterprise users now have the option to trigger an email notification to one or more addresses on success and/or failure of any scheduled event. This is in addition to in-app notifications which always show the status of such events.
Automated Data Quality Testing with CoginitiScript
Why manually trigger your data quality tests when you can schedule them? Team and Enterprise users can now use Coginiti’s built-in scheduling functionality to automate CoginitiScript test block execution on a recurring basis, either individually or for all tests in a package. Receive real-time status updates via in-app notification or email.
Learn more about the CoginitiScript.
Thank you for being a part of the Coginiti journey. Let’s keep revolutionizing data analytics together. If you’re not a Coginiti user yet, now’s the perfect time to start your trial!