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
1
vote
1 answer

What format should the secret-string take to connect to an Aurora Postgres database using AWS data api?

First, everything I am doing is from the CLI. I don't have permissions to use the web interface. I am trying to make a call to an existing Aurora Postrgres database using the AWS data api. I am following the directions on this…
irrational
  • 767
  • 7
  • 24
1
vote
1 answer

Catching and Parsing AWS RDSDataService exceptions

I am using RDSDataService in a lambda to execute queries in an Aurora Serverless DB. It's all good when everything runs fine, but when there is an error running the query I get something like this An error occurred (BadRequestException) when…
DrkStr
  • 1,752
  • 5
  • 38
  • 90
1
vote
0 answers

Test Execution Error in Lambda RDS Data API for Javascript

I am trying to connect the AWS Lambda with SQL query to an AWS RDS (MySQL) using the Data API and return the query result for a user with a particular id. This is how the handler looks like: 'use strict'; const AWS = require('aws-sdk') const RDS =…
program_bumble_bee
  • 439
  • 2
  • 25
  • 57
1
vote
2 answers

AWS Lambda times out when calling RDS Serverless

I have a VPC with two ISOLATED subnets, one for my RDS Serverless cluster, and one for my Lambda functions. But my Lambda functions all timeout when they're calling my RDS. My question is; is this VPC + isolated subnets a working structure for API…
Jesper Bylund
  • 883
  • 9
  • 23
1
vote
0 answers

RDS Connection being in idle state. Airflow Celery worker

I am using airflow 1.10.9 and celery worker. I have dags which run whenever task comes and it spins up new ec2 instance and it connects to RDS on the basis of logic but ec2 holds the connection even when there no task is running and it keeps holding…
Shubham Jain
  • 199
  • 1
  • 4
  • 15
1
vote
3 answers

Python how to parse output of Amazon RDS Data Service

I'm struggling to parse output of ExecuteStatement action using Amazon RDS Data service https://docs.aws.amazon.com/rdsdataservice/latest/APIReference/API_ExecuteStatement.html Documentation is very poor and I can't find any meaningful examples. I'm…
Petr Kashlikov
  • 101
  • 1
  • 11
1
vote
1 answer

Load balancing Or Read replica in AWS RDS

The ASP.net MVC application is in EC2 and interacting with RDS ( SQL Server). The application is sending Bulk GET request (API call) to RDS via NHibernate to get the items. The application performance is very slow as sometimes it’s making around 500…
AskMe
  • 2,495
  • 8
  • 49
  • 102
1
vote
1 answer

Is there a way to increase number of connection to AWS RDS

I have an Excel file with 10 records. These records are getting updated into a SQL Server database using an AJAX call. This is working fine. However, when the number of records increases to 100, I get an error Alert message “an error has occurred…
AskMe
  • 2,495
  • 8
  • 49
  • 102
1
vote
2 answers

how to load data from AWS RDS to Google BigQuery in streaming mode?

how to load data from AWS RDS to Google BigQuery in streaming mode? Description: I have data in RDS (SQL Server), and wanted to load this data into Google BigQuery in real-time.
LAHU BHAWAR
  • 93
  • 2
  • 13
1
vote
1 answer

AWS API to query RDS database

Is there any API to query a standard AWS RDS without using an SQL client? I see that there is a data API available for serverless Aurora databases (https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/data-api.html) but it doesn't work for…
tschumann
  • 2,776
  • 3
  • 26
  • 42
1
vote
1 answer

Passing in IAM credentials when using the Aurora Serverless Data API?

I am trying to figure out how to pass in static IAM AWS credentials when using the AWS Data API to interact with an Aurora Serverless db. I am using the AWS Python Boto library and I read data from a table like this (which by default uses the…
user1974753
  • 1,359
  • 1
  • 18
  • 32
0
votes
0 answers

AWS REDCap installation error DBParameterGroupFamily aurora-mysql5.7 cannot be used

I installed REDCap from this github launch stack button. For the first time installation it went good and installed the necessary stack without any issue. However, due to some other issues with existing installation I decided to install another…
Karan
  • 752
  • 2
  • 13
  • 34
0
votes
1 answer

Prisma Data Proxy ignoring connection limit and pool timeout in serverless environment (AWS + Serverless Framework + Prisma ORM)

I'm trying to use connection_limit and pool_timeout Prisma Data proxy with specific values, but it seems to ignore them. I'm using PostgreSQL in AWS RDS. My current connection test…
Dave
  • 1
  • 1
0
votes
0 answers

how can we get RDS(postgres) database in aws-glue script without using connection

I am trying to get the data from RDS database using aws glue service. I know using connection we can get the solution. But I wanted to know is there any way to access our RDS-database in glue-script directly. I tried with below code but it is not…
Akash Gupta
  • 1
  • 1
0
votes
2 answers

How to connect MySQL Database to Spring boot 3?

I am writing Restful API in Spring boot 3 with java 17 and i am unable to create table .Can anyone please help POM File
Bhavya Kalra
  • 1
  • 1
  • 4
1
2
3