cancel
Showing results for 
Search instead for 
Did you mean: 
Warehousing & Analytics
Engage in discussions on data warehousing, analytics, and BI solutions within the Databricks Community. Share insights, tips, and best practices for leveraging data for informed decision-making.
cancel
Showing results for 
Search instead for 
Did you mean: 

@All Users Group​ , can someone please advise on this question? using community edition databricks can we connect PostgreSql is this possible,since I ...

db-avengers2rul
Contributor II

@All Users Group​ ,

can someone please advise on this question?

using community edition databricks can we connect PostgreSql is this possible,since I have tried but I was getting the error, please refer to the below post for more details

I really appreciate any help you can provide.

3 REPLIES 3

daniel_sahal
Esteemed Contributor

It is possible, but it looks like your code is a little bit messy.

Check this article up:

https://docs.databricks.com/external-data/postgresql.html

@Daniel Sahal​ 

please check i have just followed exactly the same as per the databricks documentation.but still getting the error

@Daniel Sahal​ 

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 '<username>',
  password '<password>'
);

what is that i need to enter in dbtable '<table-name>', ?

what is that i need to enter in host '<database-host-url>' ?

any sample example ?

Join 100K+ Data Experts: Register Now & Grow with Us!

Excited to expand your horizons with us? Click here to Register and begin your journey to success!

Already a member? Login and join your local regional user group! If there isn’t one near you, fill out this form and we’ll create one for you to join!