Schema Info

Schema Name: sfdl_prod_rds.sparefoot_sparefoot_supp_account_data

created: 2022-08-18 17:15:20
disabled: False
format: raw
id: 1083
is_partitioned: False
is_schema_datatyped: False

name:

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

type: rds

Schema Versions: 15

Version 1718375

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_supp_account_data`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/sparefoot_supp_account_data/2026-04-17/1776453037'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_supp_account_data"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_supp_account_data/2026-04-17/1776453037
id: 1718375
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: 1083
schema_scan_id: 162193967
updated: 2026-04-17 14:10:56

Version 1718206

created: 2026-04-17 09:22:29

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_supp_account_data`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/sparefoot_supp_account_data/2026-04-17/1776435743'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_supp_account_data"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_supp_account_data/2026-04-17/1776435743
id: 1718206
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: 1083
schema_scan_id: 162178302
updated: 2026-04-17 09:22:43

Version 1717433

created: 2026-04-17 00:06:40

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_supp_account_data`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/sparefoot_supp_account_data/2026-04-17/1776402384'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_supp_account_data"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_supp_account_data/2026-04-17/1776402384
id: 1717433
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: 1083
schema_scan_id: 162163564
updated: 2026-04-17 00:06:51

Version 1717311

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_supp_account_data`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/sparefoot_supp_account_data/2026-04-16/1776388313'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_supp_account_data"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_supp_account_data/2026-04-16/1776388313
id: 1717311
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: 1083
schema_scan_id: 162156029
updated: 2026-04-16 20:15:46

Version 1717141

created: 2026-04-16 14:14:26

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_supp_account_data`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/sparefoot_supp_account_data/2026-04-16/1776366678'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_supp_account_data"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_supp_account_data/2026-04-16/1776366678
id: 1717141
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: 1083
schema_scan_id: 162138013
updated: 2026-04-16 14:14:40

Version 1716988

created: 2026-04-16 09:11:48

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_supp_account_data`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/sparefoot_supp_account_data/2026-04-16/1776348697'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_supp_account_data"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_supp_account_data/2026-04-16/1776348697
id: 1716988
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: 1083
schema_scan_id: 162122516
updated: 2026-04-16 09:11:59

Version 1716206

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_supp_account_data`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/sparefoot_supp_account_data/2026-04-16/1776316133'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_supp_account_data"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_supp_account_data/2026-04-16/1776316133
id: 1716206
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: 1083
schema_scan_id: 162107782
updated: 2026-04-16 00:09:33

Version 1716097

created: 2026-04-15 20:21:14

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_supp_account_data`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/sparefoot_supp_account_data/2026-04-15/1776302464'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_supp_account_data"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_supp_account_data/2026-04-15/1776302464
id: 1716097
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: 1083
schema_scan_id: 162100308
updated: 2026-04-15 20:21:28

Version 1715969

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_supp_account_data`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/sparefoot_supp_account_data/2026-04-15/1776280595'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_supp_account_data"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_supp_account_data/2026-04-15/1776280595
id: 1715969
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: 1083
schema_scan_id: 162081724
updated: 2026-04-15 14:16:52

Version 1715775

created: 2026-04-15 08:43:10

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_supp_account_data`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/sparefoot_supp_account_data/2026-04-15/1776260563'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_supp_account_data"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_supp_account_data/2026-04-15/1776260563
id: 1715775
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: 1083
schema_scan_id: 162064513
updated: 2026-04-15 08:43:24

Version 1714995

created: 2026-04-15 00:07:50

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_supp_account_data`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/sparefoot_supp_account_data/2026-04-15/1776229665'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_supp_account_data"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_supp_account_data/2026-04-15/1776229665
id: 1714995
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: 1083
schema_scan_id: 162051924
updated: 2026-04-15 00:08:01

Version 1714864

created: 2026-04-14 20:06:44

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_supp_account_data`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/sparefoot_supp_account_data/2026-04-14/1776215194'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_supp_account_data"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_supp_account_data/2026-04-14/1776215194
id: 1714864
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: 1083
schema_scan_id: 162044109
updated: 2026-04-14 20:06:56

Version 1714735

created: 2026-04-14 14:15:41

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_supp_account_data`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/sparefoot_supp_account_data/2026-04-14/1776194097'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_supp_account_data"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_supp_account_data/2026-04-14/1776194097
id: 1714735
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: 1083
schema_scan_id: 162026116
updated: 2026-04-14 14:15:52

Version 1714547

created: 2026-04-14 08:55:13

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_supp_account_data`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/sparefoot_supp_account_data/2026-04-14/1776174909'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_supp_account_data"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_supp_account_data/2026-04-14/1776174909
id: 1714547
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: 1083
schema_scan_id: 162009415
updated: 2026-04-14 08:55:24

