Skip to content

Instantly share code, notes, and snippets.

@NazarenkoDenis

NazarenkoDenis/backup_of_schema.json

Created November 28, 2024 09:56
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save NazarenkoDenis/97053bea1104e07640af2ef8f0d2b9fd to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save NazarenkoDenis/97053bea1104e07640af2ef8f0d2b9fd to your computer and use it in GitHub Desktop.
Download ZIP
Raw
backup_of_schema.json
{
"explores": [
{
"lineageID": "e57e9c44-7261-434d-8da9-e75f2ea27efd",
"name": "payouts_upd",
"label": "",
"relationships": [
{
"lineageID": "b58301d2-adfa-4397-861c-f73563f89134",
"from": "fulfillment_items.fulfillment_id",
"to": "fulfillments.id"
}
],
"isHidden": false
},
{
"lineageID": "27f02867-a7df-4cec-9273-4d9d5ad06586",
"name": "order_items_custom_1",
"label": "Order Items + Fulfillment Items Custom",
"relationships": [
{
"lineageID": "6e48d8dc-4829-4be1-9a2a-fc97cb91aa51",
"from": "stores.instance_id",
"to": "order_items.instance_id"
},
{
"lineageID": "866d7de7-3dc5-47b3-b409-0268c7e1a0a3",
"from": "order_items.order_id",
"to": "orders.id"
},
{
"lineageID": "49c61c0d-0e80-4656-ba31-fd2f62775041",
"from": "customers.id",
"to": "orders.customer_id"
},
{
"lineageID": "074a5600-6adf-4b31-9292-cd936bc72ecd",
"from": "product_variants.inventory_item_id",
"to": "inventory_items.id"
},
{
"lineageID": "ef7bc964-fa6a-4ed4-92b7-3cd37f040f27",
"from": "inventory_levels.inventory_item_id",
"to": "product_variants.inventory_item_id"
},
{
"lineageID": "f5ed8e47-c5d5-4935-b598-188b811b2b7d",
"from": "locations.id",
"to": "fulfillments.location_id"
},
{
"lineageID": "9ce10022-8c99-45bc-b5ff-db4a7ae2b799",
"from": "product_variants.id",
"to": "order_items.variant_id"
},
{
"lineageID": "c97a7e3e-4c34-41af-b925-678fa619d94f",
"from": "products.id",
"to": "order_items.product_id"
},
{
"lineageID": "3b75f03c-4471-47ff-9c3d-12ecae15f879",
"from": "order_items.id",
"to": "refund_items.order_item_id"
},
{
"lineageID": "fb7c3ef7-1c4e-4d9f-bc4b-b7f5618cd3e7",
"from": "order_adjustments.refund_id",
"to": "refunds.id"
},
{
"lineageID": "dd099d2b-3e60-43eb-87ce-4349cba1cdc8",
"from": "refunds.order_id",
"to": "orders.id"
},
{
"lineageID": "df5ee47c-7708-40d3-a5b0-f3971232e927",
"from": "transactions.order_id",
"to": "orders.id"
},
{
"lineageID": "49ac1068-265f-4a47-8593-90c6cc066243",
"from": "orders.id",
"to": "payout_transactions.source_order_id"
},
{
"lineageID": "8b27fe5a-f0c8-40e5-ace1-05d81f83a625",
"from": "fulfillment_items.id",
"to": "order_items.id"
},
{
"lineageID": "d1fe9d41-3592-4ce3-ab84-06ae794cd054",
"from": "fulfillments.id",
"to": "fulfillment_items.fulfillment_id"
}
],
"isHidden": false
},
{
"lineageID": "fb25cba2-4703-3d80-a4a3-89e3df978800",
"relationships": [
{
"lineageID": "80fc29ac-0afe-32dd-9043-190a535fe47e",
"isRemoved": true
},
{
"lineageID": "130174de-9399-3ac4-923b-ae6574a5671a",
"isRemoved": true
},
{
"lineageID": "a70a3f2b-b1b2-3361-a4fb-7164b5fe29d7",
"isRemoved": true
},
{
"lineageID": "9046f4b6-17b8-3b90-8c5a-d06a4c5d3913",
"isRemoved": true
},
{
"lineageID": "3b1accf8-efc6-3388-bc68-018492b7cd81",
"isRemoved": true
},
{
"lineageID": "f43a12e0-ad9c-3ac8-b936-765874be9108",
"isRemoved": true
},
{
"lineageID": "f202f472-0afc-3ff6-953e-74e4e4a7b2f8",
"isRemoved": true
},
{
"lineageID": "cb0bce84-b7e9-3a08-bb40-49a26b1f028d",
"isRemoved": true
},
{
"lineageID": "e3d8e76e-11db-3568-84c0-901cafeedb25",
"isRemoved": true
},
{
"lineageID": "638f1e0b-cae2-3f1e-897d-97024f19467e",
"isRemoved": true
},
{
"lineageID": "c9e57a34-ac1f-43ae-faba-3148c1723131",
"isRemoved": true
}
]
}
],
"tables": [
{
"lineageID": "a68424b6-219b-3c06-b476-18f3e53c7128",
"columns": [
{
"lineageID": "4be1e2bf-0066-4e81-ab29-0ca32730c24f",
"name": "id_str",
"kind": "dimension",
"dataType": "string",
"isUnique": false,
"isHidden": true,
"expression": "customers.concatenate_x(customers.id)",
"label": "",
"description": "",
"valueFormat": "",
"labelShort": "",
"groupLabel": "",
"requiredFields": [],
"drillColumns": [],
"aliases": [],
"timeframes": []
},
{
"lineageID": "a66a614c-a19a-40d2-9a49-0ef90fee4ecb",
"name": "url",
"kind": "dimension",
"dataType": "string",
"isUnique": false,
"isHidden": false,
"expression": "\"https://admin.shopify.com/store/zent-test/customers/\" + convert(customers.id, STRING)",
"label": "",
"description": "",
"valueFormat": "",
"labelShort": "",
"groupLabel": "",
"requiredFields": [],
"drillColumns": [],
"aliases": [],
"timeframes": []
}
],
"datasource": {}
},
{
"lineageID": "0b157755-1ac9-3457-97af-2535c3a3ca2c",
"columns": [
{
"lineageID": "549cbee6-37dd-4185-acf1-63d5de688495",
"name": "committed",
"kind": "dimension",
"dataType": "",
"isUnique": false,
"isHidden": false,
"expression": "calculate(order_items.total_net_quantity, is_blank(orders.fulfillment_status))",
"label": "",
"description": "",
"valueFormat": "",
"labelShort": "",
"groupLabel": "",
"requiredFields": [],
"drillColumns": [],
"aliases": [],
"timeframes": []
},
{
"lineageID": "9b51cab0-1bed-44da-b70a-992a1118458b",
"name": "on_hand",
"kind": "dimension",
"dataType": "",
"isUnique": false,
"isHidden": false,
"expression": "inventory_items.committed + inventory_items.total_available",
"label": "",
"description": "",
"valueFormat": "",
"labelShort": "",
"groupLabel": "",
"requiredFields": [],
"drillColumns": [],
"aliases": [],
"timeframes": []
}
],
"datasource": {}
},
{
"lineageID": "da2189f5-7013-34c2-a50d-bb9676477265",
"columns": [
{
"lineageID": "3a9fa3ed-c69c-4b10-905e-db54d7ff0835",
"name": "now",
"kind": "dimension",
"dataType": "",
"isUnique": false,
"isHidden": false,
"expression": "now()",
"label": "",
"description": "",
"valueFormat": "default",
"labelShort": "",
"groupLabel": "",
"requiredFields": [],
"drillColumns": [],
"aliases": [],
"timeframes": []
},
{
"lineageID": "234f106d-4d5b-477d-93e8-5a472efb888a",
"name": "processed_at_seconds",
"kind": "dimension",
"dataType": "",
"isUnique": false,
"isHidden": false,
"expression": "left(convert(date_add(date_add(now(), -4, HOUR), -1, DAY), STRING), 10)",
"label": "",
"description": "",
"valueFormat": "",
"labelShort": "",
"groupLabel": "",
"requiredFields": [],
"drillColumns": [],
"aliases": [],
"timeframes": []
},
{
"lineageID": "6ea46110-898a-42cf-b226-07f705220f9a",
"name": "2",
"kind": "dimension",
"dataType": "",
"isUnique": false,
"isHidden": false,
"expression": "left(convert(date_add(date_add(sales.date, -4, HOUR), -1, DAY), STRING), 10)",
"label": "",
"description": "",
"valueFormat": "",
"labelShort": "",
"groupLabel": "",
"requiredFields": [],
"drillColumns": [],
"aliases": [],
"timeframes": []
},
{
"lineageID": "8d4030d7-70d0-4810-845b-aef544ee36ee",
"name": "3",
"kind": "dimension",
"dataType": "",
"isUnique": false,
"isHidden": false,
"expression": "case(\n left(convert(date_add(date_add(now(), -4, HOUR), -1, DAY), STRING), 10) = left(convert(date_add(date_add(sales.date, -4, HOUR), -1, DAY), STRING), 10), 'Yes',\n 'No'\n)",
"label": "",
"description": "",
"valueFormat": "",
"labelShort": "",
"groupLabel": "",
"requiredFields": [],
"drillColumns": [],
"aliases": [],
"timeframes": []
}
],
"datasource": {}
}
]
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment