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!