Schema Info

Schema Name: sfdl_prod_rds.sparefoot_sparefoot_supp_facility_data

created: 2022-08-18 17:15:32
disabled: False
format: raw
id: 1084
is_partitioned: False
is_schema_datatyped: False

name:

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

type: rds

Schema Versions: 15

Version 1718387

created: 2026-04-17 14:13:41

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_supp_facility_data`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_supp_facility_data`\n(\n `attribute`  string , `facility_id`  int , `has_attribute`  smallint , `value`  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_supp_facility_data/2026-04-17/1776453217'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_supp_facility_data"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_supp_facility_data/2026-04-17/1776453217
id: 1718387
processed: 1

raw_data:

{
    "attribute": "string",
    "facility_id": "int32",
    "has_attribute": "int16",
    "value": "string"
}

schema_attributes:

{
    "attribute": "string",
    "facility_id": "int",
    "has_attribute": "smallint",
    "value": "string"
}

schema_name_id: 1084
schema_scan_id: 162193991
updated: 2026-04-17 14:13:55

Version 1718184

created: 2026-04-17 09:10:47

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_supp_facility_data`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_supp_facility_data`\n(\n `attribute`  string , `facility_id`  int , `has_attribute`  smallint , `value`  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_supp_facility_data/2026-04-17/1776435044'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_supp_facility_data"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_supp_facility_data/2026-04-17/1776435044
id: 1718184
processed: 1

raw_data:

{
    "attribute": "string",
    "facility_id": "int32",
    "has_attribute": "int16",
    "value": "string"
}

schema_attributes:

{
    "attribute": "string",
    "facility_id": "int",
    "has_attribute": "smallint",
    "value": "string"
}

schema_name_id: 1084
schema_scan_id: 162178198
updated: 2026-04-17 09:11:01

Version 1717441

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_supp_facility_data`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_supp_facility_data`\n(\n `attribute`  string , `facility_id`  int , `has_attribute`  smallint , `value`  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_supp_facility_data/2026-04-17/1776402430'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_supp_facility_data"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_supp_facility_data/2026-04-17/1776402430
id: 1717441
processed: 1

raw_data:

{
    "attribute": "string",
    "facility_id": "int32",
    "has_attribute": "int16",
    "value": "string"
}

schema_attributes:

{
    "attribute": "string",
    "facility_id": "int",
    "has_attribute": "smallint",
    "value": "string"
}

schema_name_id: 1084
schema_scan_id: 162163574
updated: 2026-04-17 00:07:31

Version 1717336

created: 2026-04-16 20:18:59

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_supp_facility_data`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_supp_facility_data`\n(\n `attribute`  string , `facility_id`  int , `has_attribute`  smallint , `value`  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_supp_facility_data/2026-04-16/1776388560'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_supp_facility_data"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_supp_facility_data/2026-04-16/1776388560
id: 1717336
processed: 1

raw_data:

{
    "attribute": "string",
    "facility_id": "int32",
    "has_attribute": "int16",
    "value": "string"
}

schema_attributes:

{
    "attribute": "string",
    "facility_id": "int",
    "has_attribute": "smallint",
    "value": "string"
}

schema_name_id: 1084
schema_scan_id: 162156088
updated: 2026-04-16 20:19:13

Version 1717165

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_supp_facility_data`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_supp_facility_data`\n(\n `attribute`  string , `facility_id`  int , `has_attribute`  smallint , `value`  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_supp_facility_data/2026-04-16/1776366939'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_supp_facility_data"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_supp_facility_data/2026-04-16/1776366939
id: 1717165
processed: 1

raw_data:

{
    "attribute": "string",
    "facility_id": "int32",
    "has_attribute": "int16",
    "value": "string"
}

schema_attributes:

{
    "attribute": "string",
    "facility_id": "int",
    "has_attribute": "smallint",
    "value": "string"
}

schema_name_id: 1084
schema_scan_id: 162138058
updated: 2026-04-16 14:15:59

Version 1716972

created: 2026-04-16 09:09:01

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_supp_facility_data`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_supp_facility_data`\n(\n `attribute`  string , `facility_id`  int , `has_attribute`  smallint , `value`  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_supp_facility_data/2026-04-16/1776348537'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_supp_facility_data"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_supp_facility_data/2026-04-16/1776348537
id: 1716972
processed: 1

raw_data:

{
    "attribute": "string",
    "facility_id": "int32",
    "has_attribute": "int16",
    "value": "string"
}

schema_attributes:

{
    "attribute": "string",
    "facility_id": "int",
    "has_attribute": "smallint",
    "value": "string"
}

schema_name_id: 1084
schema_scan_id: 162122493
updated: 2026-04-16 09:09:12

Version 1716211

created: 2026-04-16 00:09:46

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_supp_facility_data`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_supp_facility_data`\n(\n `attribute`  string , `facility_id`  int , `has_attribute`  smallint , `value`  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_supp_facility_data/2026-04-16/1776316151'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_supp_facility_data"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_supp_facility_data/2026-04-16/1776316151
id: 1716211
processed: 1

raw_data:

{
    "attribute": "string",
    "facility_id": "int32",
    "has_attribute": "int16",
    "value": "string"
}

schema_attributes:

{
    "attribute": "string",
    "facility_id": "int",
    "has_attribute": "smallint",
    "value": "string"
}

schema_name_id: 1084
schema_scan_id: 162107787
updated: 2026-04-16 00:09:59

Version 1716093

created: 2026-04-15 20:20:43

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_supp_facility_data`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_supp_facility_data`\n(\n `attribute`  string , `facility_id`  int , `has_attribute`  smallint , `value`  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_supp_facility_data/2026-04-15/1776302438'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_supp_facility_data"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_supp_facility_data/2026-04-15/1776302438
id: 1716093
processed: 1

raw_data:

{
    "attribute": "string",
    "facility_id": "int32",
    "has_attribute": "int16",
    "value": "string"
}

schema_attributes:

{
    "attribute": "string",
    "facility_id": "int",
    "has_attribute": "smallint",
    "value": "string"
}

schema_name_id: 1084
schema_scan_id: 162100304
updated: 2026-04-15 20:20:57

Version 1715964

created: 2026-04-15 14:15:49

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_supp_facility_data`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_supp_facility_data`\n(\n `attribute`  string , `facility_id`  int , `has_attribute`  smallint , `value`  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_supp_facility_data/2026-04-15/1776280545'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_supp_facility_data"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_supp_facility_data/2026-04-15/1776280545
id: 1715964
processed: 1

raw_data:

{
    "attribute": "string",
    "facility_id": "int32",
    "has_attribute": "int16",
    "value": "string"
}

schema_attributes:

{
    "attribute": "string",
    "facility_id": "int",
    "has_attribute": "smallint",
    "value": "string"
}

schema_name_id: 1084
schema_scan_id: 162081705
updated: 2026-04-15 14:16:02

Version 1715768

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_supp_facility_data`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_supp_facility_data`\n(\n `attribute`  string , `facility_id`  int , `has_attribute`  smallint , `value`  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_supp_facility_data/2026-04-15/1776260528'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_supp_facility_data"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_supp_facility_data/2026-04-15/1776260528
id: 1715768
processed: 1

raw_data:

{
    "attribute": "string",
    "facility_id": "int32",
    "has_attribute": "int16",
    "value": "string"
}

schema_attributes:

{
    "attribute": "string",
    "facility_id": "int",
    "has_attribute": "smallint",
    "value": "string"
}

schema_name_id: 1084
schema_scan_id: 162064493
updated: 2026-04-15 08:42:26

Version 1715016

created: 2026-04-15 00:16:10

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_supp_facility_data`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_supp_facility_data`\n(\n `attribute`  string , `facility_id`  int , `has_attribute`  smallint , `value`  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_supp_facility_data/2026-04-15/1776230167'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_supp_facility_data"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_supp_facility_data/2026-04-15/1776230167
id: 1715016
processed: 1

raw_data:

{
    "attribute": "string",
    "facility_id": "int32",
    "has_attribute": "int16",
    "value": "string"
}

schema_attributes:

{
    "attribute": "string",
    "facility_id": "int",
    "has_attribute": "smallint",
    "value": "string"
}

schema_name_id: 1084
schema_scan_id: 162051977
updated: 2026-04-15 00:16:21

Version 1714901

created: 2026-04-14 20:20:12

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_supp_facility_data`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_supp_facility_data`\n(\n `attribute`  string , `facility_id`  int , `has_attribute`  smallint , `value`  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_supp_facility_data/2026-04-14/1776215998'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_supp_facility_data"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_supp_facility_data/2026-04-14/1776215998
id: 1714901
processed: 1

raw_data:

{
    "attribute": "string",
    "facility_id": "int32",
    "has_attribute": "int16",
    "value": "string"
}

schema_attributes:

{
    "attribute": "string",
    "facility_id": "int",
    "has_attribute": "smallint",
    "value": "string"
}

schema_name_id: 1084
schema_scan_id: 162044303
updated: 2026-04-14 20:20:23

Version 1714718

created: 2026-04-14 14:13:44

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_supp_facility_data`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_supp_facility_data`\n(\n `attribute`  string , `facility_id`  int , `has_attribute`  smallint , `value`  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_supp_facility_data/2026-04-14/1776194014'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_supp_facility_data"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_supp_facility_data/2026-04-14/1776194014
id: 1714718
processed: 1

raw_data:

{
    "attribute": "string",
    "facility_id": "int32",
    "has_attribute": "int16",
    "value": "string"
}

schema_attributes:

{
    "attribute": "string",
    "facility_id": "int",
    "has_attribute": "smallint",
    "value": "string"
}

schema_name_id: 1084
schema_scan_id: 162026096
updated: 2026-04-14 14:13:55

Version 1714599

created: 2026-04-14 09:11:32

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_supp_facility_data`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_supp_facility_data`\n(\n `attribute`  string , `facility_id`  int , `has_attribute`  smallint , `value`  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_supp_facility_data/2026-04-14/1776175829'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_supp_facility_data"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_supp_facility_data/2026-04-14/1776175829
id: 1714599
processed: 1

raw_data:

{
    "attribute": "string",
    "facility_id": "int32",
    "has_attribute": "int16",
    "value": "string"
}

schema_attributes:

{
    "attribute": "string",
    "facility_id": "int",
    "has_attribute": "smallint",
    "value": "string"
}

schema_name_id: 1084
schema_scan_id: 162010970
updated: 2026-04-14 09:11:43

Version 1713825

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_supp_facility_data`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_supp_facility_data`\n(\n `attribute`  string , `facility_id`  int , `has_attribute`  smallint , `value`  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_supp_facility_data/2026-04-14/1776143690'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_supp_facility_data"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_supp_facility_data/2026-04-14/1776143690
id: 1713825
processed: 1

raw_data:

{
    "attribute": "string",
    "facility_id": "int32",
    "has_attribute": "int16",
    "value": "string"
}

schema_attributes:

{
    "attribute": "string",
    "facility_id": "int",
    "has_attribute": "smallint",
    "value": "string"
}

schema_name_id: 1084
schema_scan_id: 161996367
updated: 2026-04-14 00:15:23

Schema Scans: 15

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

Scan 162193991

duration: 0:00:14.190601

exit_message:

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

id: 162193991

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_supp_facility_data/2026-04-17/1776453217",
        "key": "raw/sparefoot_supp_facility_data/2026-04-17/1776453217/supp_facility_data_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_supp_facility_data",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 7672857780500714717,
        "service_name": "sparefoot",
        "span_id": 9483606275301964439,
        "trace_id": 7672857780500714717
    }
}

running: False
schema_name_id: 1084
start_time: 2026-04-17 14:13:40
success: True
trace_id: 7672857780500714717

Scan 162178198

duration: 0:00:14.137878

exit_message:

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

id: 162178198

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_supp_facility_data/2026-04-17/1776435044",
        "key": "raw/sparefoot_supp_facility_data/2026-04-17/1776435044/supp_facility_data_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_supp_facility_data",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 9520367245797626235,
        "service_name": "sparefoot",
        "span_id": 13412110665532286336,
        "trace_id": 9520367245797626235
    }
}

running: False
schema_name_id: 1084
start_time: 2026-04-17 09:10:46
success: True
trace_id: 9520367245797626235

Scan 162163574

duration: 0:00:11.564473

exit_message:

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

id: 162163574

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_supp_facility_data/2026-04-17/1776402430",
        "key": "raw/sparefoot_supp_facility_data/2026-04-17/1776402430/supp_facility_data_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_supp_facility_data",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 8980559922305710451,
        "service_name": "sparefoot",
        "span_id": 10339178290185032053,
        "trace_id": 8980559922305710451
    }
}

running: False
schema_name_id: 1084
start_time: 2026-04-17 00:07:19
success: True
trace_id: 8980559922305710451

Scan 162156088

duration: 0:00:14.168019

exit_message:

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

id: 162156088

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_supp_facility_data/2026-04-16/1776388560",
        "key": "raw/sparefoot_supp_facility_data/2026-04-16/1776388560/supp_facility_data_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_supp_facility_data",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 3759001589579370126,
        "service_name": "sparefoot",
        "span_id": 17056046306566718954,
        "trace_id": 3759001589579370126
    }
}

running: False
schema_name_id: 1084
start_time: 2026-04-16 20:18:59
success: True
trace_id: 3759001589579370126

Scan 162138058

duration: 0:00:14.197418

exit_message:

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

id: 162138058

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_supp_facility_data/2026-04-16/1776366939",
        "key": "raw/sparefoot_supp_facility_data/2026-04-16/1776366939/supp_facility_data_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_supp_facility_data",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 9934197630214720059,
        "service_name": "sparefoot",
        "span_id": 11531935683921892158,
        "trace_id": 9934197630214720059
    }
}

running: False
schema_name_id: 1084
start_time: 2026-04-16 14:15:45
success: True
trace_id: 9934197630214720059

Scan 162122493

duration: 0:00:11.718057

exit_message:

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

id: 162122493

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_supp_facility_data/2026-04-16/1776348537",
        "key": "raw/sparefoot_supp_facility_data/2026-04-16/1776348537/supp_facility_data_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_supp_facility_data",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 6903065061219596586,
        "service_name": "sparefoot",
        "span_id": 17994815908200061245,
        "trace_id": 6903065061219596586
    }
}

running: False
schema_name_id: 1084
start_time: 2026-04-16 09:09:00
success: True
trace_id: 6903065061219596586

Scan 162107787

duration: 0:00:14.103128

exit_message:

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

id: 162107787

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_supp_facility_data/2026-04-16/1776316151",
        "key": "raw/sparefoot_supp_facility_data/2026-04-16/1776316151/supp_facility_data_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_supp_facility_data",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 2549186521132255170,
        "service_name": "sparefoot",
        "span_id": 16902722627589122142,
        "trace_id": 2549186521132255170
    }
}

running: False
schema_name_id: 1084
start_time: 2026-04-16 00:09:45
success: True
trace_id: 2549186521132255170

Scan 162100304

duration: 0:00:14.086596

exit_message:

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

id: 162100304

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_supp_facility_data/2026-04-15/1776302438",
        "key": "raw/sparefoot_supp_facility_data/2026-04-15/1776302438/supp_facility_data_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_supp_facility_data",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 13316071477775537761,
        "service_name": "sparefoot",
        "span_id": 10886137399874937297,
        "trace_id": 13316071477775537761
    }
}

