Ellis Valentiner
09/18/2024, 3:55 PMstream_maps overrides the configuration in select?Edgar Ramírez (Arch.dev)
09/18/2024, 3:57 PMEllis Valentiner
09/18/2024, 4:02 PMcustomer_id column to each table when we replicate it. Currently we list each table in both the select and again in the stream_maps where we have a simple customer_id: int("${CUSTOMER_ID}").
Example:
stream_maps:
table_one:
customer_id: int("${CUSTOMER_ID}")
table_two:
customer_id: int("${CUSTOMER_ID}")
some_other_field: 1
We would like to use glob to reduce the redundancy. Like this:
stream_maps:
'*':
customer_id: int("${CUSTOMER_ID}")
table_two:
some_other_field: 1
However when we do this then Meltano tries to replicate other tables that are not included in our select.Ellis Valentiner
09/18/2024, 4:09 PMselect:
- table_one.*
- table_two.*
but when we use the * in stream_maps then we start to also replicate other tables (e.g. table_three)Ellis Valentiner
09/18/2024, 4:14 PM