Schema Info

Schema Name: sfdl_stage_rds.sparefoot_sparefoot_uplid_address

created: 2022-08-12 10:57:54
disabled: False
format: raw
id: 1382
is_partitioned: False
is_schema_datatyped: False

name:

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

type: rds

Schema Versions: 15

Version 906530

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_uplid_address`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_uplid_address`\n(\n `city`  string , `created_at`  timestamp , `state`  string , `street_address_1`  string , `street_address_2`  string , `updated_at`  timestamp , `uplid_address_id`  int , `uplid_id`  int \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_address/2026-04-17/1776402844'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_uplid_address"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_uplid_address/2026-04-17/1776402844
id: 906530
processed: 1

raw_data:

{
    "city": "string",
    "created_at": "timestamp[ns]",
    "state": "string",
    "street_address_1": "string",
    "street_address_2": "string",
    "updated_at": "timestamp[ns]",
    "uplid_address_id": "int32",
    "uplid_id": "int32"
}

schema_attributes:

{
    "city": "string",
    "created_at": "timestamp",
    "state": "string",
    "street_address_1": "string",
    "street_address_2": "string",
    "updated_at": "timestamp",
    "uplid_address_id": "int",
    "uplid_id": "int"
}

schema_name_id: 1382
schema_scan_id: 6415097
updated: 2026-04-17 00:14:21

Version 906327

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_uplid_address`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_uplid_address`\n(\n `city`  string , `created_at`  timestamp , `state`  string , `street_address_1`  string , `street_address_2`  string , `updated_at`  timestamp , `uplid_address_id`  int , `uplid_id`  int \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_address/2026-04-16/1776316087'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_uplid_address"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_uplid_address/2026-04-16/1776316087
id: 906327
processed: 1

raw_data:

{
    "city": "string",
    "created_at": "timestamp[ns]",
    "state": "string",
    "street_address_1": "string",
    "street_address_2": "string",
    "updated_at": "timestamp[ns]",
    "uplid_address_id": "int32",
    "uplid_id": "int32"
}

schema_attributes:

{
    "city": "string",
    "created_at": "timestamp",
    "state": "string",
    "street_address_1": "string",
    "street_address_2": "string",
    "updated_at": "timestamp",
    "uplid_address_id": "int",
    "uplid_id": "int"
}

schema_name_id: 1382
schema_scan_id: 6414561
updated: 2026-04-16 00:08:26

Version 906137

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_uplid_address`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_uplid_address`\n(\n `city`  string , `created_at`  timestamp , `state`  string , `street_address_1`  string , `street_address_2`  string , `updated_at`  timestamp , `uplid_address_id`  int , `uplid_id`  int \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_address/2026-04-15/1776230838'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_uplid_address"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_uplid_address/2026-04-15/1776230838
id: 906137
processed: 1

raw_data:

{
    "city": "string",
    "created_at": "timestamp[ns]",
    "state": "string",
    "street_address_1": "string",
    "street_address_2": "string",
    "updated_at": "timestamp[ns]",
    "uplid_address_id": "int32",
    "uplid_id": "int32"
}

schema_attributes:

{
    "city": "string",
    "created_at": "timestamp",
    "state": "string",
    "street_address_1": "string",
    "street_address_2": "string",
    "updated_at": "timestamp",
    "uplid_address_id": "int",
    "uplid_id": "int"
}

schema_name_id: 1382
schema_scan_id: 6414101
updated: 2026-04-15 00:27:44

Version 905900

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_uplid_address`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_uplid_address`\n(\n `city`  string , `created_at`  timestamp , `state`  string , `street_address_1`  string , `street_address_2`  string , `updated_at`  timestamp , `uplid_address_id`  int , `uplid_id`  int \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_address/2026-04-14/1776143419'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_uplid_address"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_uplid_address/2026-04-14/1776143419
id: 905900
processed: 1

raw_data:

{
    "city": "string",
    "created_at": "timestamp[ns]",
    "state": "string",
    "street_address_1": "string",
    "street_address_2": "string",
    "updated_at": "timestamp[ns]",
    "uplid_address_id": "int32",
    "uplid_id": "int32"
}

schema_attributes:

{
    "city": "string",
    "created_at": "timestamp",
    "state": "string",
    "street_address_1": "string",
    "street_address_2": "string",
    "updated_at": "timestamp",
    "uplid_address_id": "int",
    "uplid_id": "int"
}

schema_name_id: 1382
schema_scan_id: 6413566
updated: 2026-04-14 00:10:37

Version 905692

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_uplid_address`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_uplid_address`\n(\n `city`  string , `created_at`  timestamp , `state`  string , `street_address_1`  string , `street_address_2`  string , `updated_at`  timestamp , `uplid_address_id`  int , `uplid_id`  int \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_address/2026-04-13/1776057329'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_uplid_address"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_uplid_address/2026-04-13/1776057329
id: 905692
processed: 1

raw_data:

{
    "city": "string",
    "created_at": "timestamp[ns]",
    "state": "string",
    "street_address_1": "string",
    "street_address_2": "string",
    "updated_at": "timestamp[ns]",
    "uplid_address_id": "int32",
    "uplid_id": "int32"
}

schema_attributes:

{
    "city": "string",
    "created_at": "timestamp",
    "state": "string",
    "street_address_1": "string",
    "street_address_2": "string",
    "updated_at": "timestamp",
    "uplid_address_id": "int",
    "uplid_id": "int"
}

schema_name_id: 1382
schema_scan_id: 6413025
updated: 2026-04-13 00:15:44

Version 905488

created: 2026-04-12 00:09:09

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_uplid_address`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_uplid_address`\n(\n `city`  string , `created_at`  timestamp , `state`  string , `street_address_1`  string , `street_address_2`  string , `updated_at`  timestamp , `uplid_address_id`  int , `uplid_id`  int \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_address/2026-04-12/1775970544'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_uplid_address"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_uplid_address/2026-04-12/1775970544
id: 905488
processed: 1

raw_data:

{
    "city": "string",
    "created_at": "timestamp[ns]",
    "state": "string",
    "street_address_1": "string",
    "street_address_2": "string",
    "updated_at": "timestamp[ns]",
    "uplid_address_id": "int32",
    "uplid_id": "int32"
}

schema_attributes:

{
    "city": "string",
    "created_at": "timestamp",
    "state": "string",
    "street_address_1": "string",
    "street_address_2": "string",
    "updated_at": "timestamp",
    "uplid_address_id": "int",
    "uplid_id": "int"
}

schema_name_id: 1382
schema_scan_id: 6412639
updated: 2026-04-12 00:09:20

Version 905272

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_uplid_address`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_uplid_address`\n(\n `city`  string , `created_at`  timestamp , `state`  string , `street_address_1`  string , `street_address_2`  string , `updated_at`  timestamp , `uplid_address_id`  int , `uplid_id`  int \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_address/2026-04-11/1775884113'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_uplid_address"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_uplid_address/2026-04-11/1775884113
id: 905272
processed: 1

raw_data:

{
    "city": "string",
    "created_at": "timestamp[ns]",
    "state": "string",
    "street_address_1": "string",
    "street_address_2": "string",
    "updated_at": "timestamp[ns]",
    "uplid_address_id": "int32",
    "uplid_id": "int32"
}

schema_attributes:

{
    "city": "string",
    "created_at": "timestamp",
    "state": "string",
    "street_address_1": "string",
    "street_address_2": "string",
    "updated_at": "timestamp",
    "uplid_address_id": "int",
    "uplid_id": "int"
}

schema_name_id: 1382
schema_scan_id: 6412243
updated: 2026-04-11 00:08:52

Version 905046

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_uplid_address`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_uplid_address`\n(\n `city`  string , `created_at`  timestamp , `state`  string , `street_address_1`  string , `street_address_2`  string , `updated_at`  timestamp , `uplid_address_id`  int , `uplid_id`  int \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_address/2026-04-10/1775797546'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_uplid_address"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_uplid_address/2026-04-10/1775797546
id: 905046
processed: 1

raw_data:

{
    "city": "string",
    "created_at": "timestamp[ns]",
    "state": "string",
    "street_address_1": "string",
    "street_address_2": "string",
    "updated_at": "timestamp[ns]",
    "uplid_address_id": "int32",
    "uplid_id": "int32"
}

schema_attributes:

{
    "city": "string",
    "created_at": "timestamp",
    "state": "string",
    "street_address_1": "string",
    "street_address_2": "string",
    "updated_at": "timestamp",
    "uplid_address_id": "int",
    "uplid_id": "int"
}

schema_name_id: 1382
schema_scan_id: 6411725
updated: 2026-04-10 00:06:03

Version 904863

created: 2026-04-09 00:13:40

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_uplid_address`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_uplid_address`\n(\n `city`  string , `created_at`  timestamp , `state`  string , `street_address_1`  string , `street_address_2`  string , `updated_at`  timestamp , `uplid_address_id`  int , `uplid_id`  int \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_address/2026-04-09/1775711609'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_uplid_address"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_uplid_address/2026-04-09/1775711609
id: 904863
processed: 1

raw_data:

{
    "city": "string",
    "created_at": "timestamp[ns]",
    "state": "string",
    "street_address_1": "string",
    "street_address_2": "string",
    "updated_at": "timestamp[ns]",
    "uplid_address_id": "int32",
    "uplid_id": "int32"
}

schema_attributes:

{
    "city": "string",
    "created_at": "timestamp",
    "state": "string",
    "street_address_1": "string",
    "street_address_2": "string",
    "updated_at": "timestamp",
    "uplid_address_id": "int",
    "uplid_id": "int"
}

schema_name_id: 1382
schema_scan_id: 6411250
updated: 2026-04-09 00:13:51

Version 904672

created: 2026-04-08 00:31:20

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_uplid_address`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_uplid_address`\n(\n `city`  string , `created_at`  timestamp , `state`  string , `street_address_1`  string , `street_address_2`  string , `updated_at`  timestamp , `uplid_address_id`  int , `uplid_id`  int \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_address/2026-04-08/1775626264'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_uplid_address"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_uplid_address/2026-04-08/1775626264
id: 904672
processed: 1

raw_data:

{
    "city": "string",
    "created_at": "timestamp[ns]",
    "state": "string",
    "street_address_1": "string",
    "street_address_2": "string",
    "updated_at": "timestamp[ns]",
    "uplid_address_id": "int32",
    "uplid_id": "int32"
}

schema_attributes:

{
    "city": "string",
    "created_at": "timestamp",
    "state": "string",
    "street_address_1": "string",
    "street_address_2": "string",
    "updated_at": "timestamp",
    "uplid_address_id": "int",
    "uplid_id": "int"
}

schema_name_id: 1382
schema_scan_id: 6410775
updated: 2026-04-08 00:31:31

Version 904435

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_uplid_address`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_uplid_address`\n(\n `city`  string , `created_at`  timestamp , `state`  string , `street_address_1`  string , `street_address_2`  string , `updated_at`  timestamp , `uplid_address_id`  int , `uplid_id`  int \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_address/2026-04-07/1775538684'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_uplid_address"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_uplid_address/2026-04-07/1775538684
id: 904435
processed: 1

raw_data:

{
    "city": "string",
    "created_at": "timestamp[ns]",
    "state": "string",
    "street_address_1": "string",
    "street_address_2": "string",
    "updated_at": "timestamp[ns]",
    "uplid_address_id": "int32",
    "uplid_id": "int32"
}

schema_attributes:

{
    "city": "string",
    "created_at": "timestamp",
    "state": "string",
    "street_address_1": "string",
    "street_address_2": "string",
    "updated_at": "timestamp",
    "uplid_address_id": "int",
    "uplid_id": "int"
}

schema_name_id: 1382
schema_scan_id: 6410239
updated: 2026-04-07 00:11:41

Version 904229

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_uplid_address`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_uplid_address`\n(\n `city`  string , `created_at`  timestamp , `state`  string , `street_address_1`  string , `street_address_2`  string , `updated_at`  timestamp , `uplid_address_id`  int , `uplid_id`  int \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_address/2026-04-06/1775452254'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_uplid_address"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_uplid_address/2026-04-06/1775452254
id: 904229
processed: 1

raw_data:

{
    "city": "string",
    "created_at": "timestamp[ns]",
    "state": "string",
    "street_address_1": "string",
    "street_address_2": "string",
    "updated_at": "timestamp[ns]",
    "uplid_address_id": "int32",
    "uplid_id": "int32"
}

schema_attributes:

{
    "city": "string",
    "created_at": "timestamp",
    "state": "string",
    "street_address_1": "string",
    "street_address_2": "string",
    "updated_at": "timestamp",
    "uplid_address_id": "int",
    "uplid_id": "int"
}

schema_name_id: 1382
schema_scan_id: 6409702
updated: 2026-04-06 00:11:17

Version 903993

created: 2026-04-05 00:05:52

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_uplid_address`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_uplid_address`\n(\n `city`  string , `created_at`  timestamp , `state`  string , `street_address_1`  string , `street_address_2`  string , `updated_at`  timestamp , `uplid_address_id`  int , `uplid_id`  int \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_address/2026-04-05/1775365544'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_uplid_address"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_uplid_address/2026-04-05/1775365544
id: 903993
processed: 1

raw_data:

{
    "city": "string",
    "created_at": "timestamp[ns]",
    "state": "string",
    "street_address_1": "string",
    "street_address_2": "string",
    "updated_at": "timestamp[ns]",
    "uplid_address_id": "int32",
    "uplid_id": "int32"
}

schema_attributes:

{
    "city": "string",
    "created_at": "timestamp",
    "state": "string",
    "street_address_1": "string",
    "street_address_2": "string",
    "updated_at": "timestamp",
    "uplid_address_id": "int",
    "uplid_id": "int"
}

schema_name_id: 1382
schema_scan_id: 6409286
updated: 2026-04-05 00:06:06

Version 903820

created: 2026-04-04 00:10:07

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_uplid_address`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_uplid_address`\n(\n `city`  string , `created_at`  timestamp , `state`  string , `street_address_1`  string , `street_address_2`  string , `updated_at`  timestamp , `uplid_address_id`  int , `uplid_id`  int \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_address/2026-04-04/1775279403'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_uplid_address"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_uplid_address/2026-04-04/1775279403
id: 903820
processed: 1

raw_data:

{
    "city": "string",
    "created_at": "timestamp[ns]",
    "state": "string",
    "street_address_1": "string",
    "street_address_2": "string",
    "updated_at": "timestamp[ns]",
    "uplid_address_id": "int32",
    "uplid_id": "int32"
}

schema_attributes:

{
    "city": "string",
    "created_at": "timestamp",
    "state": "string",
    "street_address_1": "string",
    "street_address_2": "string",
    "updated_at": "timestamp",
    "uplid_address_id": "int",
    "uplid_id": "int"
}

schema_name_id: 1382
schema_scan_id: 6408936
updated: 2026-04-04 00:10:21

Version 903575

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_uplid_address`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_uplid_address`\n(\n `city`  string , `created_at`  timestamp , `state`  string , `street_address_1`  string , `street_address_2`  string , `updated_at`  timestamp , `uplid_address_id`  int , `uplid_id`  int \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_address/2026-04-03/1775192781'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_uplid_address"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_uplid_address/2026-04-03/1775192781
id: 903575
processed: 1

raw_data:

{
    "city": "string",
    "created_at": "timestamp[ns]",
    "state": "string",
    "street_address_1": "string",
    "street_address_2": "string",
    "updated_at": "timestamp[ns]",
    "uplid_address_id": "int32",
    "uplid_id": "int32"
}

schema_attributes:

{
    "city": "string",
    "created_at": "timestamp",
    "state": "string",
    "street_address_1": "string",
    "street_address_2": "string",
    "updated_at": "timestamp",
    "uplid_address_id": "int",
    "uplid_id": "int"
}

schema_name_id: 1382
schema_scan_id: 6408407
updated: 2026-04-03 00:06:40

Schema Scans: 15

Last at 2026-04-17 00:14:09

Scan 6415097

duration: 0:00:11.708862

exit_message:

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

id: 6415097

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_address/2026-04-17/1776402844",
        "key": "raw/sparefoot_uplid_address/2026-04-17/1776402844/uplid_address_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_uplid_address",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 7439128409037379426,
        "service_name": "sparefoot",
        "span_id": 10758035787813909701,
        "trace_id": 7439128409037379426
    }
}

running: False
schema_name_id: 1382
start_time: 2026-04-17 00:14:09
success: True
trace_id: 7439128409037379426

Scan 6414561

duration: 0:00:11.671648

exit_message:

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

id: 6414561

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_address/2026-04-16/1776316087",
        "key": "raw/sparefoot_uplid_address/2026-04-16/1776316087/uplid_address_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_uplid_address",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 10410876421109361008,
        "service_name": "sparefoot",
        "span_id": 14748130805857350843,
        "trace_id": 10410876421109361008
    }
}

running: False
schema_name_id: 1382
start_time: 2026-04-16 00:08:15
success: True
trace_id: 10410876421109361008

Scan 6414101

duration: 0:00:11.839262

exit_message:

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

id: 6414101

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_address/2026-04-15/1776230838",
        "key": "raw/sparefoot_uplid_address/2026-04-15/1776230838/uplid_address_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_uplid_address",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 1635901131888892512,
        "service_name": "sparefoot",
        "span_id": 9863779714108886421,
        "trace_id": 1635901131888892512
    }
}

running: False
schema_name_id: 1382
start_time: 2026-04-15 00:27:32
success: True
trace_id: 1635901131888892512

Scan 6413566

duration: 0:00:14.595054

exit_message:

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

id: 6413566

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_address/2026-04-14/1776143419",
        "key": "raw/sparefoot_uplid_address/2026-04-14/1776143419/uplid_address_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_uplid_address",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 7767497292678122179,
        "service_name": "sparefoot",
        "span_id": 4456181070033304771,
        "trace_id": 7767497292678122179
    }
}

running: False
schema_name_id: 1382
start_time: 2026-04-14 00:10:22
success: True
trace_id: 7767497292678122179

Scan 6413025

duration: 0:00:11.700903

exit_message:

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

id: 6413025

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_address/2026-04-13/1776057329",
        "key": "raw/sparefoot_uplid_address/2026-04-13/1776057329/uplid_address_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_uplid_address",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 8582550759261481705,
        "service_name": "sparefoot",
        "span_id": 3812032147726781661,
        "trace_id": 8582550759261481705
    }
}

running: False
schema_name_id: 1382
start_time: 2026-04-13 00:15:32
success: True
trace_id: 8582550759261481705

Scan 6412639

duration: 0:00:11.696722

exit_message:

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

id: 6412639

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_address/2026-04-12/1775970544",
        "key": "raw/sparefoot_uplid_address/2026-04-12/1775970544/uplid_address_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_uplid_address",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 8168804658977931468,
        "service_name": "sparefoot",
        "span_id": 18374648414971281377,
        "trace_id": 8168804658977931468
    }
}

running: False
schema_name_id: 1382
start_time: 2026-04-12 00:09:08
success: True
trace_id: 8168804658977931468

Scan 6412243

duration: 0:00:11.726317

exit_message:

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

id: 6412243

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_address/2026-04-11/1775884113",
        "key": "raw/sparefoot_uplid_address/2026-04-11/1775884113/uplid_address_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_uplid_address",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 7256958915586680305,
        "service_name": "sparefoot",
        "span_id": 16489962120043953573,
        "trace_id": 7256958915586680305
    }
}

running: False
schema_name_id: 1382
start_time: 2026-04-11 00:08:40
success: True
trace_id: 7256958915586680305

Scan 6411725

duration: 0:00:14.233843

exit_message:

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

id: 6411725

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_address/2026-04-10/1775797546",
        "key": "raw/sparefoot_uplid_address/2026-04-10/1775797546/uplid_address_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_uplid_address",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 15313217988057440350,
        "service_name": "sparefoot",
        "span_id": 6594917466054664981,
        "trace_id": 15313217988057440350
    }
}

