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.
Hi All,
Relatively new to the AWS world. I have a requirement where i have some sensitive files in s3 that i want users to only have read access (no download, no s3 query select). On the other end I...
1
answers
0
votes
23
views
asked 5 hours agolg...
I am keeping track of some data, based on the date on S3. The files are stored in directories like this: year=yyyy/month=mm/day=dd and inside this directory, there are multiple csv files. I want a...
1
answers
0
votes
38
views
asked a day agolg...
From the AWS documentation (https://docs.aws.amazon.com/athena/latest/ug/connectors-bigquery.html#connectors-bigquery-passthrough-queries), it says that I can use something like:
SELECT * FROM...
1
answers
0
votes
26
views
asked a day agolg...
I'm trying to run a Python script in aws glue that uses athena.get_query_runtime_statistics when I run i on my local machine the script works, but running at glue returns this error
0
answers
0
votes
46
views
asked 3 days agolg...
1. Created table using
CREATE EXTERNAL TABLE `daily_wallet_dlr_new`(
`transactiondate` bigint,
`walletid` string,
`appname` string,
`app_id` string,
`sku` string,
...
1
answers
0
votes
51
views
asked 3 days agolg...
Amazon QuickSightlg...
Hello everyone,
Please, I need help resolving the "No tables found" error![Quicksight](/media/postImages/original/IMTNgSk5_lQXOfIyIvOZs8og)
on Quicksight
I would appreciate it if anyone could guide...
2
answers
0
votes
120
views
asked 5 days agolg...
I have data that I collect from AWS Batch and CloudWatch. I made a lambda function that runs every day that collects those data daily and saves the result to S3. I have a folder called 'logs' and the...
0
answers
0
votes
564
views
asked 7 days agolg...
We have enabled the lake formation for some POC and we are unable to disable it and get default setting. The problem we have is if I create a db in athena and to create table in same database using...
1
answers
0
votes
111
views
asked 7 days agolg...
I'm experimenting with Amazon DataZone and encountered something unexpected. I have a simple setup with one AWS account and one DataZone domain, which includes:
1 Glue Table
1 S3 bucket with my...
0
answers
0
votes
267
views
asked 8 days agolg...
Do anyone know how to filter athena waf log from the last hour?
for example
`SELECT count(*) AS countRequests,httprequest.clientip, terminatingruleid, httprequest.uri
FROM "waf_logs"
WHERE
date...
Accepted AnswerAmazon Athena
2
answers
0
votes
84
views
asked 8 days agolg...
I wrote a python code that uploads data to S3 in csv format daily. I formatted the file name like this: 'some_data_YY_MM_DD.csv'. Using Athena, I want to query from the past 7 days of data.
1. Is...
3
answers
0
votes
632
views
asked 9 days agolg...
Facing the following error when using 2 jobs and 1 crawler:
Job 1: changing the schema and saving the csv file as parquet in S3.
Job 2: ETL Process
Crawler: Saving it in the AWs Glue Datacatalog...
1
answers
0
votes
602
views
asked 9 days agolg...