connect rds from databricks sql editor

[pinaki1]

Is it possible to connect and execute query directly from rds in sql editor without using unity catelog

[-werners-]

what do you mean by RDS?

Databricks SQL works fine without Unity enabled and can be accessed by all kinds of tools using ODBC/JDBC.

[pinaki1]

rds means AWS rds. Remote postgres server

[luis_herrera]

Hi there,

Yes, you could do federated queries from DB SQL Editor. This is an experimental feature, though. UC is actually not supported.

You can read more here:

https://docs.databricks.com/query-federation/index.html

PS: check out #DAIS2023 talks

[pinaki1]

its not working. getting error like this

[luis_herrera]

Databricks SQL supports read-only query federation to PostgreSQL on serverless and pro SQL warehouses. I would check first you are using the right flavor of SQL warehouse. Could you post the code you are using (without credentials)?

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')

);