Prompt Detail:
using the following JSON and Snowflake SQL extract all information in individual columns
{
"productBrandId": "kozi-plast",
"productBrandName": "Kozi Plast",
"productCategoryLevels": {
"level1": "",
"level2": "",
"level3": "",
"level4": ""
},
"productDescription": "<p>Prato Fundo Azul Perolado</p>",
"productDiscounts": [],
"productMinimumQuantity": 36,
"productName": "Prato Fundo Azul Perolado",
"productPackagingDetails": {
"dimensions": "",
"weight": 0,
"weight_unit": "kg"
},
"productPricing": {
"price": 2.1,
"resellPrice": 3.73,
"taxes": 0,
"unitPrice": 2.1
},
"productReviewPayload": {},
"productSku": "6104|1983",
"productStock": 0,
"productTags": [],
"productUnitPackagingDetails": {
"dimensions": "",
"weight": 0,
"weight_unit": "kg"
},
"productVariantId": "41943161733327"
}
Add a comment