Snowflake Cloud Data Warehouse V2 Connector > Additional runtime configurations > SQL override scenarios from the advanced properties
  

SQL override scenarios from the advanced properties

When you specify both an SQL override and overrides to the database, schema, warehouse, or role from the advanced properties, consider the following override combinations based on your use case:

Use case 1: Mapping contains role and SQL override

If you select the Snowflake object, for example, table1, in a mapping, and you specify an override to the role and also an SQL override for the object from the advanced properties, the override role must have access to table selected in the mapping. The mapping fails if the role specified as an override does not have access to the table.
To make this use case work, you can perform one of the following tasks:

Use case 2: Mapping contains SQL override and also database, schema, and role overrides

If you select a Snowflake object, for example, table1, in a mapping, and include the following configurations:
In this use case, if the table does not exist in the overriding database, the mapping fails with a table1 not found error.
To make this use case work, specify a valid table name that corresponds to the overriding database and schema name.