snowflake loader needs private key to authenticate

[AlessandroLorenzi]

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"
    }
  }