Snowflake Setup and Configuration (using storage integration)

Prerequisites

For Exporting Data from Inflection to Snowflake

Admin access to your Inflection account
Snowflake account credentials
Service account with appropriate permissions
Key-pair authentication credentials (recommended) or username and password
The user running the SQL queries for the setup should have ACCOUNTADMIN role access

For Importing Data from Snowflake to Inflection

Admin access to your Inflection account
Snowflake account with ACCOUNTADMIN role or MANAGE GRANTS privilege
Database containing source tables that meet Inflection schema requirements
Key-pair authentication credentials (recommended) or username and password
The user running the SQL queries for the setup should have ACCOUNTADMIN role access

Important: Snowflake is deprecating single-factor password authentication for service users. By August-October 2026, all service users (TYPE=SERVICE) must use key-pair authentication. Learn more in Snowflake’s Password Deprecation Timeline.

Import Snowflake Data to Inflection

Set Up Import Connection in Inflection

Navigate to Connections → Data Connections
Click Add new connection

Add new connection button on the Data Connections page

Enter connection details:
Choose your authentication method: Option A: Key-Pair Authentication (Recommended):
- Account name - a human-friendly name for this particular Snowflake import
- Database - name of the database where all the Inflection-ready tables are present
- Username - username of the service account
- Private key - RSA private key (2048-bit minimum) in PEM format
- Private key passphrase (if applicable) - for encrypted private keys
Reference: Here is the document from Snowflake to generate your Private Key
Option B: Username & Password Authentication
- Account name - a human-friendly name for this particular Snowflake import
- Database - name of the database where all the Inflection-ready tables are present
- Username, Password - authentication credentials for the Snowflake service account
Integration setup
1. Run the SQL script provided, get the STORAGE_AWS_IAM_USER_ARN and STORAGE_AWS_EXTERNAL_ID values from the query result, provide them in the corresponding text boxes and submit

Set up Snowflake to allow Inflection read

You’ll need to be logged in as an ACCOUNTADMIN or an account that has MANAGE GRANTS. Inflection will need access to the Database, Schema, Tables, Views and Warehouse that the data is in. While the below steps defines default resources, you can define any user, role, warehouse you’d like.

Create warehouse

CREATE WAREHOUSE "INFLECTION_WAREHOUSE"
  WITH WAREHOUSE_SIZE = 'XSMALL'
    WAREHOUSE_TYPE = 'STANDARD'
    AUTO_RESUME = TRUE;

Create Role for Inflection

CREATE ROLE INFLECTION_ROLE
   COMMENT = 'Access on inflection schema to maintain state between syncs';

Create User for Inflection Choose based on your authentication method: For Key-Pair Authentication (Recommended):

-- Step 1: Create user without password
CREATE USER INFLECTION_USER
  DEFAULT_ROLE = INFLECTION_ROLE
  DEFAULT_WAREHOUSE = "INFLECTION_WAREHOUSE"
  COMMENT = 'User for inflection operations';

-- Step 2: Assign public key (replace with your actual public key)
ALTER USER INFLECTION_USER 
  SET RSA_PUBLIC_KEY='<your_public_key_without_BEGIN_END_delimiters>';

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

For Username & Password Authentication:

CREATE USER INFLECTION_USER
MUST_CHANGE_PASSWORD = FALSE
DEFAULT_ROLE = INFLECTION_ROLE
DEFAULT_WAREHOUSE = "INFLECTION_WAREHOUSE"
PASSWORD = "my_strong_password"
COMMENT = 'User for inflection operations';

Create an inflection schema in the database. The database refers to the database where the source data lives. Replace <DB_NAME> with the database name.
CREATE SCHEMA <DB_NAME>.INFLECTION COMMENT = 'Schema for Inflection operations';

Granting permissions and access.

Role to User

GRANT ROLE INFLECTION_ROLE TO USER INFLECTION_USER;

Warehouse usage to Role

GRANT USAGE ON WAREHOUSE "INFLECTION_WAREHOUSE" TO ROLE "INFLECTION_ROLE";

Grant access to the inflection schema

GRANT USAGE, CREATE TABLE, CREATE VIEW
  ON SCHEMA <DB_NAME>.INFLECTION
  TO ROLE INFLECTION_ROLE;
GRANT ALL 
	ON FUTURE TABLES IN SCHEMA INFLECTION 
	TO ROLE INFLECTION_ROLE;

Grant access to the source data

#Permission to list schemas in the database (USAGE: Access to USE and SHOW ops)
GRANT USAGE
	ON DATABASE <DB_NAME>
	TO ROLE INFLECTION_ROLE;

#Permission to list tables and views in the database
GRANT USAGE
	ON SCHEMA <DB_NAME>.<SCHEMA_NAME>
	TO ROLE INFLECTION_ROLE;

