- I keep getting the following connection error:
-
SNOWFLAKE_OOO - Error while connecting to Snowflake. net.Snowflake.Client.jdbc.SnowflakeSQLException:
IP <ip address> is not allowed to access Snowflake. Contact your local security administrator.
- This error can occur when your Snowflake account uses network policies and
you haven't configured one to allow Control Hub to communicate with your Snowflake account. It can also occur when a new
Control Hub IP address needs to be added to an existing network policy.
- For more information, see Snowflake Requirement for Network Policies.
- My job run or pipeline preview fails with the following error, saying that
the user name or password is incorrect:
-
com.streamsets.transformer.snowpark.SnowparkLauncherException: SNOWFLAKE_000 - Error while connecting to Snowflake: net.snowflake.client.jdbc.SnowflakeSQLException: Incorrect username or password was specified.
- The Snowflake credentials specified for your account are not valid. Maybe
there was a typo when you configured your credentials. Or, perhaps your
Snowflake password has changed.
- Update the Snowflake credentials associated with your StreamSets account, and then try the operation again.
- Data preview starts, but generates no data. The origin has the following
stage error:
-
TRANSFORMER_01 - Origin 'Operator: [Type: class com.streamsets.transformer.snowpark.origin.snowflake.table.TableOrigin id: <origin name>]' failed to while trying to produce data for following offsets: 'SQL compilation error: Object '<Snowflake table name>' does not exist or not authorized.'. Origin = [null, Offset = [Start: null End: null Generated Timestamp: <timestamp>]
- The specified origin is configured to read a table that does not exist.
Verify the correct name of the Snowflake table and update the table name in
the origin accordingly.
)
icon is disabled