Schema Info

Schema Name: sfdl_prod_rds.sparefoot_sparefoot_sitelink_full_units

created: 2022-08-18 17:23:56
disabled: False
format: raw
id: 1129
is_partitioned: False
is_schema_datatyped: False

name:

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

type: rds

Schema Versions: 15

Version 1718417

created: 2026-04-17 14:17:58

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_sitelink_full_units`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/sparefoot_sitelink_full_units/2026-04-17/1776453471'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_sitelink_full_units"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_sitelink_full_units/2026-04-17/1776453471
id: 1718417
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: 1129
schema_scan_id: 162194072
updated: 2026-04-17 14:18:11

Version 1718217

created: 2026-04-17 09:24:18

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_sitelink_full_units`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/sparefoot_sitelink_full_units/2026-04-17/1776435852'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_sitelink_full_units"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_sitelink_full_units/2026-04-17/1776435852
id: 1718217
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: 1129
schema_scan_id: 162178315
updated: 2026-04-17 09:24:29

Version 1717474

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_sitelink_full_units`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/sparefoot_sitelink_full_units/2026-04-17/1776402927'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_sitelink_full_units"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_sitelink_full_units/2026-04-17/1776402927
id: 1717474
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: 1129
schema_scan_id: 162163648
updated: 2026-04-17 00:15:45

Version 1717372

created: 2026-04-16 20:40:38

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_sitelink_full_units`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/sparefoot_sitelink_full_units/2026-04-16/1776390024'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_sitelink_full_units"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_sitelink_full_units/2026-04-16/1776390024
id: 1717372
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: 1129
schema_scan_id: 162156254
updated: 2026-04-16 20:40:52

Version 1717191

created: 2026-04-16 14:21:30

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_sitelink_full_units`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/sparefoot_sitelink_full_units/2026-04-16/1776367224'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_sitelink_full_units"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_sitelink_full_units/2026-04-16/1776367224
id: 1717191
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: 1129
schema_scan_id: 162138152
updated: 2026-04-16 14:21:44

Version 1716981

created: 2026-04-16 09:10:56

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_sitelink_full_units`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/sparefoot_sitelink_full_units/2026-04-16/1776348651'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_sitelink_full_units"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_sitelink_full_units/2026-04-16/1776348651
id: 1716981
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: 1129
schema_scan_id: 162122505
updated: 2026-04-16 09:11:09

Version 1716235

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_sitelink_full_units`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/sparefoot_sitelink_full_units/2026-04-16/1776316686'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_sitelink_full_units"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_sitelink_full_units/2026-04-16/1776316686
id: 1716235
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: 1129
schema_scan_id: 162107825
updated: 2026-04-16 00:18:38

Version 1716129

created: 2026-04-15 20:28:34

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_sitelink_full_units`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/sparefoot_sitelink_full_units/2026-04-15/1776302907'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_sitelink_full_units"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_sitelink_full_units/2026-04-15/1776302907
id: 1716129
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: 1129
schema_scan_id: 162100361
updated: 2026-04-15 20:28:45

Version 1715971

created: 2026-04-15 14:16:52

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_sitelink_full_units`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/sparefoot_sitelink_full_units/2026-04-15/1776280606'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_sitelink_full_units"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_sitelink_full_units/2026-04-15/1776280606
id: 1715971
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: 1129
schema_scan_id: 162081729
updated: 2026-04-15 14:17:04

Version 1715772

created: 2026-04-15 08:42:46

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_sitelink_full_units`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/sparefoot_sitelink_full_units/2026-04-15/1776260503'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_sitelink_full_units"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_sitelink_full_units/2026-04-15/1776260503
id: 1715772
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: 1129
schema_scan_id: 162064503
updated: 2026-04-15 08:42:57

Version 1714993

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_sitelink_full_units`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/sparefoot_sitelink_full_units/2026-04-15/1776229655'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_sitelink_full_units"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_sitelink_full_units/2026-04-15/1776229655
id: 1714993
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: 1129
schema_scan_id: 162051919
updated: 2026-04-15 00:07:54

Version 1714907

created: 2026-04-14 20:22:25

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_sitelink_full_units`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/sparefoot_sitelink_full_units/2026-04-14/1776216138'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_sitelink_full_units"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_sitelink_full_units/2026-04-14/1776216138
id: 1714907
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: 1129
schema_scan_id: 162044312
updated: 2026-04-14 20:22:39

Version 1714713

created: 2026-04-14 14:13:02

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_sitelink_full_units`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/sparefoot_sitelink_full_units/2026-04-14/1776193975'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_sitelink_full_units"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_sitelink_full_units/2026-04-14/1776193975
id: 1714713
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: 1129
schema_scan_id: 162026091
updated: 2026-04-14 14:13:14

Version 1714606

created: 2026-04-14 09:14:40

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_sitelink_full_units`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/sparefoot_sitelink_full_units/2026-04-14/1776175926'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_sitelink_full_units"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_sitelink_full_units/2026-04-14/1776175926
id: 1714606
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: 1129
schema_scan_id: 162010982
updated: 2026-04-14 09:14:54

