You can access custom queries for Google BigQuery, Snowflake and SparkSQL by selecting a data provider from the data provider's list and then selecting Custom Queries.
Creating a new query¶
You can add a new custom query by clicking on the plus "+" button located on the top right corner of the Custom Queries dialog.
This opens a window to create a Custom Query as shown below.
Type the name and then your SQL query. After this we can click on the Execute button to run it. If everything goes ok, you should see the results in a table like this:
If there are errors caused by a wrong SQL query or any other reason, the error is printed in the results area. In the example below,
catgroup was mistyped to
catgroupp to render an error message. You can expand or collapse the results window by clicking on the caret down icon above the results area in case you'd like to have more room to edit your query.
You can save your query by clicking on the Save button. After that, your query will be listed under the Custom Queries menu in the providers list:
Editing a custom query¶
You can edit existing queries by clicking the pencil icon near the query name. A window will open where you can modify your query.
To preview the query results of an existing query, click the Execute button again.
Deleting a custom query¶
To delete a query, click on the pencil icon and then click the Delete button. A confirmation message will appear. Confirm if you'd like to proceed with the deletion.