Prompt Title: Extracting JSON data (EN)

Created 1 year ago
Votes 0
Views 215 times
0

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" }
avatar
Elias Prost
Shared 1 prompt
Created 1 year ago

Leave a Comment

Related Tag Prompts

0
0
MySQL Database Creation.
1 year ago 2023-03-08 12:23:48 Pub
0
0
SQL
1 year ago 2023-03-09 20:39:37 sql
0
0
SQL Course Syllabus.
1 year ago 2023-03-10 11:16:27 ee
0
0
sql
1 year ago 2023-03-14 21:19:25 ds
0
0
Splitting rows to columns.
1 year ago 2023-04-03 07:30:07 chandrika
0
0
0
0
MySQL Table Columns Retrieval.
1 year ago 2023-04-17 15:10:00 Zenby
0
0
asking for video solution
1 year ago 2023-04-22 14:48:38 Devesh
0
0
Drishti Project
2 months ago 2024-02-25 17:31:41 Drishti
0
0
Drishti Project1
2 months ago 2024-02-25 17:32:54 Drishti