I’m trying to connect my airflow dag to my snowflake using private_key_content.

Connection:

{
   conn_type: snowflake,
   host: <snowflake_host>,
   login: <snowflake_user>,
   password: null,
   schema: <snowflake_schema>,
   port: null,
   extra: {
       account: <snowflake_account>,
       database: <snowflake_database>,
       private_key_content: <private_key_content>,
       warehouse: <snowflake_warehouse>,
       role: <snowflake_role>
   }
}

I’m trying to use this snowflake connection to my SnowflakeOperator in my Dags. I’m trying to connect using key pair authentication but it returns an error:

snowflake.connector.errors.ProgrammingError: 251006: 251006: Password is empty