Refresh Redshift target fails with F_JD22CA: DBMS error [ERROR: skipping "<tablename>" --- only table or database owner can analyze it. How do I fix?
We experienced one of these issues while replicating to a Redshift target. The refresh fails with the message:
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\]
Target table remains empty.
The resolution is to make sure the HVR user connecting to Redshift is a superuser.