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.
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.
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.