Hello The schema in the source oracle database is using UPPERCASE for everything - table and column names. When using the Postgres target it’s correctly translated to include double quotes. This however makes PG case sensitive and for some reason the apps are using mixed casing and it used to work in oracle. Is there a way to transform the property names? It works for stream names, but it seems that it doesn’t work for property names:

loaders:

name: target-postgres

variant: meltanolabs

pip_url: meltanolabs-target-postgres

config:

stream_maps:

"*":

__alias__: "__stream_name__.lower()"

You cannot bulk alias properties currently. Here are some related issues: • https://github.com/meltano/sdk/issues/2490 • https://github.com/meltano/sdk/issues/2545 • https://github.com/meltano/sdk/issues/2897

Thank you for digging these up. I guess I will do the suggested property aliasing approach - https://sdk.meltano.com/en/latest/stream_maps.html#aliasing-properties Hopefully once I understand the SDK better I can contribute to https://github.com/meltano/sdk/issues/2897

(sorry, meant to say yes you can alias properties but not in bulk -- glad you found the right section of the docs 😅)