3

I'm trying to load the entirety of each row in a csv file into a variant column.

my copy into statement fails with the below

Error parsing JSON:

Which is really odd as my data isn't JSON and I've never told it to try and validate it as json.

create or replace file format NeilTest
RECORD_DELIMITER = '0x0A'
field_delimiter = NONE
 TYPE =  CSV 
VALIDATE_UTF8 = FALSE;

with

    create table Stage_Neil_Test
(
  Data VARIANT,
  File_Name string

);

copy into Stage_Neil_Test(Data, File_Name
                                 ) 
from (select 
      s.$1,  METADATA$FILENAME
      from @Neil_Test_stage s)

How do I stop snowflake from thinking it is JSON?

Neil P
  • 2,920
  • 5
  • 33
  • 64

1 Answers1

3

You need to explicitly cast the text into a VARIANT type, since it cannot auto-interpret it as it would if the data were JSON.

Simply:

copy into Stage_Neil_Test(Data, File_Name
                                 ) 
from (select 
      s.$1::VARIANT,  METADATA$FILENAME
      from @Neil_Test_stage s)
Stuart Ozer
  • 1,354
  • 7
  • 7
  • in this case, the data in the snow flake will be csv format? or it will be converted into JSON format automatically?? – Naga Dec 25 '21 at 13:11