Schema Info

Schema Name: sfdl_prod_rds.sparefoot_sparefoot_centershift4_units

created: 2022-08-18 17:24:52
disabled: False
format: raw
id: 1133
is_partitioned: False
is_schema_datatyped: False

name:

{
    "database": "sfdl_prod_rds",
    "table": "sparefoot_sparefoot_centershift4_units"
}

type: rds

Schema Versions: 15

Version 1718408

created: 2026-04-17 14:17:15

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_centershift4_units`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_centershift4_units`\n(\n `access_type`  string , `access_type_val`  string , `attribute01`  string , `attribute01_val`  string , `attribute02`  string , `attribute02_val`  string , `class_desc`  string , `climate`  string , `climate_val`  string , `created`  timestamp , `cs_site_id`  bigint , `cs_unit_id`  bigint , `depth`  double , `door`  string , `door_val`  string , `features`  string , `features_val`  string , `height`  double , `id`  int , `listing_avail_id`  int , `listing_avail_space_id`  int , `modified`  timestamp , `notes`  string , `obj_period_uom_val`  string , `pcd_id`  string , `push_rate`  double , `rent_rate`  double , `reservation_type`  string , `status_val`  string , `unavailable_due_to_site_rules`  smallint , `unit_group_id`  string , `unit_number`  string , `version`  int , `width`  double \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-prod/raw/sparefoot_centershift4_units/2026-04-17/1776453416'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_centershift4_units"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_centershift4_units/2026-04-17/1776453416
id: 1718408
processed: 1

raw_data:

{
    "access_type": "string",
    "access_type_val": "string",
    "attribute01": "string",
    "attribute01_val": "string",
    "attribute02": "string",
    "attribute02_val": "string",
    "class_desc": "string",
    "climate": "string",
    "climate_val": "string",
    "created": "timestamp[ns]",
    "cs_site_id": "int64",
    "cs_unit_id": "int64",
    "depth": "double",
    "door": "string",
    "door_val": "string",
    "features": "string",
    "features_val": "string",
    "height": "double",
    "id": "int32",
    "listing_avail_id": "int32",
    "listing_avail_space_id": "int32",
    "modified": "timestamp[ns]",
    "notes": "string",
    "obj_period_uom_val": "string",
    "pcd_id": "string",
    "push_rate": "double",
    "rent_rate": "double",
    "reservation_type": "string",
    "status_val": "string",
    "unavailable_due_to_site_rules": "int16",
    "unit_group_id": "string",
    "unit_number": "string",
    "version": "int32",
    "width": "double"
}

schema_attributes:

{
    "access_type": "string",
    "access_type_val": "string",
    "attribute01": "string",
    "attribute01_val": "string",
    "attribute02": "string",
    "attribute02_val": "string",
    "class_desc": "string",
    "climate": "string",
    "climate_val": "string",
    "created": "timestamp",
    "cs_site_id": "bigint",
    "cs_unit_id": "bigint",
    "depth": "double",
    "door": "string",
    "door_val": "string",
    "features": "string",
    "features_val": "string",
    "height": "double",
    "id": "int",
    "listing_avail_id": "int",
    "listing_avail_space_id": "int",
    "modified": "timestamp",
    "notes": "string",
    "obj_period_uom_val": "string",
    "pcd_id": "string",
    "push_rate": "double",
    "rent_rate": "double",
    "reservation_type": "string",
    "status_val": "string",
    "unavailable_due_to_site_rules": "smallint",
    "unit_group_id": "string",
    "unit_number": "string",
    "version": "int",
    "width": "double"
}

schema_name_id: 1133
schema_scan_id: 162194045
updated: 2026-04-17 14:17:26

Version 1718197

created: 2026-04-17 09:19:19

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_centershift4_units`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_centershift4_units`\n(\n `access_type`  string , `access_type_val`  string , `attribute01`  string , `attribute01_val`  string , `attribute02`  string , `attribute02_val`  string , `class_desc`  string , `climate`  string , `climate_val`  string , `created`  timestamp , `cs_site_id`  bigint , `cs_unit_id`  bigint , `depth`  double , `door`  string , `door_val`  string , `features`  string , `features_val`  string , `height`  double , `id`  int , `listing_avail_id`  int , `listing_avail_space_id`  int , `modified`  timestamp , `notes`  string , `obj_period_uom_val`  string , `pcd_id`  string , `push_rate`  double , `rent_rate`  double , `reservation_type`  string , `status_val`  string , `unavailable_due_to_site_rules`  smallint , `unit_group_id`  string , `unit_number`  string , `version`  int , `width`  double \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-prod/raw/sparefoot_centershift4_units/2026-04-17/1776435553'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_centershift4_units"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_centershift4_units/2026-04-17/1776435553
id: 1718197
processed: 1

raw_data:

{
    "access_type": "string",
    "access_type_val": "string",
    "attribute01": "string",
    "attribute01_val": "string",
    "attribute02": "string",
    "attribute02_val": "string",
    "class_desc": "string",
    "climate": "string",
    "climate_val": "string",
    "created": "timestamp[ns]",
    "cs_site_id": "int64",
    "cs_unit_id": "int64",
    "depth": "double",
    "door": "string",
    "door_val": "string",
    "features": "string",
    "features_val": "string",
    "height": "double",
    "id": "int32",
    "listing_avail_id": "int32",
    "listing_avail_space_id": "int32",
    "modified": "timestamp[ns]",
    "notes": "string",
    "obj_period_uom_val": "string",
    "pcd_id": "string",
    "push_rate": "double",
    "rent_rate": "double",
    "reservation_type": "string",
    "status_val": "string",
    "unavailable_due_to_site_rules": "int16",
    "unit_group_id": "string",
    "unit_number": "string",
    "version": "int32",
    "width": "double"
}

schema_attributes:

{
    "access_type": "string",
    "access_type_val": "string",
    "attribute01": "string",
    "attribute01_val": "string",
    "attribute02": "string",
    "attribute02_val": "string",
    "class_desc": "string",
    "climate": "string",
    "climate_val": "string",
    "created": "timestamp",
    "cs_site_id": "bigint",
    "cs_unit_id": "bigint",
    "depth": "double",
    "door": "string",
    "door_val": "string",
    "features": "string",
    "features_val": "string",
    "height": "double",
    "id": "int",
    "listing_avail_id": "int",
    "listing_avail_space_id": "int",
    "modified": "timestamp",
    "notes": "string",
    "obj_period_uom_val": "string",
    "pcd_id": "string",
    "push_rate": "double",
    "rent_rate": "double",
    "reservation_type": "string",
    "status_val": "string",
    "unavailable_due_to_site_rules": "smallint",
    "unit_group_id": "string",
    "unit_number": "string",
    "version": "int",
    "width": "double"
}

schema_name_id: 1133
schema_scan_id: 162178288
updated: 2026-04-17 09:19:32

Version 1717473

created: 2026-04-17 00:14:01

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_centershift4_units`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_centershift4_units`\n(\n `access_type`  string , `access_type_val`  string , `attribute01`  string , `attribute01_val`  string , `attribute02`  string , `attribute02_val`  string , `class_desc`  string , `climate`  string , `climate_val`  string , `created`  timestamp , `cs_site_id`  bigint , `cs_unit_id`  bigint , `depth`  double , `door`  string , `door_val`  string , `features`  string , `features_val`  string , `height`  double , `id`  int , `listing_avail_id`  int , `listing_avail_space_id`  int , `modified`  timestamp , `notes`  string , `obj_period_uom_val`  string , `pcd_id`  string , `push_rate`  double , `rent_rate`  double , `reservation_type`  string , `status_val`  string , `unavailable_due_to_site_rules`  smallint , `unit_group_id`  string , `unit_number`  string , `version`  int , `width`  double \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-prod/raw/sparefoot_centershift4_units/2026-04-17/1776402833'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_centershift4_units"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_centershift4_units/2026-04-17/1776402833
id: 1717473
processed: 1

raw_data:

{
    "access_type": "string",
    "access_type_val": "string",
    "attribute01": "string",
    "attribute01_val": "string",
    "attribute02": "string",
    "attribute02_val": "string",
    "class_desc": "string",
    "climate": "string",
    "climate_val": "string",
    "created": "timestamp[ns]",
    "cs_site_id": "int64",
    "cs_unit_id": "int64",
    "depth": "double",
    "door": "string",
    "door_val": "string",
    "features": "string",
    "features_val": "string",
    "height": "double",
    "id": "int32",
    "listing_avail_id": "int32",
    "listing_avail_space_id": "int32",
    "modified": "timestamp[ns]",
    "notes": "string",
    "obj_period_uom_val": "string",
    "pcd_id": "string",
    "push_rate": "double",
    "rent_rate": "double",
    "reservation_type": "string",
    "status_val": "string",
    "unavailable_due_to_site_rules": "int16",
    "unit_group_id": "string",
    "unit_number": "string",
    "version": "int32",
    "width": "double"
}

schema_attributes:

{
    "access_type": "string",
    "access_type_val": "string",
    "attribute01": "string",
    "attribute01_val": "string",
    "attribute02": "string",
    "attribute02_val": "string",
    "class_desc": "string",
    "climate": "string",
    "climate_val": "string",
    "created": "timestamp",
    "cs_site_id": "bigint",
    "cs_unit_id": "bigint",
    "depth": "double",
    "door": "string",
    "door_val": "string",
    "features": "string",
    "features_val": "string",
    "height": "double",
    "id": "int",
    "listing_avail_id": "int",
    "listing_avail_space_id": "int",
    "modified": "timestamp",
    "notes": "string",
    "obj_period_uom_val": "string",
    "pcd_id": "string",
    "push_rate": "double",
    "rent_rate": "double",
    "reservation_type": "string",
    "status_val": "string",
    "unavailable_due_to_site_rules": "smallint",
    "unit_group_id": "string",
    "unit_number": "string",
    "version": "int",
    "width": "double"
}

schema_name_id: 1133
schema_scan_id: 162163634
updated: 2026-04-17 00:14:12

Version 1717365

created: 2026-04-16 20:39:47

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_centershift4_units`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_centershift4_units`\n(\n `access_type`  string , `access_type_val`  string , `attribute01`  string , `attribute01_val`  string , `attribute02`  string , `attribute02_val`  string , `class_desc`  string , `climate`  string , `climate_val`  string , `created`  timestamp , `cs_site_id`  bigint , `cs_unit_id`  bigint , `depth`  double , `door`  string , `door_val`  string , `features`  string , `features_val`  string , `height`  double , `id`  int , `listing_avail_id`  int , `listing_avail_space_id`  int , `modified`  timestamp , `notes`  string , `obj_period_uom_val`  string , `pcd_id`  string , `push_rate`  double , `rent_rate`  double , `reservation_type`  string , `status_val`  string , `unavailable_due_to_site_rules`  smallint , `unit_group_id`  string , `unit_number`  string , `version`  int , `width`  double \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-prod/raw/sparefoot_centershift4_units/2026-04-16/1776389976'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_centershift4_units"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_centershift4_units/2026-04-16/1776389976
id: 1717365
processed: 1

raw_data:

{
    "access_type": "string",
    "access_type_val": "string",
    "attribute01": "string",
    "attribute01_val": "string",
    "attribute02": "string",
    "attribute02_val": "string",
    "class_desc": "string",
    "climate": "string",
    "climate_val": "string",
    "created": "timestamp[ns]",
    "cs_site_id": "int64",
    "cs_unit_id": "int64",
    "depth": "double",
    "door": "string",
    "door_val": "string",
    "features": "string",
    "features_val": "string",
    "height": "double",
    "id": "int32",
    "listing_avail_id": "int32",
    "listing_avail_space_id": "int32",
    "modified": "timestamp[ns]",
    "notes": "string",
    "obj_period_uom_val": "string",
    "pcd_id": "string",
    "push_rate": "double",
    "rent_rate": "double",
    "reservation_type": "string",
    "status_val": "string",
    "unavailable_due_to_site_rules": "int16",
    "unit_group_id": "string",
    "unit_number": "string",
    "version": "int32",
    "width": "double"
}

schema_attributes:

{
    "access_type": "string",
    "access_type_val": "string",
    "attribute01": "string",
    "attribute01_val": "string",
    "attribute02": "string",
    "attribute02_val": "string",
    "class_desc": "string",
    "climate": "string",
    "climate_val": "string",
    "created": "timestamp",
    "cs_site_id": "bigint",
    "cs_unit_id": "bigint",
    "depth": "double",
    "door": "string",
    "door_val": "string",
    "features": "string",
    "features_val": "string",
    "height": "double",
    "id": "int",
    "listing_avail_id": "int",
    "listing_avail_space_id": "int",
    "modified": "timestamp",
    "notes": "string",
    "obj_period_uom_val": "string",
    "pcd_id": "string",
    "push_rate": "double",
    "rent_rate": "double",
    "reservation_type": "string",
    "status_val": "string",
    "unavailable_due_to_site_rules": "smallint",
    "unit_group_id": "string",
    "unit_number": "string",
    "version": "int",
    "width": "double"
}

schema_name_id: 1133
schema_scan_id: 162156247
updated: 2026-04-16 20:39:58

Version 1717171

created: 2026-04-16 14:16:34

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_centershift4_units`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_centershift4_units`\n(\n `access_type`  string , `access_type_val`  string , `attribute01`  string , `attribute01_val`  string , `attribute02`  string , `attribute02_val`  string , `class_desc`  string , `climate`  string , `climate_val`  string , `created`  timestamp , `cs_site_id`  bigint , `cs_unit_id`  bigint , `depth`  double , `door`  string , `door_val`  string , `features`  string , `features_val`  string , `height`  double , `id`  int , `listing_avail_id`  int , `listing_avail_space_id`  int , `modified`  timestamp , `notes`  string , `obj_period_uom_val`  string , `pcd_id`  string , `push_rate`  double , `rent_rate`  double , `reservation_type`  string , `status_val`  string , `unavailable_due_to_site_rules`  smallint , `unit_group_id`  string , `unit_number`  string , `version`  int , `width`  double \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-prod/raw/sparefoot_centershift4_units/2026-04-16/1776366990'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_centershift4_units"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_centershift4_units/2026-04-16/1776366990
id: 1717171
processed: 1

raw_data:

{
    "access_type": "string",
    "access_type_val": "string",
    "attribute01": "string",
    "attribute01_val": "string",
    "attribute02": "string",
    "attribute02_val": "string",
    "class_desc": "string",
    "climate": "string",
    "climate_val": "string",
    "created": "timestamp[ns]",
    "cs_site_id": "int64",
    "cs_unit_id": "int64",
    "depth": "double",
    "door": "string",
    "door_val": "string",
    "features": "string",
    "features_val": "string",
    "height": "double",
    "id": "int32",
    "listing_avail_id": "int32",
    "listing_avail_space_id": "int32",
    "modified": "timestamp[ns]",
    "notes": "string",
    "obj_period_uom_val": "string",
    "pcd_id": "string",
    "push_rate": "double",
    "rent_rate": "double",
    "reservation_type": "string",
    "status_val": "string",
    "unavailable_due_to_site_rules": "int16",
    "unit_group_id": "string",
    "unit_number": "string",
    "version": "int32",
    "width": "double"
}

schema_attributes:

{
    "access_type": "string",
    "access_type_val": "string",
    "attribute01": "string",
    "attribute01_val": "string",
    "attribute02": "string",
    "attribute02_val": "string",
    "class_desc": "string",
    "climate": "string",
    "climate_val": "string",
    "created": "timestamp",
    "cs_site_id": "bigint",
    "cs_unit_id": "bigint",
    "depth": "double",
    "door": "string",
    "door_val": "string",
    "features": "string",
    "features_val": "string",
    "height": "double",
    "id": "int",
    "listing_avail_id": "int",
    "listing_avail_space_id": "int",
    "modified": "timestamp",
    "notes": "string",
    "obj_period_uom_val": "string",
    "pcd_id": "string",
    "push_rate": "double",
    "rent_rate": "double",
    "reservation_type": "string",
    "status_val": "string",
    "unavailable_due_to_site_rules": "smallint",
    "unit_group_id": "string",
    "unit_number": "string",
    "version": "int",
    "width": "double"
}

schema_name_id: 1133
schema_scan_id: 162138080
updated: 2026-04-16 14:16:45

Version 1716994

created: 2026-04-16 09:14:25

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_centershift4_units`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_centershift4_units`\n(\n `access_type`  string , `access_type_val`  string , `attribute01`  string , `attribute01_val`  string , `attribute02`  string , `attribute02_val`  string , `class_desc`  string , `climate`  string , `climate_val`  string , `created`  timestamp , `cs_site_id`  bigint , `cs_unit_id`  bigint , `depth`  double , `door`  string , `door_val`  string , `features`  string , `features_val`  string , `height`  double , `id`  int , `listing_avail_id`  int , `listing_avail_space_id`  int , `modified`  timestamp , `notes`  string , `obj_period_uom_val`  string , `pcd_id`  string , `push_rate`  double , `rent_rate`  double , `reservation_type`  string , `status_val`  string , `unavailable_due_to_site_rules`  smallint , `unit_group_id`  string , `unit_number`  string , `version`  int , `width`  double \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-prod/raw/sparefoot_centershift4_units/2026-04-16/1776348851'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_centershift4_units"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_centershift4_units/2026-04-16/1776348851
id: 1716994
processed: 1

raw_data:

{
    "access_type": "string",
    "access_type_val": "string",
    "attribute01": "string",
    "attribute01_val": "string",
    "attribute02": "string",
    "attribute02_val": "string",
    "class_desc": "string",
    "climate": "string",
    "climate_val": "string",
    "created": "timestamp[ns]",
    "cs_site_id": "int64",
    "cs_unit_id": "int64",
    "depth": "double",
    "door": "string",
    "door_val": "string",
    "features": "string",
    "features_val": "string",
    "height": "double",
    "id": "int32",
    "listing_avail_id": "int32",
    "listing_avail_space_id": "int32",
    "modified": "timestamp[ns]",
    "notes": "string",
    "obj_period_uom_val": "string",
    "pcd_id": "string",
    "push_rate": "double",
    "rent_rate": "double",
    "reservation_type": "string",
    "status_val": "string",
    "unavailable_due_to_site_rules": "int16",
    "unit_group_id": "string",
    "unit_number": "string",
    "version": "int32",
    "width": "double"
}

schema_attributes:

{
    "access_type": "string",
    "access_type_val": "string",
    "attribute01": "string",
    "attribute01_val": "string",
    "attribute02": "string",
    "attribute02_val": "string",
    "class_desc": "string",
    "climate": "string",
    "climate_val": "string",
    "created": "timestamp",
    "cs_site_id": "bigint",
    "cs_unit_id": "bigint",
    "depth": "double",
    "door": "string",
    "door_val": "string",
    "features": "string",
    "features_val": "string",
    "height": "double",
    "id": "int",
    "listing_avail_id": "int",
    "listing_avail_space_id": "int",
    "modified": "timestamp",
    "notes": "string",
    "obj_period_uom_val": "string",
    "pcd_id": "string",
    "push_rate": "double",
    "rent_rate": "double",
    "reservation_type": "string",
    "status_val": "string",
    "unavailable_due_to_site_rules": "smallint",
    "unit_group_id": "string",
    "unit_number": "string",
    "version": "int",
    "width": "double"
}

schema_name_id: 1133
schema_scan_id: 162122530
updated: 2026-04-16 09:14:36

Version 1716236

created: 2026-04-16 00:18:58

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_centershift4_units`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_centershift4_units`\n(\n `access_type`  string , `access_type_val`  string , `attribute01`  string , `attribute01_val`  string , `attribute02`  string , `attribute02_val`  string , `class_desc`  string , `climate`  string , `climate_val`  string , `created`  timestamp , `cs_site_id`  bigint , `cs_unit_id`  bigint , `depth`  double , `door`  string , `door_val`  string , `features`  string , `features_val`  string , `height`  double , `id`  int , `listing_avail_id`  int , `listing_avail_space_id`  int , `modified`  timestamp , `notes`  string , `obj_period_uom_val`  string , `pcd_id`  string , `push_rate`  double , `rent_rate`  double , `reservation_type`  string , `status_val`  string , `unavailable_due_to_site_rules`  smallint , `unit_group_id`  string , `unit_number`  string , `version`  int , `width`  double \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-prod/raw/sparefoot_centershift4_units/2026-04-16/1776316733'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_centershift4_units"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_centershift4_units/2026-04-16/1776316733
id: 1716236
processed: 1

raw_data:

{
    "access_type": "string",
    "access_type_val": "string",
    "attribute01": "string",
    "attribute01_val": "string",
    "attribute02": "string",
    "attribute02_val": "string",
    "class_desc": "string",
    "climate": "string",
    "climate_val": "string",
    "created": "timestamp[ns]",
    "cs_site_id": "int64",
    "cs_unit_id": "int64",
    "depth": "double",
    "door": "string",
    "door_val": "string",
    "features": "string",
    "features_val": "string",
    "height": "double",
    "id": "int32",
    "listing_avail_id": "int32",
    "listing_avail_space_id": "int32",
    "modified": "timestamp[ns]",
    "notes": "string",
    "obj_period_uom_val": "string",
    "pcd_id": "string",
    "push_rate": "double",
    "rent_rate": "double",
    "reservation_type": "string",
    "status_val": "string",
    "unavailable_due_to_site_rules": "int16",
    "unit_group_id": "string",
    "unit_number": "string",
    "version": "int32",
    "width": "double"
}

schema_attributes:

{
    "access_type": "string",
    "access_type_val": "string",
    "attribute01": "string",
    "attribute01_val": "string",
    "attribute02": "string",
    "attribute02_val": "string",
    "class_desc": "string",
    "climate": "string",
    "climate_val": "string",
    "created": "timestamp",
    "cs_site_id": "bigint",
    "cs_unit_id": "bigint",
    "depth": "double",
    "door": "string",
    "door_val": "string",
    "features": "string",
    "features_val": "string",
    "height": "double",
    "id": "int",
    "listing_avail_id": "int",
    "listing_avail_space_id": "int",
    "modified": "timestamp",
    "notes": "string",
    "obj_period_uom_val": "string",
    "pcd_id": "string",
    "push_rate": "double",
    "rent_rate": "double",
    "reservation_type": "string",
    "status_val": "string",
    "unavailable_due_to_site_rules": "smallint",
    "unit_group_id": "string",
    "unit_number": "string",
    "version": "int",
    "width": "double"
}

schema_name_id: 1133
schema_scan_id: 162107826
updated: 2026-04-16 00:19:09

Version 1716130

created: 2026-04-15 20:29:20

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_centershift4_units`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_centershift4_units`\n(\n `access_type`  string , `access_type_val`  string , `attribute01`  string , `attribute01_val`  string , `attribute02`  string , `attribute02_val`  string , `class_desc`  string , `climate`  string , `climate_val`  string , `created`  timestamp , `cs_site_id`  bigint , `cs_unit_id`  bigint , `depth`  double , `door`  string , `door_val`  string , `features`  string , `features_val`  string , `height`  double , `id`  int , `listing_avail_id`  int , `listing_avail_space_id`  int , `modified`  timestamp , `notes`  string , `obj_period_uom_val`  string , `pcd_id`  string , `push_rate`  double , `rent_rate`  double , `reservation_type`  string , `status_val`  string , `unavailable_due_to_site_rules`  smallint , `unit_group_id`  string , `unit_number`  string , `version`  int , `width`  double \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-prod/raw/sparefoot_centershift4_units/2026-04-15/1776302954'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_centershift4_units"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_centershift4_units/2026-04-15/1776302954
id: 1716130
processed: 1

raw_data:

{
    "access_type": "string",
    "access_type_val": "string",
    "attribute01": "string",
    "attribute01_val": "string",
    "attribute02": "string",
    "attribute02_val": "string",
    "class_desc": "string",
    "climate": "string",
    "climate_val": "string",
    "created": "timestamp[ns]",
    "cs_site_id": "int64",
    "cs_unit_id": "int64",
    "depth": "double",
    "door": "string",
    "door_val": "string",
    "features": "string",
    "features_val": "string",
    "height": "double",
    "id": "int32",
    "listing_avail_id": "int32",
    "listing_avail_space_id": "int32",
    "modified": "timestamp[ns]",
    "notes": "string",
    "obj_period_uom_val": "string",
    "pcd_id": "string",
    "push_rate": "double",
    "rent_rate": "double",
    "reservation_type": "string",
    "status_val": "string",
    "unavailable_due_to_site_rules": "int16",
    "unit_group_id": "string",
    "unit_number": "string",
    "version": "int32",
    "width": "double"
}

schema_attributes:

{
    "access_type": "string",
    "access_type_val": "string",
    "attribute01": "string",
    "attribute01_val": "string",
    "attribute02": "string",
    "attribute02_val": "string",
    "class_desc": "string",
    "climate": "string",
    "climate_val": "string",
    "created": "timestamp",
    "cs_site_id": "bigint",
    "cs_unit_id": "bigint",
    "depth": "double",
    "door": "string",
    "door_val": "string",
    "features": "string",
    "features_val": "string",
    "height": "double",
    "id": "int",
    "listing_avail_id": "int",
    "listing_avail_space_id": "int",
    "modified": "timestamp",
    "notes": "string",
    "obj_period_uom_val": "string",
    "pcd_id": "string",
    "push_rate": "double",
    "rent_rate": "double",
    "reservation_type": "string",
    "status_val": "string",
    "unavailable_due_to_site_rules": "smallint",
    "unit_group_id": "string",
    "unit_number": "string",
    "version": "int",
    "width": "double"
}

schema_name_id: 1133
schema_scan_id: 162100363
updated: 2026-04-15 20:29:32

Version 1715955

created: 2026-04-15 14:12:41

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_centershift4_units`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_centershift4_units`\n(\n `access_type`  string , `access_type_val`  string , `attribute01`  string , `attribute01_val`  string , `attribute02`  string , `attribute02_val`  string , `class_desc`  string , `climate`  string , `climate_val`  string , `created`  timestamp , `cs_site_id`  bigint , `cs_unit_id`  bigint , `depth`  double , `door`  string , `door_val`  string , `features`  string , `features_val`  string , `height`  double , `id`  int , `listing_avail_id`  int , `listing_avail_space_id`  int , `modified`  timestamp , `notes`  string , `obj_period_uom_val`  string , `pcd_id`  string , `push_rate`  double , `rent_rate`  double , `reservation_type`  string , `status_val`  string , `unavailable_due_to_site_rules`  smallint , `unit_group_id`  string , `unit_number`  string , `version`  int , `width`  double \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-prod/raw/sparefoot_centershift4_units/2026-04-15/1776280345'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_centershift4_units"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_centershift4_units/2026-04-15/1776280345
id: 1715955
processed: 1

raw_data:

{
    "access_type": "string",
    "access_type_val": "string",
    "attribute01": "string",
    "attribute01_val": "string",
    "attribute02": "string",
    "attribute02_val": "string",
    "class_desc": "string",
    "climate": "string",
    "climate_val": "string",
    "created": "timestamp[ns]",
    "cs_site_id": "int64",
    "cs_unit_id": "int64",
    "depth": "double",
    "door": "string",
    "door_val": "string",
    "features": "string",
    "features_val": "string",
    "height": "double",
    "id": "int32",
    "listing_avail_id": "int32",
    "listing_avail_space_id": "int32",
    "modified": "timestamp[ns]",
    "notes": "string",
    "obj_period_uom_val": "string",
    "pcd_id": "string",
    "push_rate": "double",
    "rent_rate": "double",
    "reservation_type": "string",
    "status_val": "string",
    "unavailable_due_to_site_rules": "int16",
    "unit_group_id": "string",
    "unit_number": "string",
    "version": "int32",
    "width": "double"
}

schema_attributes:

{
    "access_type": "string",
    "access_type_val": "string",
    "attribute01": "string",
    "attribute01_val": "string",
    "attribute02": "string",
    "attribute02_val": "string",
    "class_desc": "string",
    "climate": "string",
    "climate_val": "string",
    "created": "timestamp",
    "cs_site_id": "bigint",
    "cs_unit_id": "bigint",
    "depth": "double",
    "door": "string",
    "door_val": "string",
    "features": "string",
    "features_val": "string",
    "height": "double",
    "id": "int",
    "listing_avail_id": "int",
    "listing_avail_space_id": "int",
    "modified": "timestamp",
    "notes": "string",
    "obj_period_uom_val": "string",
    "pcd_id": "string",
    "push_rate": "double",
    "rent_rate": "double",
    "reservation_type": "string",
    "status_val": "string",
    "unavailable_due_to_site_rules": "smallint",
    "unit_group_id": "string",
    "unit_number": "string",
    "version": "int",
    "width": "double"
}

schema_name_id: 1133
schema_scan_id: 162081683
updated: 2026-04-15 14:12:55

Version 1715766

created: 2026-04-15 08:41:33

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_centershift4_units`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_centershift4_units`\n(\n `access_type`  string , `access_type_val`  string , `attribute01`  string , `attribute01_val`  string , `attribute02`  string , `attribute02_val`  string , `class_desc`  string , `climate`  string , `climate_val`  string , `created`  timestamp , `cs_site_id`  bigint , `cs_unit_id`  bigint , `depth`  double , `door`  string , `door_val`  string , `features`  string , `features_val`  string , `height`  double , `id`  int , `listing_avail_id`  int , `listing_avail_space_id`  int , `modified`  timestamp , `notes`  string , `obj_period_uom_val`  string , `pcd_id`  string , `push_rate`  double , `rent_rate`  double , `reservation_type`  string , `status_val`  string , `unavailable_due_to_site_rules`  smallint , `unit_group_id`  string , `unit_number`  string , `version`  int , `width`  double \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-prod/raw/sparefoot_centershift4_units/2026-04-15/1776260409'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_centershift4_units"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_centershift4_units/2026-04-15/1776260409
id: 1715766
processed: 1

raw_data:

{
    "access_type": "string",
    "access_type_val": "string",
    "attribute01": "string",
    "attribute01_val": "string",
    "attribute02": "string",
    "attribute02_val": "string",
    "class_desc": "string",
    "climate": "string",
    "climate_val": "string",
    "created": "timestamp[ns]",
    "cs_site_id": "int64",
    "cs_unit_id": "int64",
    "depth": "double",
    "door": "string",
    "door_val": "string",
    "features": "string",
    "features_val": "string",
    "height": "double",
    "id": "int32",
    "listing_avail_id": "int32",
    "listing_avail_space_id": "int32",
    "modified": "timestamp[ns]",
    "notes": "string",
    "obj_period_uom_val": "string",
    "pcd_id": "string",
    "push_rate": "double",
    "rent_rate": "double",
    "reservation_type": "string",
    "status_val": "string",
    "unavailable_due_to_site_rules": "int16",
    "unit_group_id": "string",
    "unit_number": "string",
    "version": "int32",
    "width": "double"
}

schema_attributes:

{
    "access_type": "string",
    "access_type_val": "string",
    "attribute01": "string",
    "attribute01_val": "string",
    "attribute02": "string",
    "attribute02_val": "string",
    "class_desc": "string",
    "climate": "string",
    "climate_val": "string",
    "created": "timestamp",
    "cs_site_id": "bigint",
    "cs_unit_id": "bigint",
    "depth": "double",
    "door": "string",
    "door_val": "string",
    "features": "string",
    "features_val": "string",
    "height": "double",
    "id": "int",
    "listing_avail_id": "int",
    "listing_avail_space_id": "int",
    "modified": "timestamp",
    "notes": "string",
    "obj_period_uom_val": "string",
    "pcd_id": "string",
    "push_rate": "double",
    "rent_rate": "double",
    "reservation_type": "string",
    "status_val": "string",
    "unavailable_due_to_site_rules": "smallint",
    "unit_group_id": "string",
    "unit_number": "string",
    "version": "int",
    "width": "double"
}

schema_name_id: 1133
schema_scan_id: 162064468
updated: 2026-04-15 08:41:47

Version 1715012

created: 2026-04-15 00:13:48

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_centershift4_units`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_centershift4_units`\n(\n `access_type`  string , `access_type_val`  string , `attribute01`  string , `attribute01_val`  string , `attribute02`  string , `attribute02_val`  string , `class_desc`  string , `climate`  string , `climate_val`  string , `created`  timestamp , `cs_site_id`  bigint , `cs_unit_id`  bigint , `depth`  double , `door`  string , `door_val`  string , `features`  string , `features_val`  string , `height`  double , `id`  int , `listing_avail_id`  int , `listing_avail_space_id`  int , `modified`  timestamp , `notes`  string , `obj_period_uom_val`  string , `pcd_id`  string , `push_rate`  double , `rent_rate`  double , `reservation_type`  string , `status_val`  string , `unavailable_due_to_site_rules`  smallint , `unit_group_id`  string , `unit_number`  string , `version`  int , `width`  double \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-prod/raw/sparefoot_centershift4_units/2026-04-15/1776230024'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_centershift4_units"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_centershift4_units/2026-04-15/1776230024
id: 1715012
processed: 1

raw_data:

{
    "access_type": "string",
    "access_type_val": "string",
    "attribute01": "string",
    "attribute01_val": "string",
    "attribute02": "string",
    "attribute02_val": "string",
    "class_desc": "string",
    "climate": "string",
    "climate_val": "string",
    "created": "timestamp[ns]",
    "cs_site_id": "int64",
    "cs_unit_id": "int64",
    "depth": "double",
    "door": "string",
    "door_val": "string",
    "features": "string",
    "features_val": "string",
    "height": "double",
    "id": "int32",
    "listing_avail_id": "int32",
    "listing_avail_space_id": "int32",
    "modified": "timestamp[ns]",
    "notes": "string",
    "obj_period_uom_val": "string",
    "pcd_id": "string",
    "push_rate": "double",
    "rent_rate": "double",
    "reservation_type": "string",
    "status_val": "string",
    "unavailable_due_to_site_rules": "int16",
    "unit_group_id": "string",
    "unit_number": "string",
    "version": "int32",
    "width": "double"
}

schema_attributes:

{
    "access_type": "string",
    "access_type_val": "string",
    "attribute01": "string",
    "attribute01_val": "string",
    "attribute02": "string",
    "attribute02_val": "string",
    "class_desc": "string",
    "climate": "string",
    "climate_val": "string",
    "created": "timestamp",
    "cs_site_id": "bigint",
    "cs_unit_id": "bigint",
    "depth": "double",
    "door": "string",
    "door_val": "string",
    "features": "string",
    "features_val": "string",
    "height": "double",
    "id": "int",
    "listing_avail_id": "int",
    "listing_avail_space_id": "int",
    "modified": "timestamp",
    "notes": "string",
    "obj_period_uom_val": "string",
    "pcd_id": "string",
    "push_rate": "double",
    "rent_rate": "double",
    "reservation_type": "string",
    "status_val": "string",
    "unavailable_due_to_site_rules": "smallint",
    "unit_group_id": "string",
    "unit_number": "string",
    "version": "int",
    "width": "double"
}

schema_name_id: 1133
schema_scan_id: 162051965
updated: 2026-04-15 00:13:59

Version 1714917

created: 2026-04-14 20:26:24

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_centershift4_units`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_centershift4_units`\n(\n `access_type`  string , `access_type_val`  string , `attribute01`  string , `attribute01_val`  string , `attribute02`  string , `attribute02_val`  string , `class_desc`  string , `climate`  string , `climate_val`  string , `created`  timestamp , `cs_site_id`  bigint , `cs_unit_id`  bigint , `depth`  double , `door`  string , `door_val`  string , `features`  string , `features_val`  string , `height`  double , `id`  int , `listing_avail_id`  int , `listing_avail_space_id`  int , `modified`  timestamp , `notes`  string , `obj_period_uom_val`  string , `pcd_id`  string , `push_rate`  double , `rent_rate`  double , `reservation_type`  string , `status_val`  string , `unavailable_due_to_site_rules`  smallint , `unit_group_id`  string , `unit_number`  string , `version`  int , `width`  double \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-prod/raw/sparefoot_centershift4_units/2026-04-14/1776216378'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_centershift4_units"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_centershift4_units/2026-04-14/1776216378
id: 1714917
processed: 1

raw_data:

{
    "access_type": "string",
    "access_type_val": "string",
    "attribute01": "string",
    "attribute01_val": "string",
    "attribute02": "string",
    "attribute02_val": "string",
    "class_desc": "string",
    "climate": "string",
    "climate_val": "string",
    "created": "timestamp[ns]",
    "cs_site_id": "int64",
    "cs_unit_id": "int64",
    "depth": "double",
    "door": "string",
    "door_val": "string",
    "features": "string",
    "features_val": "string",
    "height": "double",
    "id": "int32",
    "listing_avail_id": "int32",
    "listing_avail_space_id": "int32",
    "modified": "timestamp[ns]",
    "notes": "string",
    "obj_period_uom_val": "string",
    "pcd_id": "string",
    "push_rate": "double",
    "rent_rate": "double",
    "reservation_type": "string",
    "status_val": "string",
    "unavailable_due_to_site_rules": "int16",
    "unit_group_id": "string",
    "unit_number": "string",
    "version": "int32",
    "width": "double"
}

schema_attributes:

{
    "access_type": "string",
    "access_type_val": "string",
    "attribute01": "string",
    "attribute01_val": "string",
    "attribute02": "string",
    "attribute02_val": "string",
    "class_desc": "string",
    "climate": "string",
    "climate_val": "string",
    "created": "timestamp",
    "cs_site_id": "bigint",
    "cs_unit_id": "bigint",
    "depth": "double",
    "door": "string",
    "door_val": "string",
    "features": "string",
    "features_val": "string",
    "height": "double",
    "id": "int",
    "listing_avail_id": "int",
    "listing_avail_space_id": "int",
    "modified": "timestamp",
    "notes": "string",
    "obj_period_uom_val": "string",
    "pcd_id": "string",
    "push_rate": "double",
    "rent_rate": "double",
    "reservation_type": "string",
    "status_val": "string",
    "unavailable_due_to_site_rules": "smallint",
    "unit_group_id": "string",
    "unit_number": "string",
    "version": "int",
    "width": "double"
}

schema_name_id: 1133
schema_scan_id: 162044339
updated: 2026-04-14 20:26:37

Version 1714720

created: 2026-04-14 14:14:03

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_centershift4_units`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_centershift4_units`\n(\n `access_type`  string , `access_type_val`  string , `attribute01`  string , `attribute01_val`  string , `attribute02`  string , `attribute02_val`  string , `class_desc`  string , `climate`  string , `climate_val`  string , `created`  timestamp , `cs_site_id`  bigint , `cs_unit_id`  bigint , `depth`  double , `door`  string , `door_val`  string , `features`  string , `features_val`  string , `height`  double , `id`  int , `listing_avail_id`  int , `listing_avail_space_id`  int , `modified`  timestamp , `notes`  string , `obj_period_uom_val`  string , `pcd_id`  string , `push_rate`  double , `rent_rate`  double , `reservation_type`  string , `status_val`  string , `unavailable_due_to_site_rules`  smallint , `unit_group_id`  string , `unit_number`  string , `version`  int , `width`  double \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-prod/raw/sparefoot_centershift4_units/2026-04-14/1776194037'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_centershift4_units"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_centershift4_units/2026-04-14/1776194037
id: 1714720
processed: 1

raw_data:

{
    "access_type": "string",
    "access_type_val": "string",
    "attribute01": "string",
    "attribute01_val": "string",
    "attribute02": "string",
    "attribute02_val": "string",
    "class_desc": "string",
    "climate": "string",
    "climate_val": "string",
    "created": "timestamp[ns]",
    "cs_site_id": "int64",
    "cs_unit_id": "int64",
    "depth": "double",
    "door": "string",
    "door_val": "string",
    "features": "string",
    "features_val": "string",
    "height": "double",
    "id": "int32",
    "listing_avail_id": "int32",
    "listing_avail_space_id": "int32",
    "modified": "timestamp[ns]",
    "notes": "string",
    "obj_period_uom_val": "string",
    "pcd_id": "string",
    "push_rate": "double",
    "rent_rate": "double",
    "reservation_type": "string",
    "status_val": "string",
    "unavailable_due_to_site_rules": "int16",
    "unit_group_id": "string",
    "unit_number": "string",
    "version": "int32",
    "width": "double"
}

schema_attributes:

{
    "access_type": "string",
    "access_type_val": "string",
    "attribute01": "string",
    "attribute01_val": "string",
    "attribute02": "string",
    "attribute02_val": "string",
    "class_desc": "string",
    "climate": "string",
    "climate_val": "string",
    "created": "timestamp",
    "cs_site_id": "bigint",
    "cs_unit_id": "bigint",
    "depth": "double",
    "door": "string",
    "door_val": "string",
    "features": "string",
    "features_val": "string",
    "height": "double",
    "id": "int",
    "listing_avail_id": "int",
    "listing_avail_space_id": "int",
    "modified": "timestamp",
    "notes": "string",
    "obj_period_uom_val": "string",
    "pcd_id": "string",
    "push_rate": "double",
    "rent_rate": "double",
    "reservation_type": "string",
    "status_val": "string",
    "unavailable_due_to_site_rules": "smallint",
    "unit_group_id": "string",
    "unit_number": "string",
    "version": "int",
    "width": "double"
}

schema_name_id: 1133
schema_scan_id: 162026099
updated: 2026-04-14 14:14:14

Version 1714576

created: 2026-04-14 09:04:13

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_centershift4_units`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_centershift4_units`\n(\n `access_type`  string , `access_type_val`  string , `attribute01`  string , `attribute01_val`  string , `attribute02`  string , `attribute02_val`  string , `class_desc`  string , `climate`  string , `climate_val`  string , `created`  timestamp , `cs_site_id`  bigint , `cs_unit_id`  bigint , `depth`  double , `door`  string , `door_val`  string , `features`  string , `features_val`  string , `height`  double , `id`  int , `listing_avail_id`  int , `listing_avail_space_id`  int , `modified`  timestamp , `notes`  string , `obj_period_uom_val`  string , `pcd_id`  string , `push_rate`  double , `rent_rate`  double , `reservation_type`  string , `status_val`  string , `unavailable_due_to_site_rules`  smallint , `unit_group_id`  string , `unit_number`  string , `version`  int , `width`  double \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-prod/raw/sparefoot_centershift4_units/2026-04-14/1776175444'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_centershift4_units"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_centershift4_units/2026-04-14/1776175444
id: 1714576
processed: 1

raw_data:

{
    "access_type": "string",
    "access_type_val": "string",
    "attribute01": "string",
    "attribute01_val": "string",
    "attribute02": "string",
    "attribute02_val": "string",
    "class_desc": "string",
    "climate": "string",
    "climate_val": "string",
    "created": "timestamp[ns]",
    "cs_site_id": "int64",
    "cs_unit_id": "int64",
    "depth": "double",
    "door": "string",
    "door_val": "string",
    "features": "string",
    "features_val": "string",
    "height": "double",
    "id": "int32",
    "listing_avail_id": "int32",
    "listing_avail_space_id": "int32",
    "modified": "timestamp[ns]",
    "notes": "string",
    "obj_period_uom_val": "string",
    "pcd_id": "string",
    "push_rate": "double",
    "rent_rate": "double",
    "reservation_type": "string",
    "status_val": "string",
    "unavailable_due_to_site_rules": "int16",
    "unit_group_id": "string",
    "unit_number": "string",
    "version": "int32",
    "width": "double"
}

schema_attributes:

{
    "access_type": "string",
    "access_type_val": "string",
    "attribute01": "string",
    "attribute01_val": "string",
    "attribute02": "string",
    "attribute02_val": "string",
    "class_desc": "string",
    "climate": "string",
    "climate_val": "string",
    "created": "timestamp",
    "cs_site_id": "bigint",
    "cs_unit_id": "bigint",
    "depth": "double",
    "door": "string",
    "door_val": "string",
    "features": "string",
    "features_val": "string",
    "height": "double",
    "id": "int",
    "listing_avail_id": "int",
    "listing_avail_space_id": "int",
    "modified": "timestamp",
    "notes": "string",
    "obj_period_uom_val": "string",
    "pcd_id": "string",
    "push_rate": "double",
    "rent_rate": "double",
    "reservation_type": "string",
    "status_val": "string",
    "unavailable_due_to_site_rules": "smallint",
    "unit_group_id": "string",
    "unit_number": "string",
    "version": "int",
    "width": "double"
}

schema_name_id: 1133
schema_scan_id: 162010822
updated: 2026-04-14 09:04:27

Version 1713804

created: 2026-04-14 00:09:41

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_centershift4_units`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_centershift4_units`\n(\n `access_type`  string , `access_type_val`  string , `attribute01`  string , `attribute01_val`  string , `attribute02`  string , `attribute02_val`  string , `class_desc`  string , `climate`  string , `climate_val`  string , `created`  timestamp , `cs_site_id`  bigint , `cs_unit_id`  bigint , `depth`  double , `door`  string , `door_val`  string , `features`  string , `features_val`  string , `height`  double , `id`  int , `listing_avail_id`  int , `listing_avail_space_id`  int , `modified`  timestamp , `notes`  string , `obj_period_uom_val`  string , `pcd_id`  string , `push_rate`  double , `rent_rate`  double , `reservation_type`  string , `status_val`  string , `unavailable_due_to_site_rules`  smallint , `unit_group_id`  string , `unit_number`  string , `version`  int , `width`  double \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-prod/raw/sparefoot_centershift4_units/2026-04-14/1776143368'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_centershift4_units"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_centershift4_units/2026-04-14/1776143368
id: 1713804
processed: 1

raw_data:

{
    "access_type": "string",
    "access_type_val": "string",
    "attribute01": "string",
    "attribute01_val": "string",
    "attribute02": "string",
    "attribute02_val": "string",
    "class_desc": "string",
    "climate": "string",
    "climate_val": "string",
    "created": "timestamp[ns]",
    "cs_site_id": "int64",
    "cs_unit_id": "int64",
    "depth": "double",
    "door": "string",
    "door_val": "string",
    "features": "string",
    "features_val": "string",
    "height": "double",
    "id": "int32",
    "listing_avail_id": "int32",
    "listing_avail_space_id": "int32",
    "modified": "timestamp[ns]",
    "notes": "string",
    "obj_period_uom_val": "string",
    "pcd_id": "string",
    "push_rate": "double",
    "rent_rate": "double",
    "reservation_type": "string",
    "status_val": "string",
    "unavailable_due_to_site_rules": "int16",
    "unit_group_id": "string",
    "unit_number": "string",
    "version": "int32",
    "width": "double"
}

schema_attributes:

{
    "access_type": "string",
    "access_type_val": "string",
    "attribute01": "string",
    "attribute01_val": "string",
    "attribute02": "string",
    "attribute02_val": "string",
    "class_desc": "string",
    "climate": "string",
    "climate_val": "string",
    "created": "timestamp",
    "cs_site_id": "bigint",
    "cs_unit_id": "bigint",
    "depth": "double",
    "door": "string",
    "door_val": "string",
    "features": "string",
    "features_val": "string",
    "height": "double",
    "id": "int",
    "listing_avail_id": "int",
    "listing_avail_space_id": "int",
    "modified": "timestamp",
    "notes": "string",
    "obj_period_uom_val": "string",
    "pcd_id": "string",
    "push_rate": "double",
    "rent_rate": "double",
    "reservation_type": "string",
    "status_val": "string",
    "unavailable_due_to_site_rules": "smallint",
    "unit_group_id": "string",
    "unit_number": "string",
    "version": "int",
    "width": "double"
}

schema_name_id: 1133
schema_scan_id: 161996338
updated: 2026-04-14 00:09:53

Schema Scans: 15

Last at 2026-04-17 14:17:14

Scan 162194045

duration: 0:00:12.426513

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 162194045

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_centershift4_units/2026-04-17/1776453416",
        "key": "raw/sparefoot_centershift4_units/2026-04-17/1776453416/centershift4_units_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_centershift4_units",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 6028548014256890012,
        "service_name": "sparefoot",
        "span_id": 8275419901146849520,
        "trace_id": 6028548014256890012
    }
}

running: False
schema_name_id: 1133
start_time: 2026-04-17 14:17:14
success: True
trace_id: 6028548014256890012

Scan 162178288

duration: 0:00:15.068112

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 162178288

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_centershift4_units/2026-04-17/1776435553",
        "key": "raw/sparefoot_centershift4_units/2026-04-17/1776435553/centershift4_units_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_centershift4_units",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 4904444343016743499,
        "service_name": "sparefoot",
        "span_id": 14024374345805502385,
        "trace_id": 4904444343016743499
    }
}

running: False
schema_name_id: 1133
start_time: 2026-04-17 09:19:17
success: True
trace_id: 4904444343016743499

Scan 162163634

duration: 0:00:12.742283

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 162163634

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_centershift4_units/2026-04-17/1776402833",
        "key": "raw/sparefoot_centershift4_units/2026-04-17/1776402833/centershift4_units_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_centershift4_units",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 15368593527729193928,
        "service_name": "sparefoot",
        "span_id": 15116347069328271302,
        "trace_id": 15368593527729193928
    }
}

running: False
schema_name_id: 1133
start_time: 2026-04-17 00:13:59
success: True
trace_id: 15368593527729193928

Scan 162156247

duration: 0:00:12.506311

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 162156247

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_centershift4_units/2026-04-16/1776389976",
        "key": "raw/sparefoot_centershift4_units/2026-04-16/1776389976/centershift4_units_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_centershift4_units",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 3487035828557100532,
        "service_name": "sparefoot",
        "span_id": 17762413480744104036,
        "trace_id": 3487035828557100532
    }
}

running: False
schema_name_id: 1133
start_time: 2026-04-16 20:39:45
success: True
trace_id: 3487035828557100532

Scan 162138080

duration: 0:00:12.331788

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 162138080

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_centershift4_units/2026-04-16/1776366990",
        "key": "raw/sparefoot_centershift4_units/2026-04-16/1776366990/centershift4_units_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_centershift4_units",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 4169993264730157971,
        "service_name": "sparefoot",
        "span_id": 17426052203869222358,
        "trace_id": 4169993264730157971
    }
}

running: False
schema_name_id: 1133
start_time: 2026-04-16 14:16:33
success: True
trace_id: 4169993264730157971

Scan 162122530

duration: 0:00:12.663111

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 162122530

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_centershift4_units/2026-04-16/1776348851",
        "key": "raw/sparefoot_centershift4_units/2026-04-16/1776348851/centershift4_units_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_centershift4_units",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 1607008754310931849,
        "service_name": "sparefoot",
        "span_id": 1268860409725433279,
        "trace_id": 1607008754310931849
    }
}

running: False
schema_name_id: 1133
start_time: 2026-04-16 09:14:23
success: True
trace_id: 1607008754310931849

Scan 162107826

duration: 0:00:12.361793

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 162107826

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_centershift4_units/2026-04-16/1776316733",
        "key": "raw/sparefoot_centershift4_units/2026-04-16/1776316733/centershift4_units_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_centershift4_units",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 2221984359830734856,
        "service_name": "sparefoot",
        "span_id": 8773830006529719639,
        "trace_id": 2221984359830734856
    }
}

running: False
schema_name_id: 1133
start_time: 2026-04-16 00:18:57
success: True
trace_id: 2221984359830734856

Scan 162100363

duration: 0:00:12.511470

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 162100363

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_centershift4_units/2026-04-15/1776302954",
        "key": "raw/sparefoot_centershift4_units/2026-04-15/1776302954/centershift4_units_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_centershift4_units",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 9236516322032821607,
        "service_name": "sparefoot",
        "span_id": 7489205809975720875,
        "trace_id": 9236516322032821607
    }
}

