PostgreSQL

Set up a PostgreSQL connection

When inside a workbook, click View > Databases, then click the + icon and follow the on-screen instructions.

Create a PostgreSQL connection

For detailed instructions, see Connect your data to DataLab.

If you want to experiment with PostgreSQL without setting up a connection, you can use our sample database with Lego data (source).

Query a PostgreSQL database

You can now query your PostgreSQL database with a SQL cell. Select it in the Select source dropdown in the top left corner of a SQL cell, or select the sample PostgreSQL database.

Example of a SQL cell using the Lego sample database connection. The query result is available as df.