問題文
A retail analytics team receives one daily sales file per store as a gzip-compressed CSV. The files are already uploaded to a named internal stage. Marketing needs the rows in a Snowflake table every morning, and a single malformed row must not silently disappear from the reported totals. Which loading approach matches the requirement?
選択肢
- Run COPY INTO with ON_ERROR set to CONTINUE so that the load always succeeds and the remaining rows that arrive are available for the morning report.
- Use PUT to move the files in sequence into the stage a second time with the FORCE option enabled, which reloads every file and guarantees a complete set.
- Define an external table over the stage so the files that arrived stay where they are, and let the morning report query the external table directly.
- Run COPY INTO the target table from the named stage and leave ON_ERROR at its default, so the statement aborts when any row fails to convert.