Share via

Snowflake Connector no longer has connection string setting from Azure Key Vault?

Matthew Ozbun 0 Reputation points
2024-08-20T20:51:22.4066667+00:00

I have ADF pipelines that use the legacy Snowflake connector and the connection is configured via the Connection String setting using Azure Key Vault. User's image

The new non-legacy connector doesn't seem to have this option and is looking for warehouse, database, warehouse, username - none of which have Azure Key Vault integration, only the password does (see below). I would like to upgrade to the non-legacy version, but losing this functionality requires a bit of rework - is it possible to add the connection string/key vault functionality to the new connector?

User's image

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,566 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more

  2. PRADEEPCHEEKATLA-MSFT 88,716 Reputation points Microsoft Employee
    2024-08-22T14:05:31.7633333+00:00

    @Matthew Ozbun - Thanks for the question and using MS Q&A platform.

    This is a known limiation due to enforcing security best practices. Snowflake connector doesn't support passing connection string directly due to enforce security.

    For supported options, refer to Copy and transform data in Snowflake using Azure Data Factory or Azure Synapse Analytics.

    Hope this helps. Do let us know if you any further queries.

    If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.