Schema Info

Schema Name: sfdl_prod_rds.sparefoot_sparefoot_facility_closure

created: 2022-08-18 17:20:13
disabled: False
format: raw
id: 1105
is_partitioned: False
is_schema_datatyped: False

name:

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

type: rds

Schema Versions: 15

Version 1718367

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_facility_closure`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_facility_closure`\n(\n `active`  smallint , `closed_date_end`  timestamp , `closed_date_start`  timestamp , `facility_closure_id`  int , `facility_id`  int \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_closure/2026-04-17/1776453005'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_facility_closure"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_facility_closure/2026-04-17/1776453005
id: 1718367
processed: 1

raw_data:

{
    "active": "int16",
    "closed_date_end": "timestamp[ns]",
    "closed_date_start": "timestamp[ns]",
    "facility_closure_id": "int32",
    "facility_id": "int32"
}

schema_attributes:

{
    "active": "smallint",
    "closed_date_end": "timestamp",
    "closed_date_start": "timestamp",
    "facility_closure_id": "int",
    "facility_id": "int"
}

schema_name_id: 1105
schema_scan_id: 162193959
updated: 2026-04-17 14:10:28

Version 1718218

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_facility_closure`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_facility_closure`\n(\n `active`  smallint , `closed_date_end`  timestamp , `closed_date_start`  timestamp , `facility_closure_id`  int , `facility_id`  int \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_closure/2026-04-17/1776435858'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_facility_closure"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_facility_closure/2026-04-17/1776435858
id: 1718218
processed: 1

raw_data:

{
    "active": "int16",
    "closed_date_end": "timestamp[ns]",
    "closed_date_start": "timestamp[ns]",
    "facility_closure_id": "int32",
    "facility_id": "int32"
}

schema_attributes:

{
    "active": "smallint",
    "closed_date_end": "timestamp",
    "closed_date_start": "timestamp",
    "facility_closure_id": "int",
    "facility_id": "int"
}

schema_name_id: 1105
schema_scan_id: 162178316
updated: 2026-04-17 09:24:35

Version 1717467

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_facility_closure`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_facility_closure`\n(\n `active`  smallint , `closed_date_end`  timestamp , `closed_date_start`  timestamp , `facility_closure_id`  int , `facility_id`  int \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_closure/2026-04-17/1776402623'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_facility_closure"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_facility_closure/2026-04-17/1776402623
id: 1717467
processed: 1

raw_data:

{
    "active": "int16",
    "closed_date_end": "timestamp[ns]",
    "closed_date_start": "timestamp[ns]",
    "facility_closure_id": "int32",
    "facility_id": "int32"
}

schema_attributes:

{
    "active": "smallint",
    "closed_date_end": "timestamp",
    "closed_date_start": "timestamp",
    "facility_closure_id": "int",
    "facility_id": "int"
}

schema_name_id: 1105
schema_scan_id: 162163625
updated: 2026-04-17 00:13:49

Version 1717345

created: 2026-04-16 20:23:53

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_facility_closure`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_facility_closure`\n(\n `active`  smallint , `closed_date_end`  timestamp , `closed_date_start`  timestamp , `facility_closure_id`  int , `facility_id`  int \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_closure/2026-04-16/1776388867'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_facility_closure"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_facility_closure/2026-04-16/1776388867
id: 1717345
processed: 1

raw_data:

{
    "active": "int16",
    "closed_date_end": "timestamp[ns]",
    "closed_date_start": "timestamp[ns]",
    "facility_closure_id": "int32",
    "facility_id": "int32"
}

schema_attributes:

{
    "active": "smallint",
    "closed_date_end": "timestamp",
    "closed_date_start": "timestamp",
    "facility_closure_id": "int",
    "facility_id": "int"
}

schema_name_id: 1105
schema_scan_id: 162156139
updated: 2026-04-16 20:24:07

Version 1717140

created: 2026-04-16 14:14:24

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_facility_closure`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_facility_closure`\n(\n `active`  smallint , `closed_date_end`  timestamp , `closed_date_start`  timestamp , `facility_closure_id`  int , `facility_id`  int \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_closure/2026-04-16/1776366653'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_facility_closure"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_facility_closure/2026-04-16/1776366653
id: 1717140
processed: 1

raw_data:

{
    "active": "int16",
    "closed_date_end": "timestamp[ns]",
    "closed_date_start": "timestamp[ns]",
    "facility_closure_id": "int32",
    "facility_id": "int32"
}

schema_attributes:

{
    "active": "smallint",
    "closed_date_end": "timestamp",
    "closed_date_start": "timestamp",
    "facility_closure_id": "int",
    "facility_id": "int"
}

schema_name_id: 1105
schema_scan_id: 162138011
updated: 2026-04-16 14:14:38

Version 1717004

created: 2026-04-16 09:15:51

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_facility_closure`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_facility_closure`\n(\n `active`  smallint , `closed_date_end`  timestamp , `closed_date_start`  timestamp , `facility_closure_id`  int , `facility_id`  int \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_closure/2026-04-16/1776348940'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_facility_closure"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_facility_closure/2026-04-16/1776348940
id: 1717004
processed: 1

raw_data:

{
    "active": "int16",
    "closed_date_end": "timestamp[ns]",
    "closed_date_start": "timestamp[ns]",
    "facility_closure_id": "int32",
    "facility_id": "int32"
}

schema_attributes:

{
    "active": "smallint",
    "closed_date_end": "timestamp",
    "closed_date_start": "timestamp",
    "facility_closure_id": "int",
    "facility_id": "int"
}

schema_name_id: 1105
schema_scan_id: 162122549
updated: 2026-04-16 09:16:02

Version 1716193

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_facility_closure`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_facility_closure`\n(\n `active`  smallint , `closed_date_end`  timestamp , `closed_date_start`  timestamp , `facility_closure_id`  int , `facility_id`  int \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_closure/2026-04-16/1776315980'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_facility_closure"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_facility_closure/2026-04-16/1776315980
id: 1716193
processed: 1

raw_data:

{
    "active": "int16",
    "closed_date_end": "timestamp[ns]",
    "closed_date_start": "timestamp[ns]",
    "facility_closure_id": "int32",
    "facility_id": "int32"
}

schema_attributes:

{
    "active": "smallint",
    "closed_date_end": "timestamp",
    "closed_date_start": "timestamp",
    "facility_closure_id": "int",
    "facility_id": "int"
}

schema_name_id: 1105
schema_scan_id: 162107746
updated: 2026-04-16 00:06:37

Version 1716094

created: 2026-04-15 20:20:49

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_facility_closure`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_facility_closure`\n(\n `active`  smallint , `closed_date_end`  timestamp , `closed_date_start`  timestamp , `facility_closure_id`  int , `facility_id`  int \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_closure/2026-04-15/1776302443'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_facility_closure"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_facility_closure/2026-04-15/1776302443
id: 1716094
processed: 1

raw_data:

{
    "active": "int16",
    "closed_date_end": "timestamp[ns]",
    "closed_date_start": "timestamp[ns]",
    "facility_closure_id": "int32",
    "facility_id": "int32"
}

schema_attributes:

{
    "active": "smallint",
    "closed_date_end": "timestamp",
    "closed_date_start": "timestamp",
    "facility_closure_id": "int",
    "facility_id": "int"
}

schema_name_id: 1105
schema_scan_id: 162100305
updated: 2026-04-15 20:21:01

Version 1715962

created: 2026-04-15 14:15:25

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_facility_closure`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_facility_closure`\n(\n `active`  smallint , `closed_date_end`  timestamp , `closed_date_start`  timestamp , `facility_closure_id`  int , `facility_id`  int \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_closure/2026-04-15/1776280522'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_facility_closure"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_facility_closure/2026-04-15/1776280522
id: 1715962
processed: 1

raw_data:

{
    "active": "int16",
    "closed_date_end": "timestamp[ns]",
    "closed_date_start": "timestamp[ns]",
    "facility_closure_id": "int32",
    "facility_id": "int32"
}

schema_attributes:

{
    "active": "smallint",
    "closed_date_end": "timestamp",
    "closed_date_start": "timestamp",
    "facility_closure_id": "int",
    "facility_id": "int"
}

schema_name_id: 1105
schema_scan_id: 162081698
updated: 2026-04-15 14:15:39

Version 1715754

created: 2026-04-15 08:39:51

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_facility_closure`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_facility_closure`\n(\n `active`  smallint , `closed_date_end`  timestamp , `closed_date_start`  timestamp , `facility_closure_id`  int , `facility_id`  int \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_closure/2026-04-15/1776260297'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_facility_closure"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_facility_closure/2026-04-15/1776260297
id: 1715754
processed: 1

raw_data:

{
    "active": "int16",
    "closed_date_end": "timestamp[ns]",
    "closed_date_start": "timestamp[ns]",
    "facility_closure_id": "int32",
    "facility_id": "int32"
}

schema_attributes:

{
    "active": "smallint",
    "closed_date_end": "timestamp",
    "closed_date_start": "timestamp",
    "facility_closure_id": "int",
    "facility_id": "int"
}

schema_name_id: 1105
schema_scan_id: 162064413
updated: 2026-04-15 08:40:02

Version 1715004

created: 2026-04-15 00:08:24

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_facility_closure`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_facility_closure`\n(\n `active`  smallint , `closed_date_end`  timestamp , `closed_date_start`  timestamp , `facility_closure_id`  int , `facility_id`  int \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_closure/2026-04-15/1776229697'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_facility_closure"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_facility_closure/2026-04-15/1776229697
id: 1715004
processed: 1

raw_data:

{
    "active": "int16",
    "closed_date_end": "timestamp[ns]",
    "closed_date_start": "timestamp[ns]",
    "facility_closure_id": "int32",
    "facility_id": "int32"
}

schema_attributes:

{
    "active": "smallint",
    "closed_date_end": "timestamp",
    "closed_date_start": "timestamp",
    "facility_closure_id": "int",
    "facility_id": "int"
}

schema_name_id: 1105
schema_scan_id: 162051947
updated: 2026-04-15 00:08:37

Version 1714905

created: 2026-04-14 20:20:34

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_facility_closure`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_facility_closure`\n(\n `active`  smallint , `closed_date_end`  timestamp , `closed_date_start`  timestamp , `facility_closure_id`  int , `facility_id`  int \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_closure/2026-04-14/1776216031'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_facility_closure"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_facility_closure/2026-04-14/1776216031
id: 1714905
processed: 1

raw_data:

{
    "active": "int16",
    "closed_date_end": "timestamp[ns]",
    "closed_date_start": "timestamp[ns]",
    "facility_closure_id": "int32",
    "facility_id": "int32"
}

schema_attributes:

{
    "active": "smallint",
    "closed_date_end": "timestamp",
    "closed_date_start": "timestamp",
    "facility_closure_id": "int",
    "facility_id": "int"
}

schema_name_id: 1105
schema_scan_id: 162044308
updated: 2026-04-14 20:20:48

Version 1714703

created: 2026-04-14 14:10:32

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_facility_closure`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_facility_closure`\n(\n `active`  smallint , `closed_date_end`  timestamp , `closed_date_start`  timestamp , `facility_closure_id`  int , `facility_id`  int \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_closure/2026-04-14/1776193828'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_facility_closure"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_facility_closure/2026-04-14/1776193828
id: 1714703
processed: 1

raw_data:

{
    "active": "int16",
    "closed_date_end": "timestamp[ns]",
    "closed_date_start": "timestamp[ns]",
    "facility_closure_id": "int32",
    "facility_id": "int32"
}

schema_attributes:

{
    "active": "smallint",
    "closed_date_end": "timestamp",
    "closed_date_start": "timestamp",
    "facility_closure_id": "int",
    "facility_id": "int"
}

schema_name_id: 1105
schema_scan_id: 162026076
updated: 2026-04-14 14:10:43

Version 1714590

created: 2026-04-14 09:09:33

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_facility_closure`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_facility_closure`\n(\n `active`  smallint , `closed_date_end`  timestamp , `closed_date_start`  timestamp , `facility_closure_id`  int , `facility_id`  int \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_closure/2026-04-14/1776175723'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_facility_closure"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_facility_closure/2026-04-14/1776175723
id: 1714590
processed: 1

raw_data:

{
    "active": "int16",
    "closed_date_end": "timestamp[ns]",
    "closed_date_start": "timestamp[ns]",
    "facility_closure_id": "int32",
    "facility_id": "int32"
}

schema_attributes:

{
    "active": "smallint",
    "closed_date_end": "timestamp",
    "closed_date_start": "timestamp",
    "facility_closure_id": "int",
    "facility_id": "int"
}

schema_name_id: 1105
schema_scan_id: 162010959
updated: 2026-04-14 09:09:47

Version 1713819

created: 2026-04-14 00:14:06

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_facility_closure`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_facility_closure`\n(\n `active`  smallint , `closed_date_end`  timestamp , `closed_date_start`  timestamp , `facility_closure_id`  int , `facility_id`  int \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_closure/2026-04-14/1776143637'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_facility_closure"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_facility_closure/2026-04-14/1776143637
id: 1713819
processed: 1

raw_data:

{
    "active": "int16",
    "closed_date_end": "timestamp[ns]",
    "closed_date_start": "timestamp[ns]",
    "facility_closure_id": "int32",
    "facility_id": "int32"
}

schema_attributes:

{
    "active": "smallint",
    "closed_date_end": "timestamp",
    "closed_date_start": "timestamp",
    "facility_closure_id": "int",
    "facility_id": "int"
}

schema_name_id: 1105
schema_scan_id: 161996358
updated: 2026-04-14 00:14:17

Schema Scans: 15

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

Scan 162193959

duration: 0:00:14.227678

exit_message:

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

id: 162193959

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_closure/2026-04-17/1776453005",
        "key": "raw/sparefoot_facility_closure/2026-04-17/1776453005/facility_closure_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_facility_closure",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 8527168848858043303,
        "service_name": "sparefoot",
        "span_id": 2258330764871414786,
        "trace_id": 8527168848858043303
    }
}

running: False
schema_name_id: 1105
start_time: 2026-04-17 14:10:13
success: True
trace_id: 8527168848858043303

Scan 162178316

duration: 0:00:14.182866

exit_message:

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

id: 162178316

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_closure/2026-04-17/1776435858",
        "key": "raw/sparefoot_facility_closure/2026-04-17/1776435858/facility_closure_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_facility_closure",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 2499028184519076712,
        "service_name": "sparefoot",
        "span_id": 12796898510527619895,
        "trace_id": 2499028184519076712
    }
}

running: False
schema_name_id: 1105
start_time: 2026-04-17 09:24:21
success: True
trace_id: 2499028184519076712

Scan 162163625

duration: 0:00:14.271940

exit_message:

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

id: 162163625

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_closure/2026-04-17/1776402623",
        "key": "raw/sparefoot_facility_closure/2026-04-17/1776402623/facility_closure_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_facility_closure",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 10478048417711411586,
        "service_name": "sparefoot",
        "span_id": 8693937571828318045,
        "trace_id": 10478048417711411586
    }
}

running: False
schema_name_id: 1105
start_time: 2026-04-17 00:13:35
success: True
trace_id: 10478048417711411586

Scan 162156139

duration: 0:00:14.222705

exit_message:

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

id: 162156139

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_closure/2026-04-16/1776388867",
        "key": "raw/sparefoot_facility_closure/2026-04-16/1776388867/facility_closure_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_facility_closure",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 9340360557740344050,
        "service_name": "sparefoot",
        "span_id": 16399753444137214143,
        "trace_id": 9340360557740344050
    }
}

running: False
schema_name_id: 1105
start_time: 2026-04-16 20:23:53
success: True
trace_id: 9340360557740344050

Scan 162138011

duration: 0:00:14.347046

exit_message:

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

id: 162138011

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_closure/2026-04-16/1776366653",
        "key": "raw/sparefoot_facility_closure/2026-04-16/1776366653/facility_closure_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_facility_closure",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 2276460967499794911,
        "service_name": "sparefoot",
        "span_id": 2266596887606994561,
        "trace_id": 2276460967499794911
    }
}

running: False
schema_name_id: 1105
start_time: 2026-04-16 14:14:24
success: True
trace_id: 2276460967499794911

Scan 162122549

duration: 0:00:11.596675

exit_message:

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

id: 162122549

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_closure/2026-04-16/1776348940",
        "key": "raw/sparefoot_facility_closure/2026-04-16/1776348940/facility_closure_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_facility_closure",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 12841351134282076566,
        "service_name": "sparefoot",
        "span_id": 18168526885290784789,
        "trace_id": 12841351134282076566
    }
}

running: False
schema_name_id: 1105
start_time: 2026-04-16 09:15:50
success: True
trace_id: 12841351134282076566

Scan 162107746

duration: 0:00:14.081994

exit_message:

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

id: 162107746

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_closure/2026-04-16/1776315980",
        "key": "raw/sparefoot_facility_closure/2026-04-16/1776315980/facility_closure_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_facility_closure",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 10688217165496384011,
        "service_name": "sparefoot",
        "span_id": 4989838253841616334,
        "trace_id": 10688217165496384011
    }
}

running: False
schema_name_id: 1105
start_time: 2026-04-16 00:06:23
success: True
trace_id: 10688217165496384011

Scan 162100305

duration: 0:00:11.700699

exit_message:

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

id: 162100305

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_closure/2026-04-15/1776302443",
        "key": "raw/sparefoot_facility_closure/2026-04-15/1776302443/facility_closure_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_facility_closure",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 1813770248060485287,
        "service_name": "sparefoot",
        "span_id": 6941115692944764870,
        "trace_id": 1813770248060485287
    }
}

