TimescaleDB with AWS Lambda

This section contains tutorials for working with AWS Lambda and TimescaleDB.

• Create a data API for TimescaleDB using AWS Lambda and API Gateway.
• Pull data from 3rd party API and ingest into TimescaleDB using AWS Lambda and Docker. This is great if you have a lot of dependencies.
• Continuously deploy your Lambda function with GitHub Actions using Github Actions.

Prerequisites

Before you begin, make sure you have completed the Analyze intraday stock data tutorial. This tutorial needs the tables and data that you set up in that tutorial.

To complete this tutorial, you need an AWS account. You also need access to the AWS command-line interface (CLI). To check if you have AWS CLI installed, use this command at the command prompt. If it is installed, the command shows the version number, like this:

aws --version
aws-cli/2.2.18 Python/3.8.8 Linux/5.10.0-1044-oem exe/x86_64.ubuntu.20 prompt/off

For more information about installing the AWS CLI, see the AWS installation instructions.

VPC on Timescale Cloud

If you are completing this tutorial in Timescale Cloud, make sure you have created a VPC on both AWS, and on your database in Timescale Cloud. For more information about setting up a VPC, see the Timescale Cloud VPC section.

Try for free

Programming language

The code examples in this tutorial use Python, but you can use any language supported by AWS Lambda.

Resources

For more information about the topics in this tutorial, check out these resources:

• AWS CLI Version 2 References
• Creating Lambda container images
• Getting started with AWS Lambda
• Analyze historical intraday stock data
• Analyze cryptocurrency market data