Can someone tell me how I can filter which tables ...
# troubleshooting
n
Can someone tell me how I can filter which tables are loaded by the postgres extractor? I just need 2-3 tables of a schema, not everything
t
I think you want to control that using the 'select' options in the tap
n
I found the following example: https://github.com/robmoore/meltano-postgres-example/blob/master/meltano.yml When I enter something in that format meltano tells me there is no streams marked for sync. How should I i.e. add a table with the name country? is it public.country? oder country? or country.*? or something else?
t
You configure that with the
select
element in the
extractors
section. The exact format will depend on what the tap produces, unfortunately, but it's probably something like country.*
Technically the format there is
stream.field
, so if the stream name is country and you want all fields it'll be
country.*
. The tap will determine the stream name though. From the example you linked to I'd expect it to be country.*