Skip to content

Tech note - Snowflake to block single-factor password authentication

Removal of Snowflake single-factor password authentication

On December 1st, 2024, Snowflake announced plans to block single-factor password authentication by November 2025.

Matillion will act in alignment with Snowflake to ensure that single-factor password authentication to Snowflake is removed from the Data Productivity Cloud by Snowflake's November 2025 date.


Key pair authentication

Matillion currently ships the Data Productivity Cloud with support for both single-factor password and key pair authentication mechanisms to Snowflake. Single-factor password support will be removed in a future update and users should edit their projects and environments to use Snowflake key pair authentication as soon as possible.

To start using key pair authentication:

  1. Log in to your Data Productivity Cloud account.
  2. In the left navigation, click the Projects icon .
  3. Click the name of the project you wish to set up Snowflake key pair authentication for. This must be a Snowflake project.
  4. Click Environments.
  5. Click ... for the environment where you wish to edit the connection to Snowflake.
  6. Click Edit environment.
  7. On the Edit Snowflake credentials page, ensure that Credentials type is set to Key pair.
  8. The fields to complete next depend on whether your configuration is Full SaaS or Hybrid SaaS. Read Key pair for more information.

If you haven't set up Snowflake key pair authentication yet, read Snowflake's documentation to learn more about key pair authentication: Key-pair authentication and key-pair rotation.


Streaming pipelines

If you have streaming pipelines connected to a Snowflake destination, you should edit the connection details to use key pair authentication rather than a single-factor password.

  1. Log in to your Data Productivity Cloud account.
  2. In the left navigation, click the Projects icon .
  3. Click the name of the project that holds the Streaming pipeline you wish to set up Snowflake key pair authentication for. This must be a Snowflake project.
  4. Click Streaming.
  5. Locate the Streaming pipeline to edit and then click ...Edit.
  6. Navigate through Edit Streaming pipeline and configure a valid key pair authentication connection. Read Snowflake destination connection for more information.
  7. Click Save pipeline.