Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
Snowflake Connector Error
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(6.4, 55.00000000000001%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPN%3C/text%3E%3C/svg%3E)
Phillip Neiman
0
Reputation points
How do I fix this error with Snowflake? They say they have whitelisted my IP address range but my ADF pipeline still fails with this message.
Operation on target SnowFlake_data to BlobStor CSV failed: ErrorCode=UserErrorFailedToConnectOdbcSource,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=ERROR [28000] Incoming request with IP/Token XX.XX.XXX.XX is not allowed to access Snowflake. Contact your account administrator. For more information about this error, go to https://community.snowflake.com/s/ip-xxxxxxxxxxxx-is-not-allowed-to-access. ERROR [28000] Incoming request with IP/Token XX.XX.XXX.XX is not allowed to access Snowflake. Contact your account administrator. For more information about this error, go to https://community.snowflake.com/s/ip-xxxxxxxxxxxx-is-not-allowed-to-access.,Source=Microsoft.DataTransfer.Runtime.GenericOdbcConnectors,''Type=System.Data.Odbc.OdbcException,Message=ERROR [28000] Incoming request with IP/Token XX.XX.XXX.XX is not allowed to access Snowflake. Contact your account administrator. For more information about this error, go to https://community.snowflake.com/s/ip-xxxxxxxxxxxx-is-not-allowed-to-access. ERROR [28000] Incoming request with IP/Token XX.XX.XXX.XX is not allowed to access Snowflake. Contact your account administrator. For more information about this error, go to https://community.snowflake.com/s/ip-xxxxxxxxxxxx-is-not-allowed-to-access.,Source=,'
Azure Data Factory
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(268.8, 8%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EST%3C/text%3E%3C/svg%3E)
Smaran Thoomu 32,520 Reputation points Microsoft External Staff Moderator2023-12-28T11:56:35.5433333+00:00 Welcome to Microsoft Q&A Platform. Thank you for posting your query.
Based on the error message indicates that your IP address is not allowed to access Snowflake. Even though Snowflake has whitelisted your IP address range, it is possible that the whitelist has not been applied correctly or that there is a delay in the application of the whitelist.
To fix this error, you can try the following steps:- Verify that your IP address range has been whitelisted correctly by contacting Snowflake support.
- Check if there is a delay in the application of the whitelist. Sometimes it can take a few minutes for the whitelist to be applied.
- Try connecting to Snowflake from a different network or IP address to see if the issue is specific to your network.
- Check if there are any firewall rules or network security groups that are blocking the connection to Snowflake.
- If you are using a VPN or proxy, make sure that it is configured correctly and that it is not causing any issues with the connection to Snowflake. If none of these steps resolve the issue, you may need to contact Snowflake support for further assistance.
Reference:
-
Smaran Thoomu 32,520 Reputation points Microsoft External Staff Moderator
2023-12-29T07:18:36.51+00:00 @Phillip Neiman We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
-
Smaran Thoomu 32,520 Reputation points Microsoft External Staff Moderator
2023-12-31T19:50:58.8433333+00:00 @Phillip Neiman We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Sign in to comment
Sign in to answer