Which of the below SQLs will you run to validate any loads of the pipe within the last hour?

Which of the below SQLs will you run to validate any loads of the pipe within the last hour?
A . select * from table(validate_pipe_load(
pipe_name=>’data_engineer_pipe’,
start_time=>dateadd(hour, -1, current_timestamp())));
B. select * from table(pipe_load_status(
pipe_name=>’data_engineer_pipe’,
start_time=>dateadd(hour, -1, current_timestamp())));
C. select * from table(check_pipe_load(
pipe_name=>’data_engineer_pipe’,
start_time=>dateadd(hour, -1, current_timestamp())));

View Answer

Answer: A

Explanation

https://docs.snowflake.com/en/sql-reference/functions/validate_pipe_load.html#validate-pipe-load

VALIDATE_PIPE_LOAD

This table function can be used to validate data files processed by Snowpipe within a specified time range. The function returns details about any errors encountered during an attempted data load into Snowflake tables.