Schema Info

Schema Name: sfdl_prod_rds.sparefoot_sparefoot_uplid

created: 2022-08-18 17:23:51
disabled: False
format: raw
id: 1128
is_partitioned: False
is_schema_datatyped: False

name:

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

type: rds

Schema Versions: 15

Version 1718398

created: 2026-04-17 14:16:08

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_uplid`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_uplid`\n(\n `city`  string , `created_at`  timestamp , `deprecated`  smallint , `duplicate_of`  int , `match_info`  string , `matched`  smallint , `state`  string , `street_address_1`  string , `street_address_2`  string , `updated_at`  timestamp , `uplid_id`  int , `zip`  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_uplid/2026-04-17/1776453363'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_uplid"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_uplid/2026-04-17/1776453363
id: 1718398
processed: 1

raw_data:

{
    "city": "string",
    "created_at": "timestamp[ns]",
    "deprecated": "int16",
    "duplicate_of": "int32",
    "match_info": "string",
    "matched": "int16",
    "state": "string",
    "street_address_1": "string",
    "street_address_2": "string",
    "updated_at": "timestamp[ns]",
    "uplid_id": "int32",
    "zip": "string"
}

schema_attributes:

{
    "city": "string",
    "created_at": "timestamp",
    "deprecated": "smallint",
    "duplicate_of": "int",
    "match_info": "string",
    "matched": "smallint",
    "state": "string",
    "street_address_1": "string",
    "street_address_2": "string",
    "updated_at": "timestamp",
    "uplid_id": "int",
    "zip": "string"
}

schema_name_id: 1128
schema_scan_id: 162194024
updated: 2026-04-17 14:16:22

Version 1718219

created: 2026-04-17 09:24:37

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_uplid`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_uplid`\n(\n `city`  string , `created_at`  timestamp , `deprecated`  smallint , `duplicate_of`  int , `match_info`  string , `matched`  smallint , `state`  string , `street_address_1`  string , `street_address_2`  string , `updated_at`  timestamp , `uplid_id`  int , `zip`  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_uplid/2026-04-17/1776435865'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_uplid"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_uplid/2026-04-17/1776435865
id: 1718219
processed: 1

raw_data:

{
    "city": "string",
    "created_at": "timestamp[ns]",
    "deprecated": "int16",
    "duplicate_of": "int32",
    "match_info": "string",
    "matched": "int16",
    "state": "string",
    "street_address_1": "string",
    "street_address_2": "string",
    "updated_at": "timestamp[ns]",
    "uplid_id": "int32",
    "zip": "string"
}

schema_attributes:

{
    "city": "string",
    "created_at": "timestamp",
    "deprecated": "smallint",
    "duplicate_of": "int",
    "match_info": "string",
    "matched": "smallint",
    "state": "string",
    "street_address_1": "string",
    "street_address_2": "string",
    "updated_at": "timestamp",
    "uplid_id": "int",
    "zip": "string"
}

schema_name_id: 1128
schema_scan_id: 162178319
updated: 2026-04-17 09:24:48

Version 1717456

created: 2026-04-17 00:12:43

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_uplid`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_uplid`\n(\n `city`  string , `created_at`  timestamp , `deprecated`  smallint , `duplicate_of`  int , `match_info`  string , `matched`  smallint , `state`  string , `street_address_1`  string , `street_address_2`  string , `updated_at`  timestamp , `uplid_id`  int , `zip`  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_uplid/2026-04-17/1776402641'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_uplid"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_uplid/2026-04-17/1776402641
id: 1717456
processed: 1

raw_data:

{
    "city": "string",
    "created_at": "timestamp[ns]",
    "deprecated": "int16",
    "duplicate_of": "int32",
    "match_info": "string",
    "matched": "int16",
    "state": "string",
    "street_address_1": "string",
    "street_address_2": "string",
    "updated_at": "timestamp[ns]",
    "uplid_id": "int32",
    "zip": "string"
}

schema_attributes:

{
    "city": "string",
    "created_at": "timestamp",
    "deprecated": "smallint",
    "duplicate_of": "int",
    "match_info": "string",
    "matched": "smallint",
    "state": "string",
    "street_address_1": "string",
    "street_address_2": "string",
    "updated_at": "timestamp",
    "uplid_id": "int",
    "zip": "string"
}

schema_name_id: 1128
schema_scan_id: 162163612
updated: 2026-04-17 00:12:54

Version 1717352

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_uplid`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_uplid`\n(\n `city`  string , `created_at`  timestamp , `deprecated`  smallint , `duplicate_of`  int , `match_info`  string , `matched`  smallint , `state`  string , `street_address_1`  string , `street_address_2`  string , `updated_at`  timestamp , `uplid_id`  int , `zip`  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_uplid/2026-04-16/1776388911'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_uplid"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_uplid/2026-04-16/1776388911
id: 1717352
processed: 1

raw_data:

{
    "city": "string",
    "created_at": "timestamp[ns]",
    "deprecated": "int16",
    "duplicate_of": "int32",
    "match_info": "string",
    "matched": "int16",
    "state": "string",
    "street_address_1": "string",
    "street_address_2": "string",
    "updated_at": "timestamp[ns]",
    "uplid_id": "int32",
    "zip": "string"
}

schema_attributes:

{
    "city": "string",
    "created_at": "timestamp",
    "deprecated": "smallint",
    "duplicate_of": "int",
    "match_info": "string",
    "matched": "smallint",
    "state": "string",
    "street_address_1": "string",
    "street_address_2": "string",
    "updated_at": "timestamp",
    "uplid_id": "int",
    "zip": "string"
}

schema_name_id: 1128
schema_scan_id: 162156154
updated: 2026-04-16 20:24:43

Version 1717179

created: 2026-04-16 14:18:32

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_uplid`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_uplid`\n(\n `city`  string , `created_at`  timestamp , `deprecated`  smallint , `duplicate_of`  int , `match_info`  string , `matched`  smallint , `state`  string , `street_address_1`  string , `street_address_2`  string , `updated_at`  timestamp , `uplid_id`  int , `zip`  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_uplid/2026-04-16/1776367091'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_uplid"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_uplid/2026-04-16/1776367091
id: 1717179
processed: 1

raw_data:

{
    "city": "string",
    "created_at": "timestamp[ns]",
    "deprecated": "int16",
    "duplicate_of": "int32",
    "match_info": "string",
    "matched": "int16",
    "state": "string",
    "street_address_1": "string",
    "street_address_2": "string",
    "updated_at": "timestamp[ns]",
    "uplid_id": "int32",
    "zip": "string"
}

schema_attributes:

{
    "city": "string",
    "created_at": "timestamp",
    "deprecated": "smallint",
    "duplicate_of": "int",
    "match_info": "string",
    "matched": "smallint",
    "state": "string",
    "street_address_1": "string",
    "street_address_2": "string",
    "updated_at": "timestamp",
    "uplid_id": "int",
    "zip": "string"
}

schema_name_id: 1128
schema_scan_id: 162138124
updated: 2026-04-16 14:18:44

Version 1716977

created: 2026-04-16 09:09:25

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_uplid`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_uplid`\n(\n `city`  string , `created_at`  timestamp , `deprecated`  smallint , `duplicate_of`  int , `match_info`  string , `matched`  smallint , `state`  string , `street_address_1`  string , `street_address_2`  string , `updated_at`  timestamp , `uplid_id`  int , `zip`  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_uplid/2026-04-16/1776348559'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_uplid"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_uplid/2026-04-16/1776348559
id: 1716977
processed: 1

raw_data:

{
    "city": "string",
    "created_at": "timestamp[ns]",
    "deprecated": "int16",
    "duplicate_of": "int32",
    "match_info": "string",
    "matched": "int16",
    "state": "string",
    "street_address_1": "string",
    "street_address_2": "string",
    "updated_at": "timestamp[ns]",
    "uplid_id": "int32",
    "zip": "string"
}

schema_attributes:

{
    "city": "string",
    "created_at": "timestamp",
    "deprecated": "smallint",
    "duplicate_of": "int",
    "match_info": "string",
    "matched": "smallint",
    "state": "string",
    "street_address_1": "string",
    "street_address_2": "string",
    "updated_at": "timestamp",
    "uplid_id": "int",
    "zip": "string"
}

schema_name_id: 1128
schema_scan_id: 162122498
updated: 2026-04-16 09:09:38

Version 1716218

created: 2026-04-16 00:13:44

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_uplid`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_uplid`\n(\n `city`  string , `created_at`  timestamp , `deprecated`  smallint , `duplicate_of`  int , `match_info`  string , `matched`  smallint , `state`  string , `street_address_1`  string , `street_address_2`  string , `updated_at`  timestamp , `uplid_id`  int , `zip`  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_uplid/2026-04-16/1776316420'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_uplid"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_uplid/2026-04-16/1776316420
id: 1716218
processed: 1

raw_data:

{
    "city": "string",
    "created_at": "timestamp[ns]",
    "deprecated": "int16",
    "duplicate_of": "int32",
    "match_info": "string",
    "matched": "int16",
    "state": "string",
    "street_address_1": "string",
    "street_address_2": "string",
    "updated_at": "timestamp[ns]",
    "uplid_id": "int32",
    "zip": "string"
}

schema_attributes:

{
    "city": "string",
    "created_at": "timestamp",
    "deprecated": "smallint",
    "duplicate_of": "int",
    "match_info": "string",
    "matched": "smallint",
    "state": "string",
    "street_address_1": "string",
    "street_address_2": "string",
    "updated_at": "timestamp",
    "uplid_id": "int",
    "zip": "string"
}

schema_name_id: 1128
schema_scan_id: 162107796
updated: 2026-04-16 00:13:57

Version 1716111

created: 2026-04-15 20:25:06

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_uplid`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_uplid`\n(\n `city`  string , `created_at`  timestamp , `deprecated`  smallint , `duplicate_of`  int , `match_info`  string , `matched`  smallint , `state`  string , `street_address_1`  string , `street_address_2`  string , `updated_at`  timestamp , `uplid_id`  int , `zip`  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_uplid/2026-04-15/1776302693'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_uplid"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_uplid/2026-04-15/1776302693
id: 1716111
processed: 1

raw_data:

{
    "city": "string",
    "created_at": "timestamp[ns]",
    "deprecated": "int16",
    "duplicate_of": "int32",
    "match_info": "string",
    "matched": "int16",
    "state": "string",
    "street_address_1": "string",
    "street_address_2": "string",
    "updated_at": "timestamp[ns]",
    "uplid_id": "int32",
    "zip": "string"
}

schema_attributes:

{
    "city": "string",
    "created_at": "timestamp",
    "deprecated": "smallint",
    "duplicate_of": "int",
    "match_info": "string",
    "matched": "smallint",
    "state": "string",
    "street_address_1": "string",
    "street_address_2": "string",
    "updated_at": "timestamp",
    "uplid_id": "int",
    "zip": "string"
}

schema_name_id: 1128
schema_scan_id: 162100327
updated: 2026-04-15 20:25:18

Version 1715966

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_uplid`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_uplid`\n(\n `city`  string , `created_at`  timestamp , `deprecated`  smallint , `duplicate_of`  int , `match_info`  string , `matched`  smallint , `state`  string , `street_address_1`  string , `street_address_2`  string , `updated_at`  timestamp , `uplid_id`  int , `zip`  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_uplid/2026-04-15/1776280565'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_uplid"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_uplid/2026-04-15/1776280565
id: 1715966
processed: 1

raw_data:

{
    "city": "string",
    "created_at": "timestamp[ns]",
    "deprecated": "int16",
    "duplicate_of": "int32",
    "match_info": "string",
    "matched": "int16",
    "state": "string",
    "street_address_1": "string",
    "street_address_2": "string",
    "updated_at": "timestamp[ns]",
    "uplid_id": "int32",
    "zip": "string"
}

schema_attributes:

{
    "city": "string",
    "created_at": "timestamp",
    "deprecated": "smallint",
    "duplicate_of": "int",
    "match_info": "string",
    "matched": "smallint",
    "state": "string",
    "street_address_1": "string",
    "street_address_2": "string",
    "updated_at": "timestamp",
    "uplid_id": "int",
    "zip": "string"
}

schema_name_id: 1128
schema_scan_id: 162081720
updated: 2026-04-15 14:16:34

Version 1715763

created: 2026-04-15 08:41:02

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_uplid`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_uplid`\n(\n `city`  string , `created_at`  timestamp , `deprecated`  smallint , `duplicate_of`  int , `match_info`  string , `matched`  smallint , `state`  string , `street_address_1`  string , `street_address_2`  string , `updated_at`  timestamp , `uplid_id`  int , `zip`  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_uplid/2026-04-15/1776260416'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_uplid"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_uplid/2026-04-15/1776260416
id: 1715763
processed: 1

raw_data:

{
    "city": "string",
    "created_at": "timestamp[ns]",
    "deprecated": "int16",
    "duplicate_of": "int32",
    "match_info": "string",
    "matched": "int16",
    "state": "string",
    "street_address_1": "string",
    "street_address_2": "string",
    "updated_at": "timestamp[ns]",
    "uplid_id": "int32",
    "zip": "string"
}

schema_attributes:

{
    "city": "string",
    "created_at": "timestamp",
    "deprecated": "smallint",
    "duplicate_of": "int",
    "match_info": "string",
    "matched": "smallint",
    "state": "string",
    "street_address_1": "string",
    "street_address_2": "string",
    "updated_at": "timestamp",
    "uplid_id": "int",
    "zip": "string"
}

schema_name_id: 1128
schema_scan_id: 162064449
updated: 2026-04-15 08:41:14

Version 1715018

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_uplid`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_uplid`\n(\n `city`  string , `created_at`  timestamp , `deprecated`  smallint , `duplicate_of`  int , `match_info`  string , `matched`  smallint , `state`  string , `street_address_1`  string , `street_address_2`  string , `updated_at`  timestamp , `uplid_id`  int , `zip`  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_uplid/2026-04-15/1776230179'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_uplid"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_uplid/2026-04-15/1776230179
id: 1715018
processed: 1

raw_data:

{
    "city": "string",
    "created_at": "timestamp[ns]",
    "deprecated": "int16",
    "duplicate_of": "int32",
    "match_info": "string",
    "matched": "int16",
    "state": "string",
    "street_address_1": "string",
    "street_address_2": "string",
    "updated_at": "timestamp[ns]",
    "uplid_id": "int32",
    "zip": "string"
}

schema_attributes:

{
    "city": "string",
    "created_at": "timestamp",
    "deprecated": "smallint",
    "duplicate_of": "int",
    "match_info": "string",
    "matched": "smallint",
    "state": "string",
    "street_address_1": "string",
    "street_address_2": "string",
    "updated_at": "timestamp",
    "uplid_id": "int",
    "zip": "string"
}

schema_name_id: 1128
schema_scan_id: 162051979
updated: 2026-04-15 00:16:34

Version 1714886

created: 2026-04-14 20:14:08

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_uplid`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_uplid`\n(\n `city`  string , `created_at`  timestamp , `deprecated`  smallint , `duplicate_of`  int , `match_info`  string , `matched`  smallint , `state`  string , `street_address_1`  string , `street_address_2`  string , `updated_at`  timestamp , `uplid_id`  int , `zip`  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_uplid/2026-04-14/1776215644'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_uplid"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_uplid/2026-04-14/1776215644
id: 1714886
processed: 1

raw_data:

{
    "city": "string",
    "created_at": "timestamp[ns]",
    "deprecated": "int16",
    "duplicate_of": "int32",
    "match_info": "string",
    "matched": "int16",
    "state": "string",
    "street_address_1": "string",
    "street_address_2": "string",
    "updated_at": "timestamp[ns]",
    "uplid_id": "int32",
    "zip": "string"
}

schema_attributes:

{
    "city": "string",
    "created_at": "timestamp",
    "deprecated": "smallint",
    "duplicate_of": "int",
    "match_info": "string",
    "matched": "smallint",
    "state": "string",
    "street_address_1": "string",
    "street_address_2": "string",
    "updated_at": "timestamp",
    "uplid_id": "int",
    "zip": "string"
}

schema_name_id: 1128
schema_scan_id: 162044239
updated: 2026-04-14 20:14:21

Version 1714705

created: 2026-04-14 14:10:58

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_uplid`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_uplid`\n(\n `city`  string , `created_at`  timestamp , `deprecated`  smallint , `duplicate_of`  int , `match_info`  string , `matched`  smallint , `state`  string , `street_address_1`  string , `street_address_2`  string , `updated_at`  timestamp , `uplid_id`  int , `zip`  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_uplid/2026-04-14/1776193841'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_uplid"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_uplid/2026-04-14/1776193841
id: 1714705
processed: 1

raw_data:

{
    "city": "string",
    "created_at": "timestamp[ns]",
    "deprecated": "int16",
    "duplicate_of": "int32",
    "match_info": "string",
    "matched": "int16",
    "state": "string",
    "street_address_1": "string",
    "street_address_2": "string",
    "updated_at": "timestamp[ns]",
    "uplid_id": "int32",
    "zip": "string"
}

schema_attributes:

{
    "city": "string",
    "created_at": "timestamp",
    "deprecated": "smallint",
    "duplicate_of": "int",
    "match_info": "string",
    "matched": "smallint",
    "state": "string",
    "street_address_1": "string",
    "street_address_2": "string",
    "updated_at": "timestamp",
    "uplid_id": "int",
    "zip": "string"
}

schema_name_id: 1128
schema_scan_id: 162026078
updated: 2026-04-14 14:11:12

Version 1714546

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_uplid`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_uplid`\n(\n `city`  string , `created_at`  timestamp , `deprecated`  smallint , `duplicate_of`  int , `match_info`  string , `matched`  smallint , `state`  string , `street_address_1`  string , `street_address_2`  string , `updated_at`  timestamp , `uplid_id`  int , `zip`  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_uplid/2026-04-14/1776174900'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_uplid"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_uplid/2026-04-14/1776174900
id: 1714546
processed: 1

raw_data:

{
    "city": "string",
    "created_at": "timestamp[ns]",
    "deprecated": "int16",
    "duplicate_of": "int32",
    "match_info": "string",
    "matched": "int16",
    "state": "string",
    "street_address_1": "string",
    "street_address_2": "string",
    "updated_at": "timestamp[ns]",
    "uplid_id": "int32",
    "zip": "string"
}

schema_attributes:

{
    "city": "string",
    "created_at": "timestamp",
    "deprecated": "smallint",
    "duplicate_of": "int",
    "match_info": "string",
    "matched": "smallint",
    "state": "string",
    "street_address_1": "string",
    "street_address_2": "string",
    "updated_at": "timestamp",
    "uplid_id": "int",
    "zip": "string"
}

schema_name_id: 1128
schema_scan_id: 162009408
updated: 2026-04-14 08:55:20

Version 1713832

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_uplid`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_uplid`\n(\n `city`  string , `created_at`  timestamp , `deprecated`  smallint , `duplicate_of`  int , `match_info`  string , `matched`  smallint , `state`  string , `street_address_1`  string , `street_address_2`  string , `updated_at`  timestamp , `uplid_id`  int , `zip`  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_uplid/2026-04-14/1776143755'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_uplid"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_uplid/2026-04-14/1776143755
id: 1713832
processed: 1

raw_data:

{
    "city": "string",
    "created_at": "timestamp[ns]",
    "deprecated": "int16",
    "duplicate_of": "int32",
    "match_info": "string",
    "matched": "int16",
    "state": "string",
    "street_address_1": "string",
    "street_address_2": "string",
    "updated_at": "timestamp[ns]",
    "uplid_id": "int32",
    "zip": "string"
}

schema_attributes:

{
    "city": "string",
    "created_at": "timestamp",
    "deprecated": "smallint",
    "duplicate_of": "int",
    "match_info": "string",
    "matched": "smallint",
    "state": "string",
    "street_address_1": "string",
    "street_address_2": "string",
    "updated_at": "timestamp",
    "uplid_id": "int",
    "zip": "string"
}

schema_name_id: 1128
schema_scan_id: 161996377
updated: 2026-04-14 00:16:13

Schema Scans: 15

Last at 2026-04-17 14:16:08

Scan 162194024

duration: 0:00:14.387497

exit_message:

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

id: 162194024

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_uplid/2026-04-17/1776453363",
        "key": "raw/sparefoot_uplid/2026-04-17/1776453363/uplid_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_uplid",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 8669170684710779546,
        "service_name": "sparefoot",
        "span_id": 9520278215530269555,
        "trace_id": 8669170684710779546
    }
}

running: False
schema_name_id: 1128
start_time: 2026-04-17 14:16:08
success: True
trace_id: 8669170684710779546

Scan 162178319

duration: 0:00:12.028364

exit_message:

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

id: 162178319

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_uplid/2026-04-17/1776435865",
        "key": "raw/sparefoot_uplid/2026-04-17/1776435865/uplid_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_uplid",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 7465705470120899189,
        "service_name": "sparefoot",
        "span_id": 16741841509445451569,
        "trace_id": 7465705470120899189
    }
}

running: False
schema_name_id: 1128
start_time: 2026-04-17 09:24:36
success: True
trace_id: 7465705470120899189

Scan 162163612

duration: 0:00:11.870006

exit_message:

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

id: 162163612

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_uplid/2026-04-17/1776402641",
        "key": "raw/sparefoot_uplid/2026-04-17/1776402641/uplid_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_uplid",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 4301723610056628862,
        "service_name": "sparefoot",
        "span_id": 15416067361086540465,
        "trace_id": 4301723610056628862
    }
}

running: False
schema_name_id: 1128
start_time: 2026-04-17 00:12:42
success: True
trace_id: 4301723610056628862

Scan 162156154

duration: 0:00:14.417296

exit_message:

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

id: 162156154

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_uplid/2026-04-16/1776388911",
        "key": "raw/sparefoot_uplid/2026-04-16/1776388911/uplid_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_uplid",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 16202434027660748071,
        "service_name": "sparefoot",
        "span_id": 6860309902495575996,
        "trace_id": 16202434027660748071
    }
}

running: False
schema_name_id: 1128
start_time: 2026-04-16 20:24:29
success: True
trace_id: 16202434027660748071

Scan 162138124

duration: 0:00:11.932016

exit_message:

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

id: 162138124

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_uplid/2026-04-16/1776367091",
        "key": "raw/sparefoot_uplid/2026-04-16/1776367091/uplid_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_uplid",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 12363015456687879643,
        "service_name": "sparefoot",
        "span_id": 447075838083766216,
        "trace_id": 12363015456687879643
    }
}

running: False
schema_name_id: 1128
start_time: 2026-04-16 14:18:32
success: True
trace_id: 12363015456687879643

Scan 162122498

duration: 0:00:14.340539

exit_message:

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

id: 162122498

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_uplid/2026-04-16/1776348559",
        "key": "raw/sparefoot_uplid/2026-04-16/1776348559/uplid_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_uplid",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 8612462467661149019,
        "service_name": "sparefoot",
        "span_id": 12995130582725690161,
        "trace_id": 8612462467661149019
    }
}

running: False
schema_name_id: 1128
start_time: 2026-04-16 09:09:24
success: True
trace_id: 8612462467661149019

Scan 162107796

duration: 0:00:14.384765

exit_message:

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

id: 162107796

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_uplid/2026-04-16/1776316420",
        "key": "raw/sparefoot_uplid/2026-04-16/1776316420/uplid_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_uplid",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 2878621020613990476,
        "service_name": "sparefoot",
        "span_id": 8028907820432649208,
        "trace_id": 2878621020613990476
    }
}

running: False
schema_name_id: 1128
start_time: 2026-04-16 00:13:43
success: True
trace_id: 2878621020613990476

Scan 162100327

duration: 0:00:12.128693

exit_message:

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

id: 162100327

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_uplid/2026-04-15/1776302693",
        "key": "raw/sparefoot_uplid/2026-04-15/1776302693/uplid_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_uplid",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 13548576775238251816,
        "service_name": "sparefoot",
        "span_id": 7511620829284751688,
        "trace_id": 13548576775238251816
    }
}

