BigQuery SBB Schemas

customers.json

[
    {
        "mode": "REQUIRED",
        "name": "c_custkey",
        "type": "INTEGER"
    },
    {
        "mode": "REQUIRED",
        "name": "c_name",
        "type": "STRING"
    },
    {
        "mode": "REQUIRED",
        "name": "c_address",
        "type": "STRING"
    },
    {
        "mode": "REQUIRED",
        "name": "c_city",
        "type": "STRING"
    },
    {
        "mode": "REQUIRED",
        "name": "c_nation",
        "type": "STRING"
    },
    {
        "mode": "REQUIRED",
        "name": "c_region",
        "type": "STRING"
    },
    {
        "mode": "REQUIRED",
        "name": "c_phone",
        "type": "STRING"
    },
    {
        "mode": "REQUIRED",
        "name": "c_mktsegment",
        "type": "STRING"
    }
]

dwdate.json

[
  {
      "mode": "REQUIRED",
      "name": "d_datekey",
      "type": "INTEGER"
  },
  {
      "mode": "REQUIRED",
      "name": "d_date",
      "type": "STRING"
  },
  {
      "mode": "REQUIRED",
      "name": "d_dayofweek",
      "type": "STRING"
  },
  {
      "mode": "REQUIRED",
      "name": "d_month",
      "type": "STRING"
  },
  {
      "mode": "REQUIRED",
      "name": "d_year",
      "type": "INTEGER"
  },
  {
      "mode": "REQUIRED",
      "name": "d_yearmonthnum",
      "type": "INTEGER"
  },
  {
      "mode": "REQUIRED",
      "name": "d_yearmonth",
      "type": "STRING"
  },
  {
      "mode": "REQUIRED",
      "name": "d_daynuminweek",
      "type": "INTEGER"
  },
  {
      "mode": "REQUIRED",
      "name": "d_daynuminmonth",
      "type": "INTEGER"
  },
  {
      "mode": "REQUIRED",
      "name": "d_daynuminyear",
      "type": "INTEGER"
  },
  {
      "mode": "REQUIRED",
      "name": "d_monthnuminyear",
      "type": "INTEGER"
  },
  {
      "mode": "REQUIRED",
      "name": "d_weeknuminyear",
      "type": "INTEGER"
  },
  {
      "mode": "REQUIRED",
      "name": "d_sellingseason",
      "type": "STRING"
  },
  {
      "mode": "REQUIRED",
      "name": "d_lastdayinweekfl",
      "type": "STRING"
  },
  {
      "mode": "REQUIRED",
      "name": "d_lastdayinmonthfl",
      "type": "STRING"
  },
  {
      "mode": "REQUIRED",
      "name": "d_holidayfl",
      "type": "STRING"
  },
  {
      "mode": "REQUIRED",
      "name": "d_weekdayfl",
      "type": "STRING"
  }
]

lineorders.json

[
  {
      "mode": "REQUIRED",
      "name": "lo_orderkey",
      "type": "INTEGER"
  },
  {
      "mode": "REQUIRED",
      "name": "lo_linenumber",
      "type": "INTEGER"
  },
  {
      "mode": "REQUIRED",
      "name": "lo_custkey",
      "type": "INTEGER"
  },
  {
      "mode": "REQUIRED",
      "name": "lo_partkey",
      "type": "INTEGER"
  },
  {
      "mode": "REQUIRED",
      "name": "lo_suppkey",
      "type": "INTEGER"
  },
  {
      "mode": "REQUIRED",
      "name": "lo_orderdate",
      "type": "INTEGER"
  },
  {
      "mode": "REQUIRED",
      "name": "lo_orderpriority",
      "type": "STRING"
  },
  {
      "mode": "REQUIRED",
      "name": "lo_shippriority",
      "type": "STRING"
  },
  {
      "mode": "REQUIRED",
      "name": "lo_quantity",
      "type": "INTEGER"
  },
  {
      "mode": "REQUIRED",
      "name": "lo_extendedprice",
      "type": "INTEGER"
  },
  {
      "mode": "REQUIRED",
      "name": "lo_ordertotalprice",
      "type": "INTEGER"
  },
  {
      "mode": "REQUIRED",
      "name": "lo_discount",
      "type": "INTEGER"
  },
  {
      "mode": "REQUIRED",
      "name": "lo_revenue",
      "type": "INTEGER"
  },
  {
      "mode": "REQUIRED",
      "name": "lo_supplycost",
      "type": "INTEGER"
  },
  {
      "mode": "REQUIRED",
      "name": "lo_tax",
      "type": "INTEGER"
  },
  {
      "mode": "REQUIRED",
      "name": "lo_commitdate",
      "type": "INTEGER"
  },
  {
      "mode": "REQUIRED",
      "name": "lo_shipmode",
      "type": "STRING"
  }
]

parts.json

[
  {
      "mode": "REQUIRED",
      "name": "p_partkey",
      "type": "INTEGER"
  },
  {
      "mode": "REQUIRED",
      "name": "p_name",
      "type": "STRING"
  },
  {
      "mode": "REQUIRED",
      "name": "p_mfgr",
      "type": "STRING"
  },
  {
      "mode": "REQUIRED",
      "name": "p_category",
      "type": "STRING"
  },
  {
      "mode": "REQUIRED",
      "name": "p_brand1",
      "type": "STRING"
  },
  {
      "mode": "REQUIRED",
      "name": "p_color",
      "type": "STRING"
  },
  {
      "mode": "REQUIRED",
      "name": "p_type",
      "type": "STRING"
  },
  {
      "mode": "REQUIRED",
      "name": "p_size",
      "type": "INTEGER"
  },
  {
      "mode": "REQUIRED",
      "name": "p_container",
      "type": "STRING"
  }
]

suppliers.json

[
  {
      "mode": "REQUIRED",
      "name": "s_suppkey",
      "type": "INTEGER"
  },
  {
      "mode": "REQUIRED",
      "name": "s_name",
      "type": "STRING"
  },
  {
      "mode": "REQUIRED",
      "name": "s_address",
      "type": "STRING"
  },
  {
      "mode": "REQUIRED",
      "name": "s_city",
      "type": "STRING"
  },
  {
      "mode": "REQUIRED",
      "name": "s_nation",
      "type": "STRING"
  },
  {
      "mode": "REQUIRED",
      "name": "s_region",
      "type": "STRING"
  },
  {
      "mode": "REQUIRED",
      "name": "s_phone",
      "type": "STRING"
  }
]