List: ETL | Curated by Mohd Atif

Feb 21, 2023
40 stories
ETL
Chris So
I built an E(T)L-pipeline in Python to transfer data from MS SQL Server to PostgreSQL… and you should, too!
Mar 16, 2021
Mar 16, 2021
Konstantinos Patronas
Python: Create an ETL with Luigi, Pandas and SQLAlchemyWhat is ETL?
Dec 6, 2020
3
Dec 6, 2020
3
Luís Oliveira
in
Level Up Coding
Data Warehouse vs Data Lake vs Data LakehouseImportant concepts explained in a simple way
Feb 6, 2023
Feb 6, 2023
Da Data Guy
Optimizing SQL Temp Tables Using This Trick?We’ve all wrote SQL queries where we either can’t use a windows function, such as COUNT, inside of a WHERE clause or using too many joins…
Oct 12, 2022
Oct 12, 2022
Lorenzo Peppoloni
in
Towards Data Science
Data pipelines, Luigi, Airflow: everything you need to knowThis post is based on a talk I recently gave to my colleagues about Airflow.
Sep 20, 2018
13
Sep 20, 2018
13
Felipe Hoffa
in
Snowflake Builders Blog: Data Engineers, App Developers, AI/ML, & Data Science
Magic Data Apps with Snowflake, Streamlit, and DuckDBThis pattern will allow you to create high-traffic apps available to the world, hosted by Streamlit Cloud. Play and prepare your data with…
May 27, 2022
1
May 27, 2022
1
Fran Lozano
Building a data application with DuckDBVisualizing the car and motorcycle market in Spain from my computer.
Dec 4, 2022
1
Dec 4, 2022
1
Haq Nawaz
in
Dev Genius
Build Data Pipelines with Airbyte, a new Data Integration toolUsing Airbyte, SQL Server, PostgreSQL
Dec 24, 2022
Dec 24, 2022
Lucca Miorelli
How to track tweets about movies with Apache Airflow: a Data Engineering ProjectIntroduction
Nov 3, 2022
Nov 3, 2022
Julia Rolemberg
How can we make data engineers work less? Part 2 — Step-by-Step guideThis post’s goal is to continue engaging data engineering teams to automate their ETLs. Coding Step-by-Step guide.
Oct 26, 2022
Oct 26, 2022
Julia Rolemberg
How can we make data engineers work less? Part 1This post aims to engage data engineering teams to automate their ETLs, so they can focus on developing advanced strategies, not only…
Oct 12, 2022
1
Oct 12, 2022
1
Muhammad Usman
in
Nerd For Tech
Visual Analytics of COVID-19 in Grafana using PostgreSQL (part-1)Coronavirus disease (COVID-19) is an infectious disease caused by a virus that can spread from person to person.
Jul 23, 2021
Jul 23, 2021
Muhammad Haseeb
Building a Highly Scalable Data Streaming Pipeline in PythonA step by step guide for building a highly scalable data streaming pipeline in Python.
Nov 27, 2022
Nov 27, 2022
Dana Fatadilla Rabba
in
Towards Dev
ETL Data Pipeline - Scraping Data to BigQuery and Scheduling using AirflowTable of Content
Oct 14, 2022
Oct 14, 2022
 This story is no longer available
Dayo Opedare
How to Build a Simple ETL Process with Python — A Beginner’s GuideIn this post, I am going to show you how you can download and extract a csv, json and xml file from a zip file, transform it and load it…
Sep 21, 2022
Sep 21, 2022
Kenneth Leung
in
Towards Data Science
PyMySQL — Connecting Python and SQL for Data ScienceEasily access MySQL databases and execute SQL queries in Python
Sep 13, 2022
3
Sep 13, 2022
3
Vaideek Bhanushali
in
Dev Genius
Data Analyst Portfolio Project.Data Analyst Portfolio Projects can be very tricky, difficult to find and successfully making them without getting a SQL query error or…
Sep 7, 2022
4
Sep 7, 2022
4
Zach Quinn
in
Pipeline: Your Data Engineering Resource
3 Data Science Projects That Got Me 12 Interviews. And 1 That Got Me in Trouble.3 work samples that got my foot in the door, and 1 that almost got me tossed out.
Aug 29, 2022
71
Aug 29, 2022
71
Ignacio Valdelvira
From Zero to Modern Data StackThe evolution of Phlo’s data platform, from an early hand-rolled v1 to a scalable Modern Data Stack
Jul 6, 2022
Jul 6, 2022