I am trying to query my athena database using
import awswrangler as wr
df = wr.athena.read_sql_query(sql="""SELECT * FROM tablename limit 10;"""
, database="databasename"
,data_source='AwsDataCatalog')
but I keep getting this error
QueryFailed: SYNTAX_ERROR: line 7:3: Schema vaultron_target does not exist. You may need to manually clean the data at location 's3://aws-athena-query-results-235823598658-us-east-1/tables/e29380fa-66dd-4939-b675-00e80fddd5ff' before retrying. Athena will not delete data in your account.
Is this because of the region information?