SQL Studio (v1.11)

Collate version 1.11 introduces SQL Studio, a powerful, permission-based query execution tool that lets your team run SQL queries directly against your data services without compromising security. In this demo, we'll walk you through setup, authentication options, and how SQL Studio integrates seamlessly with Ask Collate for intelligent, AI-powered query assistance.

What You'll Learn:
How to enable and configure SQL Studio with query runners on your database services
The difference between multiple authentication methods (Basic credentials, SSO, and OAuth) and why SQL Studio uses separate credentials from your ingestion agents
How to grant controlled, permission-based access to query execution so users only see data they're authorized to access

Demo Highlights:
Complete walkthrough of setting up query runners with Snowflake authentication, including username, private key, and passphrase configuration
Live query execution with automatic safety limits that prevent accidentally returning massive datasets
Integration with Ask Collate to generate and execute SQL queries using natural language; compute totals, analyze data, and get results instantly

Whether you're a data engineer setting up secure query access or a data analyst who needs self-service SQL capabilities, SQL Studio gives you the flexibility to execute queries safely within your governance framework.

Administrators can enable or disable query runners at any time without deleting connection profiles, making it simple to control access as your needs change.

Learn more about Collate: https://www.getcollate.io/
Try Collate's Managed OpenMetadata Service with Demo Data: https://sandbox.open-metadata.org/

#SQLStudio #DataGovernance #Collate #OpenMetadata #DataAccess #SelfServiceAnalytics #SnowflakeIntegration #DataSecurity #MetadataManagement #AskCollate