Try to search your question here, if you can't find : Ask Any Question Now ?

SnowSQL – Validation –

HomeCategory: stackoverflowSnowSQL – Validation –
Avatarpushpa asked 3 weeks ago

I am following this tutorial :
https://docs.snowflake.net/manuals/user-guide/data-load-external-tutorial-resolve.html

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

1 Answers
Best Answer
AvatarFernando answered 3 weeks ago
Your Answer

13 + 0 =

Popular Tags

WP Facebook Auto Publish Powered By : XYZScripts.com