I am seeing the normalization into Postgres change...
# replication-troubleshooting
c
I am seeing the normalization into Postgres change the column name from uppercase first letter to all lowercase. It seems that this is a postgres thing that requires columns to be quoted to keep them the proper case. I can't figure out how to make Airbyte preserve the case during normalization. I tried setting the advanced options for the CSV S3 ingestor to set the column name with escaped quotes: "\"Column\"" but that did not work. Any other ideas?
u
Hello Chris Nogradi, it's been a while without an update from us. Are you still having problems or did you find a solution?
c
I did not find a solution other than changing all my downstream code to use the uppercased new columns. I tried all sorts of ways to specify the schema column names with quotes to force the name to not change but could not find a working solution. I was going to dig into the dbt code to see but have not yet had time. I know that for dbt you can just add the quotes and it will preserve the case but I don't know how to make that happen from within the Airbyte interface. Any help would be appreciated!