connect rds from databricks sql editor
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-01-2023 11:36 PM
Is it possible to connect and execute query directly from rds in sql editor without using unity catelog
- Labels:
-
DAIS2023
-
Parquet files
-
SQL
-
SQL Editor
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-03-2023 02:09 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-03-2023 06:23 AM
rds means AWS rds. Remote postgres server
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-03-2023 04:41 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-04-2023 12:27 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-04-2023 01:20 AM
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')
);