SQL Query Editor

Intro

Holistics Query Editor is great for running SQL queries for adhoc analysis, and sharing quick results with your colleagues.

Running non-select SQL queries

In most cases, the SQL reports only contain SELECT statements. However, in advance use cases you may want the SQL to run a non-SELECT query before a SELECT (for example, create a temporary function).

In this case, you can toggle on Non-select query. If this is not toggled on, the non-SELECT query will be invalid.

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