Schema Info

Schema Name: sfdl_stage_rds.sparefoot_sparefoot_uplid

created: 2022-08-12 10:16:17
disabled: False
format: raw
id: 1327
is_partitioned: False
is_schema_datatyped: False

name:

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

type: rds

Schema Versions: 15

Version 906569

created: 2026-04-17 00:20:53

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_uplid/2026-04-17/1776403230
id: 906569
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: 1327
schema_scan_id: 6415137
updated: 2026-04-17 00:21:04

Version 906325

created: 2026-04-16 00:08:06

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_uplid/2026-04-16/1776316080
id: 906325
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: 1327
schema_scan_id: 6414559
updated: 2026-04-16 00:08:20

Version 906144

created: 2026-04-15 00:27:58

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_uplid/2026-04-15/1776230873
id: 906144
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: 1327
schema_scan_id: 6414108
updated: 2026-04-15 00:28:10

Version 905931

created: 2026-04-14 00:13:31

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_uplid/2026-04-14/1776143598
id: 905931
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: 1327
schema_scan_id: 6413599
updated: 2026-04-14 00:13:45

Version 905689

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

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_uplid/2026-04-13/1776057300
id: 905689
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: 1327
schema_scan_id: 6413022
updated: 2026-04-13 00:15:26

Version 905504

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

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_uplid/2026-04-12/1775970689
id: 905504
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: 1327
schema_scan_id: 6412656
updated: 2026-04-12 00:11:46

Version 905281

created: 2026-04-11 00:09:23

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_uplid/2026-04-11/1775884158
id: 905281
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: 1327
schema_scan_id: 6412253
updated: 2026-04-11 00:09:34

Version 905047

created: 2026-04-10 00:05:50

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_uplid/2026-04-10/1775797547
id: 905047
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: 1327
schema_scan_id: 6411726
updated: 2026-04-10 00:06:04

Version 904867

created: 2026-04-09 00:14:06

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_uplid/2026-04-09/1775711635
id: 904867
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: 1327
schema_scan_id: 6411254
updated: 2026-04-09 00:14:20

Version 904664

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

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_uplid/2026-04-08/1775625225
id: 904664
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: 1327
schema_scan_id: 6410761
updated: 2026-04-08 00:14:05

Version 904436

created: 2026-04-07 00:11:37

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_uplid/2026-04-07/1775538690
id: 904436
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: 1327
schema_scan_id: 6410240
updated: 2026-04-07 00:11:48

Version 904241

created: 2026-04-06 00:13:18

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_uplid/2026-04-06/1775452366
id: 904241
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: 1327
schema_scan_id: 6409714
updated: 2026-04-06 00:13:32

Version 904000

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

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_uplid/2026-04-05/1775365585
id: 904000
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: 1327
schema_scan_id: 6409294
updated: 2026-04-05 00:06:55

Version 903815

created: 2026-04-04 00:09:44

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_uplid/2026-04-04/1775279379
id: 903815
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: 1327
schema_scan_id: 6408931
updated: 2026-04-04 00:09:58

Version 903574

created: 2026-04-03 00:06:24

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_uplid/2026-04-03/1775192772
id: 903574
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: 1327
schema_scan_id: 6408406
updated: 2026-04-03 00:06:38

Schema Scans: 15

Last at 2026-04-17 00:20:52

Scan 6415137

duration: 0:00:11.849409

exit_message:

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

id: 6415137

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

running: False
schema_name_id: 1327
start_time: 2026-04-17 00:20:52
success: True
trace_id: 14583324515408283099

Scan 6414559

duration: 0:00:14.465309

exit_message:

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

id: 6414559

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

running: False
schema_name_id: 1327
start_time: 2026-04-16 00:08:05
success: True
trace_id: 18328108151532691256

Scan 6414108

duration: 0:00:11.836590

exit_message:

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

id: 6414108

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

running: False
schema_name_id: 1327
start_time: 2026-04-15 00:27:58
success: True
trace_id: 3870129236689276126

Scan 6413599

duration: 0:00:14.331444

exit_message:

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

id: 6413599

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

running: False
schema_name_id: 1327
start_time: 2026-04-14 00:13:31
success: True
trace_id: 13132027008673844503

Scan 6413022

duration: 0:00:11.937640

exit_message:

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

id: 6413022

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_uplid/2026-04-13/1776057300",
        "key": "raw/sparefoot_uplid/2026-04-13/1776057300/uplid_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_uplid",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 14135084725649698285,
        "service_name": "sparefoot",
        "span_id": 9600981206634542812,
        "trace_id": 14135084725649698285
    }
}

running: False
schema_name_id: 1327
start_time: 2026-04-13 00:15:14
success: True
trace_id: 14135084725649698285

Scan 6412656

duration: 0:00:11.754816

exit_message:

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

id: 6412656

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_uplid/2026-04-12/1775970689",
        "key": "raw/sparefoot_uplid/2026-04-12/1775970689/uplid_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_uplid",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 17837623784876751380,
        "service_name": "sparefoot",
        "span_id": 16490600206665681739,
        "trace_id": 17837623784876751380
    }
}

running: False
schema_name_id: 1327
start_time: 2026-04-12 00:11:35
success: True
trace_id: 17837623784876751380

Scan 6412253

duration: 0:00:11.799536

exit_message:

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

