Reports Help

SQL Query Entity Mapping

To construct and execute an SQL Query you need to first identify the entities on which the SQL Query will operate upon. The basic entities that are essential for constructing an SQL query includes Workspace, Tables and Columns.

The following section describes the mapping in SkyDesk Reports that maps to these basic entities required for SQL querying. You need to use this mapping to construct your SQL queries for execution.

In SkyDesk Reports the mapping of the entities would be the following:

SQL Query Entity SkyDesk Reports mapping
Workspace Mapped to each Workspace in SkyDesk Reports
Table Mapped to Tables and Query Tables in a workspace in SkyDesk Reports
Column Mapped to Columns of a Table or Query Table in a workspace in SkyDesk Reports

Sample:

Following is an example of a CloudSQL query executed on SkyDesk Reports:

Entities involved in  SkyDesk Reports:

Workspace Name in SkyDesk Reports : "Super Store Sales"
Table Name : Sales
Columns Involved : Customer Name, Sales, Cost and Region

SQL SELECT Query:

select "Customer Name",Sales,Cost,"Profit (Sales)" from Sales where Region = 'East'

The above query will fetch the records from the Sales table in Super Store Sales workspace in SkyDesk Reports, which are from the Region 'East'.

Top