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