Schema Info

Schema Name: sfdl_prod_rds.sparefoot_sparefoot_facility_hours

created: 2022-08-18 17:22:23
disabled: False
format: raw
id: 1120
is_partitioned: False
is_schema_datatyped: False

name:

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

type: rds

Schema Versions: 15

Version 1718372

created: 2026-04-17 14:10:39

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_facility_hours`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_facility_hours`\n(\n `fri_end`  string , `fri_start`  string , `listing_avail_id`  int , `manual_edit`  smallint , `mon_end`  string , `mon_start`  string , `sat_end`  string , `sat_start`  string , `sun_end`  string , `sun_start`  string , `thu_end`  string , `thu_start`  string , `tue_end`  string , `tue_start`  string , `type`  string , `wed_end`  string , `wed_start`  string \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_facility_hours/2026-04-17/1776453032'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_facility_hours"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_facility_hours/2026-04-17/1776453032
id: 1718372
processed: 1

raw_data:

{
    "fri_end": "string",
    "fri_start": "string",
    "listing_avail_id": "int32",
    "manual_edit": "int16",
    "mon_end": "string",
    "mon_start": "string",
    "sat_end": "string",
    "sat_start": "string",
    "sun_end": "string",
    "sun_start": "string",
    "thu_end": "string",
    "thu_start": "string",
    "tue_end": "string",
    "tue_start": "string",
    "type": "string",
    "wed_end": "string",
    "wed_start": "string"
}

schema_attributes:

{
    "fri_end": "string",
    "fri_start": "string",
    "listing_avail_id": "int",
    "manual_edit": "smallint",
    "mon_end": "string",
    "mon_start": "string",
    "sat_end": "string",
    "sat_start": "string",
    "sun_end": "string",
    "sun_start": "string",
    "thu_end": "string",
    "thu_start": "string",
    "tue_end": "string",
    "tue_start": "string",
    "type": "string",
    "wed_end": "string",
    "wed_start": "string"
}

schema_name_id: 1120
schema_scan_id: 162193964
updated: 2026-04-17 14:10:52

Version 1718220

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_facility_hours`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_facility_hours`\n(\n `fri_end`  string , `fri_start`  string , `listing_avail_id`  int , `manual_edit`  smallint , `mon_end`  string , `mon_start`  string , `sat_end`  string , `sat_start`  string , `sun_end`  string , `sun_start`  string , `thu_end`  string , `thu_start`  string , `tue_end`  string , `tue_start`  string , `type`  string , `wed_end`  string , `wed_start`  string \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_facility_hours/2026-04-17/1776435873'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_facility_hours"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_facility_hours/2026-04-17/1776435873
id: 1718220
processed: 1

raw_data:

{
    "fri_end": "string",
    "fri_start": "string",
    "listing_avail_id": "int32",
    "manual_edit": "int16",
    "mon_end": "string",
    "mon_start": "string",
    "sat_end": "string",
    "sat_start": "string",
    "sun_end": "string",
    "sun_start": "string",
    "thu_end": "string",
    "thu_start": "string",
    "tue_end": "string",
    "tue_start": "string",
    "type": "string",
    "wed_end": "string",
    "wed_start": "string"
}

schema_attributes:

{
    "fri_end": "string",
    "fri_start": "string",
    "listing_avail_id": "int",
    "manual_edit": "smallint",
    "mon_end": "string",
    "mon_start": "string",
    "sat_end": "string",
    "sat_start": "string",
    "sun_end": "string",
    "sun_start": "string",
    "thu_end": "string",
    "thu_start": "string",
    "tue_end": "string",
    "tue_start": "string",
    "type": "string",
    "wed_end": "string",
    "wed_start": "string"
}

schema_name_id: 1120
schema_scan_id: 162178320
updated: 2026-04-17 09:24:52

Version 1717439

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_facility_hours`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_facility_hours`\n(\n `fri_end`  string , `fri_start`  string , `listing_avail_id`  int , `manual_edit`  smallint , `mon_end`  string , `mon_start`  string , `sat_end`  string , `sat_start`  string , `sun_end`  string , `sun_start`  string , `thu_end`  string , `thu_start`  string , `tue_end`  string , `tue_start`  string , `type`  string , `wed_end`  string , `wed_start`  string \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_facility_hours/2026-04-17/1776402408'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_facility_hours"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_facility_hours/2026-04-17/1776402408
id: 1717439
processed: 1

raw_data:

{
    "fri_end": "string",
    "fri_start": "string",
    "listing_avail_id": "int32",
    "manual_edit": "int16",
    "mon_end": "string",
    "mon_start": "string",
    "sat_end": "string",
    "sat_start": "string",
    "sun_end": "string",
    "sun_start": "string",
    "thu_end": "string",
    "thu_start": "string",
    "tue_end": "string",
    "tue_start": "string",
    "type": "string",
    "wed_end": "string",
    "wed_start": "string"
}

schema_attributes:

{
    "fri_end": "string",
    "fri_start": "string",
    "listing_avail_id": "int",
    "manual_edit": "smallint",
    "mon_end": "string",
    "mon_start": "string",
    "sat_end": "string",
    "sat_start": "string",
    "sun_end": "string",
    "sun_start": "string",
    "thu_end": "string",
    "thu_start": "string",
    "tue_end": "string",
    "tue_start": "string",
    "type": "string",
    "wed_end": "string",
    "wed_start": "string"
}

schema_name_id: 1120
schema_scan_id: 162163571
updated: 2026-04-17 00:07:19

Version 1717322

created: 2026-04-16 20:16:46

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_facility_hours`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_facility_hours`\n(\n `fri_end`  string , `fri_start`  string , `listing_avail_id`  int , `manual_edit`  smallint , `mon_end`  string , `mon_start`  string , `sat_end`  string , `sat_start`  string , `sun_end`  string , `sun_start`  string , `thu_end`  string , `thu_start`  string , `tue_end`  string , `tue_start`  string , `type`  string , `wed_end`  string , `wed_start`  string \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_facility_hours/2026-04-16/1776388550'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_facility_hours"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_facility_hours/2026-04-16/1776388550
id: 1717322
processed: 1

raw_data:

{
    "fri_end": "string",
    "fri_start": "string",
    "listing_avail_id": "int32",
    "manual_edit": "int16",
    "mon_end": "string",
    "mon_start": "string",
    "sat_end": "string",
    "sat_start": "string",
    "sun_end": "string",
    "sun_start": "string",
    "thu_end": "string",
    "thu_start": "string",
    "tue_end": "string",
    "tue_start": "string",
    "type": "string",
    "wed_end": "string",
    "wed_start": "string"
}

schema_attributes:

{
    "fri_end": "string",
    "fri_start": "string",
    "listing_avail_id": "int",
    "manual_edit": "smallint",
    "mon_end": "string",
    "mon_start": "string",
    "sat_end": "string",
    "sat_start": "string",
    "sun_end": "string",
    "sun_start": "string",
    "thu_end": "string",
    "thu_start": "string",
    "tue_end": "string",
    "tue_start": "string",
    "type": "string",
    "wed_end": "string",
    "wed_start": "string"
}

schema_name_id: 1120
schema_scan_id: 162156058
updated: 2026-04-16 20:16:59

Version 1717142

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_facility_hours`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_facility_hours`\n(\n `fri_end`  string , `fri_start`  string , `listing_avail_id`  int , `manual_edit`  smallint , `mon_end`  string , `mon_start`  string , `sat_end`  string , `sat_start`  string , `sun_end`  string , `sun_start`  string , `thu_end`  string , `thu_start`  string , `tue_end`  string , `tue_start`  string , `type`  string , `wed_end`  string , `wed_start`  string \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_facility_hours/2026-04-16/1776366656'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_facility_hours"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_facility_hours/2026-04-16/1776366656
id: 1717142
processed: 1

raw_data:

{
    "fri_end": "string",
    "fri_start": "string",
    "listing_avail_id": "int32",
    "manual_edit": "int16",
    "mon_end": "string",
    "mon_start": "string",
    "sat_end": "string",
    "sat_start": "string",
    "sun_end": "string",
    "sun_start": "string",
    "thu_end": "string",
    "thu_start": "string",
    "tue_end": "string",
    "tue_start": "string",
    "type": "string",
    "wed_end": "string",
    "wed_start": "string"
}

schema_attributes:

{
    "fri_end": "string",
    "fri_start": "string",
    "listing_avail_id": "int",
    "manual_edit": "smallint",
    "mon_end": "string",
    "mon_start": "string",
    "sat_end": "string",
    "sat_start": "string",
    "sun_end": "string",
    "sun_start": "string",
    "thu_end": "string",
    "thu_start": "string",
    "tue_end": "string",
    "tue_start": "string",
    "type": "string",
    "wed_end": "string",
    "wed_start": "string"
}

schema_name_id: 1120
schema_scan_id: 162138014
updated: 2026-04-16 14:14:48

Version 1717006

created: 2026-04-16 09:16:40

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_facility_hours`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_facility_hours`\n(\n `fri_end`  string , `fri_start`  string , `listing_avail_id`  int , `manual_edit`  smallint , `mon_end`  string , `mon_start`  string , `sat_end`  string , `sat_start`  string , `sun_end`  string , `sun_start`  string , `thu_end`  string , `thu_start`  string , `tue_end`  string , `tue_start`  string , `type`  string , `wed_end`  string , `wed_start`  string \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_facility_hours/2026-04-16/1776348996'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_facility_hours"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_facility_hours/2026-04-16/1776348996
id: 1717006
processed: 1

raw_data:

{
    "fri_end": "string",
    "fri_start": "string",
    "listing_avail_id": "int32",
    "manual_edit": "int16",
    "mon_end": "string",
    "mon_start": "string",
    "sat_end": "string",
    "sat_start": "string",
    "sun_end": "string",
    "sun_start": "string",
    "thu_end": "string",
    "thu_start": "string",
    "tue_end": "string",
    "tue_start": "string",
    "type": "string",
    "wed_end": "string",
    "wed_start": "string"
}

schema_attributes:

{
    "fri_end": "string",
    "fri_start": "string",
    "listing_avail_id": "int",
    "manual_edit": "smallint",
    "mon_end": "string",
    "mon_start": "string",
    "sat_end": "string",
    "sat_start": "string",
    "sun_end": "string",
    "sun_start": "string",
    "thu_end": "string",
    "thu_start": "string",
    "tue_end": "string",
    "tue_start": "string",
    "type": "string",
    "wed_end": "string",
    "wed_start": "string"
}

schema_name_id: 1120
schema_scan_id: 162122567
updated: 2026-04-16 09:16:54

Version 1716216

created: 2026-04-16 00:13:22

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_facility_hours`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_facility_hours`\n(\n `fri_end`  string , `fri_start`  string , `listing_avail_id`  int , `manual_edit`  smallint , `mon_end`  string , `mon_start`  string , `sat_end`  string , `sat_start`  string , `sun_end`  string , `sun_start`  string , `thu_end`  string , `thu_start`  string , `tue_end`  string , `tue_start`  string , `type`  string , `wed_end`  string , `wed_start`  string \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_facility_hours/2026-04-16/1776316394'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_facility_hours"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_facility_hours/2026-04-16/1776316394
id: 1716216
processed: 1

raw_data:

{
    "fri_end": "string",
    "fri_start": "string",
    "listing_avail_id": "int32",
    "manual_edit": "int16",
    "mon_end": "string",
    "mon_start": "string",
    "sat_end": "string",
    "sat_start": "string",
    "sun_end": "string",
    "sun_start": "string",
    "thu_end": "string",
    "thu_start": "string",
    "tue_end": "string",
    "tue_start": "string",
    "type": "string",
    "wed_end": "string",
    "wed_start": "string"
}

schema_attributes:

{
    "fri_end": "string",
    "fri_start": "string",
    "listing_avail_id": "int",
    "manual_edit": "smallint",
    "mon_end": "string",
    "mon_start": "string",
    "sat_end": "string",
    "sat_start": "string",
    "sun_end": "string",
    "sun_start": "string",
    "thu_end": "string",
    "thu_start": "string",
    "tue_end": "string",
    "tue_start": "string",
    "type": "string",
    "wed_end": "string",
    "wed_start": "string"
}

schema_name_id: 1120
schema_scan_id: 162107794
updated: 2026-04-16 00:13:33

Version 1716082

created: 2026-04-15 20:18:20

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_facility_hours`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_facility_hours`\n(\n `fri_end`  string , `fri_start`  string , `listing_avail_id`  int , `manual_edit`  smallint , `mon_end`  string , `mon_start`  string , `sat_end`  string , `sat_start`  string , `sun_end`  string , `sun_start`  string , `thu_end`  string , `thu_start`  string , `tue_end`  string , `tue_start`  string , `type`  string , `wed_end`  string , `wed_start`  string \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_facility_hours/2026-04-15/1776302288'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_facility_hours"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_facility_hours/2026-04-15/1776302288
id: 1716082
processed: 1

raw_data:

{
    "fri_end": "string",
    "fri_start": "string",
    "listing_avail_id": "int32",
    "manual_edit": "int16",
    "mon_end": "string",
    "mon_start": "string",
    "sat_end": "string",
    "sat_start": "string",
    "sun_end": "string",
    "sun_start": "string",
    "thu_end": "string",
    "thu_start": "string",
    "tue_end": "string",
    "tue_start": "string",
    "type": "string",
    "wed_end": "string",
    "wed_start": "string"
}

schema_attributes:

{
    "fri_end": "string",
    "fri_start": "string",
    "listing_avail_id": "int",
    "manual_edit": "smallint",
    "mon_end": "string",
    "mon_start": "string",
    "sat_end": "string",
    "sat_start": "string",
    "sun_end": "string",
    "sun_start": "string",
    "thu_end": "string",
    "thu_start": "string",
    "tue_end": "string",
    "tue_start": "string",
    "type": "string",
    "wed_end": "string",
    "wed_start": "string"
}

schema_name_id: 1120
schema_scan_id: 162100288
updated: 2026-04-15 20:18:31

Version 1715949

created: 2026-04-15 14:11:46

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_facility_hours`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_facility_hours`\n(\n `fri_end`  string , `fri_start`  string , `listing_avail_id`  int , `manual_edit`  smallint , `mon_end`  string , `mon_start`  string , `sat_end`  string , `sat_start`  string , `sun_end`  string , `sun_start`  string , `thu_end`  string , `thu_start`  string , `tue_end`  string , `tue_start`  string , `type`  string , `wed_end`  string , `wed_start`  string \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_facility_hours/2026-04-15/1776280264'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_facility_hours"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_facility_hours/2026-04-15/1776280264
id: 1715949
processed: 1

raw_data:

{
    "fri_end": "string",
    "fri_start": "string",
    "listing_avail_id": "int32",
    "manual_edit": "int16",
    "mon_end": "string",
    "mon_start": "string",
    "sat_end": "string",
    "sat_start": "string",
    "sun_end": "string",
    "sun_start": "string",
    "thu_end": "string",
    "thu_start": "string",
    "tue_end": "string",
    "tue_start": "string",
    "type": "string",
    "wed_end": "string",
    "wed_start": "string"
}

schema_attributes:

{
    "fri_end": "string",
    "fri_start": "string",
    "listing_avail_id": "int",
    "manual_edit": "smallint",
    "mon_end": "string",
    "mon_start": "string",
    "sat_end": "string",
    "sat_start": "string",
    "sun_end": "string",
    "sun_start": "string",
    "thu_end": "string",
    "thu_start": "string",
    "tue_end": "string",
    "tue_start": "string",
    "type": "string",
    "wed_end": "string",
    "wed_start": "string"
}

schema_name_id: 1120
schema_scan_id: 162081674
updated: 2026-04-15 14:11:57

Version 1715773

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_facility_hours`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_facility_hours`\n(\n `fri_end`  string , `fri_start`  string , `listing_avail_id`  int , `manual_edit`  smallint , `mon_end`  string , `mon_start`  string , `sat_end`  string , `sat_start`  string , `sun_end`  string , `sun_start`  string , `thu_end`  string , `thu_start`  string , `tue_end`  string , `tue_start`  string , `type`  string , `wed_end`  string , `wed_start`  string \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_facility_hours/2026-04-15/1776260510'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_facility_hours"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_facility_hours/2026-04-15/1776260510
id: 1715773
processed: 1

raw_data:

{
    "fri_end": "string",
    "fri_start": "string",
    "listing_avail_id": "int32",
    "manual_edit": "int16",
    "mon_end": "string",
    "mon_start": "string",
    "sat_end": "string",
    "sat_start": "string",
    "sun_end": "string",
    "sun_start": "string",
    "thu_end": "string",
    "thu_start": "string",
    "tue_end": "string",
    "tue_start": "string",
    "type": "string",
    "wed_end": "string",
    "wed_start": "string"
}

schema_attributes:

{
    "fri_end": "string",
    "fri_start": "string",
    "listing_avail_id": "int",
    "manual_edit": "smallint",
    "mon_end": "string",
    "mon_start": "string",
    "sat_end": "string",
    "sat_start": "string",
    "sun_end": "string",
    "sun_start": "string",
    "thu_end": "string",
    "thu_start": "string",
    "tue_end": "string",
    "tue_start": "string",
    "type": "string",
    "wed_end": "string",
    "wed_start": "string"
}

schema_name_id: 1120
schema_scan_id: 162064506
updated: 2026-04-15 08:43:08

Version 1715025

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_facility_hours`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_facility_hours`\n(\n `fri_end`  string , `fri_start`  string , `listing_avail_id`  int , `manual_edit`  smallint , `mon_end`  string , `mon_start`  string , `sat_end`  string , `sat_start`  string , `sun_end`  string , `sun_start`  string , `thu_end`  string , `thu_start`  string , `tue_end`  string , `tue_start`  string , `type`  string , `wed_end`  string , `wed_start`  string \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_facility_hours/2026-04-15/1776230224'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_facility_hours"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_facility_hours/2026-04-15/1776230224
id: 1715025
processed: 1

raw_data:

{
    "fri_end": "string",
    "fri_start": "string",
    "listing_avail_id": "int32",
    "manual_edit": "int16",
    "mon_end": "string",
    "mon_start": "string",
    "sat_end": "string",
    "sat_start": "string",
    "sun_end": "string",
    "sun_start": "string",
    "thu_end": "string",
    "thu_start": "string",
    "tue_end": "string",
    "tue_start": "string",
    "type": "string",
    "wed_end": "string",
    "wed_start": "string"
}

schema_attributes:

{
    "fri_end": "string",
    "fri_start": "string",
    "listing_avail_id": "int",
    "manual_edit": "smallint",
    "mon_end": "string",
    "mon_start": "string",
    "sat_end": "string",
    "sat_start": "string",
    "sun_end": "string",
    "sun_start": "string",
    "thu_end": "string",
    "thu_start": "string",
    "tue_end": "string",
    "tue_start": "string",
    "type": "string",
    "wed_end": "string",
    "wed_start": "string"
}

schema_name_id: 1120
schema_scan_id: 162051990
updated: 2026-04-15 00:17:21

Version 1714904

created: 2026-04-14 20:20:28

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_facility_hours`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_facility_hours`\n(\n `fri_end`  string , `fri_start`  string , `listing_avail_id`  int , `manual_edit`  smallint , `mon_end`  string , `mon_start`  string , `sat_end`  string , `sat_start`  string , `sun_end`  string , `sun_start`  string , `thu_end`  string , `thu_start`  string , `tue_end`  string , `tue_start`  string , `type`  string , `wed_end`  string , `wed_start`  string \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_facility_hours/2026-04-14/1776216024'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_facility_hours"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_facility_hours/2026-04-14/1776216024
id: 1714904
processed: 1

raw_data:

{
    "fri_end": "string",
    "fri_start": "string",
    "listing_avail_id": "int32",
    "manual_edit": "int16",
    "mon_end": "string",
    "mon_start": "string",
    "sat_end": "string",
    "sat_start": "string",
    "sun_end": "string",
    "sun_start": "string",
    "thu_end": "string",
    "thu_start": "string",
    "tue_end": "string",
    "tue_start": "string",
    "type": "string",
    "wed_end": "string",
    "wed_start": "string"
}

schema_attributes:

{
    "fri_end": "string",
    "fri_start": "string",
    "listing_avail_id": "int",
    "manual_edit": "smallint",
    "mon_end": "string",
    "mon_start": "string",
    "sat_end": "string",
    "sat_start": "string",
    "sun_end": "string",
    "sun_start": "string",
    "thu_end": "string",
    "thu_start": "string",
    "tue_end": "string",
    "tue_start": "string",
    "type": "string",
    "wed_end": "string",
    "wed_start": "string"
}

schema_name_id: 1120
schema_scan_id: 162044307
updated: 2026-04-14 20:20:39

Version 1714702

created: 2026-04-14 14:10:31

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_facility_hours`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_facility_hours`\n(\n `fri_end`  string , `fri_start`  string , `listing_avail_id`  int , `manual_edit`  smallint , `mon_end`  string , `mon_start`  string , `sat_end`  string , `sat_start`  string , `sun_end`  string , `sun_start`  string , `thu_end`  string , `thu_start`  string , `tue_end`  string , `tue_start`  string , `type`  string , `wed_end`  string , `wed_start`  string \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_facility_hours/2026-04-14/1776193821'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_facility_hours"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_facility_hours/2026-04-14/1776193821
id: 1714702
processed: 1

raw_data:

{
    "fri_end": "string",
    "fri_start": "string",
    "listing_avail_id": "int32",
    "manual_edit": "int16",
    "mon_end": "string",
    "mon_start": "string",
    "sat_end": "string",
    "sat_start": "string",
    "sun_end": "string",
    "sun_start": "string",
    "thu_end": "string",
    "thu_start": "string",
    "tue_end": "string",
    "tue_start": "string",
    "type": "string",
    "wed_end": "string",
    "wed_start": "string"
}

schema_attributes:

{
    "fri_end": "string",
    "fri_start": "string",
    "listing_avail_id": "int",
    "manual_edit": "smallint",
    "mon_end": "string",
    "mon_start": "string",
    "sat_end": "string",
    "sat_start": "string",
    "sun_end": "string",
    "sun_start": "string",
    "thu_end": "string",
    "thu_start": "string",
    "tue_end": "string",
    "tue_start": "string",
    "type": "string",
    "wed_end": "string",
    "wed_start": "string"
}

schema_name_id: 1120
schema_scan_id: 162026075
updated: 2026-04-14 14:10:42

Version 1714586

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_facility_hours`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_facility_hours`\n(\n `fri_end`  string , `fri_start`  string , `listing_avail_id`  int , `manual_edit`  smallint , `mon_end`  string , `mon_start`  string , `sat_end`  string , `sat_start`  string , `sun_end`  string , `sun_start`  string , `thu_end`  string , `thu_start`  string , `tue_end`  string , `tue_start`  string , `type`  string , `wed_end`  string , `wed_start`  string \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_facility_hours/2026-04-14/1776175712'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_facility_hours"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_facility_hours/2026-04-14/1776175712
id: 1714586
processed: 1

raw_data:

{
    "fri_end": "string",
    "fri_start": "string",
    "listing_avail_id": "int32",
    "manual_edit": "int16",
    "mon_end": "string",
    "mon_start": "string",
    "sat_end": "string",
    "sat_start": "string",
    "sun_end": "string",
    "sun_start": "string",
    "thu_end": "string",
    "thu_start": "string",
    "tue_end": "string",
    "tue_start": "string",
    "type": "string",
    "wed_end": "string",
    "wed_start": "string"
}

schema_attributes:

{
    "fri_end": "string",
    "fri_start": "string",
    "listing_avail_id": "int",
    "manual_edit": "smallint",
    "mon_end": "string",
    "mon_start": "string",
    "sat_end": "string",
    "sat_start": "string",
    "sun_end": "string",
    "sun_start": "string",
    "thu_end": "string",
    "thu_start": "string",
    "tue_end": "string",
    "tue_start": "string",
    "type": "string",
    "wed_end": "string",
    "wed_start": "string"
}

schema_name_id: 1120
schema_scan_id: 162010946
updated: 2026-04-14 09:09:13

Version 1713823

created: 2026-04-14 00:14:25

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_facility_hours`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_facility_hours`\n(\n `fri_end`  string , `fri_start`  string , `listing_avail_id`  int , `manual_edit`  smallint , `mon_end`  string , `mon_start`  string , `sat_end`  string , `sat_start`  string , `sun_end`  string , `sun_start`  string , `thu_end`  string , `thu_start`  string , `tue_end`  string , `tue_start`  string , `type`  string , `wed_end`  string , `wed_start`  string \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_facility_hours/2026-04-14/1776143660'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_facility_hours"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_facility_hours/2026-04-14/1776143660
id: 1713823
processed: 1

raw_data:

{
    "fri_end": "string",
    "fri_start": "string",
    "listing_avail_id": "int32",
    "manual_edit": "int16",
    "mon_end": "string",
    "mon_start": "string",
    "sat_end": "string",
    "sat_start": "string",
    "sun_end": "string",
    "sun_start": "string",
    "thu_end": "string",
    "thu_start": "string",
    "tue_end": "string",
    "tue_start": "string",
    "type": "string",
    "wed_end": "string",
    "wed_start": "string"
}

schema_attributes:

{
    "fri_end": "string",
    "fri_start": "string",
    "listing_avail_id": "int",
    "manual_edit": "smallint",
    "mon_end": "string",
    "mon_start": "string",
    "sat_end": "string",
    "sat_start": "string",
    "sun_end": "string",
    "sun_start": "string",
    "thu_end": "string",
    "thu_start": "string",
    "tue_end": "string",
    "tue_start": "string",
    "type": "string",
    "wed_end": "string",
    "wed_start": "string"
}

schema_name_id: 1120
schema_scan_id: 161996365
updated: 2026-04-14 00:14:38

Schema Scans: 15

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

Scan 162193964

duration: 0:00:14.633073

exit_message:

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

id: 162193964

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_facility_hours/2026-04-17/1776453032",
        "key": "raw/sparefoot_facility_hours/2026-04-17/1776453032/facility_hours_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_facility_hours",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 8207662405117701225,
        "service_name": "sparefoot",
        "span_id": 5528314392243432912,
        "trace_id": 8207662405117701225
    }
}

running: False
schema_name_id: 1120
start_time: 2026-04-17 14:10:38
success: True
trace_id: 8207662405117701225

Scan 162178320

duration: 0:00:14.529131

exit_message:

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

id: 162178320

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_facility_hours/2026-04-17/1776435873",
        "key": "raw/sparefoot_facility_hours/2026-04-17/1776435873/facility_hours_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_facility_hours",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 8687454913231259757,
        "service_name": "sparefoot",
        "span_id": 6905533446499293128,
        "trace_id": 8687454913231259757
    }
}

running: False
schema_name_id: 1120
start_time: 2026-04-17 09:24:38
success: True
trace_id: 8687454913231259757

Scan 162163571

duration: 0:00:14.514102

exit_message:

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

id: 162163571

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_facility_hours/2026-04-17/1776402408",
        "key": "raw/sparefoot_facility_hours/2026-04-17/1776402408/facility_hours_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_facility_hours",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 13150203298655536899,
        "service_name": "sparefoot",
        "span_id": 1788362880137674676,
        "trace_id": 13150203298655536899
    }
}

running: False
schema_name_id: 1120
start_time: 2026-04-17 00:07:04
success: True
trace_id: 13150203298655536899

Scan 162156058

duration: 0:00:14.572367

exit_message:

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

id: 162156058

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_facility_hours/2026-04-16/1776388550",
        "key": "raw/sparefoot_facility_hours/2026-04-16/1776388550/facility_hours_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_facility_hours",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 2487326507957366872,
        "service_name": "sparefoot",
        "span_id": 8599012402807994810,
        "trace_id": 2487326507957366872
    }
}

running: False
schema_name_id: 1120
start_time: 2026-04-16 20:16:45
success: True
trace_id: 2487326507957366872

Scan 162138014

duration: 0:00:14.675500

exit_message:

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

id: 162138014

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_facility_hours/2026-04-16/1776366656",
        "key": "raw/sparefoot_facility_hours/2026-04-16/1776366656/facility_hours_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_facility_hours",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 8510301651774882245,
        "service_name": "sparefoot",
        "span_id": 13011010510145265442,
        "trace_id": 8510301651774882245
    }
}

running: False
schema_name_id: 1120
start_time: 2026-04-16 14:14:33
success: True
trace_id: 8510301651774882245

Scan 162122567

duration: 0:00:14.556665

exit_message:

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

id: 162122567

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_facility_hours/2026-04-16/1776348996",
        "key": "raw/sparefoot_facility_hours/2026-04-16/1776348996/facility_hours_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_facility_hours",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 4765841973035013453,
        "service_name": "sparefoot",
        "span_id": 13439711590761547832,
        "trace_id": 4765841973035013453
    }
}

running: False
schema_name_id: 1120
start_time: 2026-04-16 09:16:40
success: True
trace_id: 4765841973035013453

Scan 162107794

duration: 0:00:11.911350

exit_message:

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

id: 162107794

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_facility_hours/2026-04-16/1776316394",
        "key": "raw/sparefoot_facility_hours/2026-04-16/1776316394/facility_hours_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_facility_hours",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 14985991353691079550,
        "service_name": "sparefoot",
        "span_id": 15321056642353024140,
        "trace_id": 14985991353691079550
    }
}

running: False
schema_name_id: 1120
start_time: 2026-04-16 00:13:21
success: True
trace_id: 14985991353691079550

Scan 162100288

duration: 0:00:12.128684

exit_message:

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

id: 162100288

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_facility_hours/2026-04-15/1776302288",
        "key": "raw/sparefoot_facility_hours/2026-04-15/1776302288/facility_hours_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_facility_hours",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 7396918497564709184,
        "service_name": "sparefoot",
        "span_id": 2669395928784574797,
        "trace_id": 7396918497564709184
    }
}

