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
1125 results
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 3 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 3 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...
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...