How can I convert python dictionary to a json object with loggers in snowflake event table

Question

I have a snowflake event table created. The below code inserts log records into event table.

import snowflake.snowpark as snowpark
import logging
def main(session: snowpark.Session):
    LOGGER = logging.getLogger('snowflake.snowpark.session')
    dict1 = {"abc": "123", "cdf": "345"}

    LOGGER.info(dict1)
    return f'Testing the Logging'

Now this dict is being written as string in snowflake event table under 'VALUE' column which is VARIATNT. "{'abc': '123', 'cdf': '345}" How can make this as json object instead of string using the above loggers

Tried different ways but nothing helped

Zeshan Saqib · Accepted Answer · 2025-05-21 11:11:56Z

0

Use json.dumps() to log a proper JSON object: import logging import json

import logging
import json
dict1 = {"abc": "123", "cdf": "345"} 
LOGGER.info(json.dumps(dict1))
# ✅ logs as valid JSON for Snowflake VARIANT

This ensures the log is stored as a JSON object in Snowflake, not a plain string.

answered May 21 at 11:11

Zeshan Saqib

1495 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

T Prathyusha May 21 at 11:27

Tried this way also but it's coming as "{\"abc\": \"123\", \"cdf\": \"345\"}" in variant column in snowflake event table

Zeshan Saqib May 22 at 11:05

Don't use json.dumps(dict1) — it converts the dict to a string. Use LOGGER.info(dict1) directly to log as a proper JSON object in Snowflake VARIANT.

Collectives™ on Stack Overflow

How can I convert python dictionary to a json object with loggers in snowflake event table

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related