All Content tagged with Amazon Athena

Hello Team, Background: Recently I was working for AWS billing automation for our organization account. 1. Initially, I tried Cost explorer API method - No AWS Data Transfer cost in the service...

Hi folks, I have a partitioned table in Athena that uses dynamic partition projection, enabled with the following table properties: ``` projection.account.type injected projection.region.type ...

I have created a dynamodb table that stores some data, then created a glue crawler that crawls to store the metadata of this table so I can query it using Athena. I am seeing the dynamodb table got...

I'm using AWS Athena and I'm trying to see the action plan and I get INVALID_PARAMETER_USAGE: line 1:1:Incorrect number of parameters: expected 2 but found 0 error.

Does Athena have a way to enforce/validate that every query includes at least one WHERE clause that filters on a partitioned column? I'm looking for a way to prevent query authors from accidentally...

The CloudFormation stack Data-lake-foundation-DataLakeFoundationStack-IS67G4LRJQIU-ElasticsearchStack-YY9NNQARTKAR failed to create the resource [CopyLambdaDeployment] due to an error in the...

Hi I've created a crawler that responds to SNS Queue messages and crawls some text files in an S3 bucket. The bucket has sub-folders that the crawler seems to have identified and created a partition...

Hello, I have data in the AWS S3 bucket in the format year/month/day/hour/file1.json, file2.json..... file6.json. In the JSON file, the data are not separated by coma or new line....

What's the best way to pull EC2 OS/Platform information? Couldn't get it to work with config query, but is there a different way? This would need to work in GovCloud accounts.

Getting this error when try to start an Athena query using Python: "Error details TABLE_NOT_FOUND: line 5:11: Table 'awsdatacatalog.athenacurcfn_c_u_r_athena.cur_athena' does not exist This query ran...

I have been testing the direct write to Iceberg feature in Firehose and I have come to realize that there is a problem with the feature. It does not always work. Let me elaborate: - I created an IAM...

[Extracting key insights from Amazon S3 access logs with AWS Glue for Ray](https://aws.amazon.com/blogs/big-data/extracting-key-insights-from-amazon-s3-access-logs-with-aws-glue-for-ray/) introduces a...