Understanding _dlt_id and _dlt_parent_id in dlt
Learn what _dlt_id and _dlt_parent_id mean in dlt, why they appear in normalized tables, and how to use them in SQL joins.
dlt
8 posts
How dlt Loads Nested JSON into Tables in DuckDB
Learn how dlt normalizes nested JSON into parent and child tables in DuckDB using a simple students and courses example.
When to Use replace, append, or merge in a dlt Pipeline
Learn when to use replace, append, or merge in a dlt pipeline with practical DuckDB examples and beginner-friendly explanations.
How to Load JSON Data into DuckDB using dlt
Learn how to load a local JSON file into DuckDB with dlt, inspect the result with SQL, and understand a simple data pipeline pattern.
How to Load CSV Data into DuckDB using dlt
Learn how to load a local CSV file into DuckDB with dlt, inspect the result with SQL, and understand the basic pipeline pattern.
How to Load API Data into DuckDB with dlt
📘 Introduction In this hands-on tutorial, you will learn how to load data from a REST API into DuckDB using dlt. This is a great first local data pipeline because you do not need a cloud warehouse, a complex setup, or production credentials. We will use dlt to fetch data...
dlt vs dbt: What is the Difference?
📘 Introduction When you start learning modern data pipelines, you will quickly hear about both dlt and dbt. The names look similar, and both tools are used in data engineering workflows. But they solve different problems. In this beginner-friendly guide, we will explain the difference between dlt and dbt, where...
Install and use dlt (data load tool)
Introduction dlt (data load tool) is a powerful Python package that simplifies data ingestion and helps you build efficient data pipelines. In the Extract, Load, Transform (ELT) process, dlt is particularly suited for the Extract (E) and Load (L) stages. In this tutorial, we'll guide you through the...