Export Sequence data into your Snowflake instance
securityadmin
and sysadmin
roles.(To check your account for these roles, run SHOW GRANTS TO USER <your_username>;
and review the role column.)If your Snowflake data warehouse is using Snowflake Access Policies, you will need to have the data-syncing service’s static IP available to complete Step 2.Review and make any changes to the following setup script:
Configure the Snowflake access policy
SHOW NETWORK POLICIES;
If there are no existing Snowflake Network Policies (the SHOW query returns no results), you can skip to Step 3. If there is an existing Snowflake Network Policy, you must alter the existing policy or create a new one to safelist the data transfer service static IP address. Use the CREATE NETWORK POLICY command to specify the IP addresses that can access your Snowflake warehouse.CREATE NETWORK POLICY <transfer_service_policy_name> ALLOWED_IP_LIST = ('5.4.7.8/32');
ALLOWED_IP_LIST
will be blocked.Snowflake does not allow setting a network policy that blocks your current IP address. (An error message results while trying to create a network policy that blocks the current IP address.) But be careful when setting your first network policy.Add your destination