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