Schema Info
Schema Name: sfdl_prod_rds.sparefoot_sparefoot_uplid_address
- created: 2022-08-18 17:23:30
- disabled: False
- format: raw
- id: 1126
- is_partitioned: False
- is_schema_datatyped: False
- name:
{ "database": "sfdl_prod_rds", "table": "sparefoot_sparefoot_uplid_address" } - type: rds
Schema Versions: 15
-
Version 1718399
- created: 2026-04-17 14:16:14
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`", "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_uplid_address`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/sparefoot_uplid_address/2026-04-17/1776453365'\n", "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_uplid_address" ] - hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_uplid_address/2026-04-17/1776453365
- id: 1718399
- 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: 1126
- schema_scan_id: 162194027
- updated: 2026-04-17 14:16:28
-
Version 1718225
- created: 2026-04-17 09:25:53
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`", "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_uplid_address`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/sparefoot_uplid_address/2026-04-17/1776435950'\n", "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_uplid_address" ] - hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_uplid_address/2026-04-17/1776435950
- id: 1718225
- 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: 1126
- schema_scan_id: 162178329
- updated: 2026-04-17 09:26:05
-
Version 1717457
- created: 2026-04-17 00:12:48
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`", "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_uplid_address`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/sparefoot_uplid_address/2026-04-17/1776402647'\n", "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_uplid_address" ] - hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_uplid_address/2026-04-17/1776402647
- id: 1717457
- 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: 1126
- schema_scan_id: 162163613
- updated: 2026-04-17 00:13:01
-
Version 1717350
- created: 2026-04-16 20:24:22
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`", "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_uplid_address`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/sparefoot_uplid_address/2026-04-16/1776388918'\n", "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_uplid_address" ] - hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_uplid_address/2026-04-16/1776388918
- id: 1717350
- 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: 1126
- schema_scan_id: 162156148
- updated: 2026-04-16 20:24:33
-
Version 1717159
- created: 2026-04-16 14:15:25
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`", "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_uplid_address`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/sparefoot_uplid_address/2026-04-16/1776366918'\n", "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_uplid_address" ] - hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_uplid_address/2026-04-16/1776366918
- id: 1717159
- 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: 1126
- schema_scan_id: 162138045
- updated: 2026-04-16 14:15:36
-
Version 1716976
- created: 2026-04-16 09:09:19
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`", "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_uplid_address`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/sparefoot_uplid_address/2026-04-16/1776348553'\n", "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_uplid_address" ] - hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_uplid_address/2026-04-16/1776348553
- id: 1716976
- 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: 1126
- schema_scan_id: 162122497
- updated: 2026-04-16 09:09:30
-
Version 1716210
- created: 2026-04-16 00:09:46
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`", "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_uplid_address`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/sparefoot_uplid_address/2026-04-16/1776316145'\n", "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_uplid_address" ] - hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_uplid_address/2026-04-16/1776316145
- id: 1716210
- 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: 1126
- schema_scan_id: 162107786
- updated: 2026-04-16 00:09:57
-
Version 1716128
- created: 2026-04-15 20:26:53
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`", "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_uplid_address`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/sparefoot_uplid_address/2026-04-15/1776302809'\n", "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_uplid_address" ] - hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_uplid_address/2026-04-15/1776302809
- id: 1716128
- 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: 1126
- schema_scan_id: 162100354
- updated: 2026-04-15 20:27:06
-
Version 1715980
- created: 2026-04-15 14:18:09
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`", "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_uplid_address`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/sparefoot_uplid_address/2026-04-15/1776280673'\n", "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_uplid_address" ] - hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_uplid_address/2026-04-15/1776280673
- id: 1715980
- 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: 1126
- schema_scan_id: 162081763
- updated: 2026-04-15 14:18:21
-
Version 1715762
- created: 2026-04-15 08:40:58
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`", "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_uplid_address`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/sparefoot_uplid_address/2026-04-15/1776260361'\n", "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_uplid_address" ] - hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_uplid_address/2026-04-15/1776260361
- id: 1715762
- 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: 1126
- schema_scan_id: 162064444
- updated: 2026-04-15 08:41:09
-
Version 1715021
- created: 2026-04-15 00:16:44
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`", "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_uplid_address`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/sparefoot_uplid_address/2026-04-15/1776230198'\n", "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_uplid_address" ] - hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_uplid_address/2026-04-15/1776230198
- id: 1715021
- 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: 1126
- schema_scan_id: 162051983
- updated: 2026-04-15 00:16:55
-
Version 1714887
- created: 2026-04-14 20:14:23
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`", "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_uplid_address`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/sparefoot_uplid_address/2026-04-14/1776215651'\n", "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_uplid_address" ] - hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_uplid_address/2026-04-14/1776215651
- id: 1714887
- 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: 1126
- schema_scan_id: 162044240
- updated: 2026-04-14 20:14:36
-
Version 1714733
- created: 2026-04-14 14:15:24
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`", "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_uplid_address`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/sparefoot_uplid_address/2026-04-14/1776194119'\n", "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_uplid_address" ] - hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_uplid_address/2026-04-14/1776194119
- id: 1714733
- 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: 1126
- schema_scan_id: 162026113
- updated: 2026-04-14 14:15:38
-
Version 1714545
- created: 2026-04-14 08:55:08
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`", "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_uplid_address`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/sparefoot_uplid_address/2026-04-14/1776174899'\n", "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_uplid_address" ] - hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_uplid_address/2026-04-14/1776174899
- id: 1714545
- 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: 1126
- schema_scan_id: 162009407
- updated: 2026-04-14 08:55:19
-
Version 1713827
- created: 2026-04-14 00:15:14
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`", "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_uplid_address`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/sparefoot_uplid_address/2026-04-14/1776143708'\n", "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_uplid_address" ] - hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_uplid_address/2026-04-14/1776143708
- id: 1713827
- 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: 1126
- schema_scan_id: 161996369
- updated: 2026-04-14 00:15:27
Schema Scans: 15
Last at 2026-04-17 14:16:14
-
Scan 162194027
- duration: 0:00:14.409279
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162194027
- 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_address/2026-04-17/1776453365", "key": "raw/sparefoot_uplid_address/2026-04-17/1776453365/uplid_address_1.parquet.gz" }, "schema": { "name": "sfdl_prod_rds.sparefoot_sparefoot_uplid_address", "type": "rds" }, "trace_context": { "parent_id": 785055954564740452, "service_name": "sparefoot", "span_id": 17305240303410305058, "trace_id": 785055954564740452 } } - running: False
- schema_name_id: 1126
- start_time: 2026-04-17 14:16:14
- success: True
- trace_id: 785055954564740452
-
Scan 162178329
- duration: 0:00:11.698620
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162178329
- 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_address/2026-04-17/1776435950", "key": "raw/sparefoot_uplid_address/2026-04-17/1776435950/uplid_address_1.parquet.gz" }, "schema": { "name": "sfdl_prod_rds.sparefoot_sparefoot_uplid_address", "type": "rds" }, "trace_context": { "parent_id": 16369626816143244034, "service_name": "sparefoot", "span_id": 16917317360621116147, "trace_id": 16369626816143244034 } } - running: False
- schema_name_id: 1126
- start_time: 2026-04-17 09:25:53
- success: True
- trace_id: 16369626816143244034
-
Scan 162163613
- duration: 0:00:14.337010
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162163613
- 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_address/2026-04-17/1776402647", "key": "raw/sparefoot_uplid_address/2026-04-17/1776402647/uplid_address_1.parquet.gz" }, "schema": { "name": "sfdl_prod_rds.sparefoot_sparefoot_uplid_address", "type": "rds" }, "trace_context": { "parent_id": 2073754340413434330, "service_name": "sparefoot", "span_id": 4287891834784709824, "trace_id": 2073754340413434330 } } - running: False
- schema_name_id: 1126
- start_time: 2026-04-17 00:12:47
- success: True
- trace_id: 2073754340413434330
-
Scan 162156148
- duration: 0:00:11.828435
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162156148
- 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_address/2026-04-16/1776388918", "key": "raw/sparefoot_uplid_address/2026-04-16/1776388918/uplid_address_1.parquet.gz" }, "schema": { "name": "sfdl_prod_rds.sparefoot_sparefoot_uplid_address", "type": "rds" }, "trace_context": { "parent_id": 1794565229348451318, "service_name": "sparefoot", "span_id": 9093367981422220739, "trace_id": 1794565229348451318 } } - running: False
- schema_name_id: 1126
- start_time: 2026-04-16 20:24:21
- success: True
- trace_id: 1794565229348451318
-
Scan 162138045
- duration: 0:00:11.666466
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162138045
- 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_address/2026-04-16/1776366918", "key": "raw/sparefoot_uplid_address/2026-04-16/1776366918/uplid_address_1.parquet.gz" }, "schema": { "name": "sfdl_prod_rds.sparefoot_sparefoot_uplid_address", "type": "rds" }, "trace_context": { "parent_id": 1019992392335453660, "service_name": "sparefoot", "span_id": 9857279013505697892, "trace_id": 1019992392335453660 } } - running: False
- schema_name_id: 1126
- start_time: 2026-04-16 14:15:25
- success: True
- trace_id: 1019992392335453660
-
Scan 162122497
- duration: 0:00:11.848956
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162122497
- 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_address/2026-04-16/1776348553", "key": "raw/sparefoot_uplid_address/2026-04-16/1776348553/uplid_address_1.parquet.gz" }, "schema": { "name": "sfdl_prod_rds.sparefoot_sparefoot_uplid_address", "type": "rds" }, "trace_context": { "parent_id": 1593884341167432632, "service_name": "sparefoot", "span_id": 9192876086327376908, "trace_id": 1593884341167432632 } } - running: False
- schema_name_id: 1126
- start_time: 2026-04-16 09:09:18
- success: True
- trace_id: 1593884341167432632
-
Scan 162107786
- duration: 0:00:11.753593
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162107786
- 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_address/2026-04-16/1776316145", "key": "raw/sparefoot_uplid_address/2026-04-16/1776316145/uplid_address_1.parquet.gz" }, "schema": { "name": "sfdl_prod_rds.sparefoot_sparefoot_uplid_address", "type": "rds" }, "trace_context": { "parent_id": 17181001365192652766, "service_name": "sparefoot", "span_id": 5196444547846802895, "trace_id": 17181001365192652766 } } - running: False
- schema_name_id: 1126
- start_time: 2026-04-16 00:09:45
- success: True
- trace_id: 17181001365192652766
-
Scan 162100354
- duration: 0:00:14.258763
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162100354
- 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_address/2026-04-15/1776302809", "key": "raw/sparefoot_uplid_address/2026-04-15/1776302809/uplid_address_1.parquet.gz" }, "schema": { "name": "sfdl_prod_rds.sparefoot_sparefoot_uplid_address", "type": "rds" }, "trace_context": { "parent_id": 15500557191031940121, "service_name": "sparefoot", "span_id": 5902337427889242573, "trace_id": 15500557191031940121 } } - running: False
- schema_name_id: 1126
- start_time: 2026-04-15 20:26:52
- success: True
- trace_id: 15500557191031940121
-
Scan 162081763
- duration: 0:00:11.929744
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162081763
- 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_address/2026-04-15/1776280673", "key": "raw/sparefoot_uplid_address/2026-04-15/1776280673/uplid_address_1.parquet.gz" }, "schema": { "name": "sfdl_prod_rds.sparefoot_sparefoot_uplid_address", "type": "rds" }, "trace_context": { "parent_id": 5664680867927292239, "service_name": "sparefoot", "span_id": 4201552726706831976, "trace_id": 5664680867927292239 } } - running: False
- schema_name_id: 1126
- start_time: 2026-04-15 14:18:09
- success: True
- trace_id: 5664680867927292239
-
Scan 162064444
- duration: 0:00:11.717817
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162064444
- 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_address/2026-04-15/1776260361", "key": "raw/sparefoot_uplid_address/2026-04-15/1776260361/uplid_address_1.parquet.gz" }, "schema": { "name": "sfdl_prod_rds.sparefoot_sparefoot_uplid_address", "type": "rds" }, "trace_context": { "parent_id": 9422119479030909965, "service_name": "sparefoot", "span_id": 15477624493168199091, "trace_id": 9422119479030909965 } } - running: False
- schema_name_id: 1126
- start_time: 2026-04-15 08:40:58
- success: True
- trace_id: 9422119479030909965
-
Scan 162051983
- duration: 0:00:11.786648
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162051983
- 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_address/2026-04-15/1776230198", "key": "raw/sparefoot_uplid_address/2026-04-15/1776230198/uplid_address_1.parquet.gz" }, "schema": { "name": "sfdl_prod_rds.sparefoot_sparefoot_uplid_address", "type": "rds" }, "trace_context": { "parent_id": 7585781928264949022, "service_name": "sparefoot", "span_id": 13044453686033333130, "trace_id": 7585781928264949022 } } - running: False
- schema_name_id: 1126
- start_time: 2026-04-15 00:16:44
- success: True
- trace_id: 7585781928264949022
-
Scan 162044240
- duration: 0:00:14.407647
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162044240
- 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_address/2026-04-14/1776215651", "key": "raw/sparefoot_uplid_address/2026-04-14/1776215651/uplid_address_1.parquet.gz" }, "schema": { "name": "sfdl_prod_rds.sparefoot_sparefoot_uplid_address", "type": "rds" }, "trace_context": { "parent_id": 2623748472854034609, "service_name": "sparefoot", "span_id": 10171756754776560502, "trace_id": 2623748472854034609 } } - running: False
- schema_name_id: 1126
- start_time: 2026-04-14 20:14:22
- success: True
- trace_id: 2623748472854034609
-
Scan 162026113
- duration: 0:00:14.229423
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162026113
- 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_address/2026-04-14/1776194119", "key": "raw/sparefoot_uplid_address/2026-04-14/1776194119/uplid_address_1.parquet.gz" }, "schema": { "name": "sfdl_prod_rds.sparefoot_sparefoot_uplid_address", "type": "rds" }, "trace_context": { "parent_id": 7648226377020067518, "service_name": "sparefoot", "span_id": 17536404966418603516, "trace_id": 7648226377020067518 } } - running: False
- schema_name_id: 1126
- start_time: 2026-04-14 14:15:24
- success: True
- trace_id: 7648226377020067518
-
Scan 162009407
- duration: 0:00:11.839611
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162009407
- 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_address/2026-04-14/1776174899", "key": "raw/sparefoot_uplid_address/2026-04-14/1776174899/uplid_address_1.parquet.gz" }, "schema": { "name": "sfdl_prod_rds.sparefoot_sparefoot_uplid_address", "type": "rds" }, "trace_context": { "parent_id": 15583405056133273704, "service_name": "sparefoot", "span_id": 10304713010159679078, "trace_id": 15583405056133273704 } } - running: False
- schema_name_id: 1126
- start_time: 2026-04-14 08:55:08
- success: True
- trace_id: 15583405056133273704
-
Scan 161996369
- duration: 0:00:14.268520
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161996369
- 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_address/2026-04-14/1776143708", "key": "raw/sparefoot_uplid_address/2026-04-14/1776143708/uplid_address_1.parquet.gz" }, "schema": { "name": "sfdl_prod_rds.sparefoot_sparefoot_uplid_address", "type": "rds" }, "trace_context": { "parent_id": 18193912771490116975, "service_name": "sparefoot", "span_id": 2017563185859623105, "trace_id": 18193912771490116975 } } - running: False
- schema_name_id: 1126
- start_time: 2026-04-14 00:15:13
- success: True
- trace_id: 18193912771490116975
- 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 14:16:14
- 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_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-prod/raw/sparefoot_uplid_address/2026-04-17/1776453365'\n", "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_uplid_address`", "repair_table": "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_uplid_address" }
- hostname: schemamanager-5475496c57-7dpqb
- name: schema_manager
- process_start: 2026-01-09 11:27:47
- sf_env: prod
- version: 2112174301
{
"name": {
"created": "2022-08-18 17:23:30",
"disabled": false,
"format": "raw",
"id": 1126,
"is_partitioned": false,
"is_schema_datatyped": false,
"name": {
"database": "sfdl_prod_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 14:16:14",
"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_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-prod/raw/sparefoot_uplid_address/2026-04-17/1776453365'\n",
"drop_table": "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_uplid_address`",
"repair_table": "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_uplid_address"
}
},
"server": {
"hostname": "schemamanager-5475496c57-7dpqb",
"name": "schema_manager",
"process_start": "2026-01-09 11:27:47",
"sf_env": "prod",
"version": "2112174301"
}
}