Difference between revisions of "SQL Lab"

From Datonis
Jump to: navigation, search
m
(2 intermediate revisions by the same user not shown)
Line 1: Line 1:
 
== About SQL Lab ==
 
== 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.
+
SQL Lab is a modern, feature-rich SQL IDE. Using this, the user is able to look at his/ her data tables, create joins on existing tables, and can visualize these modified tables to get additional insights.
  
This can be accessed by going to 'SQL Lab' button present at the top of the Datonis BI toolbar.
+
This can be accessed by going to 'SQL Lab' button present at the top of the Datonis BI toolbar or by clicking on the '+New' button and selecting 'SQL Query' at the top right of the page.
  
[[File:Accessing the SQL Lab.png|none|thumb|600x600px|Accessing the SQL Lab]]There are 3 components available which are explained in the next section.
+
[[File:Accessing the SQL Lab.png|none|thumb|600x600px|Accessing the SQL Lab]]
  
 
== Components of SQL Lab ==
 
== Components of SQL Lab ==
The 3 components are explained below:
+
There are 3 components available that are explained below:
 
# 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.
Line 13: Line 13:
  
 
== SQL Lab Usage ==
 
== SQL Lab Usage ==
Show data sources, tables, and writing queries.
+
The SQL Query page gives the user a detailed look into his/her databases, the tables present for that database, and the SQL Query pane to write queries. There are 3 sections in the SQL Query page.
 +
# Datasource/ Table Pane - marked in Red
 +
# SQL Query Editor Pane - marked in Blue
 +
# SQL Query Output Pane - marked in Green
 +
[[File:SQL Editor Panes.png|none|thumb|500x500px|SQL Editor Panes]]The user is able to write his/ her own queries in the SQL Query Editor pane, check the output in the SQL Query Output pane and modify if required. The user can then choose to save the query for future use from the '<nowiki/>'''Save Query'''<nowiki/>' option or he/ she can directly view the query results in a chart using the ''''Explore'''<nowiki/>' button.
  
Query + creating charts
+
For more details on how to create charts, please visit [[Create your own custom dashboards]].
  
Video
+
The user also has an option to download the Query result as a CSV file for further analysis using ''''.CSV'''<nowiki/>' button at the top of SQL Query Output pane.
 +
 
 +
=== Example video for writing a SQL query and visualizing the results ===
 +
Here is an example video of how you can write a SQL query and using the query output quickly visualize the data using a chart.
 +
 
 +
'''ADD VIDEO HERE'''

Revision as of 06:14, 30 July 2020

About SQL Lab

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

This can be accessed by going to 'SQL Lab' button present at the top of the Datonis BI toolbar or by clicking on the '+New' button and selecting 'SQL Query' at the top right of the page.

Accessing the SQL Lab

Components of SQL Lab

There are 3 components available that 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/ her queries by a user, database, and date of creation.

SQL Lab Usage

The SQL Query page gives the user a detailed look into his/her databases, the tables present for that database, and the SQL Query pane to write queries. There are 3 sections in the SQL Query page.

  1. Datasource/ Table Pane - marked in Red
  2. SQL Query Editor Pane - marked in Blue
  3. SQL Query Output Pane - marked in Green
SQL Editor Panes
The user is able to write his/ her own queries in the SQL Query Editor pane, check the output in the SQL Query Output pane and modify if required. The user can then choose to save the query for future use from the 'Save Query' option or he/ she can directly view the query results in a chart using the 'Explore' button.

For more details on how to create charts, please visit Create your own custom dashboards.

The user also has an option to download the Query result as a CSV file for further analysis using '.CSV' button at the top of SQL Query Output pane.

Example video for writing a SQL query and visualizing the results

Here is an example video of how you can write a SQL query and using the query output quickly visualize the data using a chart.

ADD VIDEO HERE