Spectrum ERROR: Failed to incorporate external table

2
votes

Redshift Spectrum is giving the below error which executing the SELECT statements for the external table created.

ERROR:  Failed to incorporate external table "schmaname"."tablename" into local catalog.

The external table has limited number of columns, say 50.

I can query on the same table with the superuser and with a different set of a user without any issues. Is there any user settings need to be changed apart from the GRANT

1
amazon-redshiftamazon-redshift-spectrum
Did you try granting USAGE on the schema to the user? - Joe Harris
yes, USAGE and SELECT grants are applied to the user on the particular schema. - DJo

1 Answers

0
votes

I believe the OP got his answer but for others, here are the probable causes collated from various sources:

1) No. of columns in external table exceeded the limit of 1598

2) Column names of external table using reserved keywords

Another post with same issue and solutions:

AWS Redshift - Failed to incorporate external table into local catalog