Customer Segments Data Lake Schema [Up to date as of Nov 6, 2023]

[
  {
    "Name": "op",
    "Type": "string"
  },
  {
    "Name": "id",
    "Type": "string"
  },
  {
    "Name": "segment_name",
    "Type": "string"
  },
  {
    "Name": "segment_description",
    "Type": "string"
  },
  {
    "Name": "selection_criteria",
    "Type": "string"
  },
  {
    "Name": "bc_sync_status",
    "Type": "string"
  },
  {
    "Name": "bc_segment_id",
    "Type": "string"
  },
  {
    "Name": "segment_size",
    "Type": "int"
  },
  {
    "Name": "last_generated_at",
    "Type": "timestamp"
  },
  {
    "Name": "created_at",
    "Type": "timestamp"
  },
  {
    "Name": "updated_at",
    "Type": "string"
  },
  {
    "Name": "deleted_at",
    "Type": "timestamp"
  },
  {
    "Name": "hard_deleted",
    "Type": "boolean"
  },
  {
    "Name": "tenant_id",
    "Type": "string"
  },
  {
    "Name": "p_tenant_id",
    "Type": "string",
    "PartitionKey": "Partition (0)"
  },
  {
    "Name": "year",
    "Type": "string",
    "PartitionKey": "Partition (1)"
  },
  {
    "Name": "month",
    "Type": "string",
    "PartitionKey": "Partition (2)"
  },
  {
    "Name": "day",
    "Type": "string",
    "PartitionKey": "Partition (3)"
  },
  {
    "Name": "source",
    "Type": "string",
    "PartitionKey": "Partition (4)"
  }
]