running: False
schema_name_id: 1084
start_time: 2026-04-15 20:20:43
success: True
trace_id: 13316071477775537761

Scan 162081705

duration: 0:00:14.113801

exit_message:

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

id: 162081705

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_supp_facility_data/2026-04-15/1776280545",
        "key": "raw/sparefoot_supp_facility_data/2026-04-15/1776280545/supp_facility_data_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_supp_facility_data",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 11331752050689971609,
        "service_name": "sparefoot",
        "span_id": 18344572434598870735,
        "trace_id": 11331752050689971609
    }
}

running: False
schema_name_id: 1084
start_time: 2026-04-15 14:15:48
success: True
trace_id: 11331752050689971609

Scan 162064493

duration: 0:00:11.646481

exit_message:

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

id: 162064493

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_supp_facility_data/2026-04-15/1776260528",
        "key": "raw/sparefoot_supp_facility_data/2026-04-15/1776260528/supp_facility_data_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_supp_facility_data",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 8109295309905682836,
        "service_name": "sparefoot",
        "span_id": 9984450665406286508,
        "trace_id": 8109295309905682836
    }
}

running: False
schema_name_id: 1084
start_time: 2026-04-15 08:42:15
success: True
trace_id: 8109295309905682836

Scan 162051977

duration: 0:00:11.758624

