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 set of Apache Iceberg tables that are logged in Glue Catalog. I was running some basic tests on Iceberg table partitions via Athena in us-east-1 without issue. We re-deployed the exact same...
1
answers
0
votes
816
views
asked 8 months agolg...
I was trying to update the CID Dashboards to display account names as per this doc(https://catalog.workshops.aws/awscid/en-US/dashboards/foundational/cudos-cid-kpi/add-accounts) . When I run the query...
1
answers
0
votes
387
views
asked 8 months agolg...
I have ran this query for more than a year, and the query always succeed until now.
This is the Athena Query: "select * from <table_name> where organization = '<org_name>' AND start >= <epoch_time>...
1
answers
0
votes
922
views
asked 8 months agolg...
'DeleteObjects''s requestparameters is like '{"bucketName":"demo-bucket","Host":"s3.us-east-2.amazonaws.com","delete":""}' , how can i get deleted ObjectKey
3
answers
0
votes
309
views
asked 8 months agolg...
this is my sql, but 'json_extract_scalar(requestparameters, '$.x-amz-copy-source') as source' is error,
SELECT
userIdentity.username as...
Accepted AnswerAmazon Athena
4
answers
0
votes
238
views
asked 8 months agolg...
In AWS I'm generating Cost and Usage Report [CUR] from the billing console with hourly granularity into S3 bucket and from there using cloud formation stack created a database in Athena but this data...
3
answers
0
votes
1138
views
asked 8 months agolg...
I'm trying to setup PowerBI for our DynamoDB table. Using Athena with the DynamoDB Lambda connector. Smaller queries work fine, however the main import into PowerBI fails. When I play with the query...
2
answers
0
votes
281
views
asked 8 months agolg...
I have two accounts the source account A and the target account B.
I have granted account B access to the database and all its tables in account A with Super access including grant. and accepted this...
1
answers
0
votes
370
views
asked 8 months agolg...
i have a table in data catalog and when i query the table, all the data in that table are return in one column separated by commas. It's like its returning the CSV file exactly as it is without...
1
answers
0
votes
302
views
asked 8 months agolg...
Good afternoon fellow AWS users.
I'm trying to get data from Athena into a Lambda session. I've done this before with another dataset, with no problems, so I know the Python script is correctly...
1
answers
0
votes
810
views
asked 8 months agolg...
How can we integrate Athena UDF functions with Quicksight?
Is there any route for this?
0
answers
0
votes
127
views
asked 8 months agolg...
I need to build a solution that for a given Athena query, the output is inserted into RDS (Postgres). From what I have read, it makes sense to use Glue. However, I am not comprehending the exact...
2
answers
0
votes
242
views
asked 8 months agolg...