Query data using AWS serverless redshift query editor

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.