ListTableNames 2025.3.28.13-SNAPSHOT¶

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.- 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 and will be farwarded to UNMATCHED relationship.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 with matching result attribute equal to ‘MATCHED’. The unmatched ones are moved to the UNMATCHED relationship with thematching result attribute equal to ‘UNMATCHED’. Processor generates a separate flow file for each discovered source table.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¶