Schema Info

Schema Name: sfdl_stage_rds.sparefoot_sparefoot_facility_hours

created: 2022-08-12 10:25:44
disabled: False
format: raw
id: 1347
is_partitioned: False
is_schema_datatyped: False

name:

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

type: rds

Schema Versions: 15

Version 906561

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

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_facility_hours/2026-04-17/1776403185
id: 906561
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: 1347
schema_scan_id: 6415129
updated: 2026-04-17 00:20:14

Version 906356

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

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_facility_hours/2026-04-16/1776316339
id: 906356
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: 1347
schema_scan_id: 6414593
updated: 2026-04-16 00:12:40

Version 906109

created: 2026-04-15 00:09:26

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_facility_hours/2026-04-15/1776229763
id: 906109
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: 1347
schema_scan_id: 6414070
updated: 2026-04-15 00:09:40

Version 905897

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

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_facility_hours/2026-04-14/1776143400
id: 905897
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: 1347
schema_scan_id: 6413563
updated: 2026-04-14 00:10:26

Version 905683

created: 2026-04-13 00:14:39

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_facility_hours/2026-04-13/1776057275
id: 905683
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: 1347
schema_scan_id: 6413014
updated: 2026-04-13 00:14:53

Version 905486

created: 2026-04-12 00:09:01

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_facility_hours/2026-04-12/1775970519
id: 905486
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: 1347
schema_scan_id: 6412636
updated: 2026-04-12 00:09:12

Version 905267

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

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_facility_hours/2026-04-11/1775883984
id: 905267
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: 1347
schema_scan_id: 6412238
updated: 2026-04-11 00:06:40

Version 905087

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

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_facility_hours/2026-04-10/1775797903
id: 905087
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: 1347
schema_scan_id: 6411769
updated: 2026-04-10 00:12:01

Version 904855

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

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_facility_hours/2026-04-09/1775711571
id: 904855
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: 1347
schema_scan_id: 6411242
updated: 2026-04-09 00:13:11

Version 904621

created: 2026-04-08 00:06:16

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_facility_hours/2026-04-08/1775624772
id: 904621
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: 1347
schema_scan_id: 6410716
updated: 2026-04-08 00:06:29

Version 904408

created: 2026-04-07 00:06:43

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_facility_hours/2026-04-07/1775538382
id: 904408
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: 1347
schema_scan_id: 6410209
updated: 2026-04-07 00:06:55

Version 904224

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

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_facility_hours/2026-04-06/1775452086
id: 904224
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: 1347
schema_scan_id: 6409697
updated: 2026-04-06 00:08:48

Version 904037

created: 2026-04-05 00:13:28

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_facility_hours/2026-04-05/1775366004
id: 904037
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: 1347
schema_scan_id: 6409333
updated: 2026-04-05 00:13:42

Version 903829

created: 2026-04-04 00:12:02

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_facility_hours/2026-04-04/1775279517
id: 903829
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: 1347
schema_scan_id: 6408945
updated: 2026-04-04 00:12:15

Version 903616

created: 2026-04-03 00:12:00

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_facility_hours/2026-04-03/1775193097
id: 903616
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: 1347
schema_scan_id: 6408450
updated: 2026-04-03 00:12:11

Schema Scans: 15

Last at 2026-04-17 00:19:59

Scan 6415129

duration: 0:00:14.914851

exit_message:

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

id: 6415129

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_facility_hours/2026-04-17/1776403185",
        "key": "raw/sparefoot_facility_hours/2026-04-17/1776403185/facility_hours_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_facility_hours",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 2750054618322646721,
        "service_name": "sparefoot",
        "span_id": 4661775475930348399,
        "trace_id": 2750054618322646721
    }
}

running: False
schema_name_id: 1347
start_time: 2026-04-17 00:19:59
success: True
trace_id: 2750054618322646721

Scan 6414593

duration: 0:00:12.182507

exit_message:

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

id: 6414593

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_facility_hours/2026-04-16/1776316339",
        "key": "raw/sparefoot_facility_hours/2026-04-16/1776316339/facility_hours_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_facility_hours",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 15202256877008171874,
        "service_name": "sparefoot",
        "span_id": 8098525922083317501,
        "trace_id": 15202256877008171874
    }
}

running: False
schema_name_id: 1347
start_time: 2026-04-16 00:12:28
success: True
trace_id: 15202256877008171874

Scan 6414070

duration: 0:00:14.554638

exit_message:

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

id: 6414070

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_facility_hours/2026-04-15/1776229763",
        "key": "raw/sparefoot_facility_hours/2026-04-15/1776229763/facility_hours_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_facility_hours",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 3160858330055697496,
        "service_name": "sparefoot",
        "span_id": 7009007506763331992,
        "trace_id": 3160858330055697496
    }
}

running: False
schema_name_id: 1347
start_time: 2026-04-15 00:09:25
success: True
trace_id: 3160858330055697496

Scan 6413563

duration: 0:00:14.863628

exit_message:

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

id: 6413563

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_facility_hours/2026-04-14/1776143400",
        "key": "raw/sparefoot_facility_hours/2026-04-14/1776143400/facility_hours_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_facility_hours",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 10738680138800361936,
        "service_name": "sparefoot",
        "span_id": 12756747696508499355,
        "trace_id": 10738680138800361936
    }
}

running: False
schema_name_id: 1347
start_time: 2026-04-14 00:10:11
success: True
trace_id: 10738680138800361936

Scan 6413014

duration: 0:00:14.572332

exit_message:

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

id: 6413014

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_facility_hours/2026-04-13/1776057275",
        "key": "raw/sparefoot_facility_hours/2026-04-13/1776057275/facility_hours_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_facility_hours",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 15976878645434499955,
        "service_name": "sparefoot",
        "span_id": 7141582679179622200,
        "trace_id": 15976878645434499955
    }
}

