topic Re: Connect Data Pipelines to Snowflake via SSO in Data Pipelines Questions

Connect Data Pipelines to Snowflake via SSO

michelle-maps — Wed, 11 Sep 2024 00:06:55 GMT

Hello! I am wanting to utilize Data Pipelines to automate many of my workflows that involve routinely downloading data from Snowflake and uploading to ArcGIS Online.

My organization uses a browser-based SSO to log in to Snowflake.

When I go to set up a new Snowflake connection in Data Pipelines however, it looks like the authentication dropdown is greyed out. Why would that be? How can I connect to Snowflake using SSO?

Re: Connect Data Pipelines to Snowflake via SSO

BethanyScott — Tue, 17 Sep 2024 16:34:52 GMT

Hi @michelle-maps ,

Thank you for reaching out with your question.

SSO authentication for Snowflake is not currently supported for use in Data Pipelines. For now, you may need to work with your organizations administrator or Snowflake administrator to create a set of Snowflake credentials that you can use for Data Pipelines.

Thanks again,

Bethany

Re: Connect Data Pipelines to Snowflake via SSO

michelle-maps — Tue, 24 Sep 2024 17:06:06 GMT

Thank you for the response @BethanyScott! Is SSO support going to be on the roadmap for Snowflake Data Pipelines anytime soon?

Re: Connect Data Pipelines to Snowflake via SSO

BethanyScott — Tue, 24 Sep 2024 18:41:38 GMT

Hi @michelle-maps ,

It is not currently on the near- or long-term roadmap. However, we are tracking your request for planning purposes.

Thank you again - we value your feedback!

Bethany

Re: Connect Data Pipelines to Snowflake via SSO

kwillit — Mon, 21 Oct 2024 14:48:55 GMT

@BethanyScott Is there a plan to update the Snowflake Data Pipeline, given Snowflake's recent announcement that they strongly recommend using SSO or key pair authentication?

Re: Connect Data Pipelines to Snowflake via SSO

BethanyScott — Fri, 07 Feb 2025 17:26:21 GMT

Hi @kwillit,

Thank you for reaching out. We are planning to add support for connecting to Snowflake using key pair authentication later this year. We will update you here in this thread and make an announcement in our What's New documentation once it's available for use.

Thanks again,
Bethany