SNOWFLAKE · objective · 14% of the exam
Perform data loading, unloading, and transformation — SnowPro® Core Certification
The official SNOWFLAKE documentation our Perform data loading, unloading, and transformation practice questions are cited to. Review the primary sources, then practise.
Official references for this objective
-
Snowflake — COPY INTO *<table>* | Snowflake Documentation
When the FILES and PATTERN options are used together, only the specified paths in the FILES option are loaded. It is recommended to not use
-
Snowflake — COPY INTO *<location>* | Snowflake Documentation
for security reasons, do not use permanent credentials in COPY commands. Instead, use temporary credentials. If you must use permanent credentials, use external stages
-
Snowflake — Overview of data unloading | Snowflake Documentation
SELECT queries in COPY statements support the full syntax and semantics of Snowflake SQL queries, including JOIN clauses, which enables downloading data from multiple tables.
-
Snowflake — Overview of data loading | Snowflake Documentation
Options include: Column reordering Column omission Casts Truncating text strings that exceed the target column length There is no requirement for your data files to
-
Snowflake — Transform data during a load | Snowflake Documentation
COPY transformations do not support the FLATTEN function, or JOIN or GROUP BY (aggregate) syntax.
-
Snowflake — CREATE FILE FORMAT | Snowflake Documentation
When unloading data, Snowflake converts SQL NULL values to the first value in the list.