Querying Data
Our query builder functions similarly to the Schema Viewer, allowing users to explore each Data Source connected to The Data Refinery in depth. However, the Query Builder provides this functionality using SQL (Structured query language - a programming language for storing and processing information in a relational database).
With the Query Builder, users can query data sources and their relationships using SQL.
Step 1 - Navigating to the Query Builder
This part of the guide assumes you have already have data sources with sucesfull syncs
To access the Query Builder, go to the navigation menu and click on the Query Builder link under the Discovery section. You will be redirected to the Query Building screen.

Step 2 - Understanding the Query Builder Compartments
Upon entering the Query Building view, you will find a SQL editor-styled interface. The interface is split up into four sections:
Data Source Section:
This section displays all your data sources. Clicking on these sources will show their associated tables. Clicking on a table will reveal its associated columns.

Saved Query Section:
This area contains three types of queries: your saved queries, queries shared with your team, and system queries. System queries are predefined queries created by us to simplify your data querying process. Double-clicking on a query will populate the Query window with the associated SQL.

Query Section: This section is a SQL editor that allows you to type SQL queries and run them against your data sources. The SQL editor provides intelligent suggestions to facilitate query writing.

Results Section: This section is where the data resulting from successful queries will be displayed.

Frequently asked questions
Can I share queries with other members of the team?
Yes, all the queries you create can be shared with other individuals in your team.
Can I query all my data sources in the Query Builder?
Yes, you can view all existing data using the Query Builder. As long as your data connection has been synced, you'll be able to write SQL queries against that data.
Can I publish queried data into another system or tool?
Yes, as long as you have created and saved a shared query, its results can be published to another destination or system from within the Refinery. All you need to do is click the 'Create Flow' button in the query builder and follow the necessary steps to publish the data.