Skip to main content

AI Studio

Overview​

AI Studio is your intelligent workspace for data exploration and analysis — combining SQL execution, AI-powered chat, and multi-format result visualization. Write queries, generate SQL from natural language, and explore your data — all within a unified, worksheet-based interface.

Key Components​

AI Studio main interface

1. Catalog Rail (Sources Sidebar)​

The left sidebar displays all your connected datasources in a browsable tree. Expand any datasource to explore its databases, schemas, and tables. Use the search box at the top to filter sources quickly.

The sidebar has three bottom tabs:

  • Sources — Browse all connected datasources
  • Sheets — View and switch between your worksheets
  • History — See your recent query history

2. Worksheet Tabs​

Organize your work across multiple worksheets, each with a specific mode. Every tab shows a mode badge (SQL, AI, etc.) and the worksheet name. Click the + button to create a new worksheet.

Available worksheet modes:

  • SQL — Write and execute SQL queries with syntax highlighting
  • AI Chat — Ask questions in natural language and get AI-generated answers
  • Python — Notebook-grade editor with chart and dataframe output (coming soon)
  • Script — Batch/shell commands on a worker (coming soon)
  • Pipeline — Chain SQL, Python, scripts, and AI into ordered steps (coming soon)

3. SQL Editor Panel​

Write and edit SQL queries with syntax highlighting. The editor provides three view modes:

  • Sql — Standard SQL editing view
  • Rendered — Formatted/rendered view of your query
  • Conversation — View the AI conversation history for this worksheet

4. Worksheet Header​

The header bar shows:

  • AI STUDIO label with the current worksheet name
  • Save status indicator (saved, saving, etc.)
  • Worksheet menu (rename, star, save as new, share, delete via the ... menu)
  • AI Status Pill — Shows whether an AI provider is configured (green = configured, orange = not configured)
  • Share button
  • Notifications bell

5. Result Panel​

The right-side panel displays query output after execution. Before running a query, it shows "Run the worksheet to see output." After execution, results appear in a structured table with options to switch between different visualization types.

6. Query Controls​

  • Run button to execute the current query
  • Add to dashboard option to pin results to a dashboard
  • Source selection prompt — If no source is selected, you'll see "Select a source to run SQL"

Getting Started​

Step 1: Access AI Studio​

Navigate to AI Studio from the DataDios left navigation menu under Data Source.

AI Studio navigation

Step 2: Browse and Select a Datasource​

In the Catalog Rail (left sidebar), browse your connected datasources. Expand a datasource to see its databases, schemas, and tables. Select a source to set it as context for your worksheet.

Catalog Rail

Step 3: Create a Worksheet​

Click the + button in the tab bar to open the New Worksheet picker. Choose your preferred mode:

  • SQL — For writing queries directly
  • AI Chat — For natural language interaction

New Worksheet picker

Step 4: Start Working​

  • SQL worksheet: Write your query in the editor and click Run
  • AI Chat worksheet: Type a question in natural language and get AI-generated SQL or answers

Workflow Examples​

Example 1: Natural Language to Insight​

  1. Create an AI Chat worksheet using the + button
  2. Ask: "Show me top 10 customers by revenue"
  3. Review the generated SQL
  4. Insert into a SQL worksheet and execute
  5. Analyze results in the Result panel

Example 2: Schema Exploration​

  1. Expand a datasource in the Catalog Rail to browse tables
  2. Open an AI Chat worksheet and ask: "What tables contain customer information?"
  3. Receive schema overview
  4. Query specific tables based on AI guidance

Example 3: Query Optimization​

  1. Write your initial query in a SQL worksheet
  2. Switch to an AI Chat worksheet and ask: "How can I optimize this query?"
  3. Review AI suggestions
  4. Apply optimizations and compare execution time

Result Viewer​

The Result Panel displays query results with multiple visualization options. After running a query, use the chart-type switcher to change how results are displayed.

View Options​

The chart-type switcher is a toolbar row of clickable type buttons: Table, Pie, Bars, Line, Area, Columns, Timeseries, Tablechart, Stacked. For applicable chart types (Bars, Line, Area, Columns, Timeseries, Stacked), axis and series selectors appear below the toolbar to let you configure which columns to plot.

You can also export results using the Export CSV (available in table view) and Export PDF buttons.

Result viewer

Table Display​

  • View results in a structured table format for clear and organized data presentation.
Table display

Pie Chart Visualization​

  • Visualize a breakdown of key identifiers for each row.
  • Each pie chart corresponds to a single row, showing the relative contribution of selected numeric data fields.

Only numeric columns can be selected for key comparison.

Pie chart visualization

Bar Chart Visualization​

  • Visualize data trends across rows.
  • Each bar represents a single row corresponding to selected numeric columns for easy comparison.
Bar chart visualization

Line Chart Visualization​

  • Visualize data trends across rows.
  • Each line represents a single column.

Only numeric columns can be selected for key comparison.

Line chart visualization

Area Chart Visualization​

  • Visualize cumulative data trends across rows.
  • Each area represents a single column, filled beneath the line to show volume.
Area chart visualization

Columns Chart Visualization​

  • Visualize data distribution across rows with vertical column bars.
  • Each column bar represents a single row for one-to-one column comparison.
Columns chart visualization

Time Series Chart Visualization​

  • Visualize data trends over time.
  • Plots a selected numeric column against a time-based x-axis for temporal analysis.
Time series chart visualization

Table Chart View​

  • View results in a structured table format with enhanced visualization options.
Table chart view

Stacked Columns Chart Visualization​

  • Visualize data distribution across rows with stacked columns.
  • Each stacked column bar represents a single row, allowing comparison of multiple numeric columns in a stacked format.
Stacked columns chart visualization

Managing Worksheets​

Worksheet Menu​

Click the ... menu next to the worksheet name in the header to access:

  • Rename — Change the worksheet name
  • Star — Bookmark important worksheets for quick access
  • Save as new — Create a copy of the current worksheet
  • Share — Share the worksheet
  • Delete worksheet — Remove the worksheet

Save Status​

Your work is saved automatically. The save indicator next to the worksheet name shows the current status:

  • saved — All changes are persisted
  • saving — Changes are being saved
  • error — Save failed (retry available)

Best Practices​

Query Writing​

  • Start Simple: Begin with basic queries and add complexity gradually
  • Select a Source First: Always select a datasource from the Catalog Rail before running queries
  • Use the AI: Create an AI Chat worksheet for syntax help and optimization
  • Organize with Worksheets: Use separate worksheets for different tasks — name them descriptively

AI Assistant Usage​

  • Be Specific: Provide clear, detailed questions for better results
  • Review Before Executing: Always validate AI-generated SQL before running
  • Learn Patterns: Use the AI Chat worksheet to understand new SQL techniques
  • Explore Schema: Browse the Catalog Rail or ask AI about table structures

Performance Optimization​

  • Monitor Execution Time: Check the row count and duration in the Result panel toolbar
  • Use AI Suggestions: Request optimization recommendations via AI Chat
  • Add to Dashboard: Pin frequently-used query results to a dashboard for quick access

Next Steps​