Database query component using private key connection to Snowflake

Matillion ETL
1

My project has an environment to our main snowflake account. However, I have a task which needs to use a database query component to run a sql query to get results from a separate snowflake account. How can I configure the database query component to connect to snowflake using a private key instead of a username/password?

2

Hello @joshua.botticher

Welcome to the Matillion Community and thank you for your post.

At the moment Matillion ETL only supports Username/Password authentication for the Database Query Component and JDBC Table Metadata to Grid components. We do also support connection to the environment in Snowflake account using PK.

I should add that Snowflake plan to depreciate Username / Password authentication in November 2025, the team are already looking to start work to introduce PK authentication for the aforementioned components.

I hope that helps, please do let me know if you need anything else.

Kind regards, Joe

3

Hey Joe!
Any update on that? As far as I see, it’s still not possible?
As you mentioned, username/password will be deprecated soon, which means if we work with Matillion on Redshift, we are no longer able to connect to Snowflake. Our source systems already start to change to the new authentication method.

Best, Manuel

5

Hi @Manuel! My apologies for the delayed response. Let me see if I can find any further information for you about this.

Many thanks,
Claire

6

Hello @Manuel

Thanks for your post, I wanted to share an update, we are adding PK to the Database Query and JDBC Table Metadata to Grid Components in anticipation of the snowflake change.

This should be available with release 1.79, which is due around August.

I will share an update here once this is released.

Kind regards, Joe

7

Hi all,

Just to pop back, the release mentioned is being worked on and aimed for the tail end of August, I just wanted to keep you all in the loop :slight_smile:

Kind regards, Joe

8

Hi all,

The team are still working hard to get this release out ASAP! We appreciate your patience with regard to this.

Kind regards, Joe

1 Like
9

Hi,

I see that 1.78.11 is the latest Matillion ETL released on 10/2/2025. Do you know when 1.79 is getting released with Database Query component being able to use private key when connecting to Snowflake database?

Thanks.

10

Is there any update on this?
We are also looking to switch our Snowflake database query component from user/password to a private key connection. We are on Matillion ETL. Our main environment is in redshift but we use the database query component to pull in additional data from a snowflake instance.

11

Hello all, and a warm welcome to the Matillion Community, @jsaldana and @James.

Thank you for your patience. I can confirm that the private key connection to Snowflake, used with the Database Query component, will be available in Matillion ETL version 1.79. This latest release will be available very soon. In the meantime, you can authenticate to Snowflake using programmatic access tokens. Please refer to Snowflake’s documentation for more information - Using programmatic access tokens for authentication | Snowflake Documentation .

I will post a link to our documentation about this when the feature is published.

Kind regards,

Suzanne