Schema Info

Schema Name: sfdl_stage_rds.sparefoot_sparefoot_sitelink_full_units

created: 2022-08-12 10:23:18
disabled: False
format: raw
id: 1345
is_partitioned: False
is_schema_datatyped: False

name:

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

type: rds

Schema Versions: 15

Version 906565

created: 2026-04-17 00:20:38

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_sitelink_full_units`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_sitelink_full_units`\n(\n `alarm`  smallint , `board_rate`  double , `climate_controlled`  smallint , `concession_id`  int , `corporate`  smallint , `floor`  int , `inside`  smallint , `lease_num`  int , `length`  double , `listing_avail_id`  int , `listing_avail_space_id`  int , `power`  smallint , `push_rate`  double , `rentable`  smallint , `rented`  smallint , `std_rate`  double , `type_name`  string , `unit_id`  int , `unit_name`  string , `unit_type_id`  int , `waiting_list_reserved`  smallint , `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_sitelink_full_units/2026-04-17/1776403224'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_sitelink_full_units"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_sitelink_full_units/2026-04-17/1776403224
id: 906565
processed: 1

raw_data:

{
    "alarm": "int16",
    "board_rate": "double",
    "climate_controlled": "int16",
    "concession_id": "int32",
    "corporate": "int16",
    "floor": "int32",
    "inside": "int16",
    "lease_num": "int32",
    "length": "double",
    "listing_avail_id": "int32",
    "listing_avail_space_id": "int32",
    "power": "int16",
    "push_rate": "double",
    "rentable": "int16",
    "rented": "int16",
    "std_rate": "double",
    "type_name": "string",
    "unit_id": "int32",
    "unit_name": "string",
    "unit_type_id": "int32",
    "waiting_list_reserved": "int16",
    "width": "double"
}

schema_attributes:

{
    "alarm": "smallint",
    "board_rate": "double",
    "climate_controlled": "smallint",
    "concession_id": "int",
    "corporate": "smallint",
    "floor": "int",
    "inside": "smallint",
    "lease_num": "int",
    "length": "double",
    "listing_avail_id": "int",
    "listing_avail_space_id": "int",
    "power": "smallint",
    "push_rate": "double",
    "rentable": "smallint",
    "rented": "smallint",
    "std_rate": "double",
    "type_name": "string",
    "unit_id": "int",
    "unit_name": "string",
    "unit_type_id": "int",
    "waiting_list_reserved": "smallint",
    "width": "double"
}

schema_name_id: 1345
schema_scan_id: 6415133
updated: 2026-04-17 00:20:52

Version 906366

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_sitelink_full_units`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_sitelink_full_units`\n(\n `alarm`  smallint , `board_rate`  double , `climate_controlled`  smallint , `concession_id`  int , `corporate`  smallint , `floor`  int , `inside`  smallint , `lease_num`  int , `length`  double , `listing_avail_id`  int , `listing_avail_space_id`  int , `power`  smallint , `push_rate`  double , `rentable`  smallint , `rented`  smallint , `std_rate`  double , `type_name`  string , `unit_id`  int , `unit_name`  string , `unit_type_id`  int , `waiting_list_reserved`  smallint , `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_sitelink_full_units/2026-04-16/1776316446'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_sitelink_full_units"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_sitelink_full_units/2026-04-16/1776316446
id: 906366
processed: 1

raw_data:

{
    "alarm": "int16",
    "board_rate": "double",
    "climate_controlled": "int16",
    "concession_id": "int32",
    "corporate": "int16",
    "floor": "int32",
    "inside": "int16",
    "lease_num": "int32",
    "length": "double",
    "listing_avail_id": "int32",
    "listing_avail_space_id": "int32",
    "power": "int16",
    "push_rate": "double",
    "rentable": "int16",
    "rented": "int16",
    "std_rate": "double",
    "type_name": "string",
    "unit_id": "int32",
    "unit_name": "string",
    "unit_type_id": "int32",
    "waiting_list_reserved": "int16",
    "width": "double"
}

schema_attributes:

{
    "alarm": "smallint",
    "board_rate": "double",
    "climate_controlled": "smallint",
    "concession_id": "int",
    "corporate": "smallint",
    "floor": "int",
    "inside": "smallint",
    "lease_num": "int",
    "length": "double",
    "listing_avail_id": "int",
    "listing_avail_space_id": "int",
    "power": "smallint",
    "push_rate": "double",
    "rentable": "smallint",
    "rented": "smallint",
    "std_rate": "double",
    "type_name": "string",
    "unit_id": "int",
    "unit_name": "string",
    "unit_type_id": "int",
    "waiting_list_reserved": "smallint",
    "width": "double"
}

schema_name_id: 1345
schema_scan_id: 6414603
updated: 2026-04-16 00:14:31

Version 906130

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_sitelink_full_units`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_sitelink_full_units`\n(\n `alarm`  smallint , `board_rate`  double , `climate_controlled`  smallint , `concession_id`  int , `corporate`  smallint , `floor`  int , `inside`  smallint , `lease_num`  int , `length`  double , `listing_avail_id`  int , `listing_avail_space_id`  int , `power`  smallint , `push_rate`  double , `rentable`  smallint , `rented`  smallint , `std_rate`  double , `type_name`  string , `unit_id`  int , `unit_name`  string , `unit_type_id`  int , `waiting_list_reserved`  smallint , `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_sitelink_full_units/2026-04-15/1776229922'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_sitelink_full_units"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_sitelink_full_units/2026-04-15/1776229922
id: 906130
processed: 1

raw_data:

{
    "alarm": "int16",
    "board_rate": "double",
    "climate_controlled": "int16",
    "concession_id": "int32",
    "corporate": "int16",
    "floor": "int32",
    "inside": "int16",
    "lease_num": "int32",
    "length": "double",
    "listing_avail_id": "int32",
    "listing_avail_space_id": "int32",
    "power": "int16",
    "push_rate": "double",
    "rentable": "int16",
    "rented": "int16",
    "std_rate": "double",
    "type_name": "string",
    "unit_id": "int32",
    "unit_name": "string",
    "unit_type_id": "int32",
    "waiting_list_reserved": "int16",
    "width": "double"
}

schema_attributes:

{
    "alarm": "smallint",
    "board_rate": "double",
    "climate_controlled": "smallint",
    "concession_id": "int",
    "corporate": "smallint",
    "floor": "int",
    "inside": "smallint",
    "lease_num": "int",
    "length": "double",
    "listing_avail_id": "int",
    "listing_avail_space_id": "int",
    "power": "smallint",
    "push_rate": "double",
    "rentable": "smallint",
    "rented": "smallint",
    "std_rate": "double",
    "type_name": "string",
    "unit_id": "int",
    "unit_name": "string",
    "unit_type_id": "int",
    "waiting_list_reserved": "smallint",
    "width": "double"
}

schema_name_id: 1345
schema_scan_id: 6414091
updated: 2026-04-15 00:12:28

Version 905889

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_sitelink_full_units`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_sitelink_full_units`\n(\n `alarm`  smallint , `board_rate`  double , `climate_controlled`  smallint , `concession_id`  int , `corporate`  smallint , `floor`  int , `inside`  smallint , `lease_num`  int , `length`  double , `listing_avail_id`  int , `listing_avail_space_id`  int , `power`  smallint , `push_rate`  double , `rentable`  smallint , `rented`  smallint , `std_rate`  double , `type_name`  string , `unit_id`  int , `unit_name`  string , `unit_type_id`  int , `waiting_list_reserved`  smallint , `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_sitelink_full_units/2026-04-14/1776143354'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_sitelink_full_units"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_sitelink_full_units/2026-04-14/1776143354
id: 905889
processed: 1

raw_data:

{
    "alarm": "int16",
    "board_rate": "double",
    "climate_controlled": "int16",
    "concession_id": "int32",
    "corporate": "int16",
    "floor": "int32",
    "inside": "int16",
    "lease_num": "int32",
    "length": "double",
    "listing_avail_id": "int32",
    "listing_avail_space_id": "int32",
    "power": "int16",
    "push_rate": "double",
    "rentable": "int16",
    "rented": "int16",
    "std_rate": "double",
    "type_name": "string",
    "unit_id": "int32",
    "unit_name": "string",
    "unit_type_id": "int32",
    "waiting_list_reserved": "int16",
    "width": "double"
}

schema_attributes:

{
    "alarm": "smallint",
    "board_rate": "double",
    "climate_controlled": "smallint",
    "concession_id": "int",
    "corporate": "smallint",
    "floor": "int",
    "inside": "smallint",
    "lease_num": "int",
    "length": "double",
    "listing_avail_id": "int",
    "listing_avail_space_id": "int",
    "power": "smallint",
    "push_rate": "double",
    "rentable": "smallint",
    "rented": "smallint",
    "std_rate": "double",
    "type_name": "string",
    "unit_id": "int",
    "unit_name": "string",
    "unit_type_id": "int",
    "waiting_list_reserved": "smallint",
    "width": "double"
}

schema_name_id: 1345
schema_scan_id: 6413554
updated: 2026-04-14 00:09:37

Version 905710

created: 2026-04-13 00:18:09

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_sitelink_full_units`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_sitelink_full_units`\n(\n `alarm`  smallint , `board_rate`  double , `climate_controlled`  smallint , `concession_id`  int , `corporate`  smallint , `floor`  int , `inside`  smallint , `lease_num`  int , `length`  double , `listing_avail_id`  int , `listing_avail_space_id`  int , `power`  smallint , `push_rate`  double , `rentable`  smallint , `rented`  smallint , `std_rate`  double , `type_name`  string , `unit_id`  int , `unit_name`  string , `unit_type_id`  int , `waiting_list_reserved`  smallint , `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_sitelink_full_units/2026-04-13/1776057481'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_sitelink_full_units"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_sitelink_full_units/2026-04-13/1776057481
id: 905710
processed: 1

raw_data:

{
    "alarm": "int16",
    "board_rate": "double",
    "climate_controlled": "int16",
    "concession_id": "int32",
    "corporate": "int16",
    "floor": "int32",
    "inside": "int16",
    "lease_num": "int32",
    "length": "double",
    "listing_avail_id": "int32",
    "listing_avail_space_id": "int32",
    "power": "int16",
    "push_rate": "double",
    "rentable": "int16",
    "rented": "int16",
    "std_rate": "double",
    "type_name": "string",
    "unit_id": "int32",
    "unit_name": "string",
    "unit_type_id": "int32",
    "waiting_list_reserved": "int16",
    "width": "double"
}

schema_attributes:

{
    "alarm": "smallint",
    "board_rate": "double",
    "climate_controlled": "smallint",
    "concession_id": "int",
    "corporate": "smallint",
    "floor": "int",
    "inside": "smallint",
    "lease_num": "int",
    "length": "double",
    "listing_avail_id": "int",
    "listing_avail_space_id": "int",
    "power": "smallint",
    "push_rate": "double",
    "rentable": "smallint",
    "rented": "smallint",
    "std_rate": "double",
    "type_name": "string",
    "unit_id": "int",
    "unit_name": "string",
    "unit_type_id": "int",
    "waiting_list_reserved": "smallint",
    "width": "double"
}

schema_name_id: 1345
schema_scan_id: 6413045
updated: 2026-04-13 00:18:23

Version 905513

created: 2026-04-12 00:14:40

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_sitelink_full_units`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_sitelink_full_units`\n(\n `alarm`  smallint , `board_rate`  double , `climate_controlled`  smallint , `concession_id`  int , `corporate`  smallint , `floor`  int , `inside`  smallint , `lease_num`  int , `length`  double , `listing_avail_id`  int , `listing_avail_space_id`  int , `power`  smallint , `push_rate`  double , `rentable`  smallint , `rented`  smallint , `std_rate`  double , `type_name`  string , `unit_id`  int , `unit_name`  string , `unit_type_id`  int , `waiting_list_reserved`  smallint , `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_sitelink_full_units/2026-04-12/1775970855'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_sitelink_full_units"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_sitelink_full_units/2026-04-12/1775970855
id: 905513
processed: 1

raw_data:

{
    "alarm": "int16",
    "board_rate": "double",
    "climate_controlled": "int16",
    "concession_id": "int32",
    "corporate": "int16",
    "floor": "int32",
    "inside": "int16",
    "lease_num": "int32",
    "length": "double",
    "listing_avail_id": "int32",
    "listing_avail_space_id": "int32",
    "power": "int16",
    "push_rate": "double",
    "rentable": "int16",
    "rented": "int16",
    "std_rate": "double",
    "type_name": "string",
    "unit_id": "int32",
    "unit_name": "string",
    "unit_type_id": "int32",
    "waiting_list_reserved": "int16",
    "width": "double"
}

schema_attributes:

{
    "alarm": "smallint",
    "board_rate": "double",
    "climate_controlled": "smallint",
    "concession_id": "int",
    "corporate": "smallint",
    "floor": "int",
    "inside": "smallint",
    "lease_num": "int",
    "length": "double",
    "listing_avail_id": "int",
    "listing_avail_space_id": "int",
    "power": "smallint",
    "push_rate": "double",
    "rentable": "smallint",
    "rented": "smallint",
    "std_rate": "double",
    "type_name": "string",
    "unit_id": "int",
    "unit_name": "string",
    "unit_type_id": "int",
    "waiting_list_reserved": "smallint",
    "width": "double"
}

schema_name_id: 1345
schema_scan_id: 6412665
updated: 2026-04-12 00:14:54

Version 905307

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_sitelink_full_units`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_sitelink_full_units`\n(\n `alarm`  smallint , `board_rate`  double , `climate_controlled`  smallint , `concession_id`  int , `corporate`  smallint , `floor`  int , `inside`  smallint , `lease_num`  int , `length`  double , `listing_avail_id`  int , `listing_avail_space_id`  int , `power`  smallint , `push_rate`  double , `rentable`  smallint , `rented`  smallint , `std_rate`  double , `type_name`  string , `unit_id`  int , `unit_name`  string , `unit_type_id`  int , `waiting_list_reserved`  smallint , `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_sitelink_full_units/2026-04-11/1775884383'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_sitelink_full_units"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_sitelink_full_units/2026-04-11/1775884383
id: 905307
processed: 1

raw_data:

{
    "alarm": "int16",
    "board_rate": "double",
    "climate_controlled": "int16",
    "concession_id": "int32",
    "corporate": "int16",
    "floor": "int32",
    "inside": "int16",
    "lease_num": "int32",
    "length": "double",
    "listing_avail_id": "int32",
    "listing_avail_space_id": "int32",
    "power": "int16",
    "push_rate": "double",
    "rentable": "int16",
    "rented": "int16",
    "std_rate": "double",
    "type_name": "string",
    "unit_id": "int32",
    "unit_name": "string",
    "unit_type_id": "int32",
    "waiting_list_reserved": "int16",
    "width": "double"
}

schema_attributes:

{
    "alarm": "smallint",
    "board_rate": "double",
    "climate_controlled": "smallint",
    "concession_id": "int",
    "corporate": "smallint",
    "floor": "int",
    "inside": "smallint",
    "lease_num": "int",
    "length": "double",
    "listing_avail_id": "int",
    "listing_avail_space_id": "int",
    "power": "smallint",
    "push_rate": "double",
    "rentable": "smallint",
    "rented": "smallint",
    "std_rate": "double",
    "type_name": "string",
    "unit_id": "int",
    "unit_name": "string",
    "unit_type_id": "int",
    "waiting_list_reserved": "smallint",
    "width": "double"
}

schema_name_id: 1345
schema_scan_id: 6412280
updated: 2026-04-11 00:13:20

Version 905082

created: 2026-04-10 00:11:06

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_sitelink_full_units`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_sitelink_full_units`\n(\n `alarm`  smallint , `board_rate`  double , `climate_controlled`  smallint , `concession_id`  int , `corporate`  smallint , `floor`  int , `inside`  smallint , `lease_num`  int , `length`  double , `listing_avail_id`  int , `listing_avail_space_id`  int , `power`  smallint , `push_rate`  double , `rentable`  smallint , `rented`  smallint , `std_rate`  double , `type_name`  string , `unit_id`  int , `unit_name`  string , `unit_type_id`  int , `waiting_list_reserved`  smallint , `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_sitelink_full_units/2026-04-10/1775797861'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_sitelink_full_units"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_sitelink_full_units/2026-04-10/1775797861
id: 905082
processed: 1

raw_data:

{
    "alarm": "int16",
    "board_rate": "double",
    "climate_controlled": "int16",
    "concession_id": "int32",
    "corporate": "int16",
    "floor": "int32",
    "inside": "int16",
    "lease_num": "int32",
    "length": "double",
    "listing_avail_id": "int32",
    "listing_avail_space_id": "int32",
    "power": "int16",
    "push_rate": "double",
    "rentable": "int16",
    "rented": "int16",
    "std_rate": "double",
    "type_name": "string",
    "unit_id": "int32",
    "unit_name": "string",
    "unit_type_id": "int32",
    "waiting_list_reserved": "int16",
    "width": "double"
}

schema_attributes:

{
    "alarm": "smallint",
    "board_rate": "double",
    "climate_controlled": "smallint",
    "concession_id": "int",
    "corporate": "smallint",
    "floor": "int",
    "inside": "smallint",
    "lease_num": "int",
    "length": "double",
    "listing_avail_id": "int",
    "listing_avail_space_id": "int",
    "power": "smallint",
    "push_rate": "double",
    "rentable": "smallint",
    "rented": "smallint",
    "std_rate": "double",
    "type_name": "string",
    "unit_id": "int",
    "unit_name": "string",
    "unit_type_id": "int",
    "waiting_list_reserved": "smallint",
    "width": "double"
}

schema_name_id: 1345
schema_scan_id: 6411764
updated: 2026-04-10 00:11:20

Version 904835

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_sitelink_full_units`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_sitelink_full_units`\n(\n `alarm`  smallint , `board_rate`  double , `climate_controlled`  smallint , `concession_id`  int , `corporate`  smallint , `floor`  int , `inside`  smallint , `lease_num`  int , `length`  double , `listing_avail_id`  int , `listing_avail_space_id`  int , `power`  smallint , `push_rate`  double , `rentable`  smallint , `rented`  smallint , `std_rate`  double , `type_name`  string , `unit_id`  int , `unit_name`  string , `unit_type_id`  int , `waiting_list_reserved`  smallint , `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_sitelink_full_units/2026-04-09/1775711420'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_sitelink_full_units"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_sitelink_full_units/2026-04-09/1775711420
id: 904835
processed: 1

raw_data:

{
    "alarm": "int16",
    "board_rate": "double",
    "climate_controlled": "int16",
    "concession_id": "int32",
    "corporate": "int16",
    "floor": "int32",
    "inside": "int16",
    "lease_num": "int32",
    "length": "double",
    "listing_avail_id": "int32",
    "listing_avail_space_id": "int32",
    "power": "int16",
    "push_rate": "double",
    "rentable": "int16",
    "rented": "int16",
    "std_rate": "double",
    "type_name": "string",
    "unit_id": "int32",
    "unit_name": "string",
    "unit_type_id": "int32",
    "waiting_list_reserved": "int16",
    "width": "double"
}

schema_attributes:

{
    "alarm": "smallint",
    "board_rate": "double",
    "climate_controlled": "smallint",
    "concession_id": "int",
    "corporate": "smallint",
    "floor": "int",
    "inside": "smallint",
    "lease_num": "int",
    "length": "double",
    "listing_avail_id": "int",
    "listing_avail_space_id": "int",
    "power": "smallint",
    "push_rate": "double",
    "rentable": "smallint",
    "rented": "smallint",
    "std_rate": "double",
    "type_name": "string",
    "unit_id": "int",
    "unit_name": "string",
    "unit_type_id": "int",
    "waiting_list_reserved": "smallint",
    "width": "double"
}

schema_name_id: 1345
schema_scan_id: 6411218
updated: 2026-04-09 00:10:38

Version 904654

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_sitelink_full_units`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_sitelink_full_units`\n(\n `alarm`  smallint , `board_rate`  double , `climate_controlled`  smallint , `concession_id`  int , `corporate`  smallint , `floor`  int , `inside`  smallint , `lease_num`  int , `length`  double , `listing_avail_id`  int , `listing_avail_space_id`  int , `power`  smallint , `push_rate`  double , `rentable`  smallint , `rented`  smallint , `std_rate`  double , `type_name`  string , `unit_id`  int , `unit_name`  string , `unit_type_id`  int , `waiting_list_reserved`  smallint , `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_sitelink_full_units/2026-04-08/1775625129'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_sitelink_full_units"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_sitelink_full_units/2026-04-08/1775625129
id: 904654
processed: 1

raw_data:

{
    "alarm": "int16",
    "board_rate": "double",
    "climate_controlled": "int16",
    "concession_id": "int32",
    "corporate": "int16",
    "floor": "int32",
    "inside": "int16",
    "lease_num": "int32",
    "length": "double",
    "listing_avail_id": "int32",
    "listing_avail_space_id": "int32",
    "power": "int16",
    "push_rate": "double",
    "rentable": "int16",
    "rented": "int16",
    "std_rate": "double",
    "type_name": "string",
    "unit_id": "int32",
    "unit_name": "string",
    "unit_type_id": "int32",
    "waiting_list_reserved": "int16",
    "width": "double"
}

schema_attributes:

{
    "alarm": "smallint",
    "board_rate": "double",
    "climate_controlled": "smallint",
    "concession_id": "int",
    "corporate": "smallint",
    "floor": "int",
    "inside": "smallint",
    "lease_num": "int",
    "length": "double",
    "listing_avail_id": "int",
    "listing_avail_space_id": "int",
    "power": "smallint",
    "push_rate": "double",
    "rentable": "smallint",
    "rented": "smallint",
    "std_rate": "double",
    "type_name": "string",
    "unit_id": "int",
    "unit_name": "string",
    "unit_type_id": "int",
    "waiting_list_reserved": "smallint",
    "width": "double"
}

schema_name_id: 1345
schema_scan_id: 6410751
updated: 2026-04-08 00:12:55

Version 904450

created: 2026-04-07 00:15:23

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_sitelink_full_units`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_sitelink_full_units`\n(\n `alarm`  smallint , `board_rate`  double , `climate_controlled`  smallint , `concession_id`  int , `corporate`  smallint , `floor`  int , `inside`  smallint , `lease_num`  int , `length`  double , `listing_avail_id`  int , `listing_avail_space_id`  int , `power`  smallint , `push_rate`  double , `rentable`  smallint , `rented`  smallint , `std_rate`  double , `type_name`  string , `unit_id`  int , `unit_name`  string , `unit_type_id`  int , `waiting_list_reserved`  smallint , `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_sitelink_full_units/2026-04-07/1775538892'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_sitelink_full_units"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_sitelink_full_units/2026-04-07/1775538892
id: 904450
processed: 1

raw_data:

{
    "alarm": "int16",
    "board_rate": "double",
    "climate_controlled": "int16",
    "concession_id": "int32",
    "corporate": "int16",
    "floor": "int32",
    "inside": "int16",
    "lease_num": "int32",
    "length": "double",
    "listing_avail_id": "int32",
    "listing_avail_space_id": "int32",
    "power": "int16",
    "push_rate": "double",
    "rentable": "int16",
    "rented": "int16",
    "std_rate": "double",
    "type_name": "string",
    "unit_id": "int32",
    "unit_name": "string",
    "unit_type_id": "int32",
    "waiting_list_reserved": "int16",
    "width": "double"
}

schema_attributes:

{
    "alarm": "smallint",
    "board_rate": "double",
    "climate_controlled": "smallint",
    "concession_id": "int",
    "corporate": "smallint",
    "floor": "int",
    "inside": "smallint",
    "lease_num": "int",
    "length": "double",
    "listing_avail_id": "int",
    "listing_avail_space_id": "int",
    "power": "smallint",
    "push_rate": "double",
    "rentable": "smallint",
    "rented": "smallint",
    "std_rate": "double",
    "type_name": "string",
    "unit_id": "int",
    "unit_name": "string",
    "unit_type_id": "int",
    "waiting_list_reserved": "smallint",
    "width": "double"
}

schema_name_id: 1345
schema_scan_id: 6410254
updated: 2026-04-07 00:15:37

Version 904209

created: 2026-04-06 00:06:50

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_sitelink_full_units`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_sitelink_full_units`\n(\n `alarm`  smallint , `board_rate`  double , `climate_controlled`  smallint , `concession_id`  int , `corporate`  smallint , `floor`  int , `inside`  smallint , `lease_num`  int , `length`  double , `listing_avail_id`  int , `listing_avail_space_id`  int , `power`  smallint , `push_rate`  double , `rentable`  smallint , `rented`  smallint , `std_rate`  double , `type_name`  string , `unit_id`  int , `unit_name`  string , `unit_type_id`  int , `waiting_list_reserved`  smallint , `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_sitelink_full_units/2026-04-06/1775452001'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_sitelink_full_units"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_sitelink_full_units/2026-04-06/1775452001
id: 904209
processed: 1

raw_data:

{
    "alarm": "int16",
    "board_rate": "double",
    "climate_controlled": "int16",
    "concession_id": "int32",
    "corporate": "int16",
    "floor": "int32",
    "inside": "int16",
    "lease_num": "int32",
    "length": "double",
    "listing_avail_id": "int32",
    "listing_avail_space_id": "int32",
    "power": "int16",
    "push_rate": "double",
    "rentable": "int16",
    "rented": "int16",
    "std_rate": "double",
    "type_name": "string",
    "unit_id": "int32",
    "unit_name": "string",
    "unit_type_id": "int32",
    "waiting_list_reserved": "int16",
    "width": "double"
}

schema_attributes:

{
    "alarm": "smallint",
    "board_rate": "double",
    "climate_controlled": "smallint",
    "concession_id": "int",
    "corporate": "smallint",
    "floor": "int",
    "inside": "smallint",
    "lease_num": "int",
    "length": "double",
    "listing_avail_id": "int",
    "listing_avail_space_id": "int",
    "power": "smallint",
    "push_rate": "double",
    "rentable": "smallint",
    "rented": "smallint",
    "std_rate": "double",
    "type_name": "string",
    "unit_id": "int",
    "unit_name": "string",
    "unit_type_id": "int",
    "waiting_list_reserved": "smallint",
    "width": "double"
}

schema_name_id: 1345
schema_scan_id: 6409681
updated: 2026-04-06 00:07:01

Version 904007

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_sitelink_full_units`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_sitelink_full_units`\n(\n `alarm`  smallint , `board_rate`  double , `climate_controlled`  smallint , `concession_id`  int , `corporate`  smallint , `floor`  int , `inside`  smallint , `lease_num`  int , `length`  double , `listing_avail_id`  int , `listing_avail_space_id`  int , `power`  smallint , `push_rate`  double , `rentable`  smallint , `rented`  smallint , `std_rate`  double , `type_name`  string , `unit_id`  int , `unit_name`  string , `unit_type_id`  int , `waiting_list_reserved`  smallint , `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_sitelink_full_units/2026-04-05/1775365646'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_sitelink_full_units"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_sitelink_full_units/2026-04-05/1775365646
id: 904007
processed: 1

raw_data:

{
    "alarm": "int16",
    "board_rate": "double",
    "climate_controlled": "int16",
    "concession_id": "int32",
    "corporate": "int16",
    "floor": "int32",
    "inside": "int16",
    "lease_num": "int32",
    "length": "double",
    "listing_avail_id": "int32",
    "listing_avail_space_id": "int32",
    "power": "int16",
    "push_rate": "double",
    "rentable": "int16",
    "rented": "int16",
    "std_rate": "double",
    "type_name": "string",
    "unit_id": "int32",
    "unit_name": "string",
    "unit_type_id": "int32",
    "waiting_list_reserved": "int16",
    "width": "double"
}

schema_attributes:

{
    "alarm": "smallint",
    "board_rate": "double",
    "climate_controlled": "smallint",
    "concession_id": "int",
    "corporate": "smallint",
    "floor": "int",
    "inside": "smallint",
    "lease_num": "int",
    "length": "double",
    "listing_avail_id": "int",
    "listing_avail_space_id": "int",
    "power": "smallint",
    "push_rate": "double",
    "rentable": "smallint",
    "rented": "smallint",
    "std_rate": "double",
    "type_name": "string",
    "unit_id": "int",
    "unit_name": "string",
    "unit_type_id": "int",
    "waiting_list_reserved": "smallint",
    "width": "double"
}

schema_name_id: 1345
schema_scan_id: 6409301
updated: 2026-04-05 00:07:57

Version 903828

created: 2026-04-04 00:11:54

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_sitelink_full_units`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_sitelink_full_units`\n(\n `alarm`  smallint , `board_rate`  double , `climate_controlled`  smallint , `concession_id`  int , `corporate`  smallint , `floor`  int , `inside`  smallint , `lease_num`  int , `length`  double , `listing_avail_id`  int , `listing_avail_space_id`  int , `power`  smallint , `push_rate`  double , `rentable`  smallint , `rented`  smallint , `std_rate`  double , `type_name`  string , `unit_id`  int , `unit_name`  string , `unit_type_id`  int , `waiting_list_reserved`  smallint , `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_sitelink_full_units/2026-04-04/1775279507'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_sitelink_full_units"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_sitelink_full_units/2026-04-04/1775279507
id: 903828
processed: 1

raw_data:

{
    "alarm": "int16",
    "board_rate": "double",
    "climate_controlled": "int16",
    "concession_id": "int32",
    "corporate": "int16",
    "floor": "int32",
    "inside": "int16",
    "lease_num": "int32",
    "length": "double",
    "listing_avail_id": "int32",
    "listing_avail_space_id": "int32",
    "power": "int16",
    "push_rate": "double",
    "rentable": "int16",
    "rented": "int16",
    "std_rate": "double",
    "type_name": "string",
    "unit_id": "int32",
    "unit_name": "string",
    "unit_type_id": "int32",
    "waiting_list_reserved": "int16",
    "width": "double"
}

schema_attributes:

{
    "alarm": "smallint",
    "board_rate": "double",
    "climate_controlled": "smallint",
    "concession_id": "int",
    "corporate": "smallint",
    "floor": "int",
    "inside": "smallint",
    "lease_num": "int",
    "length": "double",
    "listing_avail_id": "int",
    "listing_avail_space_id": "int",
    "power": "smallint",
    "push_rate": "double",
    "rentable": "smallint",
    "rented": "smallint",
    "std_rate": "double",
    "type_name": "string",
    "unit_id": "int",
    "unit_name": "string",
    "unit_type_id": "int",
    "waiting_list_reserved": "smallint",
    "width": "double"
}

schema_name_id: 1345
schema_scan_id: 6408944
updated: 2026-04-04 00:12:08

Version 903615

created: 2026-04-03 00:11:50

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_sitelink_full_units`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_sitelink_full_units`\n(\n `alarm`  smallint , `board_rate`  double , `climate_controlled`  smallint , `concession_id`  int , `corporate`  smallint , `floor`  int , `inside`  smallint , `lease_num`  int , `length`  double , `listing_avail_id`  int , `listing_avail_space_id`  int , `power`  smallint , `push_rate`  double , `rentable`  smallint , `rented`  smallint , `std_rate`  double , `type_name`  string , `unit_id`  int , `unit_name`  string , `unit_type_id`  int , `waiting_list_reserved`  smallint , `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_sitelink_full_units/2026-04-03/1775193087'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_sitelink_full_units"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_sitelink_full_units/2026-04-03/1775193087
id: 903615
processed: 1

raw_data:

{
    "alarm": "int16",
    "board_rate": "double",
    "climate_controlled": "int16",
    "concession_id": "int32",
    "corporate": "int16",
    "floor": "int32",
    "inside": "int16",
    "lease_num": "int32",
    "length": "double",
    "listing_avail_id": "int32",
    "listing_avail_space_id": "int32",
    "power": "int16",
    "push_rate": "double",
    "rentable": "int16",
    "rented": "int16",
    "std_rate": "double",
    "type_name": "string",
    "unit_id": "int32",
    "unit_name": "string",
    "unit_type_id": "int32",
    "waiting_list_reserved": "int16",
    "width": "double"
}

schema_attributes:

{
    "alarm": "smallint",
    "board_rate": "double",
    "climate_controlled": "smallint",
    "concession_id": "int",
    "corporate": "smallint",
    "floor": "int",
    "inside": "smallint",
    "lease_num": "int",
    "length": "double",
    "listing_avail_id": "int",
    "listing_avail_space_id": "int",
    "power": "smallint",
    "push_rate": "double",
    "rentable": "smallint",
    "rented": "smallint",
    "std_rate": "double",
    "type_name": "string",
    "unit_id": "int",
    "unit_name": "string",
    "unit_type_id": "int",
    "waiting_list_reserved": "smallint",
    "width": "double"
}

schema_name_id: 1345
schema_scan_id: 6408449
updated: 2026-04-03 00:12:04

Schema Scans: 15

Last at 2026-04-17 00:20:37

Scan 6415133

duration: 0:00:14.832213

exit_message:

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

id: 6415133

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_sitelink_full_units/2026-04-17/1776403224",
        "key": "raw/sparefoot_sitelink_full_units/2026-04-17/1776403224/sitelink_full_units_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_sitelink_full_units",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 13007857889885256392,
        "service_name": "sparefoot",
        "span_id": 15163005985918252082,
        "trace_id": 13007857889885256392
    }
}

running: False
schema_name_id: 1345
start_time: 2026-04-17 00:20:37
success: True
trace_id: 13007857889885256392

Scan 6414603

duration: 0:00:14.745080

exit_message:

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

id: 6414603

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_sitelink_full_units/2026-04-16/1776316446",
        "key": "raw/sparefoot_sitelink_full_units/2026-04-16/1776316446/sitelink_full_units_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_sitelink_full_units",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 2409884818338383986,
        "service_name": "sparefoot",
        "span_id": 11794833381949807449,
        "trace_id": 2409884818338383986
    }
}

running: False
schema_name_id: 1345
start_time: 2026-04-16 00:14:16
success: True
trace_id: 2409884818338383986

Scan 6414091

duration: 0:00:14.893443

exit_message:

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

id: 6414091

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_sitelink_full_units/2026-04-15/1776229922",
        "key": "raw/sparefoot_sitelink_full_units/2026-04-15/1776229922/sitelink_full_units_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_sitelink_full_units",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 10039227228999835750,
        "service_name": "sparefoot",
        "span_id": 4351879450102942623,
        "trace_id": 10039227228999835750
    }
}

running: False
schema_name_id: 1345
start_time: 2026-04-15 00:12:13
success: True
trace_id: 10039227228999835750

Scan 6413554

duration: 0:00:14.742495

exit_message:

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

id: 6413554

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_sitelink_full_units/2026-04-14/1776143354",
        "key": "raw/sparefoot_sitelink_full_units/2026-04-14/1776143354/sitelink_full_units_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_sitelink_full_units",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 805659213879952383,
        "service_name": "sparefoot",
        "span_id": 2030391320411761563,
        "trace_id": 805659213879952383
    }
}

running: False
schema_name_id: 1345
start_time: 2026-04-14 00:09:22
success: True
trace_id: 805659213879952383

Scan 6413045

duration: 0:00:14.948351

exit_message:

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

id: 6413045

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_sitelink_full_units/2026-04-13/1776057481",
        "key": "raw/sparefoot_sitelink_full_units/2026-04-13/1776057481/sitelink_full_units_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_sitelink_full_units",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 9114769266184021971,
        "service_name": "sparefoot",
        "span_id": 14618986692658453312,
        "trace_id": 9114769266184021971
    }
}

running: False
schema_name_id: 1345
start_time: 2026-04-13 00:18:08
success: True
trace_id: 9114769266184021971

Scan 6412665

duration: 0:00:14.731292

exit_message:

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

id: 6412665

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_sitelink_full_units/2026-04-12/1775970855",
        "key": "raw/sparefoot_sitelink_full_units/2026-04-12/1775970855/sitelink_full_units_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_sitelink_full_units",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 9173118520309376467,
        "service_name": "sparefoot",
        "span_id": 10992941755273519335,
        "trace_id": 9173118520309376467
    }
}

running: False
schema_name_id: 1345
start_time: 2026-04-12 00:14:39
success: True
trace_id: 9173118520309376467

Scan 6412280

duration: 0:00:12.039174

exit_message:

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

id: 6412280

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_sitelink_full_units/2026-04-11/1775884383",
        "key": "raw/sparefoot_sitelink_full_units/2026-04-11/1775884383/sitelink_full_units_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_sitelink_full_units",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 6781403859513805063,
        "service_name": "sparefoot",
        "span_id": 7938441659655395411,
        "trace_id": 6781403859513805063
    }
}

running: False
schema_name_id: 1345
start_time: 2026-04-11 00:13:08
success: True
trace_id: 6781403859513805063

Scan 6411764

duration: 0:00:14.649662

exit_message:

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

id: 6411764

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_sitelink_full_units/2026-04-10/1775797861",
        "key": "raw/sparefoot_sitelink_full_units/2026-04-10/1775797861/sitelink_full_units_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_sitelink_full_units",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 2169189806460185212,
        "service_name": "sparefoot",
        "span_id": 14966023023281015466,
        "trace_id": 2169189806460185212
    }
}

running: False
schema_name_id: 1345
start_time: 2026-04-10 00:11:06
success: True
trace_id: 2169189806460185212

Scan 6411218

duration: 0:00:12.238199

exit_message:

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

id: 6411218

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_sitelink_full_units/2026-04-09/1775711420",
        "key": "raw/sparefoot_sitelink_full_units/2026-04-09/1775711420/sitelink_full_units_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_sitelink_full_units",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 2243726814941178772,
        "service_name": "sparefoot",
        "span_id": 4577572250052020848,
        "trace_id": 2243726814941178772
    }
}

running: False
schema_name_id: 1345
start_time: 2026-04-09 00:10:26
success: True
trace_id: 2243726814941178772

Scan 6410751

duration: 0:00:14.831498

exit_message:

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

id: 6410751

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_sitelink_full_units/2026-04-08/1775625129",
        "key": "raw/sparefoot_sitelink_full_units/2026-04-08/1775625129/sitelink_full_units_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_sitelink_full_units",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 6415739043283602196,
        "service_name": "sparefoot",
        "span_id": 14161692253059056025,
        "trace_id": 6415739043283602196
    }
}

running: False
schema_name_id: 1345
start_time: 2026-04-08 00:12:40
success: True
trace_id: 6415739043283602196

Scan 6410254

duration: 0:00:14.856121

exit_message:

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

id: 6410254

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_sitelink_full_units/2026-04-07/1775538892",
        "key": "raw/sparefoot_sitelink_full_units/2026-04-07/1775538892/sitelink_full_units_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_sitelink_full_units",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 8668881126612942099,
        "service_name": "sparefoot",
        "span_id": 4711273012917591870,
        "trace_id": 8668881126612942099
    }
}

running: False
schema_name_id: 1345
start_time: 2026-04-07 00:15:22
success: True
trace_id: 8668881126612942099

Scan 6409681

duration: 0:00:12.198405

exit_message:

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

id: 6409681

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_sitelink_full_units/2026-04-06/1775452001",
        "key": "raw/sparefoot_sitelink_full_units/2026-04-06/1775452001/sitelink_full_units_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_sitelink_full_units",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 10040101401641727043,
        "service_name": "sparefoot",
        "span_id": 7400867958064622050,
        "trace_id": 10040101401641727043
    }
}

running: False
schema_name_id: 1345
start_time: 2026-04-06 00:06:49
success: True
trace_id: 10040101401641727043

Scan 6409301

duration: 0:00:12.200629

exit_message:

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

id: 6409301

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_sitelink_full_units/2026-04-05/1775365646",
        "key": "raw/sparefoot_sitelink_full_units/2026-04-05/1775365646/sitelink_full_units_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_sitelink_full_units",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 5352318158708430921,
        "service_name": "sparefoot",
        "span_id": 446869003643573406,
        "trace_id": 5352318158708430921
    }
}

running: False
schema_name_id: 1345
start_time: 2026-04-05 00:07:45
success: True
trace_id: 5352318158708430921

Scan 6408944

duration: 0:00:14.812357

exit_message:

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

id: 6408944

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_sitelink_full_units/2026-04-04/1775279507",
        "key": "raw/sparefoot_sitelink_full_units/2026-04-04/1775279507/sitelink_full_units_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_sitelink_full_units",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 13882382170755822363,
        "service_name": "sparefoot",
        "span_id": 11812455274220189529,
        "trace_id": 13882382170755822363
    }
}

running: False
schema_name_id: 1345
start_time: 2026-04-04 00:11:53
success: True
trace_id: 13882382170755822363

Scan 6408449

duration: 0:00:14.732134

exit_message:

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

id: 6408449

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_sitelink_full_units/2026-04-03/1775193087",
        "key": "raw/sparefoot_sitelink_full_units/2026-04-03/1775193087/sitelink_full_units_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_sitelink_full_units",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 6775474729757446669,
        "service_name": "sparefoot",
        "span_id": 9091118450758401983,
        "trace_id": 6775474729757446669
    }
}

running: False
schema_name_id: 1345
start_time: 2026-04-03 00:11:49
success: True
trace_id: 6775474729757446669

Partitions:

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

Schema:

attributes:

{
    "alarm": "smallint",
    "board_rate": "double",
    "climate_controlled": "smallint",
    "concession_id": "int",
    "corporate": "smallint",
    "floor": "int",
    "inside": "smallint",
    "lease_num": "int",
    "length": "double",
    "listing_avail_id": "int",
    "listing_avail_space_id": "int",
    "power": "smallint",
    "push_rate": "double",
    "rentable": "smallint",
    "rented": "smallint",
    "std_rate": "double",
    "type_name": "string",
    "unit_id": "int",
    "unit_name": "string",
    "unit_type_id": "int",
    "waiting_list_reserved": "smallint",
    "width": "double"
}

created: 2026-04-17 00:20:38

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_sitelink_full_units`\n(\n `alarm`  smallint , `board_rate`  double , `climate_controlled`  smallint , `concession_id`  int , `corporate`  smallint , `floor`  int , `inside`  smallint , `lease_num`  int , `length`  double , `listing_avail_id`  int , `listing_avail_space_id`  int , `power`  smallint , `push_rate`  double , `rentable`  smallint , `rented`  smallint , `std_rate`  double , `type_name`  string , `unit_id`  int , `unit_name`  string , `unit_type_id`  int , `waiting_list_reserved`  smallint , `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_sitelink_full_units/2026-04-17/1776403224'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_sitelink_full_units`",
    "repair_table": "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_sitelink_full_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:23:18",
        "disabled": false,
        "format": "raw",
        "id": 1345,
        "is_partitioned": false,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_stage_rds",
            "table": "sparefoot_sparefoot_sitelink_full_units"
        },
        "type": "rds"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "alarm": "smallint",
            "board_rate": "double",
            "climate_controlled": "smallint",
            "concession_id": "int",
            "corporate": "smallint",
            "floor": "int",
            "inside": "smallint",
            "lease_num": "int",
            "length": "double",
            "listing_avail_id": "int",
            "listing_avail_space_id": "int",
            "power": "smallint",
            "push_rate": "double",
            "rentable": "smallint",
            "rented": "smallint",
            "std_rate": "double",
            "type_name": "string",
            "unit_id": "int",
            "unit_name": "string",
            "unit_type_id": "int",
            "waiting_list_reserved": "smallint",
            "width": "double"
        },
        "created": "2026-04-17 00:20:38",
        "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_sitelink_full_units`\n(\n `alarm`  smallint , `board_rate`  double , `climate_controlled`  smallint , `concession_id`  int , `corporate`  smallint , `floor`  int , `inside`  smallint , `lease_num`  int , `length`  double , `listing_avail_id`  int , `listing_avail_space_id`  int , `power`  smallint , `push_rate`  double , `rentable`  smallint , `rented`  smallint , `std_rate`  double , `type_name`  string , `unit_id`  int , `unit_name`  string , `unit_type_id`  int , `waiting_list_reserved`  smallint , `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_sitelink_full_units/2026-04-17/1776403224'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_sitelink_full_units`",
            "repair_table": "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_sitelink_full_units"
        }
    },
    "server": {
        "hostname": "schemamanager-5c55c886bf-h2ts4",
        "name": "schema_manager",
        "process_start": "2025-10-21 13:03:27",
        "sf_env": "stage",
        "version": "2112174301"
    }
}