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.
How can I monitor who is querying which glue tables?
After some trial and error I found that the BatchGetTable Glue API event is recorded using CloudTrail every time I run an Athena query, and...
I have Athena Iceberg table.
The table has 2 partitions.
Each hour I update it with `MERGE` and `DELETE` commands.
```
SELECT count(*) FROM "my_table$files"
```
now **gives 16. Meanwhile data...
asked 2 days ago
Hi. I had a table that was created by a crawler, then I deleted the table ( in Athena) and created it by DDL. after running crawler. it could not find the table and create a new table.
note: The s3...
asked 3 days ago
As per my analysis in CTR data through Amazon Athena, ContactID has information of Agent who handled the call and if no agent handled then it has cumulative incremental data in the...
Currently, I must define permissions model in lake house using lake formation that I can query data by Athena. It's ok if data sources come from S3 but seem be impossible if it's Redshift. Athena can...
Question from customer :Is there a way to backup an athena datasource without backing up each views? is snapshotting an option. From my research, the only options from this repost is to download the...
I just can't understand what I'm doing wrong.
I have a table.
```
CREATE EXTERNAL TABLE test (
originalrequest string,
requeststarted string
)
PARTITIONED BY (
req_start_partition...
asked 6 days ago
Spend couple of hours before understand that there is a bug in AWS Athena.
Here is how to recreate it.
```
CREATE EXTERNAL TABLE test (
a string)
PARTITIONED BY (
month int
)
STORED AS...
asked 7 days ago
I am trying to use Amazon Athena ODBC 2.x in order to connect to Athena from Power BI.
I have tried with both types "IAM credentials" and "Browser Azure AD". But for both ones it fails with the same...
I am getting the following error when querying a partitioned table.
select * from cdqwms where date between '2024-01-01' and '2024-01-02'
INVALID_TABLE_PROPERTY: Must provide a comma-separated...
I am storing below json file in S3 bucket after partitioning using firehose:
{"topic": "ad","timestamp": 1718465649,"ad":...
I'm confused by AWS documentation regarding compatibility with delta tables. We need to delete a column that is the "column mapping" feature supported in delta-lake 1.2.0 and we do it through spark...