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
22
votes
5 answers

AWS RDS Data API executeStatement not return column names

I'm playing with the New Data API for Amazon Aurora Serverless Is it possible to get the table column names in the response? If for example I run the following query in a user table with the columns id, first_name, last_name, email, phone: const…
niqui
  • 1,562
  • 1
  • 16
  • 28
8
votes
1 answer

Getting an Aurora Serverless Cluster ARN in CloudFormation (Output)

I am having trouble retrieving the ARN for a new RDS Aurora Serverless cluster inside a CloudFormation template. Can someone please advise on what reference the output value should be below? Resources: RDSCluster: Type: AWS::RDS::DBCluster …
mark
  • 1,953
  • 1
  • 24
  • 47
5
votes
1 answer

How to achieve consistent read across multiple SELECT using AWS RDS DataService (Aurora Serverless)

I'm not sure how to achieve consistent read across multiple SELECT queries. I need to run several SELECT queries and to make sure that between them, no UPDATE, DELETE or CREATE has altered the overall consistency. The best case for me would be…
Yves M.
  • 29,855
  • 23
  • 108
  • 144
4
votes
2 answers

Is it possible to use SQLAlchemy with AWS RDS Data API?

AWS Recently launched the Data API. This simplifies creating Lambda functions, eliminating the necessity for additional complexity by allowing API calls, instead of direct database connections. I'm trying to use SQLAlchemy in an AWS Lambda Function,…
naydichev
  • 4,672
  • 1
  • 19
  • 14
3
votes
0 answers

How to format an RDSDataService batchExecuteStatement for an update query with parameters?

I'm using the RDSDataService.batchExecuteStatement to update records in a postgres database. I'm struggling with understanding how the query parameter should be formatted for an update query. The insert query is very straight forward and the…
TemporaryFix
  • 2,008
  • 3
  • 30
  • 54
3
votes
1 answer

Best practices to escape string in AWS RDS DataService with Aurora postgres serverless

I read from: https://aws.amazon.com/blogs/database/using-the-data-api-to-interact-with-an-amazon-aurora-serverless-mysql-database/ The RDSDataService client also supports parameterized queries by allowing you to use placeholder parameters in SQL…
Phan Việt
  • 1,253
  • 11
  • 11
3
votes
2 answers

How do I paginate my mysql query using AWS rds-data using boto3 and AWS-aurora?

I am querying AWS Aurora (MySQL) serverless from AWS Lambda using Boto3. I want to query a table that has more than 10k records. My query can fetch records more than 7k. Now how can I paginate this data, on database level or Lambda level, so that I…
Shashikant Kulkarni
  • 177
  • 3
  • 15
2
votes
0 answers

How to rename the column names in AWS RDS Data API?

I just showed the data from SQL, and it is returned as a JSON ExecuteStatement. The response is like this: { "numberOfRecordsUpdated": 0, "records": [ [ { "isNull": 1 }, { …
Zani123
  • 210
  • 2
  • 11
2
votes
0 answers

AWS AppSync cannot access Aurora Serverless Postgres Cluster via VTL resolvers anymore

It seems like there was some kind of breaking change and now AWS AppSync cannot access Aurora Serverless Postgres Cluster via VTL resolvers anymore. Following even the simplest examples like this…
Christine
  • 3,014
  • 2
  • 24
  • 34
1
vote
1 answer

The size of RDS on AWS is growing exponentially every day

I set up an RDS on AWS. I'm using the free domain for my trials. There is only one table in the database and there is very little data in the table. But when I enter the free space used, it increases by almost 2 GB every day. I think he backs up one…
voltac
  • 33
  • 7
1
vote
1 answer

RDSdataService execute_statement returns (BadRequestException)

I am using boto3 library with executeStatement to get data from an RDS cluster using DATA API. Query is working fine if i select 1 or 2 columns but as soon as I select another column to query, it returns an error with (BadRequestException) …
Rishi
  • 313
  • 1
  • 4
  • 18
1
vote
1 answer

What is the downstream effect of changing AWS RDS instance default time Zone from UTC to EST?

We are using UTC time Zone as default in AWS RDS instance. All mysql databases are running in RDS instance following UTC. But based on the requirement I need to change UTC to EST so all DBs are running in EST. This is a trading platform and we…
user3430726
  • 55
  • 1
  • 7
1
vote
1 answer

AWS Aurora serverless DataApi access using custom http call (curl)

I am trying to use aurora serverless data API feature to reduce the db connection time in my serverless application. But building client is taking time. I would like to call rds HTTP service via lambda to get/post data. I came across some was posts…
Ashutosh Tripathi
  • 31
  • 5
1
vote
0 answers

How to access secret manager with boto3 and rds-data

In a chalice route, I'm using boto3 to execute queries against my RDS Aurora Serverless DB cluster. This works as expected locally ($ chalice local) but when deployed on Lamdba I receive the error: An error occurred (BadRequestException) when…
lovelikelando
  • 7,593
  • 6
  • 32
  • 50
1
vote
1 answer

Boto3 rds-data continueAfterTimeout not supported in Aurora Serverless?

I am trying to use AWS rds-data api to perform some heavy etl in aurora Serverless Postgresql. As per AWS Rds DATA documentation, By default, a call times out if it's not finished processing within 45 seconds. However, you can continue running a…
Manuel G
  • 1,523
  • 1
  • 21
  • 34
1
2 3