use database set URI connection string to query information_schema (Snowflake)
leoebfolsom opened this issue · 2 comments
sqeleton's snowflake.py
is not using the database as specified in the URI connection string when querying the information_schema
. The result is that the query of the information_schema
inappropriately defaults to the default db.
per @dlawin:
We should set self.default_database and use in this if/else:
Workaround: duplicatively list the fully qualified path in the table name. Example of that:
data-diff \
"snowflake://leo:$SNOWFLAKE_PASSWORD@$SNOWFLAKE_ACCOUNT/analytics/ANALYTICS?warehouse=INTEGRATION&role=DATAFOLDROLE" \
ANALYTICS.ANALYTICS.ORG_ACTIVITY_STREAM \
"snowflake://leo:$SNOWFLAKE_PASSWORD@$SNOWFLAKE_ACCOUNT/analytics/PR_NUM_?warehouse=INTEGRATION&role=DATAFOLDROLE" \
ANALYTICS.PR_NUM_.ORG_ACTIVITY_STREAM
(Note that ANALYTICS.ANALYTICS
and ANALYTICS.PR_NUM_
are written in both the URI string and the table name. I'm also not 100% sure this works 100% of the time.)
v0.7.14
This issue has been marked as stale because it has been open for 60 days with no activity. If you would like the issue to remain open, please comment on the issue and it will be added to the triage queue. Otherwise, it will be closed in 7 days.
Although we are closing this issue as stale, it's not gone forever. Issues can be reopened if there is renewed community interest. Just add a comment and it will be reopened for triage.