I am following this tutorial :
to try and ‘return errors by query ID and saves the results to a table for future reference’
the error is “Number of columns in file (11) does not match that of the corresponding table (10), use file format option error_on_column_count_mismatch=false to ignore this error”
This matches the tutorial, so per the tutorial I go and find the Query ID and input it into the query_id place holder in the statement below:
create or replace table save_copy_errors as select * from table(validate(mycsvtable, job_id=>'<query_id>'));
But it does not save the errors rather it returns a new error which is:
002018 (22023): SQL compilation error: Invalid argument [Invalid Job UUID provided.] for table function. Table function argument is required to be a constant.
Not sure how to solve this, as I feel I am just mirroring the tutorial correct