By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

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

0

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

Notebook: Enter image description here Enter image description here

Topics
AnalyticsMachine Learning & AI
Tags
Amazon AthenaAmazon SageMakerAWS GlueAWS Lake Formation
Language
English
AWS-User-8895452
asked 2 years ago320 views
1 Answer
0

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

tselatyjr
answered 2 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions

Relevant content