Author: Matillion
Date Posted: Jun 5, 2025
Last Modified: Jun 6, 2025
Check Network Access to Snowflake Hosts
Check the network connection between your Data Productivity Cloud agent and your Snowflake hosts.
Use this pipeline whenever you need to check that your Data Productivity Cloud agent has access to all Snowflake hosts and ports that are relevant for your Snowflake account.
Typically, Snowflake customers use a firewall to prevent unauthorized access. By default, your firewall might prevent your Data Productivity Cloud agent from accessing Snowflake. You must update your firewall’s allowed list to include the hostnames and port numbers for the URL of your Snowflake account, stages, and other hosts used by Snowflake.
The hostnames and port numbers are provided in two database views:
- SYSTEM$ALLOWLIST, the default
- SYSTEM$ALLOWLIST_PRIVATELINK, when using AWS PrivateLink, Azure Private Link or Google Cloud Private Service Connect
The pipeline will check connectivity to all the Snowflake hostnames and port numbers. Check the Task Monitor output for confirmation.
How to use the pipeline
To use the pipeline, run it from another pipeline and use Set Scalar Variables to set the IsPrivateLink flag.
Parameters
| Parameter | Description |
|---|---|
| IsPrivateLink | Set to true if you are using private connectivity |
Downloads
Licensed under: Matillion Free Subscription License
- Download Check-Network-Access-Snowflake.zip
- Target: Snowflake