tamiroze/json_rs_vs_sf.md

## json_rs_vs_sf.md

      
    Raw
  

              json_rs_vs_sf.md
            
          
Redshift
Snowflake


json_extract_path_text (properties,'name')
parse_json(properties):name


select json_extract_array_element_text('[111,112,113]', 2);
select parse_json('[111,112,113]')[2];
Redshift	Snowflake
json_extract_path_text (properties,'name')	parse_json(properties):name
select json_extract_array_element_text('[111,112,113]', 2);	select parse_json('[111,112,113]')[2];