Troubleshooting

ADF and Snowflake

General Guide

1. does the ADF user have rights to create a stage in the target schema?
2. Are all identifiers capitalized?

OutOfRange error (outdated)

Sometimes an OutOfRange error is received. Until now it was mostly caused by the ADF "SHOW REGION LIKE '%azure%'. The resultset for a non Azure instance is then empty and the ADF produces an OutOfRange error.

Schema 'Y."X"' does not exist or not authorized

One possibility is that the user of the ADF is actually not authorized, in which case this needs to be fixed. Alternatively, the problem may be the quotation marks that the ADF uses. The target scheme is used as is. However, since Snowflake is not case sensitive, this can cause errors.

Solution

Check that all Snowflake entity names relevant for the ETL process are uppercase.