running: False
schema_name_id: 1133
start_time: 2026-04-15 20:29:19
success: True
trace_id: 9236516322032821607

Scan 162081683

duration: 0:00:15.474235

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 162081683

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_centershift4_units/2026-04-15/1776280345",
        "key": "raw/sparefoot_centershift4_units/2026-04-15/1776280345/centershift4_units_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_centershift4_units",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 5888237043374539783,
        "service_name": "sparefoot",
        "span_id": 11853712286967170402,
        "trace_id": 5888237043374539783
    }
}

running: False
schema_name_id: 1133
start_time: 2026-04-15 14:12:39
success: True
trace_id: 5888237043374539783

Scan 162064468

duration: 0:00:15.206011

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 162064468

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_centershift4_units/2026-04-15/1776260409",
        "key": "raw/sparefoot_centershift4_units/2026-04-15/1776260409/centershift4_units_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_centershift4_units",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 17192298291351852590,
        "service_name": "sparefoot",
        "span_id": 17362922016795669663,
        "trace_id": 17192298291351852590
    }
}

running: False
schema_name_id: 1133
start_time: 2026-04-15 08:41:32
success: True
trace_id: 17192298291351852590

Scan 162051965

duration: 0:00:12.377946

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 162051965

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_centershift4_units/2026-04-15/1776230024",
        "key": "raw/sparefoot_centershift4_units/2026-04-15/1776230024/centershift4_units_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_centershift4_units",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 13959503278393954697,
        "service_name": "sparefoot",
        "span_id": 5160675592298606222,
        "trace_id": 13959503278393954697
    }
}

