https://community.databricks.com/t5/get-started-discussions/no-database-name-field-for-postgresql-connection/m-p/39719#M710 <P>This is the error.</P><P class="lia-indent-padding-left-30px"><SPAN>[CANNOT_ESTABLISH_CONNECTION] Cannot establish connection to remote POSTGRESQL database. Please check connection information and credentials e.g. host, port, user and password options. ** If you believe the information is correct, please check your workspace's network setup and ensure it does not have outbound restrictions to the host. Please also check that the host does not block inbound connections from the network where the workspace's Spark clusters are deployed. ** Detailed error message: FATAL: permission denied for database "postgres" Detail: User does not have CONNECT privilege..</SPAN></P><P><SPAN>I am able to connect in a notebook with the following code. The main difference appears to be that I am supplying the database name, but there is no option for that in the Data Explorer in the Workspace UI.&nbsp;</SPAN></P><LI-CODE lang="markup">jdbcURL = f"jdbc:postgresql://{database_creds['host']}/{database_creds['database']}" Class.forName("org.postgresql.Driver") df = spark.read.jdbc(url=jdbcURL, table='public.users', properties={'user': USER, 'password': PASSWORD})</LI-CODE> Sat, 12 Aug 2023 13:56:01 GMT jlmontie 2023-08-12T13:56:01Z https://community.databricks.com/t5/get-started-discussions/no-database-name-field-for-postgresql-connection/m-p/39490#M699 <P>I'm trying to get my workspace setup by connecting to my PostgreSQL database. I am following <A href="https://docs.databricks.com/en/query-federation/postgresql.html" target="_self">this article</A>. The instructions under "Create a connection" are failing because my connection requires a database name. However, the database name is not a supported variable. What options do I have to connect to my database?</P> Thu, 10 Aug 2023 05:06:21 GMT https://community.databricks.com/t5/get-started-discussions/no-database-name-field-for-postgresql-connection/m-p/39490#M699 jlmontie 2023-08-10T05:06:21Z https://community.databricks.com/t5/get-started-discussions/no-database-name-field-for-postgresql-connection/m-p/39719#M710 <P>This is the error.</P><P class="lia-indent-padding-left-30px"><SPAN>[CANNOT_ESTABLISH_CONNECTION] Cannot establish connection to remote POSTGRESQL database. Please check connection information and credentials e.g. host, port, user and password options. ** If you believe the information is correct, please check your workspace's network setup and ensure it does not have outbound restrictions to the host. Please also check that the host does not block inbound connections from the network where the workspace's Spark clusters are deployed. ** Detailed error message: FATAL: permission denied for database "postgres" Detail: User does not have CONNECT privilege..</SPAN></P><P><SPAN>I am able to connect in a notebook with the following code. The main difference appears to be that I am supplying the database name, but there is no option for that in the Data Explorer in the Workspace UI.&nbsp;</SPAN></P><LI-CODE lang="markup">jdbcURL = f"jdbc:postgresql://{database_creds['host']}/{database_creds['database']}" Class.forName("org.postgresql.Driver") df = spark.read.jdbc(url=jdbcURL, table='public.users', properties={'user': USER, 'password': PASSWORD})</LI-CODE> Sat, 12 Aug 2023 13:56:01 GMT https://community.databricks.com/t5/get-started-discussions/no-database-name-field-for-postgresql-connection/m-p/39719#M710 jlmontie 2023-08-12T13:56:01Z