running: False
schema_name_id: 1382
start_time: 2026-04-10 00:05:49
success: True
trace_id: 15313217988057440350

Scan 6411250

duration: 0:00:11.928943

exit_message:

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

id: 6411250

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_address/2026-04-09/1775711609",
        "key": "raw/sparefoot_uplid_address/2026-04-09/1775711609/uplid_address_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_uplid_address",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 4082459962855267110,
        "service_name": "sparefoot",
        "span_id": 17510741756276482829,
        "trace_id": 4082459962855267110
    }
}

running: False
schema_name_id: 1382
start_time: 2026-04-09 00:13:39
success: True
trace_id: 4082459962855267110

Scan 6410775

duration: 0:00:11.802379

exit_message:

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

id: 6410775

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_address/2026-04-08/1775626264",
        "key": "raw/sparefoot_uplid_address/2026-04-08/1775626264/uplid_address_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_uplid_address",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 17675477954640271815,
        "service_name": "sparefoot",
        "span_id": 7008067247749270325,
        "trace_id": 17675477954640271815
    }
}

running: False
schema_name_id: 1382
start_time: 2026-04-08 00:31:19
success: True
trace_id: 17675477954640271815

Scan 6410239

duration: 0:00:11.796384

exit_message:

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

id: 6410239

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_address/2026-04-07/1775538684",
        "key": "raw/sparefoot_uplid_address/2026-04-07/1775538684/uplid_address_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_uplid_address",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 8063175668162249609,
        "service_name": "sparefoot",
        "span_id": 7167008058060492096,
        "trace_id": 8063175668162249609
    }
}

