Skip to content

Instantly share code, notes, and snippets.

@NazarenkoDenis

NazarenkoDenis/fulfillment_items_schema.json

Last active March 12, 2024 13:46
Show Gist options
  • Save NazarenkoDenis/7ec01816e77c5ac4c18bfffa4990349a to your computer and use it in GitHub Desktop.
Save NazarenkoDenis/7ec01816e77c5ac4c18bfffa4990349a to your computer and use it in GitHub Desktop.
Download ZIP
Raw
fulfillment_items_schema.json
{
"explores": [
{
"lineageID": "1fe426dd-c1f3-3d7c-af6b-22b233fa9aa4",
"relationships": [
{
"lineageID": "627512d3-b1fe-4024-a548-ebedcecd6258",
"from": "fulfillment_items.order_id",
"to": "orders.id"
}
]
},
{
"lineageID": "fb25cba2-4703-3d80-a4a3-89e3df978800",
"relationships": [
{
"lineageID": "155945ed-c8a2-4a38-a172-627af7317cd6",
"from": "order_items.order_id",
"to": "fulfillment_items.order_id"
}
]
}
],
"tables": [
{
"lineageID": "4ad4189b-e74c-4d8e-8030-48970291f966",
"columns": [
{
"lineageID": "cc66b5c5-7559-467a-91f7-6fc666df51a6",
"name": "is_same",
"kind": "dimension",
"dataType": "",
"isUnique": false,
"isHidden": false,
"expression": "if(order_items.variant_id == fulfillment_items.variant_id, order_items.id, 0)",
"label": "",
"description": "",
"valueFormat": "",
"labelShort": "",
"groupLabel": "",
"requiredFields": [],
"drillColumns": [],
"aliases": [],
"timeframes": []
},
{
"lineageID": "b7f72eb7-5954-4434-9c85-c88de75f44d2",
"name": "price",
"kind": "dimension",
"dataType": "float",
"isUnique": false,
"isHidden": false,
"expression": "",
"label": "",
"description": "",
"valueFormat": "money",
"labelShort": "",
"groupLabel": "",
"requiredFields": [],
"drillColumns": [],
"aliases": [],
"timeframes": []
},
{
"lineageID": "6cb87eb6-bfd0-46ac-a95d-b28f6d3d56cf",
"name": "vendor",
"kind": "dimension",
"dataType": "string",
"isUnique": false,
"isHidden": false,
"expression": "",
"label": "",
"description": "",
"valueFormat": "",
"labelShort": "",
"groupLabel": "",
"requiredFields": [],
"drillColumns": [],
"aliases": [],
"timeframes": []
},
{
"lineageID": "7cc4fc05-788c-4b6d-a1c1-e8dc65810448",
"name": "sku",
"kind": "dimension",
"dataType": "string",
"isUnique": false,
"isHidden": false,
"expression": "",
"label": "",
"description": "",
"valueFormat": "",
"labelShort": "",
"groupLabel": "",
"requiredFields": [],
"drillColumns": [],
"aliases": [],
"timeframes": []
},
{
"lineageID": "1f507d4e-d3bf-4cba-9ee6-f514b972e1f6",
"name": "product_name",
"kind": "dimension",
"dataType": "string",
"isUnique": false,
"isHidden": false,
"expression": "",
"label": "",
"description": "",
"valueFormat": "",
"labelShort": "",
"groupLabel": "",
"requiredFields": [],
"drillColumns": [],
"aliases": [],
"timeframes": []
},
{
"lineageID": "d9f8ac0f-1b8a-4502-a618-398dae6ebe71",
"name": "variant_name",
"kind": "dimension",
"dataType": "string",
"isUnique": false,
"isHidden": false,
"expression": "",
"label": "",
"description": "",
"valueFormat": "",
"labelShort": "",
"groupLabel": "",
"requiredFields": [],
"drillColumns": [],
"aliases": [],
"timeframes": []
},
{
"lineageID": "f7c7da5b-7670-4edf-8925-077813ee7f6a",
"name": "total_price",
"kind": "measure",
"dataType": "float",
"isUnique": false,
"isHidden": false,
"expression": "fulfillment_items.sum_x(fulfillment_items.price * fulfillment_items.quantity)",
"label": "",
"description": "",
"valueFormat": "money",
"labelShort": "",
"groupLabel": "",
"requiredFields": [],
"drillColumns": [],
"aliases": [],
"timeframes": []
},
{
"lineageID": "0cf15c9b-413e-452c-a924-17da94b9147c",
"name": "total_quantity",
"kind": "measure",
"dataType": "float",
"isUnique": false,
"isHidden": false,
"expression": "fulfillment_items.sum_x(fulfillment_items.quantity)",
"label": "",
"description": "",
"valueFormat": "default",
"labelShort": "",
"groupLabel": "",
"requiredFields": [],
"drillColumns": [],
"aliases": [],
"timeframes": []
},
{
"lineageID": "96d3494d-e5e3-4c32-9de2-400bae22a90f",
"name": "total_gross_sales",
"kind": "measure",
"dataType": "float",
"isUnique": false,
"isHidden": false,
"expression": "fulfillment_items.sum_x((fulfillment_items.price * fulfillment_items.quantity) - IF(orders.taxes_included == TRUE, fulfillment_items.tax_amount, 0))",
"label": "",
"description": "",
"valueFormat": "money",
"labelShort": "",
"groupLabel": "",
"requiredFields": [],
"drillColumns": [],
"aliases": [],
"timeframes": []
},
{
"lineageID": "c2d18426-39de-4964-996a-b743e3e344b1",
"name": "tax_1_amount",
"kind": "dimension",
"dataType": "float",
"isUnique": false,
"isHidden": false,
"expression": "",
"label": "",
"description": "",
"valueFormat": "",
"labelShort": "",
"groupLabel": "",
"requiredFields": [],
"drillColumns": [],
"aliases": [],
"timeframes": []
},
{
"lineageID": "235e802d-f990-44c2-9622-321cfe8ae6bc",
"name": "tax_2_amount",
"kind": "dimension",
"dataType": "float",
"isUnique": false,
"isHidden": false,
"expression": "",
"label": "",
"description": "",
"valueFormat": "",
"labelShort": "",
"groupLabel": "",
"requiredFields": [],
"drillColumns": [],
"aliases": [],
"timeframes": []
},
{
"lineageID": "e2cdc72b-b8b3-4443-9249-ecefebee13cd",
"name": "tax_3_amount",
"kind": "dimension",
"dataType": "float",
"isUnique": false,
"isHidden": false,
"expression": "",
"label": "",
"description": "",
"valueFormat": "",
"labelShort": "",
"groupLabel": "",
"requiredFields": [],
"drillColumns": [],
"aliases": [],
"timeframes": []
},
{
"lineageID": "c1048661-0beb-4947-9870-8420231a0f92",
"name": "tax_4_amount",
"kind": "dimension",
"dataType": "float",
"isUnique": false,
"isHidden": false,
"expression": "",
"label": "",
"description": "",
"valueFormat": "",
"labelShort": "",
"groupLabel": "",
"requiredFields": [],
"drillColumns": [],
"aliases": [],
"timeframes": []
},
{
"lineageID": "7343efcf-5f8f-4c43-8d2d-e506ecb6b33c",
"name": "tax_5_amount",
"kind": "dimension",
"dataType": "float",
"isUnique": false,
"isHidden": false,
"expression": "",
"label": "",
"description": "",
"valueFormat": "",
"labelShort": "",
"groupLabel": "",
"requiredFields": [],
"drillColumns": [],
"aliases": [],
"timeframes": []
},
{
"lineageID": "3dbf37fa-2932-476c-8696-20d5761625aa",
"name": "tax_amount",
"kind": "dimension",
"dataType": "float",
"isUnique": false,
"isHidden": false,
"expression": "fulfillment_items.tax_1_amount + fulfillment_items.tax_2_amount +fulfillment_items.tax_3_amount +fulfillment_items.tax_4_amount +fulfillment_items.tax_5_amount",
"label": "",
"description": "",
"valueFormat": "",
"labelShort": "",
"groupLabel": "",
"requiredFields": [],
"drillColumns": [],
"aliases": [],
"timeframes": []
},
{
"lineageID": "01723df0-4684-4963-8ae8-9923e83d07db",
"name": "discount",
"kind": "dimension",
"dataType": "float",
"isUnique": false,
"isHidden": false,
"expression": "",
"label": "",
"description": "",
"valueFormat": "money",
"labelShort": "",
"groupLabel": "",
"requiredFields": [],
"drillColumns": [],
"aliases": [],
"timeframes": []
},
{
"lineageID": "c1445d34-89b3-4473-8711-971bb06e1abf",
"name": "total_discount",
"kind": "measure",
"dataType": "float",
"isUnique": false,
"isHidden": false,
"expression": "fulfillment_items.sum_x(fulfillment_items.discount)",
"label": "",
"description": "",
"valueFormat": "money",
"labelShort": "",
"groupLabel": "",
"requiredFields": [],
"drillColumns": [],
"aliases": [],
"timeframes": []
},
{
"lineageID": "cfeefff3-8da2-4604-ad27-b707b25f7e1f",
"name": "total_tax_amount",
"kind": "measure",
"dataType": "float",
"isUnique": false,
"isHidden": false,
"expression": "fulfillment_items.sum_x(fulfillment_items.tax_amount)",
"label": "",
"description": "",
"valueFormat": "money",
"labelShort": "",
"groupLabel": "",
"requiredFields": [],
"drillColumns": [],
"aliases": [],
"timeframes": []
}
],
"datasource": {
"columns": [
{
"lineageID": "f6264b73-d5f3-425a-bad8-3ccd470d8a3c",
"name": "price",
"dataType": "float",
"sql": ""
},
{
"lineageID": "df5fb67e-77d4-4a71-839f-73e342738d25",
"name": "product_name",
"dataType": "string",
"sql": "{{ TABLE }}.title"
},
{
"lineageID": "b1f89860-1182-49bb-84eb-78281219889d",
"name": "variant_name",
"dataType": "string",
"sql": "{{ TABLE }}.variant_title"
},
{
"lineageID": "590e7974-9fec-4efc-9a00-a31bc07c3813",
"name": "sku",
"dataType": "string",
"sql": ""
},
{
"lineageID": "6321c165-d165-4d27-9626-8b12a78c3f88",
"name": "vendor",
"dataType": "string",
"sql": ""
},
{
"lineageID": "54742edb-a968-463e-8096-b0a80e21918e",
"name": "tax_1_rate",
"dataType": "float",
"sql": "{{ TABLE }}.tax_lines-\u003e0-\u003e\u003e'rate'"
},
{
"lineageID": "cb854225-7868-46e8-9e54-c84310dd7086",
"name": "tax_2_rate",
"dataType": "float",
"sql": "{{ TABLE }}.tax_lines-\u003e1-\u003e\u003e'rate'"
},
{
"lineageID": "1146bdd4-bef2-4508-93a0-b246a4dbc8f1",
"name": "tax_3_rate",
"dataType": "float",
"sql": "{{ TABLE }}.tax_lines-\u003e2-\u003e\u003e'rate'"
},
{
"lineageID": "1689aeac-71ff-47f0-a530-82aee142a4d5",
"name": "tax_4_rate",
"dataType": "float",
"sql": "{{ TABLE }}.tax_lines-\u003e3-\u003e\u003e'rate'"
},
{
"lineageID": "f1ea6ece-ad82-49f9-9108-35ea7251e023",
"name": "tax_5_rate",
"dataType": "float",
"sql": "{{ TABLE }}.tax_lines-\u003e4-\u003e\u003e'rate'"
},
{
"lineageID": "71cfbfb3-bd9d-4912-972a-83302b40715c",
"name": "tax_1_title",
"dataType": "string",
"sql": "{{ TABLE }}.tax_lines-\u003e0-\u003e\u003e'title'"
},
{
"lineageID": "de14a0fe-4d3b-49a6-94a6-44339a37fda3",
"name": "tax_2_title",
"dataType": "string",
"sql": "{{ TABLE }}.tax_lines-\u003e1-\u003e\u003e'title'"
},
{
"lineageID": "bad2894e-0f29-4d30-a7e8-bf76deedc330",
"name": "tax_3_title",
"dataType": "float",
"sql": "{{ TABLE }}.tax_lines-\u003e2-\u003e\u003e'title'"
},
{
"lineageID": "a8f8308b-9f5b-4300-b622-ca8b226bfaac",
"name": "tax_4_title",
"dataType": "float",
"sql": "{{ TABLE }}.tax_lines-\u003e3-\u003e\u003e'title'"
},
{
"lineageID": "7c4f3b2e-5c22-4f7b-8477-3e7b6e16556d",
"name": "tax_5_title",
"dataType": "float",
"sql": "{{ TABLE }}.tax_lines-\u003e4-\u003e\u003e'title'"
},
{
"lineageID": "1916bce1-00e8-40fd-8bc0-c917a7a3fddd",
"name": "tax_1_amount",
"dataType": "float",
"sql": "{{ TABLE }}.tax_lines-\u003e0-\u003e\u003e'price'"
},
{
"lineageID": "cfae15f9-01d6-4e2f-931f-3b12b9e4f20f",
"name": "tax_2_amount",
"dataType": "float",
"sql": "{{ TABLE }}.tax_lines-\u003e1-\u003e\u003e'price'"
},
{
"lineageID": "ff4a6e10-33bb-4013-98d4-fd96c61bfd61",
"name": "tax_3_amount",
"dataType": "float",
"sql": "{{ TABLE }}.tax_lines-\u003e2-\u003e\u003e'price'"
},
{
"lineageID": "edf4ec87-f8c4-45ff-b2e7-a4ca9cd7822d",
"name": "tax_4_amount",
"dataType": "float",
"sql": "{{ TABLE }}.tax_lines-\u003e3-\u003e\u003e'price'"
},
{
"lineageID": "4572522f-d5a7-4d30-a2ab-ec6ca7b7c58f",
"name": "tax_5_amount",
"dataType": "float",
"sql": "{{ TABLE }}.tax_lines-\u003e4-\u003e\u003e'price'"
},
{
"lineageID": "a9b9e68c-2678-41fc-97ac-bef29754ee70",
"name": "discount",
"dataType": "float",
"sql": "{{ TABLE }}.total_discount"
}
]
}
},
{
"lineageID": "0203f35e-9f8c-34a0-b813-bb5f0a401209",
"columns": [
{
"lineageID": "55b3c750-e268-40af-a661-79a83b08a4e4",
"name": "updated_at",
"kind": "dimension",
"dataType": "",
"isUnique": false,
"isHidden": false,
"expression": "CASE(\n\tand(refund_items.quantity = 0, not(is_blank(refunds.processed_at))),\n\trefunds.processed_at,\n\torders.processed_at\n)",
"label": "",
"description": "Total Price - Discounts",
"valueFormat": "default",
"labelShort": "",
"groupLabel": "",
"requiredFields": [],
"drillColumns": [],
"aliases": [],
"timeframes": []
},
{
"lineageID": "dc7ba76a-e53a-31bc-afd3-6c1c794c7222",
"isHidden": false
}
],
"datasource": {}
},
{
"lineageID": "da2189f5-7013-34c2-a50d-bb9676477265",
"columns": [
{
"lineageID": "2662b901-a1c0-48f4-af63-11efa516bb5b",
"name": "updated_at",
"kind": "dimension",
"dataType": "timestamp",
"isUnique": false,
"isHidden": false,
"expression": "",
"label": "",
"description": "",
"valueFormat": "",
"labelShort": "",
"groupLabel": "",
"requiredFields": [],
"drillColumns": [],
"aliases": [],
"timeframes": []
}
],
"datasource": {
"columns": [
{
"lineageID": "5a1675e6-639f-48e2-b015-2acba37b999a",
"name": "updated_at",
"dataType": "timestamp",
"sql": ""
}
]
}
},
{
"lineageID": "4892effe-4ade-3cdd-97e9-79085fecc8f7",
"columns": [
{
"lineageID": "2b53ea9d-e99e-4ba1-b30a-cf51476e0133",
"name": "location_name",
"kind": "dimension",
"dataType": "",
"isUnique": false,
"isHidden": false,
"expression": "case (\nrefund_items.location_id = 61614817383, 'Yorkdale POS',\nrefund_items.location_id = 17407606887, '5500 Royalmount Ave',\nrefund_items.location_id = 61614784615, '4th West POS', \n'N/A'\n)",
"label": "",
"description": "",
"valueFormat": "default",
"labelShort": "",
"groupLabel": "",
"requiredFields": [],
"drillColumns": [],
"aliases": [],
"timeframes": []
}
],
"datasource": {
"columns": [
{
"lineageID": "0ed0a1d9-2613-4ef1-b3f4-b373bb892b4c",
"name": "location_id",
"dataType": "int",
"sql": ""
}
]
}
}
]
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment