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 created ICEBERG table by using CTAS command.
By mistake I deleted the Parquet files and afterwards tried to drop the table.
Now once I'm trying to delete the table I'm getting the following...
1
answers
0
votes
497
views
asked 6 months agolg...
I have been made to understand that Athena is different from normal SQL as it basically reads and queries data from an s3 backend. However, I am very much used to the SQL Alchemy ORM interface for...
1
answers
0
votes
413
views
asked 6 months agolg...
I have a bucket 'X' in account 'A', I want to create a copy of the bucket in account 'B' using Athena. I already have a mapping defined in Athena of account 'B' where I can already access another...
1
answers
0
votes
131
views
asked 6 months agolg...
I am trying to run an athena query in a Sagemaker R Kernel notebook. The query uses an external UDF function. This query works on athena console but gives the following error in the...
1
answers
0
votes
201
views
asked 6 months agolg...
When a view is created by running an Athena SQL query, it appears in the Glue catalog but errors are raised when querying the view in a Glue job or a Glue Spark context.
I am able to make the view...
1
answers
0
votes
389
views
asked 6 months agolg...
Hello
I am trying to create a protected view following https://docs.aws.amazon.com/athena/latest/ug/views-glue.html
I created a simple Athena table backed by an s3 stored csv file.
The table looks...
1
answers
1
votes
212
views
asked 6 months agolg...
Hi, I am trying to share a View from AccountA to AccountB using Lake Formation.
But it seems the shared view is trying to refer resources in the Target Account (AccountB) instead of Source Account...
2
answers
0
votes
379
views
asked 6 months agolg...
I have a CTR data in JSON format stored in s3 bucket which has the below column
"SegmentAttributes": {
"connect:Subtype": {
"ValueString": "connect:Telephony"
}
}
Due...
1
answers
0
votes
448
views
asked 6 months agolg...
Hi all, I need to demonstrate lake formation data filters usage. What is the easiest way to query this data and show the difference caused by filters.
I have 2 roles accessible to my account. One role...
1
answers
0
votes
325
views
asked 6 months agolg...
What are the ways to access delta tables in S3 other than AWS Athena?
0
answers
0
votes
80
views
asked 6 months agolg...
Hi,
I am trying to run an SQL query from sagemaker R kernel notebook.
I have connected to db using rJDBC and this works:
```
show_databases <- dbGetQuery(conn, "show...
0
answers
0
votes
137
views
asked 6 months agolg...
Hi, i have a domain in datazone in account A and i need to access data that is located in account B, but i'm facing some issues.
Here are the steps i made so far:
1) In Account B i added the data lake...
0
answers
0
votes
142
views
asked 6 months agolg...