#Permission to read from the table
GRANT SELECT
  ON TABLE <DB_NAME>.<SCHEMA_NAME>.<TABLE_NAME>
  TO ROLE INFLECTION_ROLE;

FAQ: My data is in multiple tables. Does Inflection support views?

Certainly. You can create the view in any shape and provide access to it to the inflection user like any table.

#Create a view
CREATE VIEW <DB_NAME>.<SCHEMA_NAME>.<VIEW_NAME> AS
	SELECT * FROM <DB_NAME>.<SOURCE_SCHEMA_NAME>.<SOURCE_TABLE_NAME>

#Permission to read from the view
GRANT SELECT
  ON VIEW <DB_NAME>.<SCHEMA_NAME>.<VIEW_NAME>
  TO ROLE INFLECTION_ROLE;

Keep in mind that any breaking changes from the tables that the view is generated from i.e. deleting a column, will break the view which in turn will break the connection.

Export Inflection Data to Snowflake

Set up Export Connection in Inflection

Navigate to Connections → Data Connections
Click Add new connection

Select Snowflake as your destination platform.
Select connection type: Choose Export Data to Snowflake.
Enter your Snowflake credentials
- Choose your authentication method.
  - Key-Pair Authentication (Recommended):
    - Connection name:
    - Account name: a human-friendly name for this Snowflake connection
    - Username: username of the service account that connects to Snowflake
    - Private key: RSA private key (2048-bit minimum) in PEM format
      See Snowflake’s key-pair authentication guide to generate your private key.
    - Private key passphrase (if applicable): for encrypted private keys
    - Database and Schema: name of the database and schema where Inflection should write data
  - Option B: Username & Password Authentication
    Password authentication will be deprecated by August. Migrate to key-pair authentication before this deadline.
    - Connection name:
    - Account name: a human-friendly name for this Snowflake connection
    - Username, Password: authentication credentials for a service account
    - Database and Schema: name of the database and schema where Inflection should write data
Click Create Connection
Integration setup
1. Run the “Storage Setup SQL” script provided in Connection details, get the STORAGE_AWS_IAM_USER_ARN and STORAGE_AWS_EXTERNAL_ID values from the query result, provide them in the corresponding text boxes and submit

The connection will remain in inactive state until credentials and destination tables are validated by the Inflection team.

Create Export Tables in Snowflake

Inflection provides a custom SQL script tailored to your configuration. Run this script to create the export tables in your data warehouse.

Navigate to Connections → Select the Snowflake Export connection
Click Connection Details
Click Copy code in the Table Creation SQL section

Copy code button in the Table Creation SQL section of Connection Details

The script creates tables with the necessary structure and grants required permissions (INSERT, UPDATE, DELETE) for Inflection to write data.

Activate the Export Connection

Once you have saved credentials and created required tables in Snowflake, your setup is complete. The Inflection team will validate the setup and activate the sync. You will be notified once the sync has started and data is being sent.

Activation may take up to two business days. Please ensure your data team notifies you once your tables are set up in your data warehouse.

Changing from Username Password to Key Pair Authentication

To change your connection :

Go to your snowflake connection (import or export)
Go to “Connection Settings” tab
1. Snowflake Export
2. Snowflake Import
Click on the “Edit Details” button in top right
Change the “Authentication Type” to “Key “Pair.”
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
  Reference: Here is the document from Snowflake to generate your Private Key
Click on save

Your connection will now use key pair for authentication.Follow these steps for both IMPORT and EXPORT connections.

Getting Started

Settings

Connections

Database & Audiences

Journeys & Assets

Snowflake Setup and Configuration (using storage integration)

Prerequisites

For Exporting Data from Inflection to Snowflake

For Importing Data from Snowflake to Inflection

Import Snowflake Data to Inflection

Set Up Import Connection in Inflection

FAQ: My data is in multiple tables. Does Inflection support views?

Export Inflection Data to Snowflake

Set up Export Connection in Inflection

Create Export Tables in Snowflake

Activate the Export Connection

Changing from Username Password to Key Pair Authentication

​Prerequisites

​For Exporting Data from Inflection to Snowflake

​For Importing Data from Snowflake to Inflection

​Import Snowflake Data to Inflection

​Set Up Import Connection in Inflection

​FAQ: My data is in multiple tables. Does Inflection support views?

​Export Inflection Data to Snowflake

​Set up Export Connection in Inflection

​Create Export Tables in Snowflake

​Activate the Export Connection

​Changing from Username Password to Key Pair Authentication

Prerequisites

For Exporting Data from Inflection to Snowflake

For Importing Data from Snowflake to Inflection

Import Snowflake Data to Inflection

Set Up Import Connection in Inflection

FAQ: My data is in multiple tables. Does Inflection support views?

Export Inflection Data to Snowflake

Set up Export Connection in Inflection

Create Export Tables in Snowflake

Activate the Export Connection

Changing from Username Password to Key Pair Authentication