Data integration keeps failing

  • 17Views
  • Last Post 5 days ago
  • Topic Is Solved
0
votes
Crystal Chan posted this 2 weeks ago

Hi there

I have a data integration between two RDS connections and when I try to run the package, it keeps failing with error saying "permission denied for table <tablename>" but it doesn't tell me what permissions I need to set on my table or which database is having issues.

 

What do I need to do?

 

Crystal

Order By: Standard | Newest | Votes
0
votes
Mariia Zaharova posted this 2 weeks ago

Hello Crystal!

 

The PostgreSQL user you are connecting with must have permission to create tables and triggers.

When performing synchronization repeatedly, Skyvia synchronizes only data that was changed since the previous synchronization. It uses the fields storing information about when a record was created and modified in cloud applications and creates special tracking tables and triggers in relational databases for data modification tracking. The "*_tracking_store" table is created in the database while performing initial synchronization and contains information about changes in the corresponding PostgreSQL tables before the next synchronization.

 

Feel free to ask any further questions.

 

Best regards,

Mariia

0
votes
Crystal Chan posted this 5 days ago

Thanks

Close