id: 6412253

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_uplid/2026-04-11/1775884158",
        "key": "raw/sparefoot_uplid/2026-04-11/1775884158/uplid_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_uplid",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 3759054238833248713,
        "service_name": "sparefoot",
        "span_id": 5869303649766960169,
        "trace_id": 3759054238833248713
    }
}

running: False
schema_name_id: 1327
start_time: 2026-04-11 00:09:22
success: True
trace_id: 3759054238833248713

Scan 6411726

duration: 0:00:14.429311

exit_message:

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

id: 6411726

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_uplid/2026-04-10/1775797547",
        "key": "raw/sparefoot_uplid/2026-04-10/1775797547/uplid_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_uplid",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 12271504490098187478,
        "service_name": "sparefoot",
        "span_id": 5456097444853211843,
        "trace_id": 12271504490098187478
    }
}

running: False
schema_name_id: 1327
start_time: 2026-04-10 00:05:50
success: True
trace_id: 12271504490098187478

Scan 6411254

duration: 0:00:14.303282

exit_message:

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

id: 6411254

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_uplid/2026-04-09/1775711635",
        "key": "raw/sparefoot_uplid/2026-04-09/1775711635/uplid_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_uplid",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 2086005453573935019,
        "service_name": "sparefoot",
        "span_id": 16336465741805794160,
        "trace_id": 2086005453573935019
    }
}

running: False
schema_name_id: 1327
start_time: 2026-04-09 00:14:06
success: True
trace_id: 2086005453573935019

Scan 6410761

duration: 0:00:11.857580

exit_message:

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

id: 6410761

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_uplid/2026-04-08/1775625225",
        "key": "raw/sparefoot_uplid/2026-04-08/1775625225/uplid_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_uplid",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 10268054839203505594,
        "service_name": "sparefoot",
        "span_id": 8863130314086453758,
        "trace_id": 10268054839203505594
    }
}

running: False
schema_name_id: 1327
start_time: 2026-04-08 00:13:53
success: True
trace_id: 10268054839203505594

Scan 6410240

duration: 0:00:11.943610

exit_message:

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

id: 6410240

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_uplid/2026-04-07/1775538690",
        "key": "raw/sparefoot_uplid/2026-04-07/1775538690/uplid_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_uplid",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 12627174961248120875,
        "service_name": "sparefoot",
        "span_id": 6498514103261624608,
        "trace_id": 12627174961248120875
    }
}

running: False
schema_name_id: 1327
start_time: 2026-04-07 00:11:36
success: True
trace_id: 12627174961248120875

Scan 6409714

duration: 0:00:14.645260

exit_message:

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

id: 6409714

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_uplid/2026-04-06/1775452366",
        "key": "raw/sparefoot_uplid/2026-04-06/1775452366/uplid_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_uplid",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 11261528444192066100,
        "service_name": "sparefoot",
        "span_id": 7341559870983893960,
        "trace_id": 11261528444192066100
    }
}

running: False
schema_name_id: 1327
start_time: 2026-04-06 00:13:17
success: True
trace_id: 11261528444192066100

Scan 6409294

duration: 0:00:14.422549

exit_message:

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

id: 6409294

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_uplid/2026-04-05/1775365585",
        "key": "raw/sparefoot_uplid/2026-04-05/1775365585/uplid_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_uplid",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 9229477441346055573,
        "service_name": "sparefoot",
        "span_id": 5367240134568767988,
        "trace_id": 9229477441346055573
    }
}

running: False
schema_name_id: 1327
start_time: 2026-04-05 00:06:41
success: True
trace_id: 9229477441346055573

Scan 6408931

duration: 0:00:14.385548

exit_message:

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

id: 6408931

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_uplid/2026-04-04/1775279379",
        "key": "raw/sparefoot_uplid/2026-04-04/1775279379/uplid_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_uplid",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 4075468071812419275,
        "service_name": "sparefoot",
        "span_id": 11988688732443507769,
        "trace_id": 4075468071812419275
    }
}

running: False
schema_name_id: 1327
start_time: 2026-04-04 00:09:44
success: True
trace_id: 4075468071812419275

Scan 6408406

duration: 0:00:14.491890

exit_message:

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

id: 6408406

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_uplid/2026-04-03/1775192772",
        "key": "raw/sparefoot_uplid/2026-04-03/1775192772/uplid_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_uplid",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 1539612943957494877,
        "service_name": "sparefoot",
        "span_id": 10595367534535503095,
        "trace_id": 1539612943957494877
    }
}

running: False
schema_name_id: 1327
start_time: 2026-04-03 00:06:23
success: True
trace_id: 1539612943957494877

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 00:20:53

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_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-stage/raw/sparefoot_uplid/2026-04-17/1776403230'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_uplid`",
    "repair_table": "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_uplid"
}

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:16:17",
        "disabled": false,
        "format": "raw",
        "id": 1327,
        "is_partitioned": false,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_stage_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 00:20:53",
        "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_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-stage/raw/sparefoot_uplid/2026-04-17/1776403230'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_uplid`",
            "repair_table": "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_uplid"
        }
    },
    "server": {
        "hostname": "schemamanager-5c55c886bf-h2ts4",
        "name": "schema_manager",
        "process_start": "2025-10-21 13:03:27",
        "sf_env": "stage",
        "version": "2112174301"
    }
}