running: False
schema_name_id: 1120
start_time: 2026-04-15 20:18:19
success: True
trace_id: 7396918497564709184

Scan 162081674

duration: 0:00:12.042431

exit_message:

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

id: 162081674

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_facility_hours/2026-04-15/1776280264",
        "key": "raw/sparefoot_facility_hours/2026-04-15/1776280264/facility_hours_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_facility_hours",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 3932956491955791894,
        "service_name": "sparefoot",
        "span_id": 4536429677872008290,
        "trace_id": 3932956491955791894
    }
}

running: False
schema_name_id: 1120
start_time: 2026-04-15 14:11:45
success: True
trace_id: 3932956491955791894

Scan 162064506

duration: 0:00:14.509903

exit_message:

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

id: 162064506

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_facility_hours/2026-04-15/1776260510",
        "key": "raw/sparefoot_facility_hours/2026-04-15/1776260510/facility_hours_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_facility_hours",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 4704223855255750188,
        "service_name": "sparefoot",
        "span_id": 14932421131842788126,
        "trace_id": 4704223855255750188
    }
}

running: False
schema_name_id: 1120
start_time: 2026-04-15 08:42:53
success: True
trace_id: 4704223855255750188

Scan 162051990

duration: 0:00:14.563568

exit_message:

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

