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
I'm stuck creating an athena connection in dataiku. In dataiku I use existing connection of s3 configured with role, this s3 connection is working. I've added required athena iam permissions...
1
answers
0
votes
205
views
asked 8 days agolg...
Hi!
I am trying to use DataZone to share an Iceberg table from the Glue Data Catalog with another AWS account.
I have created the table with Athena in the source account like this:
```sql
CREATE...
0
answers
0
votes
65
views
asked 9 days agolg...
I hope this message finds you well. I'm reaching out because I require assistance with enabling embedding and anonymous access for the Amazon Grafana dashboard. My goal is to integrate the live Amazon...
0
answers
0
votes
38
views
asked 12 days agolg...
SELECT *
FROM tvseso_h
WHERE DATE(tvseso_h.call_creation_date) BETWEEN ? AND ?;
the call_creation_date datatype in source table is in TIMESTAMP and when i created the view as tvseso_h for the same...
1
answers
0
votes
83
views
asked 13 days agolg...
Hello, so I have my script that runs an Athena query and sends an email,
When I was testing in my machine in the terminal, running 'python3 name-file.py'. The script works fine, the query is run and...
0
answers
0
votes
120
views
asked 15 days agolg...
Hi I have created an external table on AWS Glue catalog db .
The table points to a lz4 compressed file on an s3.
the table definition looks like this
```
CREATE EXTERNAL TABLE `myapplogs`(
...
1
answers
0
votes
246
views
asked 16 days agolg...
Hi, I'm trying to build a quite complex query that runs on some views and if i get a couple of join it ends in this error
[HY000][100071] [Simba][AthenaJDBC](100071) An error has been thrown from the...
0
answers
0
votes
48
views
asked 16 days agolg...
GENERIC_INTERNAL_ERROR
This query ran against the "synergy_mysql_prod" database, unless qualified by the query. Please post the error message on our forum or contact customer support with Query Id:...
1
answers
0
votes
64
views
asked 16 days agolg...
Trying to create an Athena table with the following query
```
CREATE TABLE IF NOT EXISTS current_energy_rates
WITH (table_type = 'ICEBERG', format='PARQUET', location='s3://pr-energy-lookup',...
0
answers
0
votes
56
views
asked 18 days agolg...
Hello AWS Community,
I'm facing a challenging issue with our AWS data pipeline that affects data visualization in Amazon QuickSight. Initially, our setup involved directly importing CSV data from S3...
0
answers
0
votes
168
views
asked 19 days agolg...
When trying to add an Athena dataset (pointing to an Iceberg table on S3 created with Glue), I get the following error message:
![Error...
1
answers
0
votes
79
views
asked 21 days agolg...
Getting this while i am querying document db using lambda function using Athena for specific tables only
TYPE_NOT_FOUND: Unknown type: row
This query ran against the "sample" database, unless...
1
answers
0
votes
80
views
asked 22 days agolg...