running: False
schema_name_id: 1128
start_time: 2026-04-15 20:25:06
success: True
trace_id: 13548576775238251816

Scan 162081720

duration: 0:00:14.587226

exit_message:

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

id: 162081720

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_uplid/2026-04-15/1776280565",
        "key": "raw/sparefoot_uplid/2026-04-15/1776280565/uplid_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_uplid",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 14206194480438762207,
        "service_name": "sparefoot",
        "span_id": 3461762164341383211,
        "trace_id": 14206194480438762207
    }
}

running: False
schema_name_id: 1128
start_time: 2026-04-15 14:16:19
success: True
trace_id: 14206194480438762207

Scan 162064449

duration: 0:00:11.760388

exit_message:

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

id: 162064449

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_uplid/2026-04-15/1776260416",
        "key": "raw/sparefoot_uplid/2026-04-15/1776260416/uplid_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_uplid",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 14018077582140314892,
        "service_name": "sparefoot",
        "span_id": 7990288934820452195,
        "trace_id": 14018077582140314892
    }
}

running: False
schema_name_id: 1128
start_time: 2026-04-15 08:41:02
success: True
trace_id: 14018077582140314892

Scan 162051979

duration: 0:00:11.856179

exit_message:

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

id: 162051979

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_uplid/2026-04-15/1776230179",
        "key": "raw/sparefoot_uplid/2026-04-15/1776230179/uplid_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_uplid",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 1949651634777970296,
        "service_name": "sparefoot",
        "span_id": 11293571319268939173,
        "trace_id": 1949651634777970296
    }
}