running: False
schema_name_id: 1133
start_time: 2026-04-15 00:13:47
success: True
trace_id: 13959503278393954697

Scan 162044339

duration: 0:00:15.193130

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 162044339

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_centershift4_units/2026-04-14/1776216378",
        "key": "raw/sparefoot_centershift4_units/2026-04-14/1776216378/centershift4_units_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_centershift4_units",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 13578666561645011036,
        "service_name": "sparefoot",
        "span_id": 14651762605532069637,
        "trace_id": 13578666561645011036
    }
}

running: False
schema_name_id: 1133
start_time: 2026-04-14 20:26:22
success: True
trace_id: 13578666561645011036

Scan 162026099

duration: 0:00:12.610245

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 162026099

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_centershift4_units/2026-04-14/1776194037",
        "key": "raw/sparefoot_centershift4_units/2026-04-14/1776194037/centershift4_units_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_centershift4_units",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 7134061588201054388,
        "service_name": "sparefoot",
        "span_id": 1081309738909425534,
        "trace_id": 7134061588201054388
    }
}

running: False
schema_name_id: 1133
start_time: 2026-04-14 14:14:01
success: True
trace_id: 7134061588201054388

Scan 162010822

duration: 0:00:15.025950

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 162010822

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_centershift4_units/2026-04-14/1776175444",
        "key": "raw/sparefoot_centershift4_units/2026-04-14/1776175444/centershift4_units_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_centershift4_units",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 14664584712752066305,
        "service_name": "sparefoot",
        "span_id": 10612378206504450772,
        "trace_id": 14664584712752066305
    }
}

