Coginiti menu Coginiti menu

Coginiti 23.9 Release: Redshift Explain Plan Visualization, AI-Powered Error Resolution, Anthropic Claude AI, and More!

Chris Crompton
October 2, 2023

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!

Redshift explain plan visualization

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!

AI Assistant Explains SQL Error

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.

Anthropic Claude AI integration with SQL IDE

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. Premium 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.

SQL event notification email

Automated Data Quality Testing with CoginitiScript

Why manually trigger your data quality tests when you can schedule them? Premium 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!