running: False
schema_name_id: 1105
start_time: 2026-04-15 20:20:49
success: True
trace_id: 1813770248060485287

Scan 162081698

duration: 0:00:14.262330

exit_message:

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

id: 162081698

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_closure/2026-04-15/1776280522",
        "key": "raw/sparefoot_facility_closure/2026-04-15/1776280522/facility_closure_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_facility_closure",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 9812437351813250642,
        "service_name": "sparefoot",
        "span_id": 5888010473392448501,
        "trace_id": 9812437351813250642
    }
}

running: False
schema_name_id: 1105
start_time: 2026-04-15 14:15:25
success: True
trace_id: 9812437351813250642

Scan 162064413

duration: 0:00:11.596811

exit_message:

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

id: 162064413

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_closure/2026-04-15/1776260297",
        "key": "raw/sparefoot_facility_closure/2026-04-15/1776260297/facility_closure_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_facility_closure",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 8075608091245731546,
        "service_name": "sparefoot",
        "span_id": 2062996226404874757,
        "trace_id": 8075608091245731546
    }
}

running: False
schema_name_id: 1105
start_time: 2026-04-15 08:39:50
success: True
trace_id: 8075608091245731546

Scan 162051947

duration: 0:00:14.160216

exit_message:

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

id: 162051947

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_closure/2026-04-15/1776229697",
        "key": "raw/sparefoot_facility_closure/2026-04-15/1776229697/facility_closure_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_facility_closure",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 5116977138968202678,
        "service_name": "sparefoot",
        "span_id": 16658714914030637536,
        "trace_id": 5116977138968202678
    }
}

