search

crate / crate-clients-tools

Clients, tools, and integrations for CrateDB.
https://crate.io/docs/clients/
Apache License 2.0
2 stars 1 forks source link

Error connecting Apache Superset to CrateDB Cloud #95

Closed amotl closed 8 months ago

amotl commented 8 months ago

Problem

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

The connection URL is:

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

image

amotl commented 8 months ago

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

amotl commented 8 months ago

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

amotl commented 8 months ago

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.

amotl commented 8 months ago

@wierdvanderhaar says:

Default port works, sorry for the confusion!

Thanks. Sorry for noticing late!