How to parse Json in snowflake database for adobe campaign classic v8? | Community
Skip to main content
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Marcel_Szimonisz

Hello @debasmita17 ,

I just did a bit of googling. To parse JSON data in Snowflake, you can use Snowflake's built-in JSON functions.

-- Assuming you have a table named "your_table" with a JSON column named "json_column" -- Sample JSON data in the table INSERT INTO your_table (json_column) VALUES ('{"name": "John", "age": 30, "city": "New York"}'), ('{"name": "Alice", "age": 25, "city": "San Francisco"}'); -- Query to parse the JSON array SELECT json_data.value:age::integer AS age, json_data.value:name::string AS name, json_data.value:city::string AS city FROM your_table, LATERAL FLATTEN(input => parse_json(json_column)) AS json_data;

Marcel

1 reply

Marcel_Szimonisz
Community Advisor
Marcel_SzimoniszCommunity AdvisorAccepted solution
Community Advisor
December 11, 2023

Hello @debasmita17 ,

I just did a bit of googling. To parse JSON data in Snowflake, you can use Snowflake's built-in JSON functions.

-- Assuming you have a table named "your_table" with a JSON column named "json_column" -- Sample JSON data in the table INSERT INTO your_table (json_column) VALUES ('{"name": "John", "age": 30, "city": "New York"}'), ('{"name": "Alice", "age": 25, "city": "San Francisco"}'); -- Query to parse the JSON array SELECT json_data.value:age::integer AS age, json_data.value:name::string AS name, json_data.value:city::string AS city FROM your_table, LATERAL FLATTEN(input => parse_json(json_column)) AS json_data;

Marcel

    Terms & ConditionsAccessibility statement

    Loading footer...