running: False
schema_name_id: 1382
start_time: 2026-04-07 00:11:29
success: True
trace_id: 8063175668162249609

Scan 6409702

duration: 0:00:14.336953

exit_message:

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

id: 6409702

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_address/2026-04-06/1775452254",
        "key": "raw/sparefoot_uplid_address/2026-04-06/1775452254/uplid_address_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_uplid_address",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 13209967200518462337,
        "service_name": "sparefoot",
        "span_id": 7707141911996502010,
        "trace_id": 13209967200518462337
    }
}

running: False
schema_name_id: 1382
start_time: 2026-04-06 00:11:03
success: True
trace_id: 13209967200518462337

Scan 6409286

duration: 0:00:14.621522

exit_message:

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

id: 6409286

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_address/2026-04-05/1775365544",
        "key": "raw/sparefoot_uplid_address/2026-04-05/1775365544/uplid_address_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_uplid_address",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 7186537297235376464,
        "service_name": "sparefoot",
        "span_id": 11816026294074808167,
        "trace_id": 7186537297235376464
    }
}

running: False
schema_name_id: 1382
start_time: 2026-04-05 00:05:52
success: True
trace_id: 7186537297235376464

Scan 6408936

duration: 0:00:14.389943

exit_message:

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

id: 6408936

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_address/2026-04-04/1775279403",
        "key": "raw/sparefoot_uplid_address/2026-04-04/1775279403/uplid_address_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_uplid_address",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 9701042237319101838,
        "service_name": "sparefoot",
        "span_id": 3140566005778101906,
        "trace_id": 9701042237319101838
    }
}