Version 1713808

created: 2026-04-14 00:11:21

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_supp_account_data`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/sparefoot_supp_account_data/2026-04-14/1776143476'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_supp_account_data"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_supp_account_data/2026-04-14/1776143476
id: 1713808
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: 1083
schema_scan_id: 161996346
updated: 2026-04-14 00:11:34

Schema Scans: 15

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

Scan 162193967

duration: 0:00:11.642215

exit_message:

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

id: 162193967

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

running: False
schema_name_id: 1083
start_time: 2026-04-17 14:10:45
success: True
trace_id: 16395990792509017032

Scan 162178302

duration: 0:00:14.115256

exit_message:

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

id: 162178302

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

running: False
schema_name_id: 1083
start_time: 2026-04-17 09:22:29
success: True
trace_id: 4150337310755554417

Scan 162163564

duration: 0:00:11.702797

exit_message:

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

id: 162163564

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

running: False
schema_name_id: 1083
start_time: 2026-04-17 00:06:39
success: True
trace_id: 9782586396802892422

Scan 162156029

duration: 0:00:14.060330

exit_message:

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

id: 162156029

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

running: False
schema_name_id: 1083
start_time: 2026-04-16 20:15:32
success: True
trace_id: 7785385857618623188

Scan 162138013

duration: 0:00:14.224468

exit_message:

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

id: 162138013

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

running: False
schema_name_id: 1083
start_time: 2026-04-16 14:14:26
success: True
trace_id: 1637528968875377218

Scan 162122516

duration: 0:00:11.670055

exit_message:

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

id: 162122516

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

running: False
schema_name_id: 1083
start_time: 2026-04-16 09:11:47
success: True
trace_id: 7912950722077613001

Scan 162107782

duration: 0:00:11.613296

exit_message:

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

id: 162107782

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

running: False
schema_name_id: 1083
start_time: 2026-04-16 00:09:22
success: True
trace_id: 8397079604882862001

Scan 162100308

duration: 0:00:14.151985

exit_message:

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

id: 162100308

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

running: False
schema_name_id: 1083
start_time: 2026-04-15 20:21:14
success: True
trace_id: 18120141556847975227

Scan 162081724

duration: 0:00:14.217430

exit_message:

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

id: 162081724

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

running: False
schema_name_id: 1083
start_time: 2026-04-15 14:16:38
success: True
trace_id: 11060177016191901276

Scan 162064513

duration: 0:00:14.092845

exit_message:

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

id: 162064513

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

running: False
schema_name_id: 1083
start_time: 2026-04-15 08:43:10
success: True
trace_id: 5683743169721822272

Scan 162051924

duration: 0:00:11.594607

exit_message:

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

id: 162051924

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

running: False
schema_name_id: 1083
start_time: 2026-04-15 00:07:50
success: True
trace_id: 18072664402338283086

Scan 162044109

duration: 0:00:11.600163

exit_message:

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

id: 162044109

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

running: False
schema_name_id: 1083
start_time: 2026-04-14 20:06:44
success: True
trace_id: 12628754257382442753

Scan 162026116

duration: 0:00:11.661589

exit_message:

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

id: 162026116

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

running: False
schema_name_id: 1083
start_time: 2026-04-14 14:15:40
success: True
trace_id: 13830885081860127570

Scan 162009415

duration: 0:00:11.461103

exit_message:

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

id: 162009415

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

running: False
schema_name_id: 1083
start_time: 2026-04-14 08:55:12
success: True
trace_id: 8452063411781021567

Scan 161996346

duration: 0:00:14.140717

exit_message:

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

id: 161996346

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

running: False
schema_name_id: 1083
start_time: 2026-04-14 00:11:20
success: True
trace_id: 8611331418711689764

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 14:10:45

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_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-prod/raw/sparefoot_supp_account_data/2026-04-17/1776453037'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_supp_account_data`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_supp_account_data"
}

Server:

hostname: schemamanager-5475496c57-7dpqb
name: schema_manager
process_start: 2026-01-09 11:27:47
sf_env: prod
version: 2112174301

Raw:

{
    "name": {
        "created": "2022-08-18 17:15:20",
        "disabled": false,
        "format": "raw",
        "id": 1083,
        "is_partitioned": false,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_prod_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 14:10:45",
        "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_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-prod/raw/sparefoot_supp_account_data/2026-04-17/1776453037'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_supp_account_data`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_supp_account_data"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}