Hello Channel, I am trying unload a postgres table into a jsonl as a test. but even with the entity selected in the meltano.yml file, is not producing anything. Please advise This is the output

Hi @oscar_gonzalez! Can you check the output of

meltano select tap-postgres --list --all

?

They are there

Under

Selected attributes

is there anything that's not

excluded

?

Everything is excluded?

Those two attributes should be displayed as

[selected ] ...

. Maybe you're missing the postgres schema name?

select:
- <pg schema name>-transunion_profile_enriched_characteristics_v2.id
- <pg schema name>-transunion_profile_enriched_characteristics_v2.transunion_profile_id

thanks, let me check it out

It's a setting specific to

pipelinewise-tap-postgres

for limiting which schemas will be inspected for tables and columns. From the docs

Comma separated schema names to scan only the required schemas to improve the performance of data extraction.

thanks, I will check it out

Also, if you look at the output of

meltano select tap-postgres --list --all

you may be able to see the complete

<pg schema name>-transunion_profile_enriched_characteristics_v2.id

stream name (being excluded)