The Merge operator is considered a DML (Data Manipulation Language) operator in Snowflake. DML operators are used to modify data in tables, and the Merge operator specifically allows for conditional updates, inserts, or deletes in a target table based on the results of a join with a source table.
Reference:
Snowflake Documentation: Query Profile Overview
Snowflake Documentation: MERGE Statement

To execute a series of SQL statements using a task, a user would use a stored procedure that contains multiple SQL statements and invoke this stored procedure from the task. References: Snowflake Documentation2.

Snowflake supports a variety of file formats for unloading semi-structured data, among which Parquet and Newline Delimited JSON (NDJSON) are two widely used formats.
B . Binary file in Parquet: Parquet is a columnar storage file format optimized for large-scale data processing and analysis. It is especially suited for complex nested data structures.
D . Newline Delimited JSON (NDJSON): This format represents JSON records separated by newline characters, facilitating the storage and processing of multiple, separate JSON objects in a single file.
These formats are chosen for their efficiency and compatibility with data analytics tools and ecosystems, enabling seamless integration and processing of exported data.
Reference:
Snowflake Documentation: Data Unloading

In Snowflake, to extract a specific value from a VARIANT column, you use the column name followed by a colon and then the key. The keys are case-sensitive. Therefore, to extract the employee's name from the
"Data" column, the correct syntax is data:employee.name.