Schema Info

Schema Name: sfdl_stage_rds.sparefoot_sparefoot_supp_unit_data

created: 2022-08-12 10:25:59
disabled: False
format: raw
id: 1349
is_partitioned: False
is_schema_datatyped: False

name:

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

type: rds

Schema Versions: 15

Version 906529

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

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_supp_unit_data/2026-04-17/1776402811
id: 906529
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: 1349
schema_scan_id: 6415095
updated: 2026-04-17 00:13:58

Version 906367

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

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_supp_unit_data/2026-04-16/1776316709
id: 906367
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: 1349
schema_scan_id: 6414604
updated: 2026-04-16 00:19:00

Version 906158

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

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_supp_unit_data/2026-04-15/1776231220
id: 906158
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: 1349
schema_scan_id: 6414122
updated: 2026-04-15 00:34:28

Version 905940

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

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_supp_unit_data/2026-04-14/1776143766
id: 905940
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: 1349
schema_scan_id: 6413609
updated: 2026-04-14 00:16:39

Version 905685

created: 2026-04-13 00:15:00

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_supp_unit_data/2026-04-13/1776057274
id: 905685
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: 1349
schema_scan_id: 6413017
updated: 2026-04-13 00:15:11

Version 905525

created: 2026-04-12 00:18:30

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_supp_unit_data/2026-04-12/1775971089
id: 905525
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: 1349
schema_scan_id: 6412677
updated: 2026-04-12 00:18:41

Version 905303

created: 2026-04-11 00:12:44

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_supp_unit_data/2026-04-11/1775884354
id: 905303
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: 1349
schema_scan_id: 6412275
updated: 2026-04-11 00:12:58

Version 905107

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

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_supp_unit_data/2026-04-10/1775798177
id: 905107
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: 1349
schema_scan_id: 6411792
updated: 2026-04-10 00:16:45

Version 904880

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

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_supp_unit_data/2026-04-09/1775711698
id: 904880
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: 1349
schema_scan_id: 6411267
updated: 2026-04-09 00:15:27

Version 904661

created: 2026-04-08 00:13:33

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_supp_unit_data/2026-04-08/1775625202
id: 904661
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: 1349
schema_scan_id: 6410758
updated: 2026-04-08 00:13:44

Version 904456

created: 2026-04-07 00:16:27

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_supp_unit_data/2026-04-07/1775538964
id: 904456
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: 1349
schema_scan_id: 6410260
updated: 2026-04-07 00:16:41

Version 904248

created: 2026-04-06 00:15:05

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_supp_unit_data/2026-04-06/1775452470
id: 904248
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: 1349
schema_scan_id: 6409721
updated: 2026-04-06 00:15:19

Version 904039

created: 2026-04-05 00:15:53

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_supp_unit_data/2026-04-05/1775366137
id: 904039
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: 1349
schema_scan_id: 6409335
updated: 2026-04-05 00:16:07

Version 903847

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

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_supp_unit_data/2026-04-04/1775279839
id: 903847
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: 1349
schema_scan_id: 6408964
updated: 2026-04-04 00:17:47

Version 903632

created: 2026-04-03 00:18:34

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_supp_unit_data/2026-04-03/1775193488
id: 903632
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: 1349
schema_scan_id: 6408467
updated: 2026-04-03 00:18:46

Schema Scans: 15

Last at 2026-04-17 00:13:44

Scan 6415095

duration: 0:00:14.360511

exit_message:

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

id: 6415095

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_supp_unit_data/2026-04-17/1776402811",
        "key": "raw/sparefoot_supp_unit_data/2026-04-17/1776402811/supp_unit_data_7.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_supp_unit_data",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 283682304022544404,
        "service_name": "sparefoot",
        "span_id": 16755419523891524859,
        "trace_id": 283682304022544404
    }
}

running: False
schema_name_id: 1349
start_time: 2026-04-17 00:13:44
success: True
trace_id: 283682304022544404

Scan 6414604

duration: 0:00:14.224712

