airbytehq / airbyte

The leading data integration platform for ETL / ELT data pipelines from APIs, databases & files to data warehouses, data lakes & data lakehouses. Both self-hosted and Cloud-hosted.
https://airbyte.com
Other
15.4k stars 3.97k forks source link

Snowflake source: support key pair authentication type #14615

Open sashaNeshcheret opened 2 years ago

sashaNeshcheret commented 2 years ago

Tell us about the problem you're trying to solve

We need to add ability to use snowflake source connector with key pair authentication.

Describe the solution you’d like

Generated private/public key pair, updated snowflake user with public key, passed path to file with private key as jdbc properties. Updated normalization. Add test for it.

Describe the alternative you’ve considered or used

A clear and concise description of any alternative solutions or features you've considered or are using today.

Additional context

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

Are you willing to submit a PR?

Remove this with your answer :-)

SoerenStahlmann commented 1 year ago

I'd also need this feature and would be willing to submit a PR. Since I am new to airbyte can someone point me in the right direction where to start?