ext_snowflake.
For general transformation execution and monitoring issues, see Troubleshooting transformations.
Errors while registering
403 because the feature is not enabled
403 because the feature is not enabled
- The API returns HTTP
403. - The message indicates the feature is not enabled for the project.
403 on an otherwise valid request
403 on an otherwise valid request
- The API returns HTTP
403. - The message indicates the subject does not have a
READ,WRITE, orUSEaction.
transformationsExternalDataSourcesAcl actions, or the source dataSetId is outside your capability scope.Resolution- Grant
transformationsExternalDataSourcesAclwith the actions you need (READ,WRITE,USE). - If the source has a
dataSetId, scope the capability withdatasetScopethat includes that data set. - Retry the request with the updated group.
Invalid or missing settings
Invalid or missing settings
- The API returns HTTP
400. - A required field is empty, or the account identifier is rejected.
accountIdentifier,userName,roleName, orwarehouseNameis missing.accountIdentifierincludes a URL scheme, a path, or spaces. A common case is pastinghttps://myorg-myaccount.snowflakecomputing.com.dataSetIddoes not exist or is not accessible.
- Supply all four values.
- Use
myorg-myaccount, with no URL. - Use a data set you can access.
expiryTime is out of range
expiryTime is out of range
- The API returns HTTP
400on create or rotate. - The message indicates
expiryTimeis out of range.
expiryTime is epoch milliseconds.409: externalId already exists
409: externalId already exists
409, and no items in the request are created.Cause- The
externalIdalready exists in the project. This endpoint is create-only; it does not update an existing source. - Or two items in the same request use the same
externalId.
- If the
externalIdalready exists, delete that source and register a replacement, or use a newexternalId. - If the
itemsarray repeats anexternalId, keep only one of each. - Retry the request.
Jobs fail after a successful rotation
Jobs fail after a successful rotation
- Rotate or Generate public key succeeds.
- The next job fails to authenticate.
Errors when a job runs
Authentication failure or invalid Snowflake credentials
Authentication failure or invalid Snowflake credentials
- Preview fails with an invalid JWT token.
- The job fails with
Authentication failure connecting to Snowflake....
- Run
DESC USERand confirmRSA_PUBLIC_KEY_FPis set. - Copy the current public key from the integration details page and send it to your Snowflake admin. See Register the public key.
- Confirm the user, role, and warehouse names match the registered connection.
- If the connection has expired, rotate the public key and send the new key to your Snowflake admin. Run the transformation again after the admin registers it.
Table not found or permission denied
Table not found or permission denied
Snowflake table not found or not authorized... or Permission denied accessing Snowflake....CauseThe table does not exist, or the service role lacks privileges. Snowflake does not distinguish the two cases.Resolution- Check the database, schema, and table names, including case. Unquoted Snowflake names are uppercase.
- Grant
USAGEon the database, schema, and warehouse, andSELECTon the table.
Warehouse is suspended
Warehouse is suspended
AUTO_RESUME is not enabled, or the service role lacks USAGE on the warehouse.Resolution- Set
AUTO_RESUME = TRUEon the warehouse, or ask a Snowflake admin to resume it. - Confirm the service role has
USAGEon the warehouse. - Rerun the transformation.
Account host cannot be reached
Account host cannot be reached
Could not reach the configured Snowflake account... or Could not resolve the Snowflake account host....CauseaccountIdentifier is wrong. Connections cannot be edited in place.Resolution- Delete the connection and register it again with the account identifier, not a Snowflake URL.
- Rerun the transformation.
Network policy rejected the connection
Network policy rejected the connection
Snowflake rejected the connection due to a network policy....CauseA Snowflake network policy blocks CDF.Resolution- Contact Cognite Support for the CDF egress IP addresses. Ask your Snowflake admin to allowlist them on the network policy.
- Rerun the transformation.
Statement timed out
Statement timed out
Snowflake statement timed out....CauseThe query ran longer than the warehouse statement timeout.Resolution- Narrow the query, or use
is_new()when a version column exists. - Ask a Snowflake admin to raise
STATEMENT_TIMEOUT_IN_SECONDSon the warehouse.
Snowflake is temporarily unreachable
Snowflake is temporarily unreachable
Snowflake is temporarily unreachable....CauseA transient network error.Resolution- Retry the transformation later.
- Do not change connection settings solely for a transient failure.
Snowflake is not configured on this cluster
Snowflake is not configured on this cluster
Snowflake is not configured on this cluster....CauseSnowflake external data sources are not configured on this cluster.ResolutionContact Cognite Support. This is not a problem with the query or the connection.Unclassified Snowflake request failed
Unclassified Snowflake request failed
Snowflake request failed (SQLState ..., error code ...).CauseSnowflake returned an error that CDF does not classify.Resolution- Read the detail in the message.
- If the cause is unclear, contact Cognite Support and include the full message.
Cannot use external data source or missing USE
Cannot use external data source or missing USE
USE action.CauseThe source externalId is wrong or missing, or the running identity lacks transformationsExternalDataSourcesAcl:USE (including data set scope).Resolution- Confirm the
externalIdin SQL matches a registered source. - Grant
USEontransformationsExternalDataSourcesAclto the identity that runs the transformation. - If the source has a
dataSetId, ensure data set scope includes it.
Errors in SQL
Invalid ext_snowflake arguments
Invalid ext_snowflake arguments
- The query fails with a message that
ext_snowflake()expects externalId, database, schema, and table. - A parameter must be a string literal.
- Use four arguments, in order:
externalId, database, schema, and table. - Pass only quoted string literals—no column references, variables, or expressions.
- Use
ext_snowflakeonly as aSELECTsource.
is_new with table alias only
is_new with table alias only
- The query rejects
is_new('cursor', a)for a Snowflake source. - The message indicates
is_newwith a table alias is only supported for data modeling sources.
is_new requires a version column, not the table alias. The alias form is for data modeling sources (cdf_nodes, cdf_edges, cdf_data_models).Resolution- Pass a column such as
a.LAST_UPDATED_TIME(or your table’s equivalentTIMESTAMPor epoch-millisecondLONGcolumn). - See Read Snowflake data in transformations and SQL patterns and best practices.
Limits
Default volume and concurrency limits for this path are Cognite-managed. There is no customer configuration page for these limits.Snowflake concurrency or read volume limit exceeded
Snowflake concurrency or read volume limit exceeded
- Reduce concurrent transformations that read Snowflake, or reduce scan volume with
is_new()when a version column exists. - Contact Cognite Support to request a higher limit.
Known limitations
Deleted rows stay in CDF
Deleted rows stay in CDF