Questions tagged with Amazon Athena

I need to block Boto3 client to access Athena workgroup while allowing Tableau. Both use JDBC driver. Is there any port/IAM policy to achieve this? Both Tableau and Boto3 client are accessing from...

I am using AWS GLUE ETL job that is fetching data from Mongo DB and putting it to AWS Glue catalog table but the issue is everytime the job runs it is creating the duplicate entries.(If there are 1000...

Hello AWS Community, I am currently storing event logs in an RDS Postgres database and am looking for an efficient way to manage the growing size of our tables. Here's what I am aiming to...

I have a table created by files stored on S3 as parquet with snappy compression. The creation is like this: CREATE EXTERNAL TABLE my_table( text STRING, url STRING ) STORED AS PARQUET LOCATION...

HIVE_CURSOR_ERROR: incorrect data check This query ran against the "dbreport" database, unless qualified by the query. Please post the error message on our forum or contact customer support with...

I have a glue database called `edb_iris_iceberg_test`. It has an iceberg type table called `sample_data_iceberg_2`. Below is the table DDL - ``` CREATE TABLE...

Hello, I am using Athena in us-east-2 and have tables that have locations to s3 buckets that are in many different regions. I have no problem querying any other region except for me-centra-1, which...

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...

I can monitor Athena resource usage using different approaches: - I can log [Athena API calls with AWS CloudTrail](https://docs.aws.amazon.com/athena/latest/ug/monitor-with-cloudtrail.html) and use...

Consider CloudFront Logs injected by AWS are stored in S3 with pattern: `s3://aws-cloudfront-log-[AWS Account ID]/[Any prefix I preferred]/E[CloudFront Distribution...

Hi everyone, for Glue catalog cross account I changed the key in catalog settings to a customer-managed kms key. I kept s3 bucket(where data stores) encryption type as it was( SSE-s3). I also did all...

Hi! I'm running an UNLOAD from Athena, and then a COPY to Redshift, I'm having an issue about how the SUPER fields are loaded into Redshift ``` UNLOAD ( SELECT curpVerification AS...