order_events.json

{
  "tables": [
    {
      "lineageID": "07ac8872-abfa-4638-b419-2e20b6e366d6",
      "name": "order_events",
      "expression": "",
      "label": "",
      "isHidden": false,
      "columns": [
        {
          "lineageID": "356e4d67-98a2-4da9-86a0-48c79203ec2c",
          "name": "_is_ShipStation_message",
          "kind": "dimension",
          "dataType": "",
          "isUnique": false,
          "isHidden": true,
          "expression": "if(str_contains(order_events.message, \"ShipStation sent a shipping confirmation email\"), 1, 0)\n",
          "label": "Is ShipStation Message",
          "description": "",
          "valueFormat": "",
          "labelShort": "",
          "groupLabel": "",
          "requiredFields": [],
          "drillColumns": [],
          "aliases": [],
          "timeframes": []
        },
        {
          "lineageID": "5b6479a9-c458-4afc-96fe-16bddea0b78d",
          "name": "is_ShipStation_message",
          "kind": "dimension",
          "dataType": "",
          "isUnique": false,
          "isHidden": true,
          "expression": "if(str_contains(order_events.messages, \"ShipStation sent a shipping confirmation email to\"), order_events.message, \"No\")\n",
          "label": "",
          "description": "",
          "valueFormat": "",
          "labelShort": "",
          "groupLabel": "",
          "requiredFields": [],
          "drillColumns": [],
          "aliases": [],
          "timeframes": []
        },
        {
          "lineageID": "3429dcd4-a23f-4363-858f-f7aede4125de",
          "name": "total_is_ShipStation_message",
          "kind": "measure",
          "dataType": "",
          "isUnique": false,
          "isHidden": true,
          "expression": "order_events.sum_x(order_events._is_ShipStation_message)\n",
          "label": "",
          "description": "",
          "valueFormat": "",
          "labelShort": "",
          "groupLabel": "",
          "requiredFields": [],
          "drillColumns": [],
          "aliases": [],
          "timeframes": []
        }
      ],
      "drillColumns": [],
      "datasource": {},
    {
      "lineageID": "da2189f5-7013-34c2-a50d-bb9676477265",
      "columns": [
        {
          "lineageID": "c65d1720-854c-4f0c-94fa-11fe622d02d0",
          "name": "is_shipStation_message",
          "kind": "dimension",
          "dataType": "",
          "isUnique": false,
          "isHidden": true,
          "expression": "if(str_contains(order_events.message, \"Shannon Smith canceled this order.\"), 1, 0)\n",
          "label": "",
          "description": "",
          "valueFormat": "",
          "labelShort": "",
          "groupLabel": "",
          "requiredFields": [],
          "drillColumns": [],
          "aliases": [],
          "timeframes": []
        },
        {
          "lineageID": "3c7063e7-6871-4d6e-97a3-62b745394078",
          "name": "shipstation_confirmation_email",
          "kind": "dimension",
          "dataType": "",
          "isUnique": false,
          "isHidden": false,
          "expression": "if(str_contains(order_events.messages, \"ShipStation sent a shipping confirmation email to\"), order_events.messages, \"No\")\n",
          "label": "ShipStation confirmation email",
          "description": "",
          "valueFormat": "",
          "labelShort": "",
          "groupLabel": "",
          "requiredFields": [],
          "drillColumns": [],
          "aliases": [],
          "timeframes": []
        }
      ],
      "datasource": {}
    }
  ]
}