Create External Catalog when dbname has special characters

micheloh — Wed, 20 May 2026 22:20:05 GMT

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.

topic Create External Catalog when dbname has special characters in Data Engineering

Create External Catalog when dbname has special characters