Snowflake select query to return data in json format

Question

I am making a select call on a table and it always returns 1 row. I would like to get the data in json format.

{
  "column_name1": "value1",
  "column_name2": "value2",
}

Does snowflake query allows anything like this ?

d.hoeffer · Accepted Answer · 2019-12-03 06:24:10Z

11

object_construct is the way to go for this.

For example,

select object_construct(*) from t1;

answered Dec 3, 2019 at 6:24

d.hoeffer

6325 silver badges14 bronze badges

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

2 Comments

The only problem is that it doesn't return the columns whose values are null, which is a issue in my use case

for people from the future, there is also OBJECT_CONSTRUCT_KEEP_NULL(*)