@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]

@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.

[daniel_sahal]

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

[db-avengers2rul]

@Daniel Sahal​ 

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

[db-avengers2rul]

@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 ?