Querying Relational Database Systems

This notebooks shows how to query data in relational database systems.

The first step is to register credentials.

For the purposes of this notebook, we assume there is a credential registered for a PostgreSQL server under name psql01.

(Password is shown as None because it is hidden from the API response for public clients.)

We can now list schemas and tables in this server as in:

Finally, we can do query over a table as:

Note that many operations will be pushed down and executed in the database system directly.

Next: Debugging Queries