SQL cells

Querying Data with SQL Cells

We've just added a schema browser to your Data Connection details -- check it out!

Once you have configured a Data Connection, you can query it though a SQL cell. If your Org has set up Shared Data Connections, these will also be available to choose from.

First, add a new SQL cell and select a data source:

‚Äč

You can then write SQL directly in the cell:

SQL Cells have an integrated preview which shows up to 10 rows.

Query results are returned as Pandas dataframes. The name of the dataframe is easily changed by clicking the grey "Returned as dataframe" title and editing. The dataframe is automatically re-named and does not require the SQL cell be re-executed to take effect.

Schema Browser

Can't remember available table names, column names, or column data types? You can browse your database schemas using the schema browser, available in the left side bar with your Data Connections. From there, you can explore the database schema, tables, and columns available by clicking the > button for the desired connection.

Initial load time for full schema details can take a few seconds. We cache schema results so that future references to the database details are immediately available.

Refreshing the Cache

If you need to update the cached schema information, click the icon next to the data connection name in the schema browser and select refresh.