AI Studio
AI Studio is a tool that enables users to create database-specific SQL queries from text queries using any LLM model in their collection.
LLM models, such as the OpenAI GPT model, can be stored in the Datasource section just like any other datasource. Objects related to each model can be viewed in this section. Any LLM model from this collection can be used on the go within AI Studio.
How It Works
1. AI chat session
Users can switch to text-based queries in the editor to start an AI chat session.
2. Querying
A natural language text-based query can be fed to the AI to generate a well-formed SQL query.
3. Query execution
The generated SQL query can be edited and executed to perform the desired operation.
4. Results
After executing the query, results are displayed in the bottom section with multi-graphical representation capabilities.
Benefits
Customization and Flexibility
Provides the flexibility to utilize the required LLM model without concerns about data privacy and cost. Additionally, users can switch between datasources on the go without losing the query and chat session.
Datasource specific
Queries are highly specific to the selected datasource, minimizing the need for syntax modifications.
Metadata inclusion
Queries are more precise as the LLM model utilizes the metadata from the datasource.
Follow up
Users can ask follow-up questions without needing to provide context from previous queries.
Features
Customization and Flexibility
Users can select any supported datasource and LLM model from their collection.
Datasource specific
AI-generated queries are tailored for the specific datasource selected.
Metadata inclusion
Metadata from the datasource is used to generate more accurate queries.
Follow up
Follow-up questions are supported in chat sessions.
FAQs
What is AI Studio in the DataDios Platform?
AI Studio is a DataDios tool that turns natural language text queries into database-specific SQL queries using any LLM model in your collection. It lets users chat with their data, generate SQL, run it, and view results in a graphical interface without needing to write complex SQL by hand.
How does AI Studio work?
AI Studio starts with an AI chat session, where users type a text-based question or instruction. The AI then generates a well-formed SQL query, which can be reviewed, edited if needed, and executed. The query results appear in the bottom section of the interface with multiple graphical representations.
How are LLM models used inside AI Studio?
LLM models, such as OpenAI GPT or other supported models, are stored in the Datasource section just like any other datasource. Each model has related objects that can be viewed, and any model from this collection can be selected and used on the fly within AI Studio to power text-to-SQL generation.
Can AI Studio work with multiple datasources?
Yes. AI Studio allows users to select any supported datasource and switch between datasources on the go. The chat session and queries remain intact, so users can explore different datasources without losing context or starting over.
How does AI Studio generate datasource-specific SQL queries?
AI Studio tailors AI-generated SQL to the currently selected datasource. It uses the schema and metadata for that datasource so that queries match the correct tables, columns, and syntax, minimizing the need for manual adjustments.
How does metadata improve query accuracy in AI Studio?
AI Studio uses metadata from the selected datasource such as table names, column names, and relationships to guide the LLM. This metadata inclusion makes the generated queries more precise and reduces errors caused by guessing or incomplete context.
What are the benefits of using AI Studio for data teams?
AI Studio gives data teams a flexible way to query databases using plain language while still producing fully editable SQL. It reduces the time spent writing and debugging queries, keeps queries aligned with datasource metadata, and provides multi-graphical result views that are easy to interpret and share.
How does AI Studio handle data privacy and cost concerns?
AI Studio lets organizations choose which LLM models to use and how they are configured. This flexibility means teams can select models and deployment options that match their data privacy requirements and cost constraints, while still benefiting from text-to-SQL capabilities.
Can users ask follow-up questions in AI Studio?
Yes. AI Studio supports follow-up questions within the same chat session. Users do not need to re-enter context from previous queries; the LLM remembers the conversation and can refine or extend queries based on earlier questions and results.
What kind of results does AI Studio display after executing a query?
After the generated SQL is executed, AI Studio shows the results in the bottom section of the interface. It supports multiple graphical representations, so users can quickly visualize query outputs and understand patterns or trends in the data.
Who should use AI Studio?
AI Studio is ideal for analysts, data scientists, engineers, and business users who want to explore data without constantly writing SQL. It is especially useful in environments with multiple datasources and evolving schemas, where metadata-aware query generation saves significant time.
How does AI Studio fit into the overall DataDios Platform?
AI Studio is part of the cloud-first DataDios Platform, which centralizes data, metadata, performance metrics, and governance information. While other modules help monitor, validate, and track changes, AI Studio focuses on making it easy to ask questions in natural language and turn those questions into actionable SQL queries and visual results.