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 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
25
views
asked 14 hours agolg...
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
129
views
asked a day agolg...
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
135
views
asked 3 days agolg...
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
83
views
asked 11 days agolg...
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
107
views
asked 13 days agolg...
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
134
views
asked 13 days agolg...
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
111
views
asked 13 days agolg...
I am using Athena UNLOAD query to unload results of SELECT in parquet format. I have columns in snake_case in Athena Table. So I did SELECT snake_case as snakeCase .. in my query.
The problem is I...
0
answers
0
votes
65
views
asked 14 days agolg...
I previously had csv files with some columns and data and I replaced one column with two new columns. When I run crawler and try to view on Athena, it throws this error:
HIVE_INVALID_METADATA: Hive...
0
answers
0
votes
111
views
asked 14 days agolg...
Hi everyone, I am trying to set up cross account access for Glue catalog, I am using a customer-managed key in Glue and also set s3 encryption type to SSE-KMS and re-encrypt all current object.. my...
3
answers
0
votes
114
views
asked 15 days agolg...
Hi, I am trying to set up the cross account access for Glue catalog. I want to have access to the data located in producer account inside consumer account's Athena. after setting up the access and run...
2
answers
0
votes
187
views
asked 16 days agolg...
Hi,
We're working on ICEBERG table and using MERGE INTO statement.
We would like to implement the following logic:
1. In case there is match between some fields in source table on top of target table...
1
answers
0
votes
79
views
asked 19 days agolg...