Schema Info

Schema Name: sfdl_stage_rds.sparefoot_sparefoot_supp_account_data

created: 2022-08-12 10:29:32
disabled: False
format: raw
id: 1357
is_partitioned: False
is_schema_datatyped: False

name:

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

type: rds

Schema Versions: 15

Version 906551

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_supp_account_data`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_supp_account_data`\n(\n `account_id`  int , `attribute`  string , `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-stage/raw/sparefoot_supp_account_data/2026-04-17/1776403135'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_supp_account_data"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_supp_account_data/2026-04-17/1776403135
id: 906551
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1357
schema_scan_id: 6415119
updated: 2026-04-17 00:19:20

Version 906340

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_supp_account_data`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_supp_account_data`\n(\n `account_id`  int , `attribute`  string , `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-stage/raw/sparefoot_supp_account_data/2026-04-16/1776316226'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_supp_account_data"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_supp_account_data/2026-04-16/1776316226
id: 906340
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1357
schema_scan_id: 6414575
updated: 2026-04-16 00:10:43

Version 906135

created: 2026-04-15 00:25:04

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_supp_account_data`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_supp_account_data`\n(\n `account_id`  int , `attribute`  string , `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-stage/raw/sparefoot_supp_account_data/2026-04-15/1776230687'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_supp_account_data"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_supp_account_data/2026-04-15/1776230687
id: 906135
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1357
schema_scan_id: 6414099
updated: 2026-04-15 00:25:18

Version 905903

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_supp_account_data`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_supp_account_data`\n(\n `account_id`  int , `attribute`  string , `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-stage/raw/sparefoot_supp_account_data/2026-04-14/1776143448'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_supp_account_data"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_supp_account_data/2026-04-14/1776143448
id: 905903
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1357
schema_scan_id: 6413569
updated: 2026-04-14 00:11:06

Version 905662

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_supp_account_data`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_supp_account_data`\n(\n `account_id`  int , `attribute`  string , `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-stage/raw/sparefoot_supp_account_data/2026-04-13/1776056934'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_supp_account_data"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_supp_account_data/2026-04-13/1776056934
id: 905662
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1357
schema_scan_id: 6412990
updated: 2026-04-13 00:09:08

Version 905503

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_supp_account_data`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_supp_account_data`\n(\n `account_id`  int , `attribute`  string , `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-stage/raw/sparefoot_supp_account_data/2026-04-12/1775970682'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_supp_account_data"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_supp_account_data/2026-04-12/1775970682
id: 905503
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1357
schema_scan_id: 6412655
updated: 2026-04-12 00:11:36

Version 905273

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_supp_account_data`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_supp_account_data`\n(\n `account_id`  int , `attribute`  string , `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-stage/raw/sparefoot_supp_account_data/2026-04-11/1775884119'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_supp_account_data"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_supp_account_data/2026-04-11/1775884119
id: 905273
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1357
schema_scan_id: 6412244
updated: 2026-04-11 00:08:58

Version 905071

created: 2026-04-10 00:08:42

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_supp_account_data`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_supp_account_data`\n(\n `account_id`  int , `attribute`  string , `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-stage/raw/sparefoot_supp_account_data/2026-04-10/1775797700'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_supp_account_data"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_supp_account_data/2026-04-10/1775797700
id: 905071
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1357
schema_scan_id: 6411752
updated: 2026-04-10 00:08:56

Version 904830

created: 2026-04-09 00:08:45

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_supp_account_data`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_supp_account_data`\n(\n `account_id`  int , `attribute`  string , `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-stage/raw/sparefoot_supp_account_data/2026-04-09/1775711321'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_supp_account_data"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_supp_account_data/2026-04-09/1775711321
id: 904830
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1357
schema_scan_id: 6411213
updated: 2026-04-09 00:08:56

Version 904656

created: 2026-04-08 00:12:48

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_supp_account_data`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_supp_account_data`\n(\n `account_id`  int , `attribute`  string , `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-stage/raw/sparefoot_supp_account_data/2026-04-08/1775625164'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_supp_account_data"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_supp_account_data/2026-04-08/1775625164
id: 904656
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1357
schema_scan_id: 6410753
updated: 2026-04-08 00:12:59

Version 904423

created: 2026-04-07 00:09:38

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_supp_account_data`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_supp_account_data`\n(\n `account_id`  int , `attribute`  string , `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-stage/raw/sparefoot_supp_account_data/2026-04-07/1775538574'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_supp_account_data"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_supp_account_data/2026-04-07/1775538574
id: 904423
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1357
schema_scan_id: 6410225
updated: 2026-04-07 00:09:52

Version 904235

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_supp_account_data`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_supp_account_data`\n(\n `account_id`  int , `attribute`  string , `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-stage/raw/sparefoot_supp_account_data/2026-04-06/1775452259'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_supp_account_data"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_supp_account_data/2026-04-06/1775452259
id: 904235
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1357
schema_scan_id: 6409708
updated: 2026-04-06 00:11:44

Version 904043

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_supp_account_data`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_supp_account_data`\n(\n `account_id`  int , `attribute`  string , `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-stage/raw/sparefoot_supp_account_data/2026-04-05/1775366174'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_supp_account_data"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_supp_account_data/2026-04-05/1775366174
id: 904043
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1357
schema_scan_id: 6409339
updated: 2026-04-05 00:16:29

Version 903786

created: 2026-04-04 00:05:26

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_supp_account_data`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_supp_account_data`\n(\n `account_id`  int , `attribute`  string , `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-stage/raw/sparefoot_supp_account_data/2026-04-04/1775279113'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_supp_account_data"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_supp_account_data/2026-04-04/1775279113
id: 903786
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1357
schema_scan_id: 6408899
updated: 2026-04-04 00:05:39

Version 903598

created: 2026-04-03 00:09:08

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_supp_account_data`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_supp_account_data`\n(\n `account_id`  int , `attribute`  string , `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-stage/raw/sparefoot_supp_account_data/2026-04-03/1775192944'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_supp_account_data"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_supp_account_data/2026-04-03/1775192944
id: 903598
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1357
schema_scan_id: 6408431
updated: 2026-04-03 00:09:22

Schema Scans: 15

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

Scan 6415119

duration: 0:00:11.652119

exit_message:

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

id: 6415119

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_account_data/2026-04-17/1776403135",
        "key": "raw/sparefoot_supp_account_data/2026-04-17/1776403135/supp_account_data.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_supp_account_data",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 3433596086744244244,
        "service_name": "sparefoot",
        "span_id": 18269840652854785225,
        "trace_id": 3433596086744244244
    }
}

running: False
schema_name_id: 1357
start_time: 2026-04-17 00:19:08
success: True
trace_id: 3433596086744244244

Scan 6414575

duration: 0:00:14.183362

exit_message:

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

id: 6414575

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_account_data/2026-04-16/1776316226",
        "key": "raw/sparefoot_supp_account_data/2026-04-16/1776316226/supp_account_data.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_supp_account_data",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 2559048651441716952,
        "service_name": "sparefoot",
        "span_id": 12109152478429929862,
        "trace_id": 2559048651441716952
    }
}

running: False
schema_name_id: 1357
start_time: 2026-04-16 00:10:29
success: True
trace_id: 2559048651441716952

Scan 6414099

duration: 0:00:14.345839

exit_message:

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

id: 6414099

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_account_data/2026-04-15/1776230687",
        "key": "raw/sparefoot_supp_account_data/2026-04-15/1776230687/supp_account_data.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_supp_account_data",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 16187521581840909810,
        "service_name": "sparefoot",
        "span_id": 8276657097887958746,
        "trace_id": 16187521581840909810
    }
}

running: False
schema_name_id: 1357
start_time: 2026-04-15 00:25:04
success: True
trace_id: 16187521581840909810

Scan 6413569

duration: 0:00:14.148420

exit_message:

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

id: 6413569

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_account_data/2026-04-14/1776143448",
        "key": "raw/sparefoot_supp_account_data/2026-04-14/1776143448/supp_account_data.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_supp_account_data",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 11950365542392023206,
        "service_name": "sparefoot",
        "span_id": 10227912961297675737,
        "trace_id": 11950365542392023206
    }
}

running: False
schema_name_id: 1357
start_time: 2026-04-14 00:10:52
success: True
trace_id: 11950365542392023206

Scan 6412990

duration: 0:00:11.564717

exit_message:

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

id: 6412990

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_account_data/2026-04-13/1776056934",
        "key": "raw/sparefoot_supp_account_data/2026-04-13/1776056934/supp_account_data.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_supp_account_data",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 13920332401522973555,
        "service_name": "sparefoot",
        "span_id": 16925577640584297969,
        "trace_id": 13920332401522973555
    }
}

running: False
schema_name_id: 1357
start_time: 2026-04-13 00:08:57
success: True
trace_id: 13920332401522973555

Scan 6412655

duration: 0:00:11.710338

exit_message:

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

id: 6412655

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_account_data/2026-04-12/1775970682",
        "key": "raw/sparefoot_supp_account_data/2026-04-12/1775970682/supp_account_data.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_supp_account_data",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 3574092393294555775,
        "service_name": "sparefoot",
        "span_id": 5487237020538182012,
        "trace_id": 3574092393294555775
    }
}

running: False
schema_name_id: 1357
start_time: 2026-04-12 00:11:24
success: True
trace_id: 3574092393294555775

Scan 6412244

duration: 0:00:14.181892

exit_message:

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

id: 6412244

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_account_data/2026-04-11/1775884119",
        "key": "raw/sparefoot_supp_account_data/2026-04-11/1775884119/supp_account_data.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_supp_account_data",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 10104821057892280888,
        "service_name": "sparefoot",
        "span_id": 18187913527498694533,
        "trace_id": 10104821057892280888
    }
}

running: False
schema_name_id: 1357
start_time: 2026-04-11 00:08:44
success: True
trace_id: 10104821057892280888

Scan 6411752

duration: 0:00:14.176842

exit_message:

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

id: 6411752

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_account_data/2026-04-10/1775797700",
        "key": "raw/sparefoot_supp_account_data/2026-04-10/1775797700/supp_account_data.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_supp_account_data",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 5413830962587566746,
        "service_name": "sparefoot",
        "span_id": 3608657413746674154,
        "trace_id": 5413830962587566746
    }
}

running: False
schema_name_id: 1357
start_time: 2026-04-10 00:08:42
success: True
trace_id: 5413830962587566746

Scan 6411213

duration: 0:00:11.651953

exit_message:

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

id: 6411213

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_account_data/2026-04-09/1775711321",
        "key": "raw/sparefoot_supp_account_data/2026-04-09/1775711321/supp_account_data.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_supp_account_data",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 15344548581716858608,
        "service_name": "sparefoot",
        "span_id": 13475643480167717815,
        "trace_id": 15344548581716858608
    }
}

running: False
schema_name_id: 1357
start_time: 2026-04-09 00:08:44
success: True
trace_id: 15344548581716858608

Scan 6410753

duration: 0:00:11.583058

exit_message:

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

id: 6410753

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_account_data/2026-04-08/1775625164",
        "key": "raw/sparefoot_supp_account_data/2026-04-08/1775625164/supp_account_data.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_supp_account_data",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 12067454767800127050,
        "service_name": "sparefoot",
        "span_id": 2089081385614890981,
        "trace_id": 12067454767800127050
    }
}

running: False
schema_name_id: 1357
start_time: 2026-04-08 00:12:47
success: True
trace_id: 12067454767800127050

Scan 6410225

duration: 0:00:14.170775

exit_message:

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

id: 6410225

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_account_data/2026-04-07/1775538574",
        "key": "raw/sparefoot_supp_account_data/2026-04-07/1775538574/supp_account_data.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_supp_account_data",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 12478637566526195756,
        "service_name": "sparefoot",
        "span_id": 6441652935611431351,
        "trace_id": 12478637566526195756
    }
}

running: False
schema_name_id: 1357
start_time: 2026-04-07 00:09:38
success: True
trace_id: 12478637566526195756

Scan 6409708

duration: 0:00:14.214608

exit_message:

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

id: 6409708

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_account_data/2026-04-06/1775452259",
        "key": "raw/sparefoot_supp_account_data/2026-04-06/1775452259/supp_account_data.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_supp_account_data",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 7170715005919466882,
        "service_name": "sparefoot",
        "span_id": 16968194706413449302,
        "trace_id": 7170715005919466882
    }
}

running: False
schema_name_id: 1357
start_time: 2026-04-06 00:11:29
success: True
trace_id: 7170715005919466882

Scan 6409339

duration: 0:00:11.567314

exit_message:

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

id: 6409339

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_account_data/2026-04-05/1775366174",
        "key": "raw/sparefoot_supp_account_data/2026-04-05/1775366174/supp_account_data.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_supp_account_data",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 5437997559060165390,
        "service_name": "sparefoot",
        "span_id": 9076875163496856047,
        "trace_id": 5437997559060165390
    }
}

running: False
schema_name_id: 1357
start_time: 2026-04-05 00:16:17
success: True
trace_id: 5437997559060165390

Scan 6408899

duration: 0:00:14.104653

exit_message:

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

id: 6408899

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_account_data/2026-04-04/1775279113",
        "key": "raw/sparefoot_supp_account_data/2026-04-04/1775279113/supp_account_data.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_supp_account_data",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 222101148975569332,
        "service_name": "sparefoot",
        "span_id": 6518898773952914869,
        "trace_id": 222101148975569332
    }
}

running: False
schema_name_id: 1357
start_time: 2026-04-04 00:05:25
success: True
trace_id: 222101148975569332

Scan 6408431

duration: 0:00:14.108213

exit_message:

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

id: 6408431

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_account_data/2026-04-03/1775192944",
        "key": "raw/sparefoot_supp_account_data/2026-04-03/1775192944/supp_account_data.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_supp_account_data",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 16221302283031371452,
        "service_name": "sparefoot",
        "span_id": 6762988382118566794,
        "trace_id": 16221302283031371452
    }
}

running: False
schema_name_id: 1357
start_time: 2026-04-03 00:09:08
success: True
trace_id: 16221302283031371452

Partitions:

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

Schema:

attributes:

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

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

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_account_data`\n(\n `account_id`  int , `attribute`  string , `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-stage/raw/sparefoot_supp_account_data/2026-04-17/1776403135'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_supp_account_data`",
    "repair_table": "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_supp_account_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:29:32",
        "disabled": false,
        "format": "raw",
        "id": 1357,
        "is_partitioned": false,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_stage_rds",
            "table": "sparefoot_sparefoot_supp_account_data"
        },
        "type": "rds"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "account_id": "int",
            "attribute": "string",
            "has_attribute": "smallint",
            "value": "string"
        },
        "created": "2026-04-17 00:19:09",
        "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_account_data`\n(\n `account_id`  int , `attribute`  string , `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-stage/raw/sparefoot_supp_account_data/2026-04-17/1776403135'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_supp_account_data`",
            "repair_table": "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_supp_account_data"
        }
    },
    "server": {
        "hostname": "schemamanager-5c55c886bf-h2ts4",
        "name": "schema_manager",
        "process_start": "2025-10-21 13:03:27",
        "sf_env": "stage",
        "version": "2112174301"
    }
}