An Architect needs to automate the daily Import of two files from an external stage into Snowflake. One file has Parquet-formatted data, the other has CSV-formatted data.
How should the data be joined and aggregated to produce a final result set?

Question

An Architect needs to automate the daily Import of two files from an external stage into Snowflake. One file has Parquet-formatted data, the other has CSV-formatted data.

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

jonathan Smallwood · Accepted Answer

Create a task using Snowflake scripting that will import the files, and then call a User-Defined Function (UDF) to produce the final result set.

jonathan Smallwood · Answer

Use Snowpipe to ingest the two files, then create a materialized view to produce the final result set.

jonathan Smallwood · Answer

Create a JavaScript stored procedure to read. join, and aggregate the data directly from the external stage, and then store the results in a table.

jonathan Smallwood · Answer

Create a materialized view to read, Join, and aggregate the data directly from the external stage, and use the view to produce the final result set

Question list

List of questions

Question 1

(0)

Question 2

(0)

Question 3

(0)

Question 4

(0)

Question 5

(0)

Question 6

(0)

Question 7

(0)

Question 8

(0)

Question 9

(0)

Question 10

(0)

Related questions

Question 111 - ARA-C01 discussion

Suggested answer: B

0 comments