Questions tagged with Amazon Athena

Content language: English

Select up to 5 tags to filter
Sort by most recent

Browse through the questions and answers listed below or filter and sort to narrow down your results.

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...
2
answers
0
votes
72
views
asked a day ago
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...
2
answers
0
votes
65
views
asked 3 days ago
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...
1
answers
0
votes
75
views
Alan
asked 4 days ago
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...
Accepted AnswerAmazon Athena
1
answers
0
votes
57
views
asked 7 days ago
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...
1
answers
0
votes
91
views
Chris J
asked 8 days ago
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...
1
answers
0
votes
82
views
suraj
asked 10 days ago
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...
1
answers
0
votes
555
views
Noah
asked 10 days ago
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...
1
answers
0
votes
353
views
shivank
asked 13 days ago
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...
2
answers
0
votes
127
views
Soumaya
asked 21 days ago
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...
1
answers
0
votes
156
views
Tom Lo
asked 22 days ago
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...
1
answers
0
votes
187
views
profile picture
gh02
asked 22 days ago
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...
1
answers
0
votes
160
views
asked 22 days ago