All Content tagged with Amazon Athena
Start querying data instantly. Get results in seconds. Pay only for the queries you run.
Content language: English
Select up to 5 tags to filter
Sort by most recent
1116 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 months 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 2 months 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 2 months 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 2 months 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...