1. Help Center
  2. Getting Started

Queries

Queries are requests for data that answer specific questions. In Mozart, you can use SQL to explore data from your connectors and the output from your transforms.

Sometimes you want to query data just to explore it or answer ad-hoc questions. The Query section is the perfect place for that.

On the header, click Query.

Now you can write code to query against any table in your Warehouse. This includes Connector schemas as well as all Transforms. The panel on the right side shows the tables available. 

Click the Run button below the SQL editing panel to seethe results of your query. By default this will be limited to 100 rows of data. You can uncheck the "Limit 100" checkbox to view more rows.

If you decide you want to turn your Query into a Transform, you can click the arrow right next to the run button and select 'Save As Transform'.

Congratulations! 

You finished the Getting Started guide -- now go write more transforms!