exit_message:

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

id: 162051977

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_supp_facility_data/2026-04-15/1776230167",
        "key": "raw/sparefoot_supp_facility_data/2026-04-15/1776230167/supp_facility_data_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_supp_facility_data",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 8610197181209862542,
        "service_name": "sparefoot",
        "span_id": 12214152228414232096,
        "trace_id": 8610197181209862542
    }
}

running: False
schema_name_id: 1084
start_time: 2026-04-15 00:16:10
success: True
trace_id: 8610197181209862542

Scan 162044303

duration: 0:00:11.768163

exit_message:

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

id: 162044303

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_supp_facility_data/2026-04-14/1776215998",
        "key": "raw/sparefoot_supp_facility_data/2026-04-14/1776215998/supp_facility_data_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_supp_facility_data",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 9548016366082108301,
        "service_name": "sparefoot",
        "span_id": 11966931094798989379,
        "trace_id": 9548016366082108301
    }
}

running: False
schema_name_id: 1084
start_time: 2026-04-14 20:20:11
success: True
trace_id: 9548016366082108301

Scan 162026096

duration: 0:00:11.678157

exit_message:

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

id: 162026096

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_supp_facility_data/2026-04-14/1776194014",
        "key": "raw/sparefoot_supp_facility_data/2026-04-14/1776194014/supp_facility_data_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_supp_facility_data",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 10857478825709293788,
        "service_name": "sparefoot",
        "span_id": 16010629056636907320,
        "trace_id": 10857478825709293788
    }
}

