Schema Info

Schema Name: sfdl_prod_rds.sparefoot_sparefoot_supp_unit_data

created: 2022-08-18 17:27:33
disabled: False
format: raw
id: 1143
is_partitioned: False
is_schema_datatyped: False

name:

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

type: rds

Schema Versions: 15

Version 1718418

created: 2026-04-17 14:19:42

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_supp_unit_data/2026-04-17/1776453574
id: 1718418
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1143
schema_scan_id: 162194091
updated: 2026-04-17 14:19:53

Version 1718194

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

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_supp_unit_data/2026-04-17/1776435490
id: 1718194
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1143
schema_scan_id: 162178280
updated: 2026-04-17 09:18:31

Version 1717481

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

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_supp_unit_data/2026-04-17/1776403172
id: 1717481
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1143
schema_scan_id: 162163689
updated: 2026-04-17 00:20:00

Version 1717340

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

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_supp_unit_data/2026-04-16/1776388783
id: 1717340
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1143
schema_scan_id: 162156128
updated: 2026-04-16 20:23:36

Version 1717193

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

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_supp_unit_data/2026-04-16/1776367307
id: 1717193
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1143
schema_scan_id: 162138159
updated: 2026-04-16 14:22:11

Version 1717007

created: 2026-04-16 09:16:42

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_supp_unit_data/2026-04-16/1776348992
id: 1717007
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1143
schema_scan_id: 162122568
updated: 2026-04-16 09:16:56

Version 1716244

created: 2026-04-16 00:21:56

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_supp_unit_data/2026-04-16/1776316908
id: 1716244
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1143
schema_scan_id: 162107836
updated: 2026-04-16 00:22:10

Version 1716137

created: 2026-04-15 20:32:16

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_supp_unit_data/2026-04-15/1776303129
id: 1716137
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1143
schema_scan_id: 162100375
updated: 2026-04-15 20:32:28

Version 1716000

created: 2026-04-15 14:24:55

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_supp_unit_data/2026-04-15/1776281075
id: 1716000
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1143
schema_scan_id: 162081841
updated: 2026-04-15 14:25:06

Version 1715798

created: 2026-04-15 08:47:17

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_supp_unit_data/2026-04-15/1776260797
id: 1715798
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1143
schema_scan_id: 162064648
updated: 2026-04-15 08:47:28

Version 1715032

created: 2026-04-15 00:21:00

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_supp_unit_data/2026-04-15/1776230452
id: 1715032
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1143
schema_scan_id: 162052003
updated: 2026-04-15 00:21:11

Version 1714925

created: 2026-04-14 20:29:00

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_supp_unit_data/2026-04-14/1776216531
id: 1714925
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1143
schema_scan_id: 162044359
updated: 2026-04-14 20:29:14

Version 1714764

created: 2026-04-14 14:20:26

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_supp_unit_data/2026-04-14/1776194248
id: 1714764
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1143
schema_scan_id: 162026201
updated: 2026-04-14 14:20:40

Version 1714607

created: 2026-04-14 09:14:54

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_supp_unit_data/2026-04-14/1776175828
id: 1714607
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1143
schema_scan_id: 162010985
updated: 2026-04-14 09:15:06

Version 1713840

created: 2026-04-14 00:16:43

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_supp_unit_data/2026-04-14/1776143769
id: 1713840
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1143
schema_scan_id: 161996385
updated: 2026-04-14 00:16:56

Schema Scans: 15

Last at 2026-04-17 14:19:42

Scan 162194091

duration: 0:00:11.631195

exit_message:

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

id: 162194091

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_unit_data/2026-04-17/1776453574",
        "key": "raw/sparefoot_supp_unit_data/2026-04-17/1776453574/supp_unit_data_6.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_supp_unit_data",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 6354756481549151131,
        "service_name": "sparefoot",
        "span_id": 15223215201218368535,
        "trace_id": 6354756481549151131
    }
}

running: False
schema_name_id: 1143
start_time: 2026-04-17 14:19:42
success: True
trace_id: 6354756481549151131

