JSON file Size loaded into Snowflake Variant Column

1
votes

We have JSON files loaded into Snowflake table (Variant column), the table has 2 column - File name and Variant column (JSON records).

I am able to get the whole table size from information schema, however we are interested in getting the size of each row/record in the table.

Can you please help me if there is any formula/function that can help me to get the row size.

1
jsonsizesnowflake-cloud-data-platformvariant

1 Answers

1
votes

LEN(expression) Returns the length of an input string or binary value.

You can concatenate columns using type cast operator and get resulted string length.

Like this:

len(col1::string||col1::string||colN::string)

len(variant) also works