CODE EXAMPLE FOR SQL

snowflake insert select

insert into mytable
  select to_date('2013-05-08T23:39:20.123'), to_timestamp('2013-05-08T23:39:20.123'), to_timestamp('2013-05-08T23:39:20.123');
  
or

insert into table1 (id, varchar1, variant1)
    select 4, 'Fourier', parse_json('{ "key1": "value1", "key2": "value2" }');