Query and explore data in SQL Lab

Data Browser’s core function is the SQL Lab – a powerful web-based SQL editor. It enables you to explore and query data directly from Semantic Data Lakehouse without the need of external SQL clients.

Prerequisites

In order to explore and query data in SQL Lab, you need to have your access and permissions sorted out for your tenant.

How to proceed

Here is how you can use the SQL Lab to explore data:

  1. Click the SQL dropdown on the above ribbon in the Home screen.

  2. Select SQL Lab.
    A new query is now open. The Database field is already pre-filled with the data associated with your tenant.

  3. Select a schema type and the particular schema from that type you wish to use.
    Data is now filtered and displayed, based on the parameters you selected. You can also further refine your data search by writing your query manually in the code section up right.

  4. Optionally, type in your SQL query in the code section, and click Run.
    The filtering results are dispayed in the section down right. Now you can save your query and later have it at your disposal.

  5. Click the Save button under the code field and name your query. Click Save again.
    The saved query can be found from the SQL dropdown by selecting Saved Queries.

Now that you know how to explore data in SQL Lab and that you saved your first query, you can proceed with creating a dataset based on it.