Snowflake

Add a Snowflake connection to export AIRIS activity reports. Activity reports can be exported in two ways:

• From the report page for manual, one-time exports
• From the scheduled batch for automatic, scheduled exports

Notes and limitations

Please note the following limitations when exporting data to Snowflake:

• Maximum number of rows: 10 million per table, per hour
• Maximum number of columns: 50 per table, per export
• To prevent performance issues, we strongly recommend limiting concurrent exports to 10 or less

In addition, the connected service requires time to process data before it's available for use, and this time can vary between different services. For example, a table with 5 million records and 50 columns can require 20-25 minutes to be fully uploaded and ready for use.

1. Set up key-pair authentication in Snowflake

If you haven't set up key-pair authentication in Snowflake, complete the following steps in Snowflake's guide for setting up key-pair authentication:

1. Generate the private key.
2. Generate a public key.
3. Store the public and private keys securely.
4. Grant the privilege to assign a public key to a Snowflake user.
5. Assign the public key to a Snowflake user.
6. Verify the user’s public key fingerprint.

2. Add the connection in the Appier console

In the Appier enterprise console, go to Common settings > Integration > Partner integrations, click Snowflake, then click + Connect Snowflake.

Enter a display name and Snowflake account identifier and connection details, then click Connect. For instructions on retrieving the required details, refer to the following Snowflake guides:

• Instructions for retrieving account identifiers (Identifier and Username)
• Instructions for retrieving connection details (Warehouse, Database, and Schema)