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 csv files stored in S3. The files are named as followed: {region name}_{today's date}.csv. There are multiple regions. These files are saved under 'log/year/month/date' directory. So this...
1
answers
0
votes
39
views
asked 2 days agolg...
I have Excel sheets with multiple sheets on it stored in S3. Currently, I have separate csv files for each sheet, and crawling from each csv files. Instead of doing this, I would like to crawl from...
1
answers
0
votes
39
views
asked 2 days agolg...
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
36
views
asked 2 days 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
61
views
asked 3 days 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
37
views
asked 3 days 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
66
views
asked 4 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
58
views
asked 5 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
129
views
asked 7 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
593
views
asked 9 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
131
views
asked 9 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...
1
answers
0
votes
286
views
asked 10 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
93
views
asked 10 days agolg...