Stack Overflow
Stack Overflow

Questions tagged [aws-rds-data-service]

Questions related to AWS RDS data service API (Aurora Serverless)

Amazon RDS provides an HTTP endpoint to run SQL statements on an Amazon Aurora Serverless DB cluster. See https://docs.aws.amazon.com/rdsdataservice/latest/APIReference/Welcome.html

45 questions
0
votes
0 answers

How to connect SQLYOG to AWS RDS(not publically available)

I want to connect sqlyog to my AWS RDS which is in private subnet and not publically available,there is limited solution and documentation available on internet regarding sqlyog integration with aws rds please do guide me ,its been 3 weeks i am…
saad jaha kayani
  • 11
  • 2
0
votes
1 answer

Permissions Needed For DMS Source and Target Databases

I am working on a AWS DMS Proof of Concept project where I need to migrate a large data set from source to target.I am successful to create the resources and do the migration but the issue I am facing is with permissions created for these database.…
Sam
  • 57
  • 7
0
votes
0 answers

Invalid transaction error with SQLAclhemy, sqlalchemy-aurora-data-api

I have a Falsk app that is using sqlalchemy-aurora-data-api the package to connect to MySQL db from the AWS RDS. In the app I am using raw queries eg. f'SELECT * FROM customers WHERE id={id}' And to execute this query I…
Shubham Jha
  • 104
  • 3
0
votes
1 answer

cannot connect to aws db

i'm trying to create connection to the aws db via c# string hostname = "databasesql.xxxxx.." string dbname = "databasesql"; string username = "someuser"; string password = "somepassword" connectionString = "Data Source=" + hostname + ";Initial…
Y.D
  • 95
  • 8
0
votes
2 answers

Add list as keys for another list and convert to dictionary

I have a list of columns and records that I get by using DATA-API RDS execute_statement using boto3. As the way the api responds it difficult to get the data out in a psycopg2 RealDictCursor format to insert into another database. What I want to do…
Rishi
  • 313
  • 1
  • 4
  • 18
0
votes
0 answers

ERROR: subquery must return only one column in PostgreSQL

I'm trying to write a select statement that requires the stored procedure in PostgreSQL. But, it fails by this error: ERROR: subquery must return only one column. The query is as follow: select( (select 'q1_parasiticide_carton_rebate' as…
Priyanka Patil
  • 23
  • 1
  • 4
0
votes
1 answer

Data Factory V2 Error Code 2200 on Data issue while pulling data from AWS RDS to DataFactory (Azure mysql)

I'm using these doc's to configure https://fabriciosanchez-en.azurewebsites.net/copying-data-from-aws-rds-mysql-into-azure-through-data-factory-integration-runtime/ the complete set up was done but when I'm running the pipeline to copy the data this…
Aduri Varma Sanjeev
  • 1
  • 2
0
votes
0 answers

Need to setup Connection Pooling properties for PostgreSQL in Maven project

My Application is serverless J2EE application and it is using AWS lambda for running. We have connection pool setup for Oracle in our application in which ojdbc driver and ucp for connection pool is being used, now we are migrating from Oracle to…
007_programmer
  • 35
  • 1
  • 10
0
votes
1 answer

Increase the 1000 limit for aws lambda results count from execute_sql using rds-data or use a different package?

I have been using AWS aurora with python lambda function for executing queries for our application. The lambda functions works great, but returns only top 1000 results not all. I tried increasing the limit to 5000 by using paginators, couldn't find…
Ara
  • 145
  • 2
  • 10
0
votes
3 answers

AWS RDS performance is very very low

There are two databases, AWS RDS and Digitalocean $ 5 VPS. I imported the same .sql file to both databases, the performance difference between them is almost 66000% select count(special_cargo_id) from special_cargos; AWS RDS elapsed time =…
Hakan
  • 77
  • 6
0
votes
1 answer

Can't connect to RDS in Asp.net core application

I've created a MySQL RDS on AWS console. Then I successfully connected to that RDS in MySQL Workbench using following steps: Connection Method: Standard (TCP/IP) Hostname: zargham.ccir1327bjhl.us-east-2.rds.amazonaws.com Port: 3306 Username: [given…
Zargham Nazeer Malik
  • 3
  • 6
0
votes
1 answer

AWS RDS db creation limit

I need to migrate to RDS from our current server. Our application automatically created dbs according to its need. since the rds have a default dB create limit of 40, is it possible to automatically increase the quota to more than 100. ? And also…
Anand A S
  • 1
-4
votes
1 answer

Should I create Separate EC2 for each database

I am creating one fullstack web application that will be used by different organisations (total 50+). I want to create separate database for each organisation. Should I create separate EC2 and RDS for each organisation or what will be the best…
Prithwiraj Nath
  • 1
  • 2
-4
votes
1 answer

Best AWS RDS instance for my requirements

I have a database of 3GB size in AWS RDS t2.micro instance. My CPU credit balance is most of the time is zero. My API calls taking long time. I update data daily so I interact with RDS frequently and lot of times. So what type of instance I should…
PRASANTH BATTULA
  • 47
  • 1
  • 8
1 2
3