running: False
schema_name_id: 1133
start_time: 2026-04-14 09:04:12
success: True
trace_id: 14664584712752066305

Scan 161996338

duration: 0:00:12.795485

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 161996338

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_centershift4_units/2026-04-14/1776143368",
        "key": "raw/sparefoot_centershift4_units/2026-04-14/1776143368/centershift4_units_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_centershift4_units",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 14955833989525695082,
        "service_name": "sparefoot",
        "span_id": 10292750633262184621,
        "trace_id": 14955833989525695082
    }
}

running: False
schema_name_id: 1133
start_time: 2026-04-14 00:09:40
success: True
trace_id: 14955833989525695082

Partitions:

count: 0
ddl: None
name: None
state:
```
[]
```
type: None

Schema:

attributes:

{
    "access_type": "string",
    "access_type_val": "string",
    "attribute01": "string",
    "attribute01_val": "string",
    "attribute02": "string",
    "attribute02_val": "string",
    "class_desc": "string",
    "climate": "string",
    "climate_val": "string",
    "created": "timestamp",
    "cs_site_id": "bigint",
    "cs_unit_id": "bigint",
    "depth": "double",
    "door": "string",
    "door_val": "string",
    "features": "string",
    "features_val": "string",
    "height": "double",
    "id": "int",
    "listing_avail_id": "int",
    "listing_avail_space_id": "int",
    "modified": "timestamp",
    "notes": "string",
    "obj_period_uom_val": "string",
    "pcd_id": "string",
    "push_rate": "double",
    "rent_rate": "double",
    "reservation_type": "string",
    "status_val": "string",
    "unavailable_due_to_site_rules": "smallint",
    "unit_group_id": "string",
    "unit_number": "string",
    "version": "int",
    "width": "double"
}

