Hi all, Is it possible to force all table and col...
# troubleshooting
d
Hi all, Is it possible to force all table and column names to be lowercase by default. I have a postgres tap and target
e
Perhaps using https://sdk.meltano.com/en/latest/stream_maps.html and enumerating all the tables and columns, though not ideal 🫤. The other option at the moment is to write your own mapper that lower-cases all fields and stream names.
d
Thank you for the recommendation, I would prefer not to enumerate all of the tables and columns as the schema is constantly changing. With taht said do you have any docs you can point me to or examples for creating my own mapper ? Is this something I can do with a simple python script locally and just reference that? I believe you could do something simular to that with transformers.
a
I use
target_postgres
pipelinewise and I find all my stream names and column names end up lowercase any way (I definitely have sources with upper case names in them). Do you have a specific example when it's not ending up lower case in your target postgres db?
d
I'm using the meltano variant. I ended up writing a custom mapper called lower, that lowercases all entities and attributes.
👍 1