running: False
schema_name_id: 1382
start_time: 2026-04-04 00:10:07
success: True
trace_id: 9701042237319101838

Scan 6408407

duration: 0:00:14.418929

exit_message:

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

id: 6408407

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_address/2026-04-03/1775192781",
        "key": "raw/sparefoot_uplid_address/2026-04-03/1775192781/uplid_address_1.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_uplid_address",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 6416115432168241059,
        "service_name": "sparefoot",
        "span_id": 2423688931839862496,
        "trace_id": 6416115432168241059
    }
}

running: False
schema_name_id: 1382
start_time: 2026-04-03 00:06:25
success: True
trace_id: 6416115432168241059

Partitions:

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

Schema:

attributes:

{
    "city": "string",
    "created_at": "timestamp",
    "state": "string",
    "street_address_1": "string",
    "street_address_2": "string",
    "updated_at": "timestamp",
    "uplid_address_id": "int",
    "uplid_id": "int"
}

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

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_address`\n(\n `city`  string , `created_at`  timestamp , `state`  string , `street_address_1`  string , `street_address_2`  string , `updated_at`  timestamp , `uplid_address_id`  int , `uplid_id`  int \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_address/2026-04-17/1776402844'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_uplid_address`",
    "repair_table": "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_uplid_address"
}

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:57:54",
        "disabled": false,
        "format": "raw",
        "id": 1382,
        "is_partitioned": false,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_stage_rds",
            "table": "sparefoot_sparefoot_uplid_address"
        },
        "type": "rds"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "city": "string",
            "created_at": "timestamp",
            "state": "string",
            "street_address_1": "string",
            "street_address_2": "string",
            "updated_at": "timestamp",
            "uplid_address_id": "int",
            "uplid_id": "int"
        },
        "created": "2026-04-17 00:14:10",
        "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_address`\n(\n `city`  string , `created_at`  timestamp , `state`  string , `street_address_1`  string , `street_address_2`  string , `updated_at`  timestamp , `uplid_address_id`  int , `uplid_id`  int \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_address/2026-04-17/1776402844'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_uplid_address`",
            "repair_table": "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_uplid_address"
        }
    },
    "server": {
        "hostname": "schemamanager-5c55c886bf-h2ts4",
        "name": "schema_manager",
        "process_start": "2025-10-21 13:03:27",
        "sf_env": "stage",
        "version": "2112174301"
    }
}