gabledata / recap

Work with your web service, database, and streaming schemas in a single format.
https://recap.build
MIT License
330 stars 24 forks source link

Parse database and schema from Snowflake URL #390

Closed criccomini closed 1 year ago

criccomini commented 1 year ago

Snowflake's Python sqlalchemy client shows URL connections like this:

snowflake://testuser1:0123456@myorganization-myaccount/testdb/public?warehouse=testwh&role=myrole

Right now, we can't support this because we don't handle the path (testdb/public). We also set "host" instead of "account" for the host.

Per-this doc, host is deprecated in favor of account.