Delete Tables - Maia Documentation

The Delete Tables orchestration component lets you 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

Snowflake
Databricks
Amazon Redshift
Google BigQuery

string

required

A human-readable name for the component.

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.

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.

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.

object selector

required

Select tables to delete.

boolean

required

Yes: If a table doesn’t exist, ignore it.
No: If a table doesn’t exist, generate an error.

drop-down

Select a Databricks Unity Catalog. The special value [Environment Default] uses the catalog defined in the environment. Selecting a catalog will determine which databases are available in the next parameter.

drop-down

required

The Databricks schema. The special value [Environment Default] uses the schema defined in the environment. Read Create and manage schemas to learn more.

object selector

required

Select tables to delete.

boolean

When Yes, the component will fail if any of the tables selected for deletion are managed tables.

string

required

A human-readable name for the component.

drop-down

required

Select the table schema. The special value [Environment Default] uses the schema defined in the environment. For more information on using multiple schemas, read Schemas.

object selector

required

Select tables to delete.

boolean

required

Yes: If a table doesn’t exist, ignore it.
No: If a table doesn’t exist, generate an error.

boolean

required

Yes: Drop dependent objects such as any dependent views that have been manually created.
No: Do not drop dependent objects. The component will fail at runtime if such objects exist and the table will not be removed.

string

required

A human-readable name for the component.

drop-down

required

The Google Cloud project that owns the BigQuery dataset. The special value [Environment Default] uses the Google Cloud project defined in the environment. For more information, read Creating projects.

drop-down

required

The Google BigQuery dataset containing the tables to delete. The special value [Environment Default] uses the dataset defined in the environment.

object selector

required

Select tables to delete.To use grid variables, toggle Use Grid Variable on. For more information, read Grid variables.

boolean

required

Yes: If a table doesn’t exist, ignore it.
No: If a table doesn’t exist, generate an error.