running: False
schema_name_id: 1084
start_time: 2026-04-14 14:13:44
success: True
trace_id: 10857478825709293788

Scan 162010970

duration: 0:00:11.725855

exit_message:

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

id: 162010970

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_supp_facility_data/2026-04-14/1776175829",
        "key": "raw/sparefoot_supp_facility_data/2026-04-14/1776175829/supp_facility_data_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_supp_facility_data",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 4223633426442965962,
        "service_name": "sparefoot",
        "span_id": 15232913888143898148,
        "trace_id": 4223633426442965962
    }
}

running: False
schema_name_id: 1084
start_time: 2026-04-14 09:11:32
success: True
trace_id: 4223633426442965962

Scan 161996367

duration: 0:00:14.209760

exit_message:

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

id: 161996367

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_supp_facility_data/2026-04-14/1776143690",
        "key": "raw/sparefoot_supp_facility_data/2026-04-14/1776143690/supp_facility_data_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_supp_facility_data",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 15529210873834481558,
        "service_name": "sparefoot",
        "span_id": 13545066066405392925,
        "trace_id": 15529210873834481558
    }
}

running: False
schema_name_id: 1084
start_time: 2026-04-14 00:15:08
success: True
trace_id: 15529210873834481558

Partitions:

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

Schema:

attributes:

{
    "attribute": "string",
    "facility_id": "int",
    "has_attribute": "smallint",
    "value": "string"
}

created: 2026-04-17 14:13:41

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_supp_facility_data`\n(\n `attribute`  string , `facility_id`  int , `has_attribute`  smallint , `value`  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_supp_facility_data/2026-04-17/1776453217'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_supp_facility_data`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_supp_facility_data"
}

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:15:32",
        "disabled": false,
        "format": "raw",
        "id": 1084,
        "is_partitioned": false,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_prod_rds",
            "table": "sparefoot_sparefoot_supp_facility_data"
        },
        "type": "rds"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "attribute": "string",
            "facility_id": "int",
            "has_attribute": "smallint",
            "value": "string"
        },
        "created": "2026-04-17 14:13:41",
        "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_supp_facility_data`\n(\n `attribute`  string , `facility_id`  int , `has_attribute`  smallint , `value`  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_supp_facility_data/2026-04-17/1776453217'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_supp_facility_data`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_supp_facility_data"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}