Connect to PostgreSQL to Databricks community edition error
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-25-2022 11:57 AM
Dear Team,
I am trying to establish a connectivity to PostgreSQL to Databricks community edition using sql notebook
however I am encountering the below error
Error in SQL statement: IllegalArgumentException: requirement failed: Host name should not contain query strings or parameters.
# using the below SQL from the databricks sytax
DROP TABLE IF EXISTS postgresql_table;
CREATE TABLE postgresql_table
USING postgresql
OPTIONS (
dbtable 'orders',
host 'postgresql://itworld_sms_user:itworld@pg.itworld.com:5432/itworld_sms_db',
port '5432',
database 'itworld_sms_db',
user 'world_sms_user',
password 'xxxxxxx'
);
example
/*postgresql://itworld_sms_user:xxxxxxx@pg.itworld.com:5432/itworld_sms_db
postgresql://<username>:<password>@<hostname>:<port>/<database>
username = itworld_sms_user
password = xxxxxxx
hostname = pg.itworld.com
port = 5432
database = itworld_sms_db*/
my questions are the following
1) can we establish connectivity using a community edition notebook ?
2) if yes to question 1 then what is wrong with the above syntax?
Labels:
- Labels:
-
Postgresql
-
SQL
1 REPLY 1
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-27-2022 12:52 PM
@Team
any suggestions ?

