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 Analysis for Beginners: Excel & Pivot Tables

Data Analysis for Beginners: Excel & Pivot Tables

Sources: zerotomastery.io
This short course on data analysis in Excel is perfect for beginners who want to acquire skills in analyzing structured data using two of Excel's most...
2 hours 10 minutes 21 seconds
Azure Data Pipelines with Terraform

Azure Data Pipelines with Terraform

Sources: Andreas Kretz
Azure is becoming an increasingly popular platform for companies using the Microsoft365 ecosystem. If you want to enhance your data engineering skills...
4 hours 20 minutes 29 seconds
MongoDB Fundamentals

MongoDB Fundamentals

Sources: Andreas Kretz
Document-oriented databases are rapidly gaining popularity among NoSQL solutions. Working with JSON documents in MongoDB is convenient, flexible, and...
1 hour 23 minutes 19 seconds
Machine Learning with Javascript

Machine Learning with Javascript

Sources: udemy, Stephen Grider
If you're here, you already know the truth: Machine Learning is the future of everything. In the coming years, there won't be a single industry in the world untouched by Machine...
17 hours 42 minutes 20 seconds
Deep Learning A-Z™: Hands-On Artificial Neural Networks

Deep Learning A-Z™: Hands-On Artificial Neural Networks

Sources: udemy
Artificial intelligence is growing exponentially. There is no doubt about that. Self-driving cars are clocking up millions of miles, IBM Watson is diagnosing pa
22 hours 36 minutes 30 seconds