SnowPro Advanced Architect

By Snowflake · Question Mode

QuestionQ104

Data Ingestion and Data Preparation

An Architect must automate the daily import of two files from an external stage into Snowflake. One file contains Parquet-formatted data, while the other contains CSV-formatted data.

How should the data be joined and aggregated to generate a final result set?

Explanation

Snowflake tasks provide scheduled execution for the daily workflow. Snowflake Scripting in the task can load each staged file with the appropriate COPY INTO and file-format settings, after which transformation logic, including a UDF call, can join and aggregate the loaded data. Materialized views cannot query external stages or join multiple tables; a materialized view is limited to a single base table and does not support joins.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!