Expand my Community achievements bar.

We are excited to introduce our latest innovation to enhance the Adobe Campaign user experience — the Adobe Campaign v8 Web User Interface!
SOLVED

How to parse Json in snowflake database for adobe campaign classic v8?

Avatar

Level 1

I want to parse the JSON in snowflake database, can you please provide the steps and code?

 

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

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

View solution in original post

1 Reply

Avatar

Correct answer by
Community Advisor

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