SQL Editor

Beside the Dataset, Holistics also has the SQL Editor as another way to explore your data. This tool is great for running SQL queries for adhoc analysis, to understand the shape of your data, or to prototype a data model setup. Similar to the Dataset UI, it also has the visualization panel in case you want to visualize your query results:

How to access SQL Editor tool

In your home page, simply click on the SQL Editor button in the Top Navigation Bar.

Running non-select SQL queries

By default, Holistics only allows SELECT statements to run against your database. However, you can still run non-SELECT statements (like INSERT, UPDATE, DROP, CREATE, GRANT...) in the SQL Editor by toggling on Non-select query option:

If this is not toggled on, the non-SELECT query will be invalidated by Holistics.

This functionality is available to all account types that has access to Query Editor (i.e Admin & Analyst).

caution

Non-select statements may affect your database directly and cause irreversible changes. Please take great care when using this functionality.