Difference between revisions of "SQL Lab"

From Datonis
Jump to: navigation, search
m
m
Line 2: Line 2:
 
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 data tables, create joins on existing tables, and can visualize these modified tables to get additional value.
  
[[File:Accessing the SQL Lab.png|none|thumb|600x600px|Accessing the SQL Lab]]
+
This can be accessed by going to 'SQL Lab' button present at the top of the Datonis BI toolbar.
 +
 
 +
[[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.
  
 
== Components of SQL Lab ==
 
== Components of SQL Lab ==
SQL Editor
+
The 3 components are explained below:
 
+
# SQL Editor
Saved Queries
+
# Saved Queries
 
+
# Query Search
Query Search
 
  
 
== SQL Lab Usage ==
 
== SQL Lab Usage ==

Revision as of 06:59, 27 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
  2. Saved Queries
  3. Query Search

SQL Lab Usage

Show data sources, tables, and writing queries.

Query + creating charts

Video