Is there a way to find out details of data type erorr in Snowflake?

0
votes

I am pretty new to Snowflake Cloud offering and was just trying to load a simple .csv file from AWS s3 staging are to a table in Snowflake using copy command.

Here is what I used as the command:

copy into "database name"."schema"."table name" from @S3_ACCESS file_format = (format_name = format name);

When run the above code, I get the following error: Numeric value '63' is not recognized

Please see the attached image. Not sure what this error is and i'm not able to find any lead in Snowflake UI itself to find out what could be wrong with the value.

Thanks in Advance!

1
snowflake-cloud-data-platform

1 Answers

0
votes

The error says, it was waiting a numberic value, but it got "63", and this value can not be converted to numeric value.

From the image you share, I can see that there are some weird characters around 6 and 3. There could be an issue with file encoding or data is corrupted.

Please check encoding option for file format:

https://docs.snowflake.com/en/sql-reference/sql/create-file-format.html#format-type-options-formattypeoptions

By the way, I recommend you always use utf-8.