Error connecting Apache Superset to CrateDB Cloud

[amotl]

Problem

@wierdvanderhaar reported an error without much further information when connecting Apache Superset to CrateDB Cloud, while roughly following the setup instructions ¹, omitting workstation setup details.

The connection URL is:

crate://tsadmin:PASSWORD@sandbox-wh.aks1.eastus2.azure.cratedb.net:5432/doc?sslmode=require

Footnotes

1. https://community.cratedb.com/t/set-up-apache-superset-with-cratedb/1716 ↩

[amotl]

Using the ?ssl=true suffix on the connection URL did not change anything. Wierd reported it's the same error.

[amotl]

Thoughts

What about omitting doc within the URL path, because CrateDB does not know about databases?

The correct way to address a schema in SQLAlchemy would be by using the schema query parameter, like ?schema=doc, but I'd always recommend to omit it completely when troubleshooting, to verify if basic connectivity works.

Related

• SQLAlchemy: Improve error message when using database path parameter sqlalchemy-cratedb#81

[amotl]

Now I am seeing it. You can't use the CrateDB SQLAlchemy dialect to connect to the PostgreSQL port, because the dialect currently speaks HTTP only. That other patch may improve the situation in this regard.

• Dialect: Add support for asyncpg and psycopg3 drivers sqlalchemy-cratedb#11

[amotl]

@wierdvanderhaar says:

Default port works, sorry for the confusion!

Thanks. Sorry for noticing late!