Skip to main content
This component allows you to delete a list of tables in a single operation. It generates a single DROP TABLE statement, optionally with IF EXISTS and CASCADE modifiers. Note that the Delete Tables component has more in common with the Snowflake DROP TABLE statement than the DELETE statement. For detailed information on DROP TABLE in Snowflake, refer to the Snowflake documentation. This component may be used inside a transaction. However, on rollback, deleted tables will NOT be restored.

​
Properties

​
Name
string
required
A human-readable name for the component.
​
Warehouse
drop-down
The Snowflake warehouse. The special value [Environment Default] uses the warehouse defined in the environment. Read Snowflake’s Virtual Warehouses documentation to learn more.
​
Database
drop-down
required
The Snowflake database. The special value [Environment Default] uses the database defined in the environment. Read Databases, Tables and Views - Overview to learn more.
​
Schema
drop-down
required
The Snowflake schema. The special value [Environment Default] uses the schema defined in the environment. Read Database, Schema, and Share DDL to learn more.
​
Target Table
dual listbox
required
Select one or more tables to delete.
​
Ignore Missing
boolean
required
  • Yes: If a table doesn’t exist, ignore it.
  • No: If a table doesn’t exist, generate an error.