SparkConnectGrpcException

[ms_221]

Getting the below error when reading the snowflake tables data .We are successfully able to connect the respective tables .cannot display the data and other transformations.

SparkConnectGrpcException: (net.snowflake.client.jdbc.SnowflakeSQLException) Incoming request with IP/Token 44.215.162.5 is not allowed to access Snowflake.

[filipniziol · Accepted solution]

Hi @ms_221 ,

The SparkConnectGrpcException you're encountering, specifically mentioning that the incoming request with a certain IP/Token is not allowed to access Snowflake, suggests an issue related to network policies or access control within Snowflake. This error typically indicates that the IP address from which the request is made is not whitelisted in Snowflake's network policies, or the token used for authentication does not have the necessary permissions.

To resolve this issue, start with:

1. Whitelist IP Address: Ensure that the IP address mentioned in the error message is whitelisted in Snowflake's network policy settings. Snowflake allows you to define network policies that specify which IP addresses can access your Snowflake account. You may need to add the IP address to an existing policy or create a new policy that includes this IP.

2. Review Snowflake Access Token Permissions: If you are using OAuth or any token-based authentication, ensure that the token has the correct permissions to access the required resources within Snowflake. The token should have permissions not just for connecting but also for reading data from the tables you're trying to access.