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 Zoho Analytics that maps to these basic entities required for SQL querying. You need to use this mapping to construct your SQL queries for execution.
In Zoho Analytics the mapping of the entities would be the following:
| SQL Query Entity | Zoho Analytics mapping |
|---|---|
| Workspace | Mapped to each Reporting Workspace in Zoho Analytics. |
| Table | Mapped to Tables and Query Tables in a Reporting Workspace in Zoho Analytics |
| Column | Mapped to Columns of a Table or Query Table in a Reporting Workspace in Zoho Analytics. |
SAMPLE:
Following is an example of a CloudSQL query executed on Zoho Analytics:
Workspace Name in Zoho Analytics : “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 Zoho Analytics, which are from the Region 'East’.