The following JSON is stored in a VARIANT column called src of the CAR

Snowflake COF-C03 Question Answer

The following JSON is stored in a VARIANT column called src of the CAR_SALES table:

A user needs to extract the dealership information from the JSON.

How can this be accomplished?

select src:dealership from car_sales;

select src.dealership from car_sales;

select src:Dealership from car_sales;

select dealership from car_sales;

COF-C03 PDF/Engine

Get 65% Discount on All Products, Use Coupon: "ac4s65"

The following JSON is stored in a VARIANT column called src of the CAR_SALES table:A...