Hi,
it looks like the Snowflake loader doesn’t currently support authentication via private key.
Snowflake has introduced a new policy that requires MFA for all services, which you can read more about here:
https://www.dataart.com/blog/snowflake-authentication-updates
Below is an example of the expected configuration:
{
"license": {
"accept": true
}
"messageQueue": "test-queue",
"storage" : {
"type": "snowflake",
"snowflakeRegion": "us-west-2",
"username": "admin",
"password": "Supersecret1",
+ "private_key": "---PRIVATE KEY---asdf1234..---END PRIVATE KEY",
"account": "acme",
"warehouse": "wh",
"schema": "atomic",
"database": "snowplow",
"transformedStage": "snowplow_stage"
}
}
Hi,
it looks like the Snowflake loader doesn’t currently support authentication via private key.
Snowflake has introduced a new policy that requires MFA for all services, which you can read more about here:
https://www.dataart.com/blog/snowflake-authentication-updates
Below is an example of the expected configuration:
{ "license": { "accept": true } "messageQueue": "test-queue", "storage" : { "type": "snowflake", "snowflakeRegion": "us-west-2", "username": "admin", "password": "Supersecret1", + "private_key": "---PRIVATE KEY---asdf1234..---END PRIVATE KEY", "account": "acme", "warehouse": "wh", "schema": "atomic", "database": "snowplow", "transformedStage": "snowplow_stage" } }