id: 162051990

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_facility_hours/2026-04-15/1776230224",
        "key": "raw/sparefoot_facility_hours/2026-04-15/1776230224/facility_hours_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_facility_hours",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 16399972747603653663,
        "service_name": "sparefoot",
        "span_id": 4768894162309239215,
        "trace_id": 16399972747603653663
    }
}

running: False
schema_name_id: 1120
start_time: 2026-04-15 00:17:07
success: True
trace_id: 16399972747603653663

Scan 162044307

duration: 0:00:12.024695

exit_message:

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

id: 162044307

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_facility_hours/2026-04-14/1776216024",
        "key": "raw/sparefoot_facility_hours/2026-04-14/1776216024/facility_hours_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_facility_hours",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 16625244725014409238,
        "service_name": "sparefoot",
        "span_id": 9915552412826688462,
        "trace_id": 16625244725014409238
    }
}

running: False
schema_name_id: 1120
start_time: 2026-04-14 20:20:27
success: True
trace_id: 16625244725014409238

Scan 162026075

duration: 0:00:12.117862

exit_message:

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

id: 162026075

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_facility_hours/2026-04-14/1776193821",
        "key": "raw/sparefoot_facility_hours/2026-04-14/1776193821/facility_hours_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_facility_hours",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 17281834169114901270,
        "service_name": "sparefoot",
        "span_id": 14823215385401754851,
        "trace_id": 17281834169114901270
    }
}

