I imported my own JSON into Snowflake (single column variant). When I ran a select my JSON column is null.
I thought it might be an issue in my dataset but I also used the sample data in the link https://docs.snowflake.com/en/user-guide/querying-semistructured.html
This is also returning null when I run
SELECT src:dealership FROM car_sales;
Currently using Firefox webui, but also tried the Snowcli with same NULL result. I'm running snow standard.
tia