created: 2026-04-17 14:17:15

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_centershift4_units`\n(\n `access_type`  string , `access_type_val`  string , `attribute01`  string , `attribute01_val`  string , `attribute02`  string , `attribute02_val`  string , `class_desc`  string , `climate`  string , `climate_val`  string , `created`  timestamp , `cs_site_id`  bigint , `cs_unit_id`  bigint , `depth`  double , `door`  string , `door_val`  string , `features`  string , `features_val`  string , `height`  double , `id`  int , `listing_avail_id`  int , `listing_avail_space_id`  int , `modified`  timestamp , `notes`  string , `obj_period_uom_val`  string , `pcd_id`  string , `push_rate`  double , `rent_rate`  double , `reservation_type`  string , `status_val`  string , `unavailable_due_to_site_rules`  smallint , `unit_group_id`  string , `unit_number`  string , `version`  int , `width`  double \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-prod/raw/sparefoot_centershift4_units/2026-04-17/1776453416'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_centershift4_units`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_centershift4_units"
}

Server:

hostname: schemamanager-5475496c57-7dpqb
name: schema_manager
process_start: 2026-01-09 11:27:47
sf_env: prod
version: 2112174301

Raw:

{
    "name": {
        "created": "2022-08-18 17:24:52",
        "disabled": false,
        "format": "raw",
        "id": 1133,
        "is_partitioned": false,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_prod_rds",
            "table": "sparefoot_sparefoot_centershift4_units"
        },
        "type": "rds"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "access_type": "string",
            "access_type_val": "string",
            "attribute01": "string",
            "attribute01_val": "string",
            "attribute02": "string",
            "attribute02_val": "string",
            "class_desc": "string",
            "climate": "string",
            "climate_val": "string",
            "created": "timestamp",
            "cs_site_id": "bigint",
            "cs_unit_id": "bigint",
            "depth": "double",
            "door": "string",
            "door_val": "string",
            "features": "string",
            "features_val": "string",
            "height": "double",
            "id": "int",
            "listing_avail_id": "int",
            "listing_avail_space_id": "int",
            "modified": "timestamp",
            "notes": "string",
            "obj_period_uom_val": "string",
            "pcd_id": "string",
            "push_rate": "double",
            "rent_rate": "double",
            "reservation_type": "string",
            "status_val": "string",
            "unavailable_due_to_site_rules": "smallint",
            "unit_group_id": "string",
            "unit_number": "string",
            "version": "int",
            "width": "double"
        },
        "created": "2026-04-17 14:17:15",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_centershift4_units`\n(\n `access_type`  string , `access_type_val`  string , `attribute01`  string , `attribute01_val`  string , `attribute02`  string , `attribute02_val`  string , `class_desc`  string , `climate`  string , `climate_val`  string , `created`  timestamp , `cs_site_id`  bigint , `cs_unit_id`  bigint , `depth`  double , `door`  string , `door_val`  string , `features`  string , `features_val`  string , `height`  double , `id`  int , `listing_avail_id`  int , `listing_avail_space_id`  int , `modified`  timestamp , `notes`  string , `obj_period_uom_val`  string , `pcd_id`  string , `push_rate`  double , `rent_rate`  double , `reservation_type`  string , `status_val`  string , `unavailable_due_to_site_rules`  smallint , `unit_group_id`  string , `unit_number`  string , `version`  int , `width`  double \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-prod/raw/sparefoot_centershift4_units/2026-04-17/1776453416'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_centershift4_units`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_centershift4_units"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}