running: False
schema_name_id: 1128
start_time: 2026-04-15 00:16:22
success: True
trace_id: 1949651634777970296

Scan 162044239

duration: 0:00:14.374094

exit_message:

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

id: 162044239

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_uplid/2026-04-14/1776215644",
        "key": "raw/sparefoot_uplid/2026-04-14/1776215644/uplid_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_uplid",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 1055238898840464830,
        "service_name": "sparefoot",
        "span_id": 17287054136970156171,
        "trace_id": 1055238898840464830
    }
}

running: False
schema_name_id: 1128
start_time: 2026-04-14 20:14:07
success: True
trace_id: 1055238898840464830

Scan 162026078

duration: 0:00:14.509318

exit_message:

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

id: 162026078

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_uplid/2026-04-14/1776193841",
        "key": "raw/sparefoot_uplid/2026-04-14/1776193841/uplid_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_uplid",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 17630321442142571358,
        "service_name": "sparefoot",
        "span_id": 1452274026371378207,
        "trace_id": 17630321442142571358
    }
}

running: False
schema_name_id: 1128
start_time: 2026-04-14 14:10:57
success: True
trace_id: 17630321442142571358

Scan 162009408

duration: 0:00:11.849229

exit_message:

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

id: 162009408

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_uplid/2026-04-14/1776174900",
        "key": "raw/sparefoot_uplid/2026-04-14/1776174900/uplid_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_uplid",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 1547429666468256384,
        "service_name": "sparefoot",
        "span_id": 3458135872365496055,
        "trace_id": 1547429666468256384
    }
}

