tamiroze/json_rs_vs_sf.md

Created June 20, 2019 00:25

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/tamiroze/f5bf77e9332de49de7363ced35922ce9.js"></script>
Save tamiroze/f5bf77e9332de49de7363ced35922ce9 to your computer and use it in GitHub Desktop.

Raw

    
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];