Issue

While replicating to a Redshift target, the refresh fails with the following error:

F_JD22CA: DBMS error \[ERROR: skipping "<tablename>" --- only table or database owner can analyze it. INFO: Load into table '<tablename>' completed, nnnn record(s) loaded successfully\]. DBMS error number \[30\]. SQL State \[HY000\]. DBMS version \[PostgreSQL 8.0.2 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.4.2 20041017 (Red Hat 3.4.2-6.fc3), Redshift 1.0.5749\]

Environment

Local Data Processing

Answer

The resolution is to make sure the HVR user connecting to Redshift is a superuser.