A Snowflake table named 'ORDERS' contains columns: ORDER ID (NUMBERY, CUSTOMER ID (NUMBERY, 'ORDER DATE (DATE), and ORDER DETAILS (VARIANT)'. The 'ORDER DETAILS column stores JSON data. You need to…

Question

Options

• AINSERT INTO ORDERS (ORDER_ID, CUSTOMER_ID, ORDER_DATE, ORDER_DETAILS) SELECT ORDER_ID, CUSTOMER_ID, ORDER_DATE, {'status': 'PENDING'} FROM @my_stage/orders.csv (FILE_FORMAT => 'my_csv_format');
• BINSERT INTO ORDERS (ORDER_ID, CUSTOMER_ID, ORDER_DATE, ORDER_DETAILS) SELECT $1, $2, $3, PARSE_JSON('{"status": "PENDING"}') FROM @my_stage/orders.csv (FILE_FORMAT => 'my_csv_format');
• CINSERT INTO ORDERS (ORDER_ID, CUSTOMER_ID, ORDER_DATE) SELECT $1, $2, $3 FROM @my_stage/orders.csv (FILE_FORMAT => 'my_csv_format');
• DINSERT INTO ORDERS SELECT $1, $2, $3, '{"status": "PENDING"}' FROM @my_stage/orders.csv (FILE_FORMAT => 'my_csv_format');

• A
  5% (1)
• B
  77% (17)
• C
  14% (3)
• D
  5% (1)

Explanation

Option B is the most efficient and correct. OBJECT CONSTRUCT directly creates a JSON object within Snowflake, which is more efficient than parsing a string using 'PARSE_JSONZ SELECT statement with stages usually use '$1 , $2, $3' notation for accessing the CSV fields. Options C uses VALUES' clause which does not integrate well with @my_stage'. Option D and E is trying to cast to VARIANT but uses wrong casting notations.

No community discussion yet for this question.