I have an issue I have with the Snowflake target and it seems like it should be pretty straightforward but I cannot seem to sort it out. I want to use Meltano to copy a table from PostgreSQL to Snowflake, but not copy all columns. I have set the select pattern in my

meltano.yml

config for the extractor, but the loader (`target-snowflake’) keeps adding all the columns from the source table every time. I cannot find anything that would stop it from doing so

I can’t seem to find the issue at the moment, but I think what’s happening is that the tap isn’t looking at what’s been selected when sending the schema. so while the records should be correct to what you’ve selected, the schema messages are showing everything. I think this would be considered a tap bug, but I bet there’s something we could do in Meltano for this problem down the line

it looks like it at least does not populate the columns, which is good. I poked at the taps too for snowflake and it seems the schema sync in there is a very much intentional thing

This old thread indicates similar behavior https://meltano.slack.com/archives/CFG3C3C66/p1600722104028300?thread_ts=1600215032.196300&cid=CFG3C3C66