We talked about:
- Natalie’s background
- Airbyte
- What is ETL?
- Why ELT instead of ETL?
- Transformations
- How does ELT help analysts be more independent?
- Data marts and Data warehouses
- Ingestion DB
- ETL vs ELT
- Data lakes
- Data swamps
- Data governance
- Ingestion layer vs Data lake
- Do you need both a Data warehouse and a Data lake?
- Airbyte and ELT
- Modern data stack
- Reverse ETL
- Is drag-and-drop killing data engineering jobs?
- Who is responsible for managing unused data?
- CDC – Change Data Capture
- Slowly changing dimension
- Are there cases where ETL is preferable over ELT?
- Why is Airbyte open source?
- The case of Elasticsearch and AWS
Links:
- Natalie's LinkedIn: https://www.linkedin.com/in/nataliekwong/
- https://airbyte.io/blog/why-the-future-of-etl-is-not-elt-but-el
Join DataTalks.Club: https://datatalks.club/slack.html
Our events: https://datatalks.club/events.html