Scan 162178280

duration: 0:00:11.613745

exit_message:

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

id: 162178280

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_unit_data/2026-04-17/1776435490",
        "key": "raw/sparefoot_supp_unit_data/2026-04-17/1776435490/supp_unit_data_6.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_supp_unit_data",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 8486776354113850641,
        "service_name": "sparefoot",
        "span_id": 15879091743193029392,
        "trace_id": 8486776354113850641
    }
}

running: False
schema_name_id: 1143
start_time: 2026-04-17 09:18:19
success: True
trace_id: 8486776354113850641

Scan 162163689

duration: 0:00:11.695478

exit_message:

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

id: 162163689

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_unit_data/2026-04-17/1776403172",
        "key": "raw/sparefoot_supp_unit_data/2026-04-17/1776403172/supp_unit_data_6.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_supp_unit_data",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 4137893904676752563,
        "service_name": "sparefoot",
        "span_id": 3956363252168088063,
        "trace_id": 4137893904676752563
    }
}

running: False
schema_name_id: 1143
start_time: 2026-04-17 00:19:48
success: True
trace_id: 4137893904676752563

Scan 162156128

duration: 0:00:11.684982

exit_message:

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

id: 162156128

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_unit_data/2026-04-16/1776388783",
        "key": "raw/sparefoot_supp_unit_data/2026-04-16/1776388783/supp_unit_data_6.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_supp_unit_data",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 5136927470564055621,
        "service_name": "sparefoot",
        "span_id": 4476342772130812816,
        "trace_id": 5136927470564055621
    }
}

running: False
schema_name_id: 1143
start_time: 2026-04-16 20:23:24
success: True
trace_id: 5136927470564055621

Scan 162138159

duration: 0:00:14.268847

exit_message:

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

id: 162138159

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_unit_data/2026-04-16/1776367307",
        "key": "raw/sparefoot_supp_unit_data/2026-04-16/1776367307/supp_unit_data_6.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_supp_unit_data",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 15992124506886020489,
        "service_name": "sparefoot",
        "span_id": 3150424138052730322,
        "trace_id": 15992124506886020489
    }
}

running: False
schema_name_id: 1143
start_time: 2026-04-16 14:21:57
success: True
trace_id: 15992124506886020489

Scan 162122568

duration: 0:00:14.228355

exit_message:

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

id: 162122568

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_unit_data/2026-04-16/1776348992",
        "key": "raw/sparefoot_supp_unit_data/2026-04-16/1776348992/supp_unit_data_6.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_supp_unit_data",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 1899598509915446011,
        "service_name": "sparefoot",
        "span_id": 14086256764183765198,
        "trace_id": 1899598509915446011
    }
}

running: False
schema_name_id: 1143
start_time: 2026-04-16 09:16:42
success: True
trace_id: 1899598509915446011

Scan 162107836

duration: 0:00:14.379786

exit_message:

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

id: 162107836

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_unit_data/2026-04-16/1776316908",
        "key": "raw/sparefoot_supp_unit_data/2026-04-16/1776316908/supp_unit_data_6.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_supp_unit_data",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 9716011142210997533,
        "service_name": "sparefoot",
        "span_id": 18375133424148967949,
        "trace_id": 9716011142210997533
    }
}

running: False
schema_name_id: 1143
start_time: 2026-04-16 00:21:55
success: True
trace_id: 9716011142210997533

Scan 162100375

duration: 0:00:11.728030

exit_message:

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

id: 162100375

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_unit_data/2026-04-15/1776303129",
        "key": "raw/sparefoot_supp_unit_data/2026-04-15/1776303129/supp_unit_data_6.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_supp_unit_data",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 10792939266830334695,
        "service_name": "sparefoot",
        "span_id": 14154353576463469164,
        "trace_id": 10792939266830334695
    }
}

running: False
schema_name_id: 1143
start_time: 2026-04-15 20:32:16
success: True
trace_id: 10792939266830334695

Scan 162081841

