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.
I'm using an Amazon Aurora PostgreSql DB cluster and I am receiving the following error after a failover:
"PG::ReadOnlySqlTransaction: ERROR: cannot execute UPDATE in a read-only transaction"
I'm...
1
answers
1
votes
44
views
asked 3 days agolg...
can someone explain me the difference between scoped permission vs when we give permission to normal user
document is little bit tough to understand, if some one can explain the by comparing it with...
1
answers
0
votes
37
views
asked 3 days agolg...
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
31
views
asked 3 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
35
views
asked 3 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
54
views
asked 3 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
49
views
asked 3 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
76
views
asked 3 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
50
views
asked 3 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
83
views
asked 3 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
57
views
asked 3 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
174
views
asked 3 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
66
views
asked 3 days agolg...