Snowflake

Connect Codatum to Snowflake to run SQL and manage data. For an overview of connections in general, see Connection.

Preparing Snowflake

1. Create a key pair and set the public key on the Snowflake user you'll use for the connection (see Snowflake's key pair authentication guide).
2. Grant the following privileges to the role assigned to the user:
   • Warehouse: USAGE
   • Database: USAGE
   • Schema: USAGE
   • Table: SELECT

Configuring Codatum

1. Open global nav > Workspace settings > Data management > Connections, then select New connection.
2. Select Snowflake.
3. Enter a Connection name.
4. Select an Access level.
5. Enter the following.

Item	Description
Organization name	The name of your Snowflake organization (see account identifier)
Account name	The name of your Snowflake account (don't confuse this with the full account identifier, which includes the organization name)
Username (login name)	The login name of the user you prepared
Role	The name of the role you prepared
Warehouse name	The name of the warehouse you prepared
Database name	The default database used when statements run (this doesn't limit which tables or schemas can be referenced in SQL)
Authentication method	Key-pair authentication (currently the only option)
Private key	The entire private key, including -----BEGIN PRIVATE KEY----- through -----END PRIVATE KEY-----
Passphrase (if the private key is encrypted)	Enter only if the private key is encrypted

After entering these, run Test connect, then save the connection. On the sync targets screen shown after saving, select the databases/schemas to sync (Table metadata sync). You can also skip this step.

Network

Codatum doesn't provide a fixed IP address for connections. If your Snowflake setup requires IP allowlisting, contact Codatum support.