Connect to PostgreSQL to Databricks community edition error

db-avengers2rul — Sun, 25 Dec 2022 19:57:58 GMT

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

https://docs.databricks.com/external-data/postgresql.html#using-the-postgresql-connector-in-databricks-runtime&language-sql

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?

Re: Connect to PostgreSQL to Databricks community edition error

db-avengers2rul — Tue, 27 Dec 2022 20:52:28 GMT

@Team

any suggestions ?

topic Re: Connect to PostgreSQL to Databricks community edition error in Data Engineering

Connect to PostgreSQL to Databricks community edition error

Re: Connect to PostgreSQL to Databricks community edition error