zero-ETL between RDS to Redshift

Question

Hi everyone,
I continue to have problems with zero-ETL, which ends on its own in three days.
even though both sides of those services are currently active. Can someone please assist us with a resolution?
Source: RDS
Target: Redshift Server less

ThomasP · Answer

Hi, if you want to see some of the information about the state of the sync of the tables you can use this query:

SELECT * FROM SVV_INTEGRATION_TABLE_STATE

You can also if your tabels are been stuck in failed try to restart the Sync with either:

This only takes the tables that are in error:
ALTER DATABASE your-database-name INTEGRATION REFRESH INERROR TABLES IN SCHEMA your-scheme-name;

This just takes all tables:
ALTER DATABASE your-database-name INTEGRATION REFRESH ALL tables;

e.g. see more here:

https://docs.aws.amazon.com/redshift/latest/mgmt/zero-etl-using.describing.html

Hope it can help

Sandeep · Answer

Could you please review the execution logs of the zero-ETL process to identify any errors, warnings, or other messages that might provide clues about why it is ending prematurely. Look for any exceptions or failures that could be causing the process to stop unexpectedly.
--------------------------------------------------------------------------------------------------------------
There no Logging mechanism for zero-ETL 
Nothing any clue to find why it is stopping after few days, even integration are Active on both side.

zero-ETL between RDS to Redshift

Could you please review the execution logs of the zero-ETL process to identify any errors, warnings, or other messages that might provide clues about why it is ending prematurely. Look for any exceptions or failures that could be causing the process to stop unexpectedly.

Relevant content