Shadowing Practice: Data Ingestion Best Practices! How to Ingest Data Efficiently at Enterprise Scale! - Learn English Speaking with Video
Creando lección...
1
Hey y'all, Data Guy here and today I'm back with yet another viewer request video,
2
this time talking about best practices for data ingestion.
3
So really focusing on the first part of your data pipelines, really the first part of almost any data engineering workflow,
4
right, is bringing data into the platform that you want that data to be brought into.
5
And so that's what we're going to explore today, is really how you can design effective systems for data ingestion regardless of what tools you're using.
6
So this isn't really a video exploring, hey, what tools you use for data ingestion, but rather what high level design practices, which are really global to any kind of data ingestion use case,
7
should you apply
8
when you're designing your data ingestion workflows to make sure you're designing them as efficiently as possible
9
and you're designing them for enterprise scale because that's what everyone wants, right?
10
So if you like these videos, please like, subscribe, consider joining my Patreon, It helps me out a ton, but without further ado, let's get into it.
11
Now, when you're initially designing your data pipelines and data ingestion, you want to design for scale and elasticity above all else.
12
Especially in cloud architectures, it is a necessity because data volumes can spark unpredictably due to external events, user behavior, system interactions.
13
There's so many different ways that your data volumes can spike unexpectedly.
14
And so your best practice here is going to be using things that are serverless or auto-scaling.
15
So, you know, servers like AWS Lambda functions or Google Cloud functions can ingest bursts of data without provisioning infrastructure,
16
but really any kind of serverless or auto-scaling component that you might want to use to, or
17
that you're going to need to use to make sure you
18
can handle those bursts of data without having a bunch of extra compute sitting idly by.
19
And in tandem with this, managed integration services like AWS Kinesis
20
or Google PubSub also help provide built-in scalability where you only pay for what you use
21
and so they're designed for high throughput ingestion in that way
22
because they'll automatically scale to match the amount of data that you actually need to adjust.
23
And another thing to you know think about designing for even
24
at the earlier stages of your data ingestion pipelines are using time-based
25
or key-based partition strategies to in your object storage systems to prevent any performance bottlenecks downstream,
26
you know, by making your data partitioned effectively earlier on, then the downstream queries don't need to query and go over all of that data.
27
They only need to go toward through their relevant partition.
28
Now, the next thing you want to think about is ensuring data quality at your ingestion point.
29
It's a lot cheaper to catch errors early and trim bad data than processing it and trying to fix it downstream.
30
Bad data is going to create bad outputs.
31
And so by not putting garbage in, you're not gonna get garbage out.
32
And so to accomplish this, you want to do things like input data quality checks to validate schemas at ingestion, you know, using schema enforcement tools.
33
You know, there's glue schema registry, there's confluent schema registry that you can use to compare the ingested schema versus an existing schema.
34
And there's also open source tools as well to make sure that the data is of the expected shape.
35
And then also implement data contracts, which are basically strict expectations programmatically defined for incoming data from producers using tools like open API,
36
protocol buffers, or even just having JSON schemas that say this data has to match this particular format.
37
And then also, your biggest kind of guard against bad data is leveraging integrating tools like Soda,
38
like Great Expectations, to automatically verify and apply more complex freshness
39
or no value checks or to check distribution of data or type consistency.
40
Those tools will actually help you dig into the data
41
and understand it rather than just doing high level schema or shape validation.
42
So it's a combination of both of those tools using conjunction
43
to help raise any issues as early as possible in the data pipeline to stop that bad data getting processed any further.
44
Now, the next thing you're going to want to think about, especially in today's day and age, is being able to support both batch and streaming workloads.
45
It's highly unlikely in modern stacks that you're only going to be doing batch processing, only going to be doing stream processing,
46
and you're likely going to be doing some kind of hybrid pipeline where, you know, you might be processing historical data in bulk and then streaming any real-time updates after that fact, right?
47
And the best practices here for making sure you can support
48
both of these use cases are to use cloud-native hybrid ingestion frameworks, you know, Databricks structured streaming and,
49
you know, Spark structured streaming essentially is a great way to, hey, if I want to use Spark for both streaming and batch, you can do that.
50
You also have Flink, Apache Flink, which will run both batch and streaming workloads or Apache Beam as well.
51
And within here as well, you know, other than, you know, the kind of tools and platforms you want to use, you also are going to want to design your ingestion logic for item potency
52
and making sure that your ingestion logic can safely replay
53
or reprocess data and get the same result to avoid duplication and loss,
54
because that's really critical with streaming workloads and avoiding data from being processed twice and again gumming up your backend databases.
55
Another good practice here is to separate raw and processed stones.
56
You have a raw data ingestion zone in S3
57
or GCS bucket before anything actually gets processed to support reprocessing
58
and recovery if you ever need to go back and reprocess any raw data as well.
59
Those are all great ways to make sure you're able to accomplish batch and streaming use cases equally effectively.
60
Now the next topic I want to discuss is everyone's favorite and that is secured.
61
Data ingestion is most often the way you're going to be ingesting and opening your systems up to sensitive data,
62
and you're going to need to implement proper protections and observability on that to make sure it stays secure.
63
And the first thing, you're going to want to make sure your data is always encrypted in transit and at rest.
64
So use things like TLS for all network transmission and cloud-native encryption protocols for stored data.
65
and then also implement access controls using your IAM policies to restrict access by source, type, and role and implement least privileged based access
66
so everyone is only scoped to access the data that they are explicitly need for their job, right?
67
And then enable, you know, observability across your entire pipeline, you know, make sure your ingestion pipelines have structured logging
68
and metrics and tracing using tools like Prometheus and OpenTelemetry and Datadog
69
So you can also set up further gates against kind of bad data or, you know, any kind of unexpected or anomalous behavior, which might indicate, you know,
70
some type of, you know, leaking of data or, you know, some kind of degradation in your security.
71
Now, the next thing I'll talk about is designing for fault tolerance and resiliency.
72
A big piece of designing good, effective data investment pipelines is making sure they can gracefully handle failures to maintain SLAs and data integrity.
73
And here, you know, number one, you're going to want to think about ensuring a high availability, deploy ingestion services across multiple zones or regions when possible.
74
You know, things like multi-zone Kafka clusters or regional failover in Event Hub.
75
So if there's a failure or degradation service in one region, your jobs will start to get processed in another active region.
76
Another thing you might want to use is something like a dead letter queue.
77
And that will route any unprocessable records to separate storage instead of just deleting them
78
or throwing them out for later inspection remediation so
79
if you get bad data you can actually look at
80
that bad data down the line understand hey why did we get this
81
and fix the process or the issue that caused
82
that bad data in the first place
83
and then also retry logic making sure you're have retry logical exponential back off
84
so you don't flood systems during outages now
85
if you don't have exponential back off you know
86
and you just have retry logic then all of your pipelines
87
that are failing are going to start trying again and pinging
88
and just going to overload any back-end service that they're connecting to.
89
So you want to make sure that you have exponential backoffs
90
that gets spread out over a longer time period and you don't have those service overloads occur.
91
Now, the next thing you want to think about is metadata capture and lineage tracking.
92
Metadata and lineage are vital for any kind of debugging or governance or auditing use cases.
93
And it's really hard to get that down the line if you aren't capturing it during ingestion.
94
So capture attributes like source system, like the time stand, like the transformation status of every step of your data pipeline
95
so that you understand how data is processed and evolved.
96
And then also implement lineage tracking tools like OpenLineage with Marques
97
or Dataplex to record and track and visualize how data flows go from start to finish.
98
You have a visual representation.
99
You can see how data is changing and evolving
100
and going through your various systems so you can identify bottlenecks or areas of issue.
101
And then also adopt a data catalog.
102
You know, you're going to want to make sure you have a central
103
place to store all of this metadata to make sure it's easily queryable and understandable and has all the context necessary.
104
And here you have, you know, something like AWS Glue catalog or Azure Purview or Google Data Catalog for discoverability and compliance and storing all this metadata.
105
Now, finally, the last piece of advice I have for you is making sure you're choosing the right tool for the job.
106
different ingestion scenarios are gonna require different tools and
107
so it's you're gonna want to make sure you're matching the right technology to your needs
108
and not trying to cram everything in one
109
that is the biggest cause of pain I see out there
110
is hey my company said we're all going all in on Databricks
111
and Spark so everything is gonna happen through Spark
112
and there's a lot of things
113
that aren't really well designed for running with Spark right and
114
so making sure you're using the right tool for each job
115
and having a whole different set of different tools for each scenario you might need to encounter is crucial
116
And it doesn't and won't force you to just cram use cases into tools
117
that aren't designed for that and have them run in efficiently.
118
So some general guidelines, you can see some examples in here, is for any kind of real-time streaming tool,
119
use a dedicated real-time streaming tool like Kafka or Pulsar or Kinesis or Flink or Azure Event Hub or Cloud PubSub.
120
For tools like for change data capture, that's where tools like Debezium is probably the gold standard.
121
Then you also have 5Tran or Airbyte that can also stream changes from operational databases as well.
122
And then for any kind of batch data ingestion, orchestrators like Airflow or Mage
123
or Daxter are really great tools for managing all the different stages of your data pipeline
124
and managing all the different tools you might need to ingest from instead of learning mechanisms
125
and give you a single kind of framework to manipulate data and move data around your environments.
126
And then finally, for IoT or event heavy pipelines, then you're actually going to want to look at time series ingestion platforms like InfluxDB or TimescaleDB,
127
which are going to be really well custom designed for those very specific set of needs you use for those use cases.
128
So that is really all different things I wanted to talk about here.
129
Data ingestion in cloud architectures is no longer, hey, you can just have a one size fits all approach.
130
you need to have modularity, elasticity, flexibility to design effective data pipelines in the day, state, and age.
131
So I hope this video has helped you figure out how to do that.
132
I hope you have a great rest of your day.
133
Data Guy out.
📺 Mismo canal
✨ Recomendar Video
C11
120 oraciones
Learn Data Modeling in 8 minutes: Dimensional Data Modeling, Data Vault, and One Big Table
Business EnglishUniversity StudentsWorking Adults
C11
159 oraciones
Top 5 AI Gateway Use Cases | Solo.io
Business EnglishUniversity StudentsWorking Adults
C1204 oraciones
Prompt Engineering - Guidelines
Business EnglishUniversity StudentsWorking Adults
C12
86 oraciones
System Design: Why is Kafka Popular?
Business EnglishUniversity StudentsWorking Adults
C12
187 oraciones
How to ACTUALLY Get a DevOps Job in 2026
Business EnglishInterview EnglishUniversity Students
C11
180 oraciones
Armchair Architects: Resiliency in the Cloud – Core Patterns
Business EnglishUniversity StudentsWorking Adults
C115
29 oraciones
Amazon Athena explained in 120 seconds💡
Business EnglishUniversity StudentsWorking Adults
C12
540 oraciones
Incremental Cooking in UE 5.7: A Dive Into the UE Cook Pipeline | Unreal Fest Chicago 2026
Business EnglishUniversity StudentsWorking Adults
C12
4 oraciones
What is Event Driven Architecture (EDA)?
Business EnglishUniversity StudentsWorking Adults
C11
149 oraciones
Inside a warehouse run by AI robots
Business EnglishUniversity StudentsWorking Adults
C1549 oraciones
The HR Dialogues #49 | Key Elements of a High-Performance Culture: What HR Needs To Know
Business EnglishUniversity StudentsWorking Adults
C11
114 oraciones
Design a File Upload Service Like a Senior Engineer
Business EnglishUniversity StudentsWorking Adults
Vocabulario y notas de pronunciación para esta lección
Esta lección de conversación de nivel C1 se basa en el vídeo “Data Ingestion Best Practices! How to Ingest Data Efficiently at Enterprise Scale!”. Las palabras que más se repiten: ingestion, tool, pipeline, streaming. Este vídeo tiene 133 frases y 2130 palabras para practicar shadowing. La parte hablada dura 11:27. El hablante habla rápido, unas 186 palabras por minuto, así que espera sonidos enlazados y reducidos. Solo el 80 % de las palabras está entre las 3.000 más comunes del inglés, por lo que el vocabulario es exigente.
Vocabulario clave de este vídeo
Las 15 palabras más avanzadas del vídeo, con su pronunciación y significado:
| Palabra | Pronunciación | Significado |
|---|---|---|
| ingestion sustantivo | /ɪnˈd͡ʒɛst͡ʃən/ | ingestión, ingesta |
| pipeline sustantivo | /ˈpaɪpˌlaɪn/ | oleoducto, tubería |
| batch sustantivo | /bæt͡ʃ/ | hornada, tanda |
| spark sustantivo | /ˈspɑɹk/ | chispa, centella |
| ingest verbo | /ɪnˈd͡ʒɛst/ | ingerir, deglutir |
| metadata sustantivo | /ˈmɛt.əˌdeɪ.tə/ | metadatos |
| exponential adjetivo | /ˌɛk.spəˈnɛn.t͡ʃəl/ | exponencial |
| lineage sustantivo | /ˈlɪn.i.ɪd͡ʒ/ | linaje, estirpe |
| workload sustantivo | volumen laboral, carga laboral | |
| downstream adjetivo | /ˌdaʊnˈstɹiːm/ | río abajo |
| partition sustantivo | /pɑɹˈtɪ.ʃən/ | parte |
| catalogue sustantivo | /ˈkæt.əˌlɔɡ/ | catálogo |
| bottleneck sustantivo | cuello de botella | |
| cram verbo | /kɹæm/ | atestar, atiborrar |
| elasticity sustantivo | /ɪ.læsˈtɪs.ɪ.ti/ | elasticidad |
Phrasal verbs que vas a escuchar
| Palabra | Significado |
|---|---|
| back off verbo | dejar/parar de insistir |
| figure out verbo | averiguar, captar |
| go over verbo | sentar, pasar |
| go through verbo | atravesar |
| see out verbo | acompañar |
Gramática en este vídeo
Las estructuras que más usa el hablante, con las palabras exactas del vídeo:
| Estructura | En el vídeo |
|---|---|
| Voz pasiva be + participio pasado — importa lo que ocurre, no quién lo hace | be brought · being processed · is secured |
| Oraciones de relativo who / which + oración — información extra sobre una persona o cosa | practices, which are · contracts, which are · Flink, which will |
| Present perfect have/has + participio pasado — una acción pasada que sigue importando ahora | have structured · has helped |
Pronunciación a tener en cuenta
El hablante usa 43 contracciones y formas reducidas, como you're, don't, gonna. Dilas en su forma corta, tal como las oyes.
- Los sonidos de “sh” y “zh”: partition /pɑɹˈtɪ.ʃən/, degradation /ˌdɛɡɹəˈdeɪʃən/, expectation /ˌɛk.spɛkˈteɪ.ʃən/, accomplish /əˈkɑm.plɪʃ/, duplication /d(j)u.plɪˈkeɪ.ʃən/
- Palabras largas — cuida el acento: metadata /ˈmɛt.əˌdeɪ.tə/, exponential /ˌɛk.spəˈnɛn.t͡ʃəl/, elasticity /ɪ.læsˈtɪs.ɪ.ti/, degradation /ˌdɛɡɹəˈdeɪʃən/, automobile /ˈɔː.tə.məˌbil/
Sonidos difíciles para hispanohablantes:
- s + consonante al inicio — sin añadir una “e” delante: schema /ˈskiːmə/, spark /ˈspɑɹk/, spike /spaɪk/
- /v/ — no es /b/: los dientes tocan el labio inferior: overload /ˌəʊvəˈləʊd/, evolve /ɪˈvɑlv/, validation /ˌvæl.əˈdeɪ.ʃən/, viewer /ˈvju.ɚ/, verify /ˈvɛɹɪfaɪ/
- /dʒ/ — no es la “y” ni la “ch”: ingestion /ɪnˈd͡ʒɛst͡ʃən/, ingest /ɪnˈd͡ʒɛst/, lineage /ˈlɪn.i.ɪd͡ʒ/, registry /ˈɹɛd͡ʒɪstɹi/, outage /ˈaʊ.tɪd͡ʒ/
Cómo practicar con este vídeo
- Escucha el vídeo entero una vez sin hablar y anota las palabras que no conoces.
- Empieza a velocidad 0,75×, haz shadowing frase por frase y vuelve a la velocidad normal cuando te resulte fácil.
- Grábate y compara con el original, prestando atención a palabras como ingestion, pipeline, batch.
¿Qué es la Técnica de Shadowing?
Shadowing es una técnica de aprendizaje de idiomas respaldada por la ciencia, desarrollada originalmente para la formación de intérpretes profesionales y popularizada por el políglota Dr. Alexander Arguelles. El método es simple pero poderoso: escuchas audio en inglés nativo y lo repites en voz alta de inmediato, como una sombra que sigue al hablante con solo 1-2 segundos de retraso. A diferencia de la escucha pasiva o los ejercicios de gramática, el shadowing obliga a tu cerebro y músculos de la boca a procesar y reproducir simultáneamente patrones de habla reales. Las investigaciones muestran que mejora significativamente la precisión de la pronunciación, la entonación, el ritmo, el habla conectada, la comprensión auditiva y la fluidez al hablar, convirtiéndola en una de las metodologías más efectivas para la preparación del IELTS Speaking y la comunicación en inglés en el mundo real.