Hi!
Any specific reason why target-redshift creates table and column names in upper case ?
https://github.com/transferwise/pipelinewise-target-redshift/blob/7e9e9e114452d2b33e02a0a911ee961c49f5ec5a/target_redshift/db_sync.py#L356
This requires putting double quotes while querying the table name and is not a standard. I can’t find a way to override this without modifying the code.
Also, every time my sync runs, I notice that it tries to create table again and again, even though it exists. The check for existing table is not working for me. Am I doing something wrong ?
│ =2023-01-16 06:02:04 name=target_redshift level=INFO message=Table 'lever' exists cmd_type=elb consumer=True name=target-redshift producer=False stdio=std │