<aside> ⚠️

Important: Snowflake is deprecating single-factor password authentication for service users. By August-October 2026, all service users (TYPE=SERVICE) will be required to use key-pair authentication or other secure methods. Password-only authentication will no longer work for programmatic access.

📚 Learn more: Snowflake's Password Deprecation Timeline

</aside>

Inflection supports 2 types of operations with Snowflake:

1. Exporting Inflection marketing data to Snowflake
2. Importing Data from Snowflake to Inflection

Export Inflection Data to Snowflake

For information on tables and schemas that inflection exports to Snowflake, please read this

Set up Export to Snowflake in Inflection

Set up Snowflake to accept Inflection Data

Submit Setup for Activation

And that’s it! Once you are set up, you can monitor sync health by following our guide here

Import Data from Snowflake to Inflection

For information on generic import guidelines, please read this

Set up Inflection to read from Snowflake

Set up Snowflake to allow Inflection reads

<aside>

Changing from Username Password to Key Pair Authentication

To change your connection :

1. Go to your snowflake connection (import or export)

2. Go to “Connection Settings” tab

   1. Snowflake Export

      

   2. Snowflake Import

      

3. Click on the “Edit Details” button in top right

4. Change the “Authentication Type” to “Key “Pair.”

   

5. Update the following fields

   1. Private key - RSA private key (2048-bit minimum) in PEM format

   2. Private key passphrase (if applicable) - for encrypted private keys

   3. Database and Schema - name of the database and schema where Inflection should write data

      <aside> 📝

      Reference: Here is the document from Snowflake to generate your Private Key

      </aside>

6. Click on save

Your connection will now use key pair for authentication.

You need to follow these steps for both IMPORT and EXPORT connections.

</aside>