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.
In Athena I've a column with an array(json), is there a way to calculate the length of that array for every row?
Accepted AnswerAmazon Athena
2
answers
0
votes
1194
views
asked 7 months agolg...
how to fix issue with AWS crawler that split comma listed values which is supposed to be one column. The data in the column is not enclosed by double quotes that is why we cannot create a custom...
1
answers
0
votes
398
views
asked 7 months agolg...
If I want to extract specific properties from a JSON array using SQL, for example, if the requestparameters structure is as follows:
```
{
'gree': [
{
'Grantee': {
'xsi:type':...
0
answers
0
votes
90
views
asked 7 months agolg...
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
785
views
asked 7 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
379
views
asked 7 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
908
views
asked 7 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
303
views
asked 7 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
234
views
asked 7 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
1107
views
asked 7 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
273
views
asked 7 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
364
views
asked 7 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
292
views
asked 8 months agolg...