Version 1713809

created: 2026-04-14 00:11:21

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_sitelink_full_units`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/sparefoot_sitelink_full_units/2026-04-14/1776143463'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_sitelink_full_units"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_sitelink_full_units/2026-04-14/1776143463
id: 1713809
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: 1129
schema_scan_id: 161996345
updated: 2026-04-14 00:11:32

Schema Scans: 15

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

Scan 162194072

duration: 0:00:14.503759

exit_message:

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

id: 162194072

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_sitelink_full_units/2026-04-17/1776453471",
        "key": "raw/sparefoot_sitelink_full_units/2026-04-17/1776453471/sitelink_full_units_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_sitelink_full_units",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 13294666789058854864,
        "service_name": "sparefoot",
        "span_id": 18116692386665199225,
        "trace_id": 13294666789058854864
    }
}

running: False
schema_name_id: 1129
start_time: 2026-04-17 14:17:57
success: True
trace_id: 13294666789058854864

Scan 162178315

duration: 0:00:12.201013

exit_message:

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

id: 162178315

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_sitelink_full_units/2026-04-17/1776435852",
        "key": "raw/sparefoot_sitelink_full_units/2026-04-17/1776435852/sitelink_full_units_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_sitelink_full_units",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 4082983566953607480,
        "service_name": "sparefoot",
        "span_id": 10989221421159818738,
        "trace_id": 4082983566953607480
    }
}

running: False
schema_name_id: 1129
start_time: 2026-04-17 09:24:17
success: True
trace_id: 4082983566953607480

Scan 162163648

duration: 0:00:12.037053

exit_message:

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

id: 162163648

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_sitelink_full_units/2026-04-17/1776402927",
        "key": "raw/sparefoot_sitelink_full_units/2026-04-17/1776402927/sitelink_full_units_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_sitelink_full_units",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 1261293970334358431,
        "service_name": "sparefoot",
        "span_id": 1450984600651545532,
        "trace_id": 1261293970334358431
    }
}

running: False
schema_name_id: 1129
start_time: 2026-04-17 00:15:33
success: True
trace_id: 1261293970334358431

Scan 162156254

duration: 0:00:14.860069

exit_message:

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

id: 162156254

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_sitelink_full_units/2026-04-16/1776390024",
        "key": "raw/sparefoot_sitelink_full_units/2026-04-16/1776390024/sitelink_full_units_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_sitelink_full_units",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 1141331360894202196,
        "service_name": "sparefoot",
        "span_id": 5892883005639222086,
        "trace_id": 1141331360894202196
    }
}

running: False
schema_name_id: 1129
start_time: 2026-04-16 20:40:37
success: True
trace_id: 1141331360894202196

Scan 162138152

duration: 0:00:14.760856

exit_message:

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

id: 162138152

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_sitelink_full_units/2026-04-16/1776367224",
        "key": "raw/sparefoot_sitelink_full_units/2026-04-16/1776367224/sitelink_full_units_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_sitelink_full_units",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 12597449436757878585,
        "service_name": "sparefoot",
        "span_id": 1247765623726973480,
        "trace_id": 12597449436757878585
    }
}

running: False
schema_name_id: 1129
start_time: 2026-04-16 14:21:29
success: True
trace_id: 12597449436757878585

Scan 162122505

duration: 0:00:14.619019

exit_message:

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

id: 162122505

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_sitelink_full_units/2026-04-16/1776348651",
        "key": "raw/sparefoot_sitelink_full_units/2026-04-16/1776348651/sitelink_full_units_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_sitelink_full_units",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 6402334902573860450,
        "service_name": "sparefoot",
        "span_id": 5499436284108642774,
        "trace_id": 6402334902573860450
    }
}

running: False
schema_name_id: 1129
start_time: 2026-04-16 09:10:55
success: True
trace_id: 6402334902573860450

Scan 162107825

duration: 0:00:14.863300

exit_message:

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

id: 162107825

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_sitelink_full_units/2026-04-16/1776316686",
        "key": "raw/sparefoot_sitelink_full_units/2026-04-16/1776316686/sitelink_full_units_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_sitelink_full_units",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 7498079352452950404,
        "service_name": "sparefoot",
        "span_id": 7370993350291058417,
        "trace_id": 7498079352452950404
    }
}

running: False
schema_name_id: 1129
start_time: 2026-04-16 00:18:23
success: True
trace_id: 7498079352452950404

Scan 162100361

duration: 0:00:12.067661

exit_message:

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

id: 162100361

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_sitelink_full_units/2026-04-15/1776302907",
        "key": "raw/sparefoot_sitelink_full_units/2026-04-15/1776302907/sitelink_full_units_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_sitelink_full_units",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 8596375737570492637,
        "service_name": "sparefoot",
        "span_id": 7844732908422795873,
        "trace_id": 8596375737570492637
    }
}

running: False
schema_name_id: 1129
start_time: 2026-04-15 20:28:33
success: True
trace_id: 8596375737570492637

Scan 162081729

duration: 0:00:12.218181

exit_message:

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

id: 162081729

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_sitelink_full_units/2026-04-15/1776280606",
        "key": "raw/sparefoot_sitelink_full_units/2026-04-15/1776280606/sitelink_full_units_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_sitelink_full_units",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 10856340334204104688,
        "service_name": "sparefoot",
        "span_id": 5373137799975236455,
        "trace_id": 10856340334204104688
    }
}

running: False
schema_name_id: 1129
start_time: 2026-04-15 14:16:52
success: True
trace_id: 10856340334204104688

Scan 162064503

duration: 0:00:12.313389

exit_message:

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

id: 162064503

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_sitelink_full_units/2026-04-15/1776260503",
        "key": "raw/sparefoot_sitelink_full_units/2026-04-15/1776260503/sitelink_full_units_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_sitelink_full_units",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 662553526572873639,
        "service_name": "sparefoot",
        "span_id": 914264568467771191,
        "trace_id": 662553526572873639
    }
}

running: False
schema_name_id: 1129
start_time: 2026-04-15 08:42:45
success: True
trace_id: 662553526572873639

Scan 162051919

duration: 0:00:14.645813

exit_message:

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

id: 162051919

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_sitelink_full_units/2026-04-15/1776229655",
        "key": "raw/sparefoot_sitelink_full_units/2026-04-15/1776229655/sitelink_full_units_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_sitelink_full_units",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 14497694965812269143,
        "service_name": "sparefoot",
        "span_id": 16905998121165890045,
        "trace_id": 14497694965812269143
    }
}

running: False
schema_name_id: 1129
start_time: 2026-04-15 00:07:39
success: True
trace_id: 14497694965812269143

Scan 162044312

duration: 0:00:14.655388

exit_message:

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

id: 162044312

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_sitelink_full_units/2026-04-14/1776216138",
        "key": "raw/sparefoot_sitelink_full_units/2026-04-14/1776216138/sitelink_full_units_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_sitelink_full_units",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 7974576194503171770,
        "service_name": "sparefoot",
        "span_id": 11845602287402949388,
        "trace_id": 7974576194503171770
    }
}

running: False
schema_name_id: 1129
start_time: 2026-04-14 20:22:24
success: True
trace_id: 7974576194503171770

Scan 162026091

duration: 0:00:12.223955

exit_message:

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

id: 162026091

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_sitelink_full_units/2026-04-14/1776193975",
        "key": "raw/sparefoot_sitelink_full_units/2026-04-14/1776193975/sitelink_full_units_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_sitelink_full_units",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 3368415049118693010,
        "service_name": "sparefoot",
        "span_id": 18056745800526011014,
        "trace_id": 3368415049118693010
    }
}

running: False
schema_name_id: 1129
start_time: 2026-04-14 14:13:02
success: True
trace_id: 3368415049118693010

Scan 162010982

duration: 0:00:14.740342

exit_message:

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

id: 162010982

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_sitelink_full_units/2026-04-14/1776175926",
        "key": "raw/sparefoot_sitelink_full_units/2026-04-14/1776175926/sitelink_full_units_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_sitelink_full_units",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 5994334015336288073,
        "service_name": "sparefoot",
        "span_id": 989758639495066674,
        "trace_id": 5994334015336288073
    }
}

running: False
schema_name_id: 1129
start_time: 2026-04-14 09:14:39
success: True
trace_id: 5994334015336288073

Scan 161996345

duration: 0:00:12.133008

exit_message:

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

id: 161996345

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_sitelink_full_units/2026-04-14/1776143463",
        "key": "raw/sparefoot_sitelink_full_units/2026-04-14/1776143463/sitelink_full_units_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_sitelink_full_units",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 6998630711368834695,
        "service_name": "sparefoot",
        "span_id": 12485539659080215913,
        "trace_id": 6998630711368834695
    }
}

running: False
schema_name_id: 1129
start_time: 2026-04-14 00:11:20
success: True
trace_id: 6998630711368834695

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 14:17:58

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_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-prod/raw/sparefoot_sitelink_full_units/2026-04-17/1776453471'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_sitelink_full_units`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_sitelink_full_units"
}

Server:

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

Raw:

{
    "name": {
        "created": "2022-08-18 17:23:56",
        "disabled": false,
        "format": "raw",
        "id": 1129,
        "is_partitioned": false,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_prod_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 14:17:58",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_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-prod/raw/sparefoot_sitelink_full_units/2026-04-17/1776453471'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_sitelink_full_units`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_sitelink_full_units"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}