CLI tool to Query the AWS Aurora Serverless Data API

Photo by Max Langelott on Unsplash

CLI Tool (quick & dirty Python script :)

  1. if you don’t use profiles for AWS, you could remove the line that creates the Session (then it will read your default profile/AWS key from the ~/.aws/credentials file). Or, you could remove that, and then prefix the command with AWS_PROFILE=someprofile to specify that on the command line, etc.
  2. If the results of your SQL call have a lot of columns (i.e. wider than your terminal window), then the data will be elided. You could print the dataframe other ways (see the tabulate package for example), or use the to_csv method on the dataframe to convert it to CSV, etc.

--

--

--

NatureQuant CTO/Co-founder. HotelTonight Co-founder. Cyclist, trail runner, espresso & coffee lover, geek, traveler, foodie.

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

Basic HTML Concepts You Absolutely Need to Know

The features of Google Sheets that you would like to know

ACS Engine Kubernetes cluster upgrades

How To Build A Dynamic Menu In ExpressionEngine?

How To Build A Dynamic Menu In ExpressionEngine?

Forces to Bring Increased Flexibility with Open Source

How Table Store Implements Cross-Region Disaster Tolerance

Building a “Maintenance Mode” with Terraform and Github Pages

Maintenance mode — We are on it

What is Agile Software Development?

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Chris Bailey

Chris Bailey

NatureQuant CTO/Co-founder. HotelTonight Co-founder. Cyclist, trail runner, espresso & coffee lover, geek, traveler, foodie.

More from Medium

How to create custom domain API in AWS API Gateway

How to upload data to S3 using a Py Flask App — let’s code

AWS S3 Read and Write Operations using AWS Lambda (Typescript/Javascript)

How to deploy Fargate Service (Serverless) using AWS CDK