Query data using AWS serverless redshift query editor

Question

I have a AWS glue table with one partition named dt, i can add data in my s3, using Athena via this glue table and can also query it.

But I am not able to query data using redshift query editor.

I have linked the external schema to the workgroup I can see my schema in the workgroup, but when I run the select statement it result in no rows to show, but querying with Athena show all my rows. I have checked all the IAM roles.

What is the issue with the redshift here, Can someone help ?

Thanks.

MilindOke · Answer

The supported file formats, compression types and encryption for Amazon Redshift is different than Athena. Double check from https://docs.aws.amazon.com/redshift/latest/dg/c-spectrum-data-files.html

If the data files are supported then you can query the system view SYS_EXTERNAL_QUERY_ERROR to get information about Redshift Spectrum scan errors https://docs.aws.amazon.com/redshift/latest/dg/SYS_EXTERNAL_QUERY_ERROR.html

Query data using AWS serverless redshift query editor

Add your answer

Relevant content