If you override the SQL and the role of a Snowflake object, verify that the override role has access to the table selected in the mapping.

To override the SQL and the role, you can perform one of the following tasks:

Grant the overriding role with the same access permissions as the role used for the Snowflake object that you selected in the mapping.
Specify an override to the table from the advanced properties. The specified override table is used in the design time and the SQL override takes precedence at runtime.

If you select a Snowflake object in a mapping and you specify both an SQL override and also override the database, schema, and role from the advanced properties, and the table does not exist in the overriding database, the mapping fails with a

table1 not found

error.

Specify a valid table name that corresponds to the overriding database and schema name.

The SQL override ports must be the same as the connected ports in the field mapping.