https://community.databricks.com/t5/warehousing-analytics/all-users-group-can-someone-please-advise-on-this-question-using/m-p/14245#M260 <P>@All Users Group​&nbsp;,</P><P></P><P>can someone please advise on this question? </P><P>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</P><P></P><P>I really appreciate any help you can provide.</P><P></P> Wed, 28 Dec 2022 20:51:18 GMT db-avengers2rul 2022-12-28T20:51:18Z https://community.databricks.com/t5/warehousing-analytics/all-users-group-can-someone-please-advise-on-this-question-using/m-p/14245#M260 <P>@All Users Group​&nbsp;,</P><P></P><P>can someone please advise on this question? </P><P>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</P><P></P><P>I really appreciate any help you can provide.</P><P></P> Wed, 28 Dec 2022 20:51:18 GMT https://community.databricks.com/t5/warehousing-analytics/all-users-group-can-someone-please-advise-on-this-question-using/m-p/14245#M260 db-avengers2rul 2022-12-28T20:51:18Z https://community.databricks.com/t5/warehousing-analytics/all-users-group-can-someone-please-advise-on-this-question-using/m-p/14246#M261 <P>It is possible, but it looks like your code is a little bit messy.</P><P>Check this article up:</P><P><A href="https://docs.databricks.com/external-data/postgresql.html" target="test_blank">https://docs.databricks.com/external-data/postgresql.html</A></P> Thu, 29 Dec 2022 06:32:49 GMT https://community.databricks.com/t5/warehousing-analytics/all-users-group-can-someone-please-advise-on-this-question-using/m-p/14246#M261 daniel_sahal 2022-12-29T06:32:49Z https://community.databricks.com/t5/warehousing-analytics/all-users-group-can-someone-please-advise-on-this-question-using/m-p/14247#M262 <P> @Daniel Sahal​&nbsp;</P><P>please check i have just followed exactly the same as per the databricks documentation.but still getting the error</P> Thu, 29 Dec 2022 17:55:21 GMT https://community.databricks.com/t5/warehousing-analytics/all-users-group-can-someone-please-advise-on-this-question-using/m-p/14247#M262 db-avengers2rul 2022-12-29T17:55:21Z https://community.databricks.com/t5/warehousing-analytics/all-users-group-can-someone-please-advise-on-this-question-using/m-p/14248#M263 <P>@Daniel Sahal​&nbsp;</P><P></P><PRE><CODE>DROP TABLE IF EXISTS postgresql_table; CREATE TABLE postgresql_table USING postgresql OPTIONS ( dbtable '&lt;table-name&gt;', host '&lt;database-host-url&gt;', port '5432', database '&lt;database-name&gt;', user '&lt;username&gt;', password '&lt;password&gt;' );</CODE></PRE><P></P><P>what is that i need to enter in dbtable '&lt;table-name&gt;', ? </P><P>what is that i need to enter in host '&lt;database-host-url&gt;' ?</P><P></P><P>any sample example ? </P><P></P><P></P> Thu, 29 Dec 2022 19:07:30 GMT https://community.databricks.com/t5/warehousing-analytics/all-users-group-can-someone-please-advise-on-this-question-using/m-p/14248#M263 db-avengers2rul 2022-12-29T19:07:30Z