Unanswered Questions in Database
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.
Hello, I am trying to use materialized views in Redshift, where I have a Zero-ETL integration configured from Aurora MySQL to Redshift. Since the destination Redshift database is completely read-only...
0
answers
0
votes
148
views
asked 6 months agolg...
Hi Team,
As we know, file stream databases are not supported in RDS, so we plan to custom RDS SQL Server. I think it will be the same as on-premises. could you please share any AWS links for...
0
answers
0
votes
1449
views
asked 6 months agolg...
Below is the code version i am using
```
pymongo==3.7
python==3.7
celery==5.2.0
```
below is a sample code which can be tried
```
# app.py (Flask application)
from flask import Flask, jsonify
from...
0
answers
0
votes
84
views
asked 6 months agolg...
Scenario:
Source table: Glue Data Catalog table **study** crawled from MySQL with columns:
* id (int),
* code (varchar),
* desc (varchar)
* and 2 other columns not used in the job.
Target table:...
0
answers
0
votes
100
views
asked 6 months agolg...
A lot of stored procedure in the migrated database called a web API to process complicated data. However, during the RDS migration, we are only given "admin" user with limited access causing some of...
0
answers
0
votes
1322
views
asked 6 months agolg...
We faced the below error when run query with offset ... rows.. fetch next...
```
Msg 33557097, Level 16, State 1, Line 57
syntax error at or near "ROWS"
Total execution time: 00:02:42.886
```
This...
0
answers
0
votes
80
views
asked 6 months agolg...
I am having a hard time connecting my RDS DB to Tableau for a dashboard I need to build. I am looking for guidance how what to do. Anything helps! It is set as publicly available and we have also set...
0
answers
0
votes
149
views
asked 6 months agolg...
When I try to create a new dataset with RDS getting the above error. I have added the necessary inbound rules in the RDS and quicksight security group. May I know what is the issue and how to fix...
0
answers
0
votes
77
views
asked 6 months agolg...
i ve created a rds postgres instance and AWS managed in the same VPC . created the user in AD and RDS. when i try to connect to RDS via Kerberos authentcation from the domin joined EC2, am getting the...
0
answers
0
votes
89
views
asked 6 months agolg...
Don't see any data when Migrating existing and changes data from MYSQL to S3 using DMS and Kinesis.lg...
I am using DMS and Kinesis DataStream and Delivery stream to migrate existing and changes from MYSQL to S3 bucket. But I don't see the data is coming in S3. I specified the schema name and table name...
0
answers
0
votes
184
views
asked 6 months agolg...
During concurrent user testing, we noticed that Neptune RDF takes more time to execute the same queries compared to Stardog. What could be the primary reasons for this difference in performance?
0
answers
0
votes
110
views
asked 6 months agolg...
I have deployed a DocumentDB cluster on AWS, utilizing the default VPC. The VPC Network ACL has been configured to allow 0.0.0.0 access, and the security groups are set to permit all traffic,...
0
answers
0
votes
93
views
asked 6 months agolg...