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?
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
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
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
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