duration: 0:00:11.838749

exit_message:

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

id: 162081841

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_unit_data/2026-04-15/1776281075",
        "key": "raw/sparefoot_supp_unit_data/2026-04-15/1776281075/supp_unit_data_6.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_supp_unit_data",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 8313583541397929404,
        "service_name": "sparefoot",
        "span_id": 4917610081045472894,
        "trace_id": 8313583541397929404
    }
}

running: False
schema_name_id: 1143
start_time: 2026-04-15 14:24:54
success: True
trace_id: 8313583541397929404

Scan 162064648

duration: 0:00:11.761126

exit_message:

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

id: 162064648

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_unit_data/2026-04-15/1776260797",
        "key": "raw/sparefoot_supp_unit_data/2026-04-15/1776260797/supp_unit_data_6.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_supp_unit_data",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 15353361998038198119,
        "service_name": "sparefoot",
        "span_id": 15738638432116620944,
        "trace_id": 15353361998038198119
    }
}

running: False
schema_name_id: 1143
start_time: 2026-04-15 08:47:16
success: True
trace_id: 15353361998038198119

Scan 162052003

duration: 0:00:11.629126

exit_message:

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

id: 162052003

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_unit_data/2026-04-15/1776230452",
        "key": "raw/sparefoot_supp_unit_data/2026-04-15/1776230452/supp_unit_data_6.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_supp_unit_data",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 8147412474162052195,
        "service_name": "sparefoot",
        "span_id": 18372097182655554102,
        "trace_id": 8147412474162052195
    }
}

running: False
schema_name_id: 1143
start_time: 2026-04-15 00:20:59
success: True
trace_id: 8147412474162052195

Scan 162044359

duration: 0:00:14.247315

exit_message:

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

id: 162044359

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_unit_data/2026-04-14/1776216531",
        "key": "raw/sparefoot_supp_unit_data/2026-04-14/1776216531/supp_unit_data_6.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_supp_unit_data",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 14126192339866372397,
        "service_name": "sparefoot",
        "span_id": 3514852685550985831,
        "trace_id": 14126192339866372397
    }
}

running: False
schema_name_id: 1143
start_time: 2026-04-14 20:29:00
success: True
trace_id: 14126192339866372397

Scan 162026201

duration: 0:00:14.356831

exit_message:

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

id: 162026201

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_unit_data/2026-04-14/1776194248",
        "key": "raw/sparefoot_supp_unit_data/2026-04-14/1776194248/supp_unit_data_6.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_supp_unit_data",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 16130948923898059330,
        "service_name": "sparefoot",
        "span_id": 9901669688142285975,
        "trace_id": 16130948923898059330
    }
}

running: False
schema_name_id: 1143
start_time: 2026-04-14 14:20:25
success: True
trace_id: 16130948923898059330

Scan 162010985

duration: 0:00:11.686849

exit_message:

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

id: 162010985

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_unit_data/2026-04-14/1776175828",
        "key": "raw/sparefoot_supp_unit_data/2026-04-14/1776175828/supp_unit_data_6.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_supp_unit_data",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 16661242480103457353,
        "service_name": "sparefoot",
        "span_id": 17101677697628046581,
        "trace_id": 16661242480103457353
    }
}

running: False
schema_name_id: 1143
start_time: 2026-04-14 09:14:54
success: True
trace_id: 16661242480103457353

Scan 161996385

duration: 0:00:14.162465

exit_message:

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

id: 161996385

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_unit_data/2026-04-14/1776143769",
        "key": "raw/sparefoot_supp_unit_data/2026-04-14/1776143769/supp_unit_data_6.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_supp_unit_data",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 2945146455398585391,
        "service_name": "sparefoot",
        "span_id": 939140853857537438,
        "trace_id": 2945146455398585391
    }
}

running: False
schema_name_id: 1143
start_time: 2026-04-14 00:16:42
success: True
trace_id: 2945146455398585391

Partitions:

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

Schema:

attributes:

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

created: 2026-04-17 14:19:42

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