Error in SQL explorer - Athena on Sagemaker Wrangler and Sagemaker notebook

Question

I can't solve this error.
I have given sagemaker IAM permission within the lake formation for this table, I have errors also using awswrangles lib within sagemaker notebook
what am I doing wrong?
Studio:
![Enter image description here](/media/postImages/original/IMB_zL50UyRjKvNJYnta9ZKQ)

Notebook:
![Enter image description here](/media/postImages/original/IM9pyYOkXNQ5urTECMAL6row)
![Enter image description here](/media/postImages/original/IM6ihq2P_ZQJ-myFQKB3Uijw)

Answer

Make sure the `ctas_approach` property of your awswrangler query is set to false.

[https://aws-sdk-pandas.readthedocs.io/en/stable/stubs/awswrangler.athena.read_sql_query.html](https://aws-sdk-pandas.readthedocs.io/en/stable/stubs/awswrangler.athena.read_sql_query.html)

Error in SQL explorer - Athena on Sagemaker Wrangler and Sagemaker notebook

Contenuto pertinente