data-diff icon indicating copy to clipboard operation
data-diff copied to clipboard

Support dbt Snowflake connection using key file itself rather than just path to key file

Open will-warner opened this issue 1 year ago • 0 comments

Is your feature request related to a problem? Please describe. https://github.com/datafold/data-diff/pull/792 enabled a Snowflake to connect using the key itself in addition to the previously allowed key path method.

dbt also supports connecting to Snowflake using the key itself as of 1.5, by providing private_key in your profile, ref.

The data-diff's dbt parser however has not been updated to parse this key from the dbt profile, meaning that you can only to connect to Snowflake via dbt using the key path method:

https://github.com/datafold/data-diff/blob/db7d8641d19a4417a378030671ce587035f5131e/data_diff/dbt_parser.py#L355-L359

Describe the solution you'd like Allow either the private_key_path or private_key to be parsed from the dbt profile.

Describe alternatives you've considered NA

Additional context Add any other context or screenshots about the feature request here.

will-warner avatar Jan 03 '24 15:01 will-warner