Skip to main content

Table exists

Description

Table Exists checks whether a specified table is present in a database and returns true or false. Use this process entry to validate database structure before running dependent workflows — for example, confirming that a target table exists before a data load, or branching to a table creation step when the table is missing. This entry performs a single check; for repeated polling until a table appears, use the Evaluate Rows Number in a Table process entry instead.

Note: This process entry performs one check and then moves on. If you want to poll until the tables appear, use Evaluate rows number in a table process entry which has a polling interval parameter.

Configurations

Field NameDescription
Process Entry nameSpecify a unique name for the process entry, on the workspace area. A process entry can be placed on the canvas several times; and each instance of the entry must have a unique name.
ConnectionThe name of the connection to connect to the database.
Schema nameThe table's schema name.
Table nameThe table name to check for existence.