exit_message:

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

id: 6414604

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_supp_unit_data/2026-04-16/1776316709",
        "key": "raw/sparefoot_supp_unit_data/2026-04-16/1776316709/supp_unit_data_6.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_supp_unit_data",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 7739116677303382222,
        "service_name": "sparefoot",
        "span_id": 5836089630244434782,
        "trace_id": 7739116677303382222
    }
}

running: False
schema_name_id: 1349
start_time: 2026-04-16 00:18:46
success: True
trace_id: 7739116677303382222

Scan 6414122

duration: 0:00:14.453280

exit_message:

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

id: 6414122

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_supp_unit_data/2026-04-15/1776231220",
        "key": "raw/sparefoot_supp_unit_data/2026-04-15/1776231220/supp_unit_data_6.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_supp_unit_data",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 15820549480267604544,
        "service_name": "sparefoot",
        "span_id": 4380671928014690670,
        "trace_id": 15820549480267604544
    }
}

running: False
schema_name_id: 1349
start_time: 2026-04-15 00:34:13
success: True
trace_id: 15820549480267604544

Scan 6413609

duration: 0:00:11.913883

exit_message:

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

id: 6413609

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_supp_unit_data/2026-04-14/1776143766",
        "key": "raw/sparefoot_supp_unit_data/2026-04-14/1776143766/supp_unit_data_6.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_supp_unit_data",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 18365469568777436433,
        "service_name": "sparefoot",
        "span_id": 17415986468661959365,
        "trace_id": 18365469568777436433
    }
}

running: False
schema_name_id: 1349
start_time: 2026-04-14 00:16:27
success: True
trace_id: 18365469568777436433

Scan 6413017

duration: 0:00:11.840264

exit_message:

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

id: 6413017

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_supp_unit_data/2026-04-13/1776057274",
        "key": "raw/sparefoot_supp_unit_data/2026-04-13/1776057274/supp_unit_data_6.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_supp_unit_data",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 15066669371255319991,
        "service_name": "sparefoot",
        "span_id": 6020109097365659446,
        "trace_id": 15066669371255319991
    }
}

running: False
schema_name_id: 1349
start_time: 2026-04-13 00:14:59
success: True
trace_id: 15066669371255319991

Scan 6412677

duration: 0:00:11.698502

exit_message:

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

id: 6412677

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_supp_unit_data/2026-04-12/1775971089",
        "key": "raw/sparefoot_supp_unit_data/2026-04-12/1775971089/supp_unit_data_6.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_supp_unit_data",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 17714559953900234980,
        "service_name": "sparefoot",
        "span_id": 7120163781431000891,
        "trace_id": 17714559953900234980
    }
}

running: False
schema_name_id: 1349
start_time: 2026-04-12 00:18:30
success: True
trace_id: 17714559953900234980

Scan 6412275

duration: 0:00:14.153175

exit_message:

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

id: 6412275

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_supp_unit_data/2026-04-11/1775884354",
        "key": "raw/sparefoot_supp_unit_data/2026-04-11/1775884354/supp_unit_data_7.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_supp_unit_data",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 10315458896309336448,
        "service_name": "sparefoot",
        "span_id": 7222449551118541386,
        "trace_id": 10315458896309336448
    }
}

running: False
schema_name_id: 1349
start_time: 2026-04-11 00:12:44
success: True
trace_id: 10315458896309336448

Scan 6411792

duration: 0:00:11.621468

exit_message:

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

id: 6411792

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_supp_unit_data/2026-04-10/1775798177",
        "key": "raw/sparefoot_supp_unit_data/2026-04-10/1775798177/supp_unit_data_6.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_supp_unit_data",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 18398458236000824952,
        "service_name": "sparefoot",
        "span_id": 8022454273870823592,
        "trace_id": 18398458236000824952
    }
}

running: False
schema_name_id: 1349
start_time: 2026-04-10 00:16:33
success: True
trace_id: 18398458236000824952

Scan 6411267

duration: 0:00:11.604185

exit_message:

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

