taylor_van_anne
08/16/2022, 7:10 PMtap-postgres
extractor. When I use this environment variable:
export TAP_POSTGRES__SELECT='["staging-emp.email", "staging-emp.emp_id"]'
and then check selected columns with meltano select tap-postgres --list
, the extractor correctly shows just these two fields I want extracted. But then when I run a meltano elt tap-postgres target-csv
, for example, it still pulls all of the fields in that table.
Is there a way to tell Meltano that I only want to select certain fields from the table?taylor_van_anne
08/16/2022, 8:07 PMmeltano select tap-postgres --list --all
to check which fields are being selected vs excluded, I see this as the output (screenshot). The columns marked “selected” are exactly what I want, but then the schema/table of the other fields that I don’t want are also green.taylor
08/16/2022, 8:56 PMtaylor
08/16/2022, 8:56 PMtaylor_van_anne
08/16/2022, 9:35 PM