running: False
schema_name_id: 1105
start_time: 2026-04-15 00:08:23
success: True
trace_id: 5116977138968202678

Scan 162044308

duration: 0:00:14.118383

exit_message:

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

id: 162044308

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_closure/2026-04-14/1776216031",
        "key": "raw/sparefoot_facility_closure/2026-04-14/1776216031/facility_closure_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_facility_closure",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 15476076810148096730,
        "service_name": "sparefoot",
        "span_id": 15700879798385848769,
        "trace_id": 15476076810148096730
    }
}

running: False
schema_name_id: 1105
start_time: 2026-04-14 20:20:34
success: True
trace_id: 15476076810148096730

Scan 162026076

duration: 0:00:11.619512

exit_message:

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

id: 162026076

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_closure/2026-04-14/1776193828",
        "key": "raw/sparefoot_facility_closure/2026-04-14/1776193828/facility_closure_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_facility_closure",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 4466727464856437402,
        "service_name": "sparefoot",
        "span_id": 8446806546883445161,
        "trace_id": 4466727464856437402
    }
}

running: False
schema_name_id: 1105
start_time: 2026-04-14 14:10:32
success: True
trace_id: 4466727464856437402

Scan 162010959

duration: 0:00:14.295122

exit_message:

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

id: 162010959

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_closure/2026-04-14/1776175723",
        "key": "raw/sparefoot_facility_closure/2026-04-14/1776175723/facility_closure_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_facility_closure",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 11469380944305803834,
        "service_name": "sparefoot",
        "span_id": 8173406306751196227,
        "trace_id": 11469380944305803834
    }
}