id: 6411267

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_supp_unit_data/2026-04-09/1775711698",
        "key": "raw/sparefoot_supp_unit_data/2026-04-09/1775711698/supp_unit_data_6.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_supp_unit_data",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 10700352863179803072,
        "service_name": "sparefoot",
        "span_id": 4088874425767495057,
        "trace_id": 10700352863179803072
    }
}

running: False
schema_name_id: 1349
start_time: 2026-04-09 00:15:15
success: True
trace_id: 10700352863179803072

Scan 6410758

duration: 0:00:11.634021

exit_message:

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

id: 6410758

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_supp_unit_data/2026-04-08/1775625202",
        "key": "raw/sparefoot_supp_unit_data/2026-04-08/1775625202/supp_unit_data_7.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_supp_unit_data",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 4603092777347944083,
        "service_name": "sparefoot",
        "span_id": 2639747435543646551,
        "trace_id": 4603092777347944083
    }
}

running: False
schema_name_id: 1349
start_time: 2026-04-08 00:13:32
success: True
trace_id: 4603092777347944083

Scan 6410260

duration: 0:00:14.066922

exit_message:

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

id: 6410260

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_supp_unit_data/2026-04-07/1775538964",
        "key": "raw/sparefoot_supp_unit_data/2026-04-07/1775538964/supp_unit_data_9.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_supp_unit_data",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 1334412581398399167,
        "service_name": "sparefoot",
        "span_id": 8825776649908176258,
        "trace_id": 1334412581398399167
    }
}

running: False
schema_name_id: 1349
start_time: 2026-04-07 00:16:27
success: True
trace_id: 1334412581398399167

Scan 6409721

duration: 0:00:14.372687

exit_message:

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

id: 6409721

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_supp_unit_data/2026-04-06/1775452470",
        "key": "raw/sparefoot_supp_unit_data/2026-04-06/1775452470/supp_unit_data_6.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_supp_unit_data",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 7818601004154410597,
        "service_name": "sparefoot",
        "span_id": 6368003582409405961,
        "trace_id": 7818601004154410597
    }
}

running: False
schema_name_id: 1349
start_time: 2026-04-06 00:15:04
success: True
trace_id: 7818601004154410597

Scan 6409335

duration: 0:00:14.164322

exit_message:

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

id: 6409335

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_supp_unit_data/2026-04-05/1775366137",
        "key": "raw/sparefoot_supp_unit_data/2026-04-05/1775366137/supp_unit_data_6.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_supp_unit_data",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 10335420168014714606,
        "service_name": "sparefoot",
        "span_id": 3828638143176748825,
        "trace_id": 10335420168014714606
    }
}

running: False
schema_name_id: 1349
start_time: 2026-04-05 00:15:52
success: True
trace_id: 10335420168014714606

Scan 6408964

duration: 0:00:11.664239

exit_message:

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

id: 6408964

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_supp_unit_data/2026-04-04/1775279839",
        "key": "raw/sparefoot_supp_unit_data/2026-04-04/1775279839/supp_unit_data_6.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_supp_unit_data",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 16554988485172108565,
        "service_name": "sparefoot",
        "span_id": 13244981949524401474,
        "trace_id": 16554988485172108565
    }
}

running: False
schema_name_id: 1349
start_time: 2026-04-04 00:17:35
success: True
trace_id: 16554988485172108565

Scan 6408467

duration: 0:00:11.744146

exit_message:

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

id: 6408467

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_supp_unit_data/2026-04-03/1775193488",
        "key": "raw/sparefoot_supp_unit_data/2026-04-03/1775193488/supp_unit_data_6.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_supp_unit_data",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 8105503400222357992,
        "service_name": "sparefoot",
        "span_id": 15894001606094037682,
        "trace_id": 8105503400222357992
    }
}

running: False
schema_name_id: 1349
start_time: 2026-04-03 00:18:34
success: True
trace_id: 8105503400222357992

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 00:13:45

ddl:

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

Server:

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

Raw:

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