Dockerized ETL With AWS, TDengine & Grafana

29m 12s
English
Paid

Course description

Data engineers often need to quickly set up a simple ETL script that just gets the job done. In this project, you will learn how to easily implement such an ETL on AWS: connect live data from a weather API and write it to a TDengine time-series database.
Read more about the course

What you will learn

The Basics of Temporal Databases

You will get acquainted with the basics of working with temporal databases, their architecture, and use cases.

Working with a Public Weather API

You will set up and explore an external weather API, and write a Python script to read data from the API.

Docker ETL on AWS

You will package the script into a Docker container and deploy it as a serverless ETL using Amazon Elastic Container Registry (ECR), Lambda, and EventBridge.

TDengine Setup

You will get familiar with TDengine, set up an instance via the TDengine cloud and configure the database.

Data Visualization in Grafana

You will visualize data from the API stored in TDengine using Grafana. You’ll learn how to connect TDengine to Grafana and create a dashboard for data analysis.

Watch Online

This is a demo lesson (10:00 remaining)

You can watch up to 10 minutes for free. Subscribe to unlock all 16 lessons in this course and access 10,000+ hours of premium content across all courses.

View Pricing
0:00
/
#1: Quick note from Andreas before you begin

All Course Lessons (16)

#Lesson TitleDurationAccess
1
Quick note from Andreas before you begin Demo
00:44
2
Introduction
01:27
3
Setup Of The Project
02:53
4
Time Series Data Basics
02:21
5
Big Pros Of Timeseries Databases
02:07
6
About TDengine
01:23
7
Setup Weather API
01:05
8
Code query API
02:42
9
TDengine Setup
03:05
10
Connect Python To TDengine
01:51
11
Lambda Docker Container & Push To ECR
01:56
12
AWS Setup
01:37
13
Create Lambda Function Using Docker image
01:05
14
Schedule Function With EventBridge
01:26
15
Cloud Watch Lambda Events
00:28
16
Grafana Setup
03:02

Unlock unlimited learning

Get instant access to all 15 lessons in this course, plus thousands of other premium courses. One subscription, unlimited knowledge.

Learn more about subscription

Comments

0 comments

Want to join the conversation?

Sign in to comment

Similar courses

Data Structures and Algorithmic Trading: Machine Learning

Data Structures and Algorithmic Trading: Machine Learning

Sources: udemy
Data Structures and Algorithmic trading is a method of executing orders using automated pre-programmed trading instructions over time. They were developed so th
2 hours 20 minutes 32 seconds
Build a Large Language Model (From Scratch)

Build a Large Language Model (From Scratch)

Sources: Sebastian Raschka
"Creating a Large Language Model from Scratch" is a practical guide that will teach you step by step how to create, train, and fine-tune large language models..
Data Analysis for Beginners: Python & Statistics

Data Analysis for Beginners: Python & Statistics

Sources: zerotomastery.io
This course is your first step into the world of data analysis using one of the main tools for analysts - Python. Without complicated terms, advanced...
6 hours 34 minutes 20 seconds
DS4B 101-P: Python for Data Science Automation

DS4B 101-P: Python for Data Science Automation

Sources: Business Science University
Python for Data Science Automation is an innovative course designed to teach data analysts how to convert business processes to python-based data science automations. The course...
27 hours 6 minutes 1 second
Choosing Data Stores

Choosing Data Stores

Sources: Andreas Kretz
One of the key tasks when creating a data platform and pipelines is the selection of appropriate data storage systems. This course is dedicated to that topic.
1 hour 25 minutes 31 seconds