Snowpark Migration Accelerator: Spark SQL DML¶

While SELECT statements are common across different SQL databases, the way data manipulation (DML) works can vary significantly between database systems. Each database has its own unique features and limitations that affect how DML statements behave, making some operations more complex than they might appear.

Here’s an overview of essential DML (Data Manipulation Language) statements you should be familiar with:

• MERGE

• SELECT

Let’s examine each of these components in detail.