running: False
schema_name_id: 1105
start_time: 2026-04-14 09:09:33
success: True
trace_id: 11469380944305803834

Scan 161996358

duration: 0:00:11.678239

exit_message:

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

id: 161996358

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_closure/2026-04-14/1776143637",
        "key": "raw/sparefoot_facility_closure/2026-04-14/1776143637/facility_closure_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_facility_closure",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 1229570807676572684,
        "service_name": "sparefoot",
        "span_id": 5437091864030681274,
        "trace_id": 1229570807676572684
    }
}

running: False
schema_name_id: 1105
start_time: 2026-04-14 00:14:06
success: True
trace_id: 1229570807676572684

Partitions:

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

Schema:

attributes:

{
    "active": "smallint",
    "closed_date_end": "timestamp",
    "closed_date_start": "timestamp",
    "facility_closure_id": "int",
    "facility_id": "int"
}

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

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_closure`\n(\n `active`  smallint , `closed_date_end`  timestamp , `closed_date_start`  timestamp , `facility_closure_id`  int , `facility_id`  int \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_closure/2026-04-17/1776453005'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_facility_closure`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_facility_closure"
}

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:20:13",
        "disabled": false,
        "format": "raw",
        "id": 1105,
        "is_partitioned": false,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_prod_rds",
            "table": "sparefoot_sparefoot_facility_closure"
        },
        "type": "rds"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "active": "smallint",
            "closed_date_end": "timestamp",
            "closed_date_start": "timestamp",
            "facility_closure_id": "int",
            "facility_id": "int"
        },
        "created": "2026-04-17 14:10:14",
        "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_closure`\n(\n `active`  smallint , `closed_date_end`  timestamp , `closed_date_start`  timestamp , `facility_closure_id`  int , `facility_id`  int \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_closure/2026-04-17/1776453005'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_facility_closure`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_facility_closure"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}