Difference between revisions of "SQL Lab"
From Datonis
(Tag: Visual edit) |
m (Tag: Visual edit) |
||
| 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 | + | 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 inights. |
| − | 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]] | + | [[File:Accessing the SQL Lab.png|none|thumb|600x600px|Accessing the SQL Lab]] |
== Components of SQL Lab == | == Components of SQL Lab == | ||
| − | + | 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 18: | Line 18: | ||
Video | Video | ||
| + | |||
| + | The SQL Query page gives the user a detailed look into his/her datasources and the tables present for that datasource. 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]] | ||
| + | |||
| + | === Example video for creating a chart[edit | edit source] === | ||
| + | Here is an example video of how you can create a chart | ||
Revision as of 06:00, 30 July 2020
Contents
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 inights.
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.
Components of SQL Lab
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.
- 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 - This feature lets the user search for his/ her queries by a user, database, and date of creation.
SQL Lab Usage
Show data sources, tables, and writing queries.
Query + creating charts
Video
The SQL Query page gives the user a detailed look into his/her datasources and the tables present for that datasource. 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
Example video for creating a chart[edit | edit source]
Here is an example video of how you can create a chart
