Prerequisites before you setting up Snowflake in Scopum
Step 1: Configure network access settings
To allow Scopum to connect to Snowflake, Scopum's IP addresses must be added to the list of allowed IPs in your Snowflake network policy. To do so, follow the steps below or ask your security or Snowflake administrator to take care of it.
Create the network policy and add Scopum IP addresses (‘184.108.40.206/32’,‘220.127.116.11/32’) to the list of allowed IP addresses:
CREATE NETWORK POLICY <scopum_policy>
ALLOWED_IP_LIST = ('18.104.22.168/32','22.214.171.124/32','<your-current-ip-address>');
In this example, you need to replace
<scopum_policy> with a name for the policy, and
<your-current-ip-address> with the current IP address of the computer you’re working on. This is required for the next step.
Apply the network policy to your Snowflake account. Note Your current IP address must be included in the Allowed IP List to run this command successfully:
ALTER ACCOUNT SET NETWORK_POLICY = <scopum_policy>;
If you encounter an error, ensure that your current IP address is in the Allowed IP List and try again. Contact Snowflake support if errors persist.
You can read more about Snowflake's Network Security Policies here
Step 2(optional): Create separate Snowflake user for Scopum
We recommend to create a separate user in Snowflake, that is only used for the data sync within Scopum. This allows for more granular access rights.
The next step is the setup of Snowflake as your data target in Scopum.