Query federation for PostgreSQL in Databricks SQL

Preview

The configurations described here are Experimental. Experimental features are provided as-is and are not supported by Databricks through customer technical support. Unity Catalog support for query federation is in preview. To request access, contact your Databricks representative.

Databricks SQL supports read-only query federation to PostgreSQL on serverless and pro SQL warehouses.

Connecting to PostgreSQL with Databricks SQL

You configure connections to PostgreSQL at the table level. You can use secrets to store and access text credentials without displaying them in plaintext. See the following example:

DROP TABLE IF EXISTS postgresql_table;
CREATE TABLE postgresql_table
USING postgresql
OPTIONS (
  dbtable '<table-name>',
  host '<database-host-url>',
  port '5432',
  database '<database-name>',
  user secret('postgres_creds', 'my_username'),
  password secret('postgres_creds', 'my_password')
);