running: False
schema_name_id: 1120
start_time: 2026-04-14 14:10:30
success: True
trace_id: 17281834169114901270

Scan 162010946

duration: 0:00:14.589742

exit_message:

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

id: 162010946

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_facility_hours/2026-04-14/1776175712",
        "key": "raw/sparefoot_facility_hours/2026-04-14/1776175712/facility_hours_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_facility_hours",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 18156700273822350886,
        "service_name": "sparefoot",
        "span_id": 14140792091039429383,
        "trace_id": 18156700273822350886
    }
}

running: False
schema_name_id: 1120
start_time: 2026-04-14 09:08:59
success: True
trace_id: 18156700273822350886

Scan 161996365

duration: 0:00:14.423832

exit_message:

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

id: 161996365

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_facility_hours/2026-04-14/1776143660",
        "key": "raw/sparefoot_facility_hours/2026-04-14/1776143660/facility_hours_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_facility_hours",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 6439678166364490400,
        "service_name": "sparefoot",
        "span_id": 7656230638408874986,
        "trace_id": 6439678166364490400
    }
}

running: False
schema_name_id: 1120
start_time: 2026-04-14 00:14:24
success: True
trace_id: 6439678166364490400

Partitions:

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

Schema:

attributes:

{
    "fri_end": "string",
    "fri_start": "string",
    "listing_avail_id": "int",
    "manual_edit": "smallint",
    "mon_end": "string",
    "mon_start": "string",
    "sat_end": "string",
    "sat_start": "string",
    "sun_end": "string",
    "sun_start": "string",
    "thu_end": "string",
    "thu_start": "string",
    "tue_end": "string",
    "tue_start": "string",
    "type": "string",
    "wed_end": "string",
    "wed_start": "string"
}

