Create External Catalog when dbname has special characters

- - Certifications
- - Learning Paths
- - Databricks Product Tours
- - Get Started Guides

- - Get Started Resources
- - Announcements
- - Community Articles
- - Databricks TV
- - Learning Events
- - MVP Articles
- - Product Platform Updates
- - Support FAQs
- - Technical Blog
- - Community Events
- - BrickTalks TV

- - Databricks Academy Learners
  - Databricks Academy Learners Forum
- - Regional and Interest Groups
- - Private Groups

- - Databricks Community Champions
- - Khoros Community Forums Support (Not for Databricks Product Questions)
- - Databricks Community Code of Conduct

Data Engineering

Join discussions on data engineering best practices, architectures, and optimization strategies within the Databricks Community. Exchange insights and solutions with fellow data engineers.

Hi experts,

I'm having a problem when trying to create an external catalog with my PostgreSQL database.

The connection is fine. But the database name that I want to connect has dashes and colon (eg. my-db-prod:all). When trying to connect with it, I always get the error

[DATA_SOURCE_OPTION_CONTAINS_INVALID_CHARACTERS] Option database must not be empty and should not contain invalid characters, query strings, or parameters. SQLSTATE: 42602

Is it has any way to create the catalog with this dbname? Unfortunately I cannot change the dbname.

Thanks.