Extracting copy logs from Snowflake

snowflake_copy_logs.sql

SELECT 
    "FILE_NAME", 
    "STAGE_LOCATION", 
    "LAST_LOAD_TIME", 
    "ROW_COUNT", 
    "FILE_SIZE", 
    "ERROR_COUNT", 
    "STATUS", 
    "TABLE_CATALOG_NAME", 
    "TABLE_SCHEMA_NAME", 
    "TABLE_NAME", 
    "PIPE_CATALOG_NAME", 
    "PIPE_SCHEMA_NAME", 
    "PIPE_NAME", 
    "PIPE_RECEIVED_TIME" 
FROM snowflake.account_usage.copy_history 
WHERE 
    LAST_LOAD_TIME between to_timestamp_ltz('2021-01-01 00:00:00.000000+00:00') AND to_timestamp_ltz('2021-01-01 01:00:00.000000+00:00')
    AND STATUS != 'load failed' 
ORDER BY LAST_LOAD_TIME DESC;