Schema Info

Schema Name: sfdl_stage_rds.sparefoot_sparefoot_centershift4_units

created: 2022-08-12 10:30:04
disabled: False
format: raw
id: 1358
is_partitioned: False
is_schema_datatyped: False

name:

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

type: rds

Schema Versions: 15

Version 906536

created: 2026-04-17 00:15:41

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_centershift4_units`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_centershift4_units/2026-04-17/1776402935'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_centershift4_units"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_centershift4_units/2026-04-17/1776402935
id: 906536
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: 1358
schema_scan_id: 6415103
updated: 2026-04-17 00:15:52

Version 906358

created: 2026-04-16 00:12:43

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_centershift4_units`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_centershift4_units/2026-04-16/1776316349'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_centershift4_units"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_centershift4_units/2026-04-16/1776316349
id: 906358
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: 1358
schema_scan_id: 6414595
updated: 2026-04-16 00:12:57

Version 906102

created: 2026-04-15 00:06:34

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_centershift4_units`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_centershift4_units/2026-04-15/1776229587'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_centershift4_units"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_centershift4_units/2026-04-15/1776229587
id: 906102
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: 1358
schema_scan_id: 6414060
updated: 2026-04-15 00:06:46

Version 905885

created: 2026-04-14 00:08:04

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_centershift4_units`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_centershift4_units/2026-04-14/1776143279'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_centershift4_units"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_centershift4_units/2026-04-14/1776143279
id: 905885
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: 1358
schema_scan_id: 6413549
updated: 2026-04-14 00:08:18

Version 905701

created: 2026-04-13 00:17:27

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_centershift4_units`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_centershift4_units/2026-04-13/1776057442'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_centershift4_units"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_centershift4_units/2026-04-13/1776057442
id: 905701
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: 1358
schema_scan_id: 6413036
updated: 2026-04-13 00:17:38

Version 905514

created: 2026-04-12 00:15:05

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_centershift4_units`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_centershift4_units/2026-04-12/1775970900'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_centershift4_units"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_centershift4_units/2026-04-12/1775970900
id: 905514
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: 1358
schema_scan_id: 6412666
updated: 2026-04-12 00:15:16

Version 905299

created: 2026-04-11 00:12:17

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_centershift4_units`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_centershift4_units/2026-04-11/1775884332'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_centershift4_units"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_centershift4_units/2026-04-11/1775884332
id: 905299
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: 1358
schema_scan_id: 6412271
updated: 2026-04-11 00:12:31

Version 905075

created: 2026-04-10 00:09:34

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_centershift4_units`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_centershift4_units/2026-04-10/1775797769'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_centershift4_units"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_centershift4_units/2026-04-10/1775797769
id: 905075
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: 1358
schema_scan_id: 6411756
updated: 2026-04-10 00:09:48

Version 904844

created: 2026-04-09 00:11:36

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_centershift4_units`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_centershift4_units/2026-04-09/1775711491'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_centershift4_units"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_centershift4_units/2026-04-09/1775711491
id: 904844
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: 1358
schema_scan_id: 6411229
updated: 2026-04-09 00:11:50

Version 904649

created: 2026-04-08 00:12:22

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_centershift4_units`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_centershift4_units/2026-04-08/1775625120'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_centershift4_units"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_centershift4_units/2026-04-08/1775625120
id: 904649
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: 1358
schema_scan_id: 6410746
updated: 2026-04-08 00:12:33

Version 904414

created: 2026-04-07 00:07:54

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_centershift4_units`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_centershift4_units/2026-04-07/1775538463'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_centershift4_units"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_centershift4_units/2026-04-07/1775538463
id: 904414
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: 1358
schema_scan_id: 6410216
updated: 2026-04-07 00:08:08

Version 904198

created: 2026-04-06 00:05:46

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_centershift4_units`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_centershift4_units/2026-04-06/1775451928'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_centershift4_units"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_centershift4_units/2026-04-06/1775451928
id: 904198
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: 1358
schema_scan_id: 6409670
updated: 2026-04-06 00:06:00

Version 904028

created: 2026-04-05 00:10:27

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_centershift4_units`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_centershift4_units/2026-04-05/1775365810'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_centershift4_units"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_centershift4_units/2026-04-05/1775365810
id: 904028
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: 1358
schema_scan_id: 6409323
updated: 2026-04-05 00:10:41

Version 903844

created: 2026-04-04 00:13:04

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_centershift4_units`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_centershift4_units/2026-04-04/1775279567'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_centershift4_units"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_centershift4_units/2026-04-04/1775279567
id: 903844
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: 1358
schema_scan_id: 6408960
updated: 2026-04-04 00:13:18

Version 903589

