Snowflake Data Cloud Connector

Back Next

Troubleshooting an issue for truncating target table

When you run a Snowflake mapping with the Truncate Target Table option enabled in the Target transformation, the mapping doesn't truncate the target table.: This issue occurs in the following types of assets when the
Autocommit
session property is set to false in the Snowflake user account:
Mappings
Mappings enabled for
SQL ELT optimization
Mappings in advanced mode enabled for
SQL ELT optimization

To troubleshoot this issue, perform one of the following steps:
Set the
Autocommit
session property to
true
in the Snowflake user account.
For more information about the
Autocommit
session property, see AUTOCOMMIT in the Snowflake documentation.
Set the
Autocommit
property to
true
in the
Additional JDBC URL Parameters
field of the Snowflake Data Cloud connection.