MeltanoLabs / tap-snowflake

Other
4 stars 10 forks source link

feat: Add new private_key & passphrase based authentication method #38

Closed haleemur closed 2 months ago

haleemur commented 2 months ago

Description

The tap can now connect to snowflake using a provided private key and passphrase. The private key can be provided as a string or the path to the private key file can be provided.

Fixes an edge-case handling where schemas needing quotes (example: "MySpecial.SchemaName") are properly handled during discovery.

Speeds up discovery slightly when tables is provided. The speed up is achieved by only inspecting relevant schemas which can be derived by parsing each table within tables.

Introduces 3 new config parameters to support key based authentication and since there are 2 ways to authenticate, password is now an optional parameter. The new parameters are:

resolves: https://github.com/MeltanoLabs/tap-snowflake/issues/19

edgarrmondragon commented 2 months ago

Thanks @haleemur!