Questions in Analytics
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 am querying an external partitioned table in redshift spectrum and it throws an error. The data is stored in S3, parquet files and one of the column is 'BINARY'. If i remove the partition column...
0
answers
0
votes
34
views
asked 4 days agolg...
Hi everyone,
I continue to have problems with zero-ETL, which ends on its own in three days.
even though both sides of those services are currently active. Can someone please assist us with a...
1
answers
0
votes
39
views
asked 4 days agolg...
Hello,
I have parquets files in S3 that i parse using Glue Crawler and query in Athena. I found that some files have two columns "x" and "y" that have a type **int64** while other files have them as...
1
answers
0
votes
67
views
asked 4 days agolg...
Unable to push Glue job to GitHub. Empty connections list is now allowed if connection is specified.lg...
Hi,
I am trying to Push the Glue job to GitHub repo. I have got added the access permissions to my role as specified in...
3
answers
0
votes
62
views
asked 4 days agolg...
I have a 5.7.mysql_aurora.2.12.2 cluster and both cluster and instance are using default parameter group `default.aurora-mysql5.7`. After created and selected AuroraDB for MySQL8.0 compatible cluster...
1
answers
0
votes
83
views
asked 4 days agolg...
I am using aws lakeformation workflow to create a data lake following [this](https://docs.aws.amazon.com/lake-formation/latest/dg/getting-started-tutorial-jdbc.html) guide. everything is setup as...
0
answers
0
votes
65
views
asked 4 days agolg...
Trying to connect to redshift database in python shell jobs. Tried with packages like psycopg2, redshift connector and pg. All of them gave similar error, hence I'm assuming problem is to establish...
1
answers
0
votes
108
views
asked 4 days agolg...
Hi all,
Following this tutorial https://docs.aws.amazon.com/opensearch-service/latest/developerguide/configure-client-ddb.html.
I have shared opensearch pipeline configuration for sinking all dynamoDB...
0
answers
0
votes
60
views
asked 4 days agolg...
Background:
I have a cluster of "Aurora MySQL", with "Credentials management" set to "Managed in AWS Secrets Manager".
My service is a spring boot service, that takes the DB password via ENV vars on...
1
answers
0
votes
240
views
asked 4 days agolg...
I've imported a dataset of JSON objects that all have consistent schema. Glue crawler finished successfully and created a table. I can select * with a limit in Athena, but when I select all rows I get...
0
answers
0
votes
86
views
asked 4 days agolg...
I'm trying to update iceberg table with Athena Client in AWS lambda but getting COMMIT error.
My query runs about 100 queries at a time, and the time interval for generating a query is within 1 to 2...
1
answers
0
votes
127
views
asked 5 days agolg...
We have a snapshot of RDS version 8.0.33 and we want to migrate to any potential version of Aurora MySQL.
The problem is that on the migration screen there are Aurora MySQL 3.05.2 and 3.06.00 which...
2
answers
0
votes
131
views
asked 5 days agolg...