running: False
schema_name_id: 1347
start_time: 2026-04-13 00:14:38
success: True
trace_id: 15976878645434499955

Scan 6412636

duration: 0:00:11.965082

exit_message:

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

id: 6412636

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_facility_hours/2026-04-12/1775970519",
        "key": "raw/sparefoot_facility_hours/2026-04-12/1775970519/facility_hours_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_facility_hours",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 9349657799692729300,
        "service_name": "sparefoot",
        "span_id": 5873946864900745584,
        "trace_id": 9349657799692729300
    }
}

running: False
schema_name_id: 1347
start_time: 2026-04-12 00:09:00
success: True
trace_id: 9349657799692729300

Scan 6412238

duration: 0:00:12.067898

exit_message:

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

id: 6412238

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_facility_hours/2026-04-11/1775883984",
        "key": "raw/sparefoot_facility_hours/2026-04-11/1775883984/facility_hours_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_facility_hours",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 4237777004530340183,
        "service_name": "sparefoot",
        "span_id": 17690378369899912860,
        "trace_id": 4237777004530340183
    }
}

running: False
schema_name_id: 1347
start_time: 2026-04-11 00:06:28
success: True
trace_id: 4237777004530340183

Scan 6411769

duration: 0:00:14.654432

exit_message:

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

id: 6411769

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_facility_hours/2026-04-10/1775797903",
        "key": "raw/sparefoot_facility_hours/2026-04-10/1775797903/facility_hours_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_facility_hours",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 3487624017413535346,
        "service_name": "sparefoot",
        "span_id": 4918578188821036777,
        "trace_id": 3487624017413535346
    }
}

running: False
schema_name_id: 1347
start_time: 2026-04-10 00:11:46
success: True
trace_id: 3487624017413535346

Scan 6411242

duration: 0:00:12.195539

exit_message:

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

id: 6411242

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_facility_hours/2026-04-09/1775711571",
        "key": "raw/sparefoot_facility_hours/2026-04-09/1775711571/facility_hours_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_facility_hours",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 14554337961105639902,
        "service_name": "sparefoot",
        "span_id": 17457223376300879778,
        "trace_id": 14554337961105639902
    }
}

running: False
schema_name_id: 1347
start_time: 2026-04-09 00:12:59
success: True
trace_id: 14554337961105639902

Scan 6410716

duration: 0:00:14.468010

exit_message:

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

id: 6410716

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_facility_hours/2026-04-08/1775624772",
        "key": "raw/sparefoot_facility_hours/2026-04-08/1775624772/facility_hours_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_facility_hours",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 1651590930028850336,
        "service_name": "sparefoot",
        "span_id": 14656973989161928070,
        "trace_id": 1651590930028850336
    }
}

running: False
schema_name_id: 1347
start_time: 2026-04-08 00:06:15
success: True
trace_id: 1651590930028850336

Scan 6410209

duration: 0:00:12.081088

exit_message:

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

id: 6410209

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_facility_hours/2026-04-07/1775538382",
        "key": "raw/sparefoot_facility_hours/2026-04-07/1775538382/facility_hours_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_facility_hours",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 9806835017604817231,
        "service_name": "sparefoot",
        "span_id": 13135302864558039980,
        "trace_id": 9806835017604817231
    }
}

running: False
schema_name_id: 1347
start_time: 2026-04-07 00:06:43
success: True
trace_id: 9806835017604817231

Scan 6409697

duration: 0:00:14.674691

exit_message:

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

id: 6409697

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_facility_hours/2026-04-06/1775452086",
        "key": "raw/sparefoot_facility_hours/2026-04-06/1775452086/facility_hours_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_facility_hours",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 7998387635140403866,
        "service_name": "sparefoot",
        "span_id": 17170987693801940119,
        "trace_id": 7998387635140403866
    }
}

running: False
schema_name_id: 1347
start_time: 2026-04-06 00:08:33
success: True
trace_id: 7998387635140403866

Scan 6409333

duration: 0:00:14.463618

exit_message:

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

id: 6409333

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_facility_hours/2026-04-05/1775366004",
        "key": "raw/sparefoot_facility_hours/2026-04-05/1775366004/facility_hours_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_facility_hours",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 7678976145373505046,
        "service_name": "sparefoot",
        "span_id": 13084074531065626334,
        "trace_id": 7678976145373505046
    }
}

running: False
schema_name_id: 1347
start_time: 2026-04-05 00:13:27
success: True
trace_id: 7678976145373505046

Scan 6408945

duration: 0:00:14.888281

exit_message:

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

id: 6408945

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_facility_hours/2026-04-04/1775279517",
        "key": "raw/sparefoot_facility_hours/2026-04-04/1775279517/facility_hours_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_facility_hours",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 5996641565179625673,
        "service_name": "sparefoot",
        "span_id": 3394827488974512905,
        "trace_id": 5996641565179625673
    }
}

running: False
schema_name_id: 1347
start_time: 2026-04-04 00:12:01
success: True
trace_id: 5996641565179625673

Scan 6408450

duration: 0:00:12.162353

exit_message:

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

id: 6408450

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_facility_hours/2026-04-03/1775193097",
        "key": "raw/sparefoot_facility_hours/2026-04-03/1775193097/facility_hours_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_facility_hours",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 1853462669031695001,
        "service_name": "sparefoot",
        "span_id": 16262692230321736082,
        "trace_id": 1853462669031695001
    }
}

running: False
schema_name_id: 1347
start_time: 2026-04-03 00:11:59
success: True
trace_id: 1853462669031695001

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 00:20:00

ddl:

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

Server:

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

Raw:

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