PostgreSQL

Set up a PostgreSQL connection
When inside a workspace, 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 Workspace.
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.
​

Last modified 1mo ago

PostgreSQL

Set up a PostgreSQL connection

Query a PostgreSQL database

​