Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.omni.co/llms.txt

Use this file to discover all available pages before exploring further.

Omni can connect to your Snowflake instance in Amazon Web Services (AWS) or Azure via PrivateLink. In this configuration, Omni establishes an encrypted connection from our network to the Snowflake network.

​
Requirements

To follow the steps in this guide, you’ll need:
  • Snowflake Business Critical or higher (PrivateLink is not available on Standard or Enterprise editions)
  • A Snowflake user with the ACCOUNTADMIN role
Additionally, your Snowflake account should be on the same cloud provider as your Omni instance. For example, if Omni is hosted on AWS, your Snowflake account should also be on AWS.

​
Setup

The setup process is slightly different between AWS and Azure. Follow the section for your Snowflake account’s cloud provider.

​
AWS setup

Before Omni can provision anything, Snowflake must authorize Omni’s connection at the AWS account level. You’ll need to open a support ticket with Snowflake to start this process, as self-service SYSTEM$AUTHORIZE_PRIVATELINK is not available for third-party vendors like Omni on AWS.
1
Open a Snowflake support case asking them to add Omni’s AWS account ID 767117061426 to your account’s PrivateLink allow list.Reference Snowflake’s AWS PrivateLink documentation for more information.
2
Once Snowflake confirms the authorization, as ACCOUNTADMIN, run the following in Snowflake and save the JSON output:
select SYSTEM$GET_PRIVATELINK_CONFIG();
3
Contact Omni support with:
  • The JSON output from step 2
  • Your Snowflake account’s AWS region
4
Omni will create the AWS VPC endpoint and finish wiring up your Snowflake connection. Omni will notify you when the connection is ready to use.

​
Azure setup

On Azure, Omni creates the Private Endpoint first, and you authorize it after the fact by running SQL commands that Omni provides.
1
As ACCOUNTADMIN, run the following in Snowflake and save the JSON output:
select SYSTEM$GET_PRIVATELINK_CONFIG();
2
Contact Omni support with:
  • The JSON output from step 1
  • Your Snowflake account’s Azure region
3
Omni will create the Azure Private Endpoint.
4
Omni will also send you two SQL commands that look like the following:
select SYSTEM$AUTHORIZE_PRIVATELINK('<pe-resource-id>', '<federated-token>');
select SYSTEM$AUTHORIZE_STAGE_PRIVATELINK_ACCESS('<pe-resource-id>');
Run both commands in Snowflake as ACCOUNTADMIN. The Private Endpoint connection will move from Pending to Approved.
5
Omni will finish wiring up your Snowflake connection. Omni will notify you when the connection is ready to use.

​
References