Create an Snowflake connection for custom exports – Ometria Help Centre

If you're interested in exporting data from Ometria to Snowflake, please get in touch with your Customer Success Representative to discuss enablement and commercials.

This article explains how to set up a Snowflake connection to send a customised data export from Ometria.

Ometria sends your data directly to your Snowflake account using Snowflake's native data sharing. No file transfers or pipelines are needed on your side.

Note: Snowflake connections are set up by Ometria, not self-service. Once your connection is ready, it will be available to select when you create an export. To get started, contact your Ometria account manager or support.

Note: Your Snowflake account must be hosted on AWS in the EU (Ireland) — eu-west-1 region to receive the share directly. Snowflake's native data sharing only works between accounts in the same cloud and region. If your account is on a different cloud or region, contact your Ometria account manager or support.

Before you begin

To set up your connection, we'll need your Snowflake account identifier. Gather the following and share it with your Ometria contact.

1. Find your Snowflake account identifier

Your account identifier is in the format orgname.accountname.

To find it:

Sign in to your Snowflake account.
Select your account name in the bottom-left corner.
Select Copy account identifier.

See Snowflake's documentation: Account identifiers.

2. Make sure your Snowflake account can accept data shares

Your Snowflake account must be able to accept inbound data shares from Ometria. This is enabled by default for most Snowflake accounts.

If you're unsure, check with your Snowflake account administrator.

3. Share your account identifier with Ometria

Send your Snowflake account identifier to your Ometria account manager or support. We'll use it to set up your Snowflake connection. Once it's ready, you'll be able to select it when creating an export.

Create a Snowflake data export

After we've set up your connection, complete the steps for creating an export and choosing your data fields.

In the second page of the export setup, select Snowflake as your connection type, then select your Snowflake connection from the dropdown.

Note: If you don't see a Snowflake connection in the dropdown, it hasn't been set up yet. Contact your Ometria account manager or support to arrange it.

Select Next.

Accept the data share in Snowflake

Once your connection is set up and your first export is scheduled, Snowflake creates a data share with your account. You need to accept it before your exports start arriving.

You'll need to use a role that can import shares — ACCOUNTADMIN, or a role granted the IMPORT SHARE privilege.

In Snowsight:

In the navigation menu, select Data sharing > External sharing.
Select the Shared with you tab.
In the Ready to Get section, select the share from Ometria.
Enter a name for the database that Ometria data will be written to, choose which roles can access it, then select Get Data.

Alternatively, you can create the database from the share with SQL (run as ACCOUNTADMIN or a role with IMPORT SHARE):

CREATE DATABASE <database_name> FROM SHARE <ometria_account>.<share_name>;

You can find the Ometria account identifier and share name by selecting your Snowflake connection in the Connections tab in Ometria.

See Snowflake's documentation: Consume imported data.

Note: The data share will only appear in Snowflake after your first export has been scheduled.

Next steps

You can now configure your export format.