ListTableNames 2025.5.31.15¶

Bundle¶

com.snowflake.openflow.runtime | runtime-database-cdc-processors-nar

Description¶

Fetches all source table names and matches them with one of the possible configurations:- regexp expression e.g. “(?i)customer.(orders|payments)” - it matches names in case insensitive way. It would match both “CUSTOMER.ORDERS” and “customer.orders” source table names. The MicrosoftSQL Server accepts FQN containing database name e.g. (?i)prod.customer.(orders|payments)- comma separated list of source table names. e.g. “customer.orders, customer.payments”. It matches source table names in case sensitive way i.e. “customer.orders” source table will beforwarded to MATCH relationship but “customer.ORDERS” won’t match. The Microsoft SQL Server accepts FQN containing database name e.g.”prod1.customer.orders, prod1.customer.payments”.Configuration is passed as a FlowFile attribute. Source table name is represented as <schema_name>.<table_name> so both inputs should take that into consideration.Matched source table names are forwarded to MATCHED relationship. Processor generates a single flow file with matching tables.Disclaimers- Postgresql allows to define database object names in case sensitive or case insensitive way. When user creates a table using following query ‘CREATE TABLE ORDERS(id int not null)’ theninternally Postgresql stores it using lower case letters i.e. orders. To enforce case sensitivity user has to wrap the table name with double quotes i.e. ‘CREATE TABLE “ORDERS”(id int notnull)’. This is important aspect when configuring table that we would like to replicate.

Tags¶

Input Requirement¶

REQUIRED

Supports Sensitive Dynamic Properties¶

false

Properties¶

Relationships¶

Writes attributes¶