Skip to main content

AI Studio

Overview​

AI Studio is your intelligent workspace for data exploration and analysis—combining SQL execution with GenAI-powered assistance. Write queries, get AI-generated suggestions, and troubleshoot in real-time, all within a unified interface.

Key Components​

Source

1. Datasource Selector​

Choose from pre-configured data sources using the dropdown menu at the top of the interface.

2. Multi-Tab Workspace​

Manage multiple queries in separate tabs (script-1, script-2, etc.) to organize your work across different tasks.

3. SQL Editor Panel​

Write and edit SQL queries with syntax highlighting and full support for DML/DDL operations.

4. AI Assistant (Chat Panel)​

Ask questions in natural language and receive SQL suggestions, schema information, and optimization help.

5. Result Viewer​

The Result Viewer allows users to view query results in multiple formats. It provides features such as pagination, execution metrics, and export capabilities for enhanced usability and analysis.

6. Query Controls​

Execute queries, configure row limits, and access scheduling options.

Getting Started​

Step 1: Access AI Studio​

Navigate to AI Studio from the DataDios main menu.

Source

Step 2: Select a Datasource​

Use the dropdown menu to choose your target database.

Source

Step 3: Choose Your Approach​

  • Write SQL directly in the editor for full control
  • Ask the AI assistant to generate queries from natural language
  • Combine both methods for optimal productivity

Workflow Examples​

Example 1: Natural Language to Insight​

  1. Ask AI: "Show me top 10 customers by revenue"
  2. Review generated SQL
  3. Insert into editor and execute
  4. Analyze results

Example 2: Schema Exploration​

  1. Ask AI: "What tables contain customer information?"
  2. Receive schema overview
  3. Query specific tables based on AI guidance

Example 3: Query Optimization​

  1. Write initial query
  2. Ask AI: "How can I optimize this query?"
  3. Review AI suggestions
  4. Apply optimizations and compare execution time

Result Viewer​

The Result Viewer offers multiple visualization options to display query results effectively.
You can switch between different visualization types using the configuration icon in the Output panel.

⚙️ Configuration Options​

Choose the format and behavior that best suit your analysis needs. The available configuration options include:

  • Visualization Type — Select how results are displayed (table, chart, etc.).
  • Hide Table Header — Hides the search option and column controls.
  • Hide Table Footer — Hides pagination and displays all data at once.
  • Hide Table Search Input — Removes the search input box.
  • Hide Table Select Columns — Removes the column selection dropdown.

Configuration Options

💡 Use these options to simplify or customize the Result Viewer interface based on your data exploration needs.

Visualization Type​

🧾 Table Display​

  • View results in a structured table format for clear and organized data presentation, including pagination for easy navigation through large datasets.

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

📊 Bar Chart Visualization​

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

Bar Chart

📈 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

🌊 Area Chart Visualization​

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

Only numeric columns can be selected for key comparison.

Area Chart

🧱 Column Chart Visualization​

  • Visualize data distribution across rows.
  • Each column bar represents a single row for one-to-one column comparison.

Only numeric columns can be selected for key comparison.

Column Chart

⏱️ Time Series Chart Visualization​

  • Visualize data trends over time.
  • Represented as a single line corresponding to the selected numeric column, plotted against a time-based x-axis for temporal analysis.

Time Series Chart

📋 Table Chart Visualization​

  • View results in a structured table format with enhanced visualization options for better insight.

Table Chart

🧩 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

Best Practices​

Query Writing​

  • Start Simple: Begin with basic queries and add complexity gradually
  • Test with Limits: Use row limits when working with large datasets
  • Use the AI: Leverage assistance for syntax help and optimization
  • Organize Code: Keep related queries in the same script tab

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 assistant to understand new SQL techniques
  • Explore Schema: Ask about table structures and relationships

Performance Optimization​

  • Set Appropriate Limits: Retrieve only necessary data
  • Monitor Execution Time: Watch for slow queries and optimize proactively
  • Use AI Suggestions: Request optimization recommendations
  • Schedule Long Queries: Use scheduling for time-intensive operations

Next Steps​