created: 2026-04-17 14:10:39

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_facility_hours`\n(\n `fri_end`  string , `fri_start`  string , `listing_avail_id`  int , `manual_edit`  smallint , `mon_end`  string , `mon_start`  string , `sat_end`  string , `sat_start`  string , `sun_end`  string , `sun_start`  string , `thu_end`  string , `thu_start`  string , `tue_end`  string , `tue_start`  string , `type`  string , `wed_end`  string , `wed_start`  string \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_facility_hours/2026-04-17/1776453032'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_facility_hours`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_facility_hours"
}

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:22:23",
        "disabled": false,
        "format": "raw",
        "id": 1120,
        "is_partitioned": false,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_prod_rds",
            "table": "sparefoot_sparefoot_facility_hours"
        },
        "type": "rds"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "fri_end": "string",
            "fri_start": "string",
            "listing_avail_id": "int",
            "manual_edit": "smallint",
            "mon_end": "string",
            "mon_start": "string",
            "sat_end": "string",
            "sat_start": "string",
            "sun_end": "string",
            "sun_start": "string",
            "thu_end": "string",
            "thu_start": "string",
            "tue_end": "string",
            "tue_start": "string",
            "type": "string",
            "wed_end": "string",
            "wed_start": "string"
        },
        "created": "2026-04-17 14:10:39",
        "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_facility_hours`\n(\n `fri_end`  string , `fri_start`  string , `listing_avail_id`  int , `manual_edit`  smallint , `mon_end`  string , `mon_start`  string , `sat_end`  string , `sat_start`  string , `sun_end`  string , `sun_start`  string , `thu_end`  string , `thu_start`  string , `tue_end`  string , `tue_start`  string , `type`  string , `wed_end`  string , `wed_start`  string \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_facility_hours/2026-04-17/1776453032'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_facility_hours`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_facility_hours"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}