Hello everyone! I have the following situation. I...
# troubleshooting
r
Hello everyone! I have the following situation. I am replicating data from an OracleDB to a Postgres, both on different virtual machines and networks. I noticed that columns with the DATE type in Oracle are being saved in Postgres as TIMESTAMP, so far so good! The problem is that the UTC is coming in wrong. The times are coming in wrong, because 3 hours are being discounted from UTC. I first checked if it wasn't a problem with the destination database (Postgres), but everything is fine! Then, I checked the UTC of the machine running Meltano and adjusted it to the correct UTC (America/São Paulo). also, following the advice from Chat GPT, I included a variable TZ: America/Sao_Paulo in meltano.yml, so it looks like this: plugins: extractors: - name: tap-oracle variant: s7clarke10 pip_url: git+https://github.com/s7clarke10/pipelinewise-tap-oracle.git env: ORA_HOST: ${ORA_HOST} ORA_USER: ${ORA_USER} ORA_PASS: ${ORA_PASS} TZ: America/Sao_Paulo # <-- Add this line config: host: ${ORA_HOST} port: 1521 user: ${ORA_USER} password: ${ORA_PASS} default_service_name: DBPROD default_replication_method: FULL_TABLE batch_size: 5000 encoding: "WE8MSWIN1252" I restarted the services and the problem still persists. Does anyone have any idea how I can solve this problem? Thanks!