This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Im trying to stream a new table into snowflake using the Stream InDB and the Bulk loader tool writing to a new temporary table. When running the work process I'm getting the error:
Error: Data Stream In (2): The COPY failed with error: Number of columns in file (9) does not match that of the corresponding table (11), use file format option error_on_column_count_mismatch=false to ignore this error
File 'LOG_UPLOAD_f7bfb8b0e078417392a34715aab60b/LOG_UPLOAD_f56fe84fe3624544a0cc3132ec7a3b.gz', line 2, character 1
Row 1 starts at line 1, column "LOG_UPLOAD"["LOG":9]
If you would like to continue loading when an error is encountered, use other values such as 'SKIP_FILE' or 'CONTINUE' for the ON_ERROR option. For more information on loading options, please run 'info loading_data' in a SQL client.
It is a new create table option and shouldn't really be failing, troubleshooting any ideas would be appreciated