Hey all :wave:! I have a scheduled job in producti...
# troubleshooting
v
Hey all 👋! I have a scheduled job in production using Airflow in Meltano, it worked well with the target-stitch but I’d like to change to the target-bigquery. All the tests passed when I run the job manually from my computer but the job fails when scheduling in production. It seems to be a replication_key error, maybe due to backwards compatibility issue as I changed the loader. The job consists in loading two tables so I have two replication keys (creationDateTime and modificationDate) which are in StringType in my schemas. The 1st table with the rk creationDateTime seems to be working so the error seems to be from the 2nd table. This detail makes me think that the error is not caused by a comparison between the state (which is in DateTime I think) and the replication_value (in StringType), otherwise both tables would have failed. Correct me if I’m wrong ! Can someone help me on this please ? Thanks a lot !! 🙂 @Stéphane Burwash