Pratique du Shadowing: Data Ingestion Best Practices! How to Ingest Data Efficiently at Enterprise Scale! - Apprendre l'anglais à l'oral avec la vidéo
Choisissez un mode d'entraînement
Chaque mode ouvre une salle d'entraînement en plein écran.
133 phrases
Si les phrases sont trop courtes ou trop longues, cliquez sur Edit pour les ajuster.
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.
Télécharger l'application
Tout pour parler couramment
Prononciation IAChaque phrase notée
Phonétique (IPA)Maîtrisez chaque son
VocabulaireEnrichissez votre lexique
Jeu de vocabulaireApprenez en jouant
Même chaîne
C115
Data Modeling Best Practices! Best Practices for Designing Your Data Models!
Daily ConversationUniversity StudentsWorking Adults
C13
What is Master Data Management? MDM Explained for Beginners
Daily ConversationWorking Adults
C12
How to Create Gold, Silver, and Bronze Tables in Postgres for a Medallion Data Architecture!
Business EnglishUniversity StudentsWorking Adults
FOR YOU
Vidéo recommandée
C11
159 phrases
Top 5 AI Gateway Use Cases | Solo.io
Daily ConversationWorking Adults
C11
114 phrases
Design a File Upload Service Like a Senior Engineer
Daily ConversationUniversity StudentsWorking Adults
C12
4 phrases
What is Event Driven Architecture (EDA)?
Daily ConversationUniversity StudentsWorking Adults
C1120
15 phrases
Accelerating generative AI training at scale with SageMaker HyperPod | Amazon Web Services
Daily ConversationWorking Adults
C11
180 phrases
Armchair Architects: Resiliency in the Cloud – Core Patterns
Daily ConversationUniversity StudentsWorking Adults
C12
272 phrases
How I'd Learn n8n if I had to Start Over in 2026
American AccentDaily ConversationUniversity StudentsWorking Adults
C11
114 phrases
Harnessing generative AI in architecture, engineering & construction
Daily ConversationUniversity StudentsWorking Adults
C11
74 phrases
LangChain in 5 Minutes (Explained Clearly)
Daily ConversationUniversity StudentsWorking Adults
C11
37 phrases
How Anthropic uses Claude in Product Management
Daily ConversationUniversity StudentsWorking Adults
B21
169 phrases
World’s most advanced robotic warehouse (AI automation)
Daily ConversationWorking Adults
C11
341 phrases
I Tried PewDiePie's Odysseus AI So You Don't Have To
Daily ConversationWorking Adults
Vocabulaire et conseils d’expression pour cette leçon
Cette leçon d’expression orale de niveau C1 s’appuie sur la vidéo « Data Ingestion Best Practices! How to Ingest Data Efficiently at Enterprise Scale! ». Les mots qui reviennent le plus souvent : ingestion, tool, pipeline, streaming. Cette vidéo contient 133 phrases et 2130 mots à répéter en shadowing. La partie parlée dure 11:27. Le locuteur parle vite, environ 186 mots par minute : attendez-vous à des liaisons et à des sons réduits. Seuls 80 % des mots font partie des 3 000 mots les plus courants en anglais, le vocabulaire est donc exigeant.
Vocabulaire clé de cette vidéo
Les 15 mots les plus avancés de la vidéo, avec leur prononciation et leur sens :
| Mot | Prononciation | Sens |
|---|---|---|
| ingestion nom | /ɪnˈd͡ʒɛst͡ʃən/ | ingestion |
| pipeline nom | /ˈpaɪpˌlaɪn/ | pipeline |
| schema nom | /ˈskiːmə/ | schéma |
| batch nom | /bæt͡ʃ/ | fournée |
| spark nom | /ˈspɑɹk/ | étincelle, flammèche |
| ingest verbe | /ɪnˈd͡ʒɛst/ | ingérer |
| metadata nom | /ˈmɛt.əˌdeɪ.tə/ | métadonnées |
| exponential adjectif | /ˌɛk.spəˈnɛn.t͡ʃəl/ | exponentiel |
| lineage nom | /ˈlɪn.i.ɪd͡ʒ/ | descendance, lignée |
| retry verbe | /riˈtɹaɪ/ | retenter, réessayer |
| workload nom | charge de travail | |
| downstream adjectif | /ˌdaʊnˈstɹiːm/ | aval, descendant |
| catalogue nom | /ˈkæt.əˌlɔɡ/ | catalogue |
| bottleneck nom | goulot, goulot de bouteille | |
| cram verbe | /kɹæm/ | bourrer, ficher |
Les verbes à particule que vous entendrez
| Mot | Prononciation | Sens |
|---|---|---|
| back off verbe | reculer | |
| figure out verbe | cerner | |
| go back verbe | rentrer, retourner | |
| go through verbe | traverser | |
| set up verbe | /ˌsɛt ˈʌp/ | mettre en place, installer |
La grammaire de cette vidéo
Les structures que le locuteur utilise le plus, avec les mots exacts de la vidéo :
| Structure | Dans la vidéo |
|---|---|
| Voix passive be + participe passé — l’accent est mis sur ce qui arrive, pas sur qui le fait | be brought · being processed · is secured |
| Propositions relatives who / which + proposition — une précision sur une personne ou une chose | practices, which are · contracts, which are · Flink, which will |
| Present perfect have/has + participe passé — une action passée qui compte encore maintenant | have structured · has helped |
Prononciation à surveiller
Le locuteur utilise 43 contractions et formes réduites, comme you're, don't, gonna. Prononcez-les sous leur forme courte, telles que vous les entendez.
- Les sons « sh » et « 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/
- Mots longs — placez bien l’accent: 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/
Les sons difficiles pour les francophones :
- /tʃ/ et /dʒ/ — à ne pas adoucir en « ch » et « j »: ingestion /ɪnˈd͡ʒɛst͡ʃən/, batch /bæt͡ʃ/, ingest /ɪnˈd͡ʒɛst/, exponential /ˌɛk.spəˈnɛn.t͡ʃəl/, lineage /ˈlɪn.i.ɪd͡ʒ/
- /r/ anglais — langue recourbée, sans frotter la gorge: spark /ˈspɑɹk/, retry /riˈtɹaɪ/, downstream /ˌdaʊnˈstɹiːm/, partition /pɑɹˈtɪ.ʃən/, cram /kɹæm/
- /ŋ/ final — sans prononcer de /g/ après: ping /pɪŋ/, incoming /ˈɪnˌkʌmɪŋ/
Comment s’entraîner avec cette vidéo
- Écoutez la vidéo en entier une fois sans parler et notez les mots que vous ne connaissez pas.
- Commencez à la vitesse 0,75×, répétez phrase par phrase, puis revenez à la vitesse normale quand cela devient facile.
- Enregistrez-vous et comparez avec l’original, en faisant attention à des mots comme ingestion, pipeline, schema.
Qu'est-ce que la technique du Shadowing ?
Le Shadowing est une technique d'apprentissage des langues fondée sur la science, développée à l'origine pour la formation des interprètes professionnels. Le principe est simple mais puissant : vous écoutez de l'anglais natif et le répétez immédiatement à voix haute — comme une ombre suivant le locuteur avec un décalage de 1 à 2 secondes. Les recherches montrent une amélioration significative de la précision de la prononciation, de l'intonation, du rythme, des liaisons, de la compréhension orale et de la fluidité.