Clubs Memberships Data Lake Schema [Up to date as of Nov 6, 2023]

[
  {
    "Name": "op",
    "Type": "string"
  },
  {
    "Name": "id",
    "Type": "string"
  },
  {
    "Name": "club_id",
    "Type": "string"
  },
  {
    "Name": "customer_id",
    "Type": "string"
  },
  {
    "Name": "human_id",
    "Type": "int"
  },
  {
    "Name": "start_date",
    "Type": "timestamp"
  },
  {
    "Name": "cancellation_date",
    "Type": "timestamp"
  },
  {
    "Name": "status",
    "Type": "string"
  },
  {
    "Name": "delivery_preference",
    "Type": "string"
  },
  {
    "Name": "primary_shipping_address_id",
    "Type": "string"
  },
  {
    "Name": "primary_billing_address_id",
    "Type": "string"
  },
  {
    "Name": "wine_preference",
    "Type": "string"
  },
  {
    "Name": "manual_processing_required",
    "Type": "string"
  },
  {
    "Name": "creation_channel",
    "Type": "string"
  },
  {
    "Name": "created_at",
    "Type": "timestamp"
  },
  {
    "Name": "updated_at",
    "Type": "string"
  },
  {
    "Name": "club_option_id",
    "Type": "string"
  },
  {
    "Name": "terms_accepted_at",
    "Type": "timestamp"
  },
  {
    "Name": "stored_card_id",
    "Type": "string"
  },
  {
    "Name": "hard_deleted",
    "Type": "boolean"
  },
  {
    "Name": "tenant_id",
    "Type": "string"
  },
  {
    "Name": "wdc_id",
    "Type": "string"
  },
  {
    "Name": "pickup_location_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)"
  }
]