DEA-C02: SnowPro Advanced — Data EngineerDemo

By Snowflake · Question Mode

QuestionQ52

Official exam objectives/topics

How can a Data Engineer retrieve every error encountered during an earlier file upload that used the COPY command?

  • A Query the VALIDATE information schema view.
  • B Call the VALIDATE table function.
  • C Call the VALIDATE_PIPE_LOAD table function.
  • D Query the VALIDATE account usage schema view.
Explanation

The Snowflake VALIDATE table function validates files from a prior COPY INTO <table> execution and returns all errors encountered during the load, rather than only the first error.

Learn more

Community Discussion

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