created: 2026-04-03 00:07:53

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_centershift4_units`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_centershift4_units/2026-04-03/1775192849'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_centershift4_units"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_centershift4_units/2026-04-03/1775192849
id: 903589
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: 1358
schema_scan_id: 6408422
updated: 2026-04-03 00:08:06

Schema Scans: 15

Last at 2026-04-17 00:15:39

Scan 6415103

duration: 0:00:12.452042

exit_message:

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

id: 6415103

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_centershift4_units/2026-04-17/1776402935",
        "key": "raw/sparefoot_centershift4_units/2026-04-17/1776402935/centershift4_units_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_centershift4_units",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 6045051384871420216,
        "service_name": "sparefoot",
        "span_id": 14491813207264040999,
        "trace_id": 6045051384871420216
    }
}

running: False
schema_name_id: 1358
start_time: 2026-04-17 00:15:39
success: True
trace_id: 6045051384871420216

Scan 6414595

duration: 0:00:15.115722

exit_message:

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

id: 6414595

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_centershift4_units/2026-04-16/1776316349",
        "key": "raw/sparefoot_centershift4_units/2026-04-16/1776316349/centershift4_units_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_centershift4_units",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 13635134484048743853,
        "service_name": "sparefoot",
        "span_id": 6150712055878287258,
        "trace_id": 13635134484048743853
    }
}

running: False
schema_name_id: 1358
start_time: 2026-04-16 00:12:42
success: True
trace_id: 13635134484048743853

Scan 6414060

duration: 0:00:12.678691

exit_message:

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

id: 6414060

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_centershift4_units/2026-04-15/1776229587",
        "key": "raw/sparefoot_centershift4_units/2026-04-15/1776229587/centershift4_units_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_centershift4_units",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 13241958190059928463,
        "service_name": "sparefoot",
        "span_id": 14106410507129540817,
        "trace_id": 13241958190059928463
    }
}

running: False
schema_name_id: 1358
start_time: 2026-04-15 00:06:33
success: True
trace_id: 13241958190059928463

Scan 6413549

duration: 0:00:15.289928

exit_message:

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

id: 6413549

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_centershift4_units/2026-04-14/1776143279",
        "key": "raw/sparefoot_centershift4_units/2026-04-14/1776143279/centershift4_units_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_centershift4_units",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 17924836857447151905,
        "service_name": "sparefoot",
        "span_id": 16012621569048034682,
        "trace_id": 17924836857447151905
    }
}

running: False
schema_name_id: 1358
start_time: 2026-04-14 00:08:03
success: True
trace_id: 17924836857447151905

Scan 6413036

duration: 0:00:12.628534

exit_message:

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

id: 6413036

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_centershift4_units/2026-04-13/1776057442",
        "key": "raw/sparefoot_centershift4_units/2026-04-13/1776057442/centershift4_units_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_centershift4_units",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 956316507491481091,
        "service_name": "sparefoot",
        "span_id": 16720963905958505797,
        "trace_id": 956316507491481091
    }
}

running: False
schema_name_id: 1358
start_time: 2026-04-13 00:17:26
success: True
trace_id: 956316507491481091

Scan 6412666

duration: 0:00:12.628414

exit_message:

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

id: 6412666

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_centershift4_units/2026-04-12/1775970900",
        "key": "raw/sparefoot_centershift4_units/2026-04-12/1775970900/centershift4_units_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_centershift4_units",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 15095961313351047271,
        "service_name": "sparefoot",
        "span_id": 14831664336471624221,
        "trace_id": 15095961313351047271
    }
}

running: False
schema_name_id: 1358
start_time: 2026-04-12 00:15:04
success: True
trace_id: 15095961313351047271

Scan 6412271

duration: 0:00:14.989281

exit_message:

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

id: 6412271

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_centershift4_units/2026-04-11/1775884332",
        "key": "raw/sparefoot_centershift4_units/2026-04-11/1775884332/centershift4_units_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_centershift4_units",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 8106147916704379076,
        "service_name": "sparefoot",
        "span_id": 12835281343065750216,
        "trace_id": 8106147916704379076
    }
}

running: False
schema_name_id: 1358
start_time: 2026-04-11 00:12:16
success: True
trace_id: 8106147916704379076

Scan 6411756

duration: 0:00:14.935368

exit_message:

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

id: 6411756

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_centershift4_units/2026-04-10/1775797769",
        "key": "raw/sparefoot_centershift4_units/2026-04-10/1775797769/centershift4_units_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_centershift4_units",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 7407469293434546189,
        "service_name": "sparefoot",
        "span_id": 12421846641567922503,
        "trace_id": 7407469293434546189
    }
}

running: False
schema_name_id: 1358
start_time: 2026-04-10 00:09:33
success: True
trace_id: 7407469293434546189

Scan 6411229

duration: 0:00:15.279160

exit_message:

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

id: 6411229

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_centershift4_units/2026-04-09/1775711491",
        "key": "raw/sparefoot_centershift4_units/2026-04-09/1775711491/centershift4_units_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_centershift4_units",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 17668409007681090536,
        "service_name": "sparefoot",
        "span_id": 4660911389593319040,
        "trace_id": 17668409007681090536
    }
}

running: False
schema_name_id: 1358
start_time: 2026-04-09 00:11:35
success: True
trace_id: 17668409007681090536

Scan 6410746

duration: 0:00:12.685512

exit_message:

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

id: 6410746

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_centershift4_units/2026-04-08/1775625120",
        "key": "raw/sparefoot_centershift4_units/2026-04-08/1775625120/centershift4_units_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_centershift4_units",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 14397987080183262532,
        "service_name": "sparefoot",
        "span_id": 14595052757472688228,
        "trace_id": 14397987080183262532
    }
}

running: False
schema_name_id: 1358
start_time: 2026-04-08 00:12:21
success: True
trace_id: 14397987080183262532

Scan 6410216

duration: 0:00:14.930060

exit_message:

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

id: 6410216

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_centershift4_units/2026-04-07/1775538463",
        "key": "raw/sparefoot_centershift4_units/2026-04-07/1775538463/centershift4_units_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_centershift4_units",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 4761687274621874023,
        "service_name": "sparefoot",
        "span_id": 10587567261062173020,
        "trace_id": 4761687274621874023
    }
}

running: False
schema_name_id: 1358
start_time: 2026-04-07 00:07:53
success: True
trace_id: 4761687274621874023

Scan 6409670

duration: 0:00:15.012169

exit_message:

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

id: 6409670

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_centershift4_units/2026-04-06/1775451928",
        "key": "raw/sparefoot_centershift4_units/2026-04-06/1775451928/centershift4_units_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_centershift4_units",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 15051135696519035122,
        "service_name": "sparefoot",
        "span_id": 16421006574810749221,
        "trace_id": 15051135696519035122
    }
}

running: False
schema_name_id: 1358
start_time: 2026-04-06 00:05:45
success: True
trace_id: 15051135696519035122

Scan 6409323

duration: 0:00:14.995293

exit_message:

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

id: 6409323

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_centershift4_units/2026-04-05/1775365810",
        "key": "raw/sparefoot_centershift4_units/2026-04-05/1775365810/centershift4_units_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_centershift4_units",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 307322907025483058,
        "service_name": "sparefoot",
        "span_id": 12800080294013504089,
        "trace_id": 307322907025483058
    }
}

running: False
schema_name_id: 1358
start_time: 2026-04-05 00:10:26
success: True
trace_id: 307322907025483058

Scan 6408960

duration: 0:00:15.172732

exit_message:

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

id: 6408960

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_centershift4_units/2026-04-04/1775279567",
        "key": "raw/sparefoot_centershift4_units/2026-04-04/1775279567/centershift4_units_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_centershift4_units",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 15830871532736522759,
        "service_name": "sparefoot",
        "span_id": 3560441284462485353,
        "trace_id": 15830871532736522759
    }
}

running: False
schema_name_id: 1358
start_time: 2026-04-04 00:13:02
success: True
trace_id: 15830871532736522759

Scan 6408422

duration: 0:00:15.161965

exit_message:

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

id: 6408422

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_centershift4_units/2026-04-03/1775192849",
        "key": "raw/sparefoot_centershift4_units/2026-04-03/1775192849/centershift4_units_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_centershift4_units",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 13156944259680242014,
        "service_name": "sparefoot",
        "span_id": 13717669775922003491,
        "trace_id": 13156944259680242014
    }
}

running: False
schema_name_id: 1358
start_time: 2026-04-03 00:07:51
success: True
trace_id: 13156944259680242014

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 00:15:41

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_centershift4_units/2026-04-17/1776402935'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_centershift4_units`",
    "repair_table": "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_centershift4_units"
}

Server:

hostname: schemamanager-5c55c886bf-h2ts4
name: schema_manager
process_start: 2025-10-21 13:03:27
sf_env: stage
version: 2112174301

Raw:

{
    "name": {
        "created": "2022-08-12 10:30:04",
        "disabled": false,
        "format": "raw",
        "id": 1358,
        "is_partitioned": false,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_stage_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 00:15:41",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_centershift4_units/2026-04-17/1776402935'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_centershift4_units`",
            "repair_table": "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_centershift4_units"
        }
    },
    "server": {
        "hostname": "schemamanager-5c55c886bf-h2ts4",
        "name": "schema_manager",
        "process_start": "2025-10-21 13:03:27",
        "sf_env": "stage",
        "version": "2112174301"
    }
}