SQL console

SQL console provides an interface for writing and executing SQL queries in Foundry.

Using SQL console

You can access SQL console in the bottom panel of Supported applications. The starter query is prepopulated based on your currently selected dataset.

You can write any supported SQL query following the supported Spark SQL dialect. In Spark SQL, identifiers such as table names should be quoted using backticks ( ` ) rather than single or double quotes. You can also leverage auto-complete features, such as searching for dataset names or column names using backticks.

Core functionality

SQL console provides the following core functionality:

• Query tabular data (SELECT)
• Autocompletion of the dataset schema and column names
• Search for other datasets within backticks (`) to perform efficient JOIN queries
• Use editor-friendly features such as keyboard shortcuts to run a highlighted query
• Output a preview table for results of the executed SQL query
• Resize columns and the bottom panel to fit your preferences

Beta functionality

Additionally, SQL console provides the following beta functionality, which can be enabled on request:

• Queries on ontology object types in Ontology Manager.
• Table creation (CREATE TABLE)
• Table alteration for Iceberg tables (INSERT INTO, UPDATE, DELETE)
• Savable SQL worksheet resources
• Optional full-screen view

Supported modes and applications

SQL console is available in the following modes and applications:

SQL console roles and permissions

In order to use SQL console in data mode, you must have access to at least one of the following roles:

If your organization has set up custom roles or download controls, Query datasets using SQL may have been restricted. Enable Preview datasets using SQL to allow previewing data while restricting full table downloads.