Difference between revisions of "SQL Lab"

From Datonis
Jump to: navigation, search
m
m
Line 10: Line 10:
 
# SQL Editor - This is the IDE where-in the user can write his/ her own SQL queries.
 
# SQL Editor - This is the IDE where-in the user can write his/ her own SQL queries.
 
# Saved Queries - Once the user has created the queries and he/ she wish to run the same query then he/ she can save the query and rerun it by accessing it in the 'Saved Queries' tab.
 
# Saved Queries - Once the user has created the queries and he/ she wish to run the same query then he/ she can save the query and rerun it by accessing it in the 'Saved Queries' tab.
# Query Search -  
+
# Query Search - This feature lets the user search for his queries by a user, database and date of creation.
  
 
== SQL Lab Usage ==
 
== SQL Lab Usage ==

Revision as of 11:19, 28 July 2020

About SQL Lab

SQL Lab is a modern, feature-rich SQL IDE. Using this, the user is able to look at his data tables, create joins on existing tables, and can visualize these modified tables to get additional value.

This can be accessed by going to 'SQL Lab' button present at the top of the Datonis BI toolbar.

Accessing the SQL Lab
There are 3 components available which are explained in the next section.

Components of SQL Lab

The 3 components are explained below:

  1. SQL Editor - This is the IDE where-in the user can write his/ her own SQL queries.
  2. Saved Queries - Once the user has created the queries and he/ she wish to run the same query then he/ she can save the query and rerun it by accessing it in the 'Saved Queries' tab.
  3. Query Search - This feature lets the user search for his queries by a user, database and date of creation.

SQL Lab Usage

Show data sources, tables, and writing queries.

Query + creating charts

Video