Skip to main content
Data manipulation language

Data manipulation language

Search complete. 10 mentions across 4 episodes found for "Data manipulation language".

Sep 8, 2026

Alex LauderbackGUEST
18:36
It doesn't mean you can't do it.
Alex LauderbackGUEST
18:38
You can still implement these unit tests to test every single DML operation that a Flow would test.
Alex LauderbackGUEST
18:43
If we're testing these DML operations in Apex, why are we not testing them in Flows? Then you layer on top of
Jack McCurdyHOST
18:49
that.
Jack McCurdyHOST
18:50
I feel like you're speaking to so many people, though, because people have been asking for robust flow testing for so long.
Jack McCurdyHOST
20:44
Is there any other types of tests that you find are important now more so than ever? Aside from making sure and understanding that your flows and apexes are still working as they should, even pre-production or in production.
Jack McCurdyHOST
20:58
Any other testing that's important you've found over the last year or so?
Alex LauderbackGUEST
21:04
So we covered the Apex test solution, but that only tests your DML operations for the most part.
Sahil WaliaGUEST
22:58
And assume you have a lot more events and you're doing something.
Sahil WaliaGUEST
23:02
Let's say you're doing a machine learning model or you're doing some DML and your code has changed now.
Sahil WaliaGUEST
23:07
and your data looks a little different.
Sahil WaliaGUEST
23:09
Or you'll be like, oh my God, I messed it up.
Sahil WaliaGUEST
27:36
So if you want, I can go deep into it.
Sahil WaliaGUEST
27:38
And basically it defines how the reads should be done or how the writes should be done.
Sahil WaliaGUEST
27:44
And just a little bit of primer, copy on writes essentially means, let's say if you're doing any some DML operation, right? It will rewrite the new file.
Sahil WaliaGUEST
27:53
So assume you have thousands of Parquet files in one Parquet file, which is 100 MB or 100 GB, you have 1 million records, right? but you only want to change one record, what it will do is it will rewrite the whole new file, right? It's great in terms of read because it'll be faster and referencing to the new file.
Al DukesHOST
23:04
Yeah, I don't know, but I'd love to know.
Al DukesHOST
23:06
DML.
Al DukesHOST
23:08
Open your...
Al DukesHOST
23:08
What are we asking for? Sleep
Steve JonesHOST
2:31
SQL history and SQL prompt saves me often, right? I can't remember what code I ran, but it doesn't capture results.
Steve JonesHOST
2:37
And if I'm running scripts, whether it's DDL or DML, or I'm clicking in SSMS, I would like a record.
Steve JonesHOST
2:45
I do try to not click things in SSMS in production and instead use the script button to copy-save those scripts and then run them.
Steve JonesHOST
2:53
It's a better habit, but in a crisis, I know I might forget, as would others.

We value your privacy

We use cookies to understand how you use our platform and to improve your experience. Click “Accept All” to consent, or “Decline non-essential” to opt out of non-essential cookies. Read our Privacy Policy.