running: False
schema_name_id: 1128
start_time: 2026-04-14 08:55:09
success: True
trace_id: 1547429666468256384

Scan 161996377

duration: 0:00:14.398955

exit_message:

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

id: 161996377

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_uplid/2026-04-14/1776143755",
        "key": "raw/sparefoot_uplid/2026-04-14/1776143755/uplid_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_uplid",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 4917009705673927584,
        "service_name": "sparefoot",
        "span_id": 1607885156891724693,
        "trace_id": 4917009705673927584
    }
}

running: False
schema_name_id: 1128
start_time: 2026-04-14 00:15:58
success: True
trace_id: 4917009705673927584

Partitions:

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

Schema:

attributes:

{
    "city": "string",
    "created_at": "timestamp",
    "deprecated": "smallint",
    "duplicate_of": "int",
    "match_info": "string",
    "matched": "smallint",
    "state": "string",
    "street_address_1": "string",
    "street_address_2": "string",
    "updated_at": "timestamp",
    "uplid_id": "int",
    "zip": "string"
}

created: 2026-04-17 14:16:08

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_uplid`\n(\n `city`  string , `created_at`  timestamp , `deprecated`  smallint , `duplicate_of`  int , `match_info`  string , `matched`  smallint , `state`  string , `street_address_1`  string , `street_address_2`  string , `updated_at`  timestamp , `uplid_id`  int , `zip`  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_uplid/2026-04-17/1776453363'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_uplid`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_uplid"
}

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:23:51",
        "disabled": false,
        "format": "raw",
        "id": 1128,
        "is_partitioned": false,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_prod_rds",
            "table": "sparefoot_sparefoot_uplid"
        },
        "type": "rds"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "city": "string",
            "created_at": "timestamp",
            "deprecated": "smallint",
            "duplicate_of": "int",
            "match_info": "string",
            "matched": "smallint",
            "state": "string",
            "street_address_1": "string",
            "street_address_2": "string",
            "updated_at": "timestamp",
            "uplid_id": "int",
            "zip": "string"
        },
        "created": "2026-04-17 14:16:08",
        "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_uplid`\n(\n `city`  string , `created_at`  timestamp , `deprecated`  smallint , `duplicate_of`  int , `match_info`  string , `matched`  smallint , `state`  string , `street_address_1`  string , `street_address_2`  string , `updated_at`  timestamp , `uplid_id`  int , `zip`  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_uplid/2026-04-17/1776453363'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_uplid`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_uplid"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}