Help Center
Go back to application
Help Center
Go back to application
Introduction
Getting Started
Database Connections
SQL
SQL LabAI Assistant for SQL QueriesAI Complete Automation WorkflowSaved QueriesAdd a New QuerySQL History
Charts
Dashboard
Cascading Style Sheets
List User – Workbench
List Role – Workbench
Alerts and Reports
Annotation layers

Add a New Query

  1. Click SQL in the toolbar and select SQL Lab from the dropdown list. 

     
  2. Click QUERY to create a new query. 

     
  3. Select the Database, Schema, and See Table Schema from the dropdown menu. 
    Note: Based on the database, you can view the schema and examine the table structure, which is already integrated with the database.
  4. Add queries in the query section located on the right side of the screen as needed.
  5. Click Run to run the query. 

     
  6. Set the query limit if required to control the maximum number of records returned by the query, ensuring better performance and resource management.
  7. Click Save and view the query in the saved query list. For more information, refer to Section Saved Query.
  8. Click Copy Link to copy the query link. 

     
    Note: After running the query, you can view the results, query history, and a preview of the executed query.
  9. For refined analysis, click Results, Query History, and Preview tabs.
  10. Click RESULT to view the result of the executed query, including create chart, download to csv, and copy to clipboard.
    1. CREATE CHART: Add a chart based on the executed query results.
    2. DOWNLOAD TO CSV: Download the query results in CSV format.
    3. COPY TO CLIPBOARD: Copy the query results to your clipboard. 

       
  11. Click QUERY HISTORY to view the query history, including State, Started, Duration, Progress, Rows, SQL, Results, and Actions.
    1. State: The status of the query.
    2. Started: The timestamp indicating when the query execution began.
    3. Duration: The amount of time taken to execute the query.
    4. Progress: The completion percentage of the processed query.
    5. Rows: The number of rows returned by the query.
    6. SQL: The SQL query that was executed.
    7. Results: A preview of the query’s output or the number of records retrieved by clicking on the icon.
    8. Actions: Available options to interact with the query, such as overwrite text, run query in new tab, or deleting the query. 

       
  12. Click PREVIEW to view query the results. 

 

Back Next

Was this article helpful?

Powered by Product Fruits