I am trying to run a select statement in Amazon Redshift on a table in my AWS Data Catalog. The AWS Data Catalog database was created by a crawler connecting to an external Oracle database.

I get the following error:

Cannot deserialize table. Missing mandatory field 'InputFormat' in response from external catalog. Add missing field to table and retry.

I have tried populating the InputFormat and the other meta data the error suggests until I eventually run out of things to try.

Has anyone seen this issue before?