Schema Info

Schema Name: sfdl_stage_rds.sparefoot_sparefoot_sitelink_facilities

created: 2022-08-12 11:00:16
disabled: False
format: raw
id: 1396
is_partitioned: False
is_schema_datatyped: False

name:

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

type: rds

Schema Versions: 15

Version 906586

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_sitelink_facilities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_sitelink_facilities`\n(\n `anniversary_billing`  smallint , `created`  timestamp , `email`  string , `id`  int , `last_polled_ticks`  string , `listing_avail_id`  int , `location_id`  int , `modified`  timestamp , `sitelink_corp_id`  int , `sitelink_location_code`  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_sitelink_facilities/2026-04-17/1776404196'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_sitelink_facilities"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_sitelink_facilities/2026-04-17/1776404196
id: 906586
processed: 1

raw_data:

{
    "anniversary_billing": "int16",
    "created": "timestamp[ns]",
    "email": "string",
    "id": "int32",
    "last_polled_ticks": "string",
    "listing_avail_id": "int32",
    "location_id": "int32",
    "modified": "timestamp[ns]",
    "sitelink_corp_id": "int32",
    "sitelink_location_code": "string"
}

schema_attributes:

{
    "anniversary_billing": "smallint",
    "created": "timestamp",
    "email": "string",
    "id": "int",
    "last_polled_ticks": "string",
    "listing_avail_id": "int",
    "location_id": "int",
    "modified": "timestamp",
    "sitelink_corp_id": "int",
    "sitelink_location_code": "string"
}

schema_name_id: 1396
schema_scan_id: 6415154
updated: 2026-04-17 00:36:54

Version 906361

created: 2026-04-16 00:12:57

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_sitelink_facilities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_sitelink_facilities`\n(\n `anniversary_billing`  smallint , `created`  timestamp , `email`  string , `id`  int , `last_polled_ticks`  string , `listing_avail_id`  int , `location_id`  int , `modified`  timestamp , `sitelink_corp_id`  int , `sitelink_location_code`  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_sitelink_facilities/2026-04-16/1776316355'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_sitelink_facilities"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_sitelink_facilities/2026-04-16/1776316355
id: 906361
processed: 1

raw_data:

{
    "anniversary_billing": "int16",
    "created": "timestamp[ns]",
    "email": "string",
    "id": "int32",
    "last_polled_ticks": "string",
    "listing_avail_id": "int32",
    "location_id": "int32",
    "modified": "timestamp[ns]",
    "sitelink_corp_id": "int32",
    "sitelink_location_code": "string"
}

schema_attributes:

{
    "anniversary_billing": "smallint",
    "created": "timestamp",
    "email": "string",
    "id": "int",
    "last_polled_ticks": "string",
    "listing_avail_id": "int",
    "location_id": "int",
    "modified": "timestamp",
    "sitelink_corp_id": "int",
    "sitelink_location_code": "string"
}

schema_name_id: 1396
schema_scan_id: 6414599
updated: 2026-04-16 00:13:09

Version 906155

created: 2026-04-15 00:29:35

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_sitelink_facilities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_sitelink_facilities`\n(\n `anniversary_billing`  smallint , `created`  timestamp , `email`  string , `id`  int , `last_polled_ticks`  string , `listing_avail_id`  int , `location_id`  int , `modified`  timestamp , `sitelink_corp_id`  int , `sitelink_location_code`  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_sitelink_facilities/2026-04-15/1776230958'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_sitelink_facilities"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_sitelink_facilities/2026-04-15/1776230958
id: 906155
processed: 1

raw_data:

{
    "anniversary_billing": "int16",
    "created": "timestamp[ns]",
    "email": "string",
    "id": "int32",
    "last_polled_ticks": "string",
    "listing_avail_id": "int32",
    "location_id": "int32",
    "modified": "timestamp[ns]",
    "sitelink_corp_id": "int32",
    "sitelink_location_code": "string"
}

schema_attributes:

{
    "anniversary_billing": "smallint",
    "created": "timestamp",
    "email": "string",
    "id": "int",
    "last_polled_ticks": "string",
    "listing_avail_id": "int",
    "location_id": "int",
    "modified": "timestamp",
    "sitelink_corp_id": "int",
    "sitelink_location_code": "string"
}

schema_name_id: 1396
schema_scan_id: 6414119
updated: 2026-04-15 00:29:46

Version 905938

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_sitelink_facilities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_sitelink_facilities`\n(\n `anniversary_billing`  smallint , `created`  timestamp , `email`  string , `id`  int , `last_polled_ticks`  string , `listing_avail_id`  int , `location_id`  int , `modified`  timestamp , `sitelink_corp_id`  int , `sitelink_location_code`  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_sitelink_facilities/2026-04-14/1776143650'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_sitelink_facilities"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_sitelink_facilities/2026-04-14/1776143650
id: 905938
processed: 1

raw_data:

{
    "anniversary_billing": "int16",
    "created": "timestamp[ns]",
    "email": "string",
    "id": "int32",
    "last_polled_ticks": "string",
    "listing_avail_id": "int32",
    "location_id": "int32",
    "modified": "timestamp[ns]",
    "sitelink_corp_id": "int32",
    "sitelink_location_code": "string"
}

schema_attributes:

{
    "anniversary_billing": "smallint",
    "created": "timestamp",
    "email": "string",
    "id": "int",
    "last_polled_ticks": "string",
    "listing_avail_id": "int",
    "location_id": "int",
    "modified": "timestamp",
    "sitelink_corp_id": "int",
    "sitelink_location_code": "string"
}

schema_name_id: 1396
schema_scan_id: 6413606
updated: 2026-04-14 00:14:29

Version 905723

created: 2026-04-13 00:19:59

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_sitelink_facilities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_sitelink_facilities`\n(\n `anniversary_billing`  smallint , `created`  timestamp , `email`  string , `id`  int , `last_polled_ticks`  string , `listing_avail_id`  int , `location_id`  int , `modified`  timestamp , `sitelink_corp_id`  int , `sitelink_location_code`  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_sitelink_facilities/2026-04-13/1776057570'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_sitelink_facilities"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_sitelink_facilities/2026-04-13/1776057570
id: 905723
processed: 1

raw_data:

{
    "anniversary_billing": "int16",
    "created": "timestamp[ns]",
    "email": "string",
    "id": "int32",
    "last_polled_ticks": "string",
    "listing_avail_id": "int32",
    "location_id": "int32",
    "modified": "timestamp[ns]",
    "sitelink_corp_id": "int32",
    "sitelink_location_code": "string"
}

schema_attributes:

{
    "anniversary_billing": "smallint",
    "created": "timestamp",
    "email": "string",
    "id": "int",
    "last_polled_ticks": "string",
    "listing_avail_id": "int",
    "location_id": "int",
    "modified": "timestamp",
    "sitelink_corp_id": "int",
    "sitelink_location_code": "string"
}

schema_name_id: 1396
schema_scan_id: 6413059
updated: 2026-04-13 00:20:12

Version 905522

created: 2026-04-12 00:16:01

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_sitelink_facilities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_sitelink_facilities`\n(\n `anniversary_billing`  smallint , `created`  timestamp , `email`  string , `id`  int , `last_polled_ticks`  string , `listing_avail_id`  int , `location_id`  int , `modified`  timestamp , `sitelink_corp_id`  int , `sitelink_location_code`  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_sitelink_facilities/2026-04-12/1775970951'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_sitelink_facilities"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_sitelink_facilities/2026-04-12/1775970951
id: 905522
processed: 1

raw_data:

{
    "anniversary_billing": "int16",
    "created": "timestamp[ns]",
    "email": "string",
    "id": "int32",
    "last_polled_ticks": "string",
    "listing_avail_id": "int32",
    "location_id": "int32",
    "modified": "timestamp[ns]",
    "sitelink_corp_id": "int32",
    "sitelink_location_code": "string"
}

schema_attributes:

{
    "anniversary_billing": "smallint",
    "created": "timestamp",
    "email": "string",
    "id": "int",
    "last_polled_ticks": "string",
    "listing_avail_id": "int",
    "location_id": "int",
    "modified": "timestamp",
    "sitelink_corp_id": "int",
    "sitelink_location_code": "string"
}

schema_name_id: 1396
schema_scan_id: 6412674
updated: 2026-04-12 00:16:12

Version 905325

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_sitelink_facilities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_sitelink_facilities`\n(\n `anniversary_billing`  smallint , `created`  timestamp , `email`  string , `id`  int , `last_polled_ticks`  string , `listing_avail_id`  int , `location_id`  int , `modified`  timestamp , `sitelink_corp_id`  int , `sitelink_location_code`  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_sitelink_facilities/2026-04-11/1775885982'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_sitelink_facilities"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_sitelink_facilities/2026-04-11/1775885982
id: 905325
processed: 1

raw_data:

{
    "anniversary_billing": "int16",
    "created": "timestamp[ns]",
    "email": "string",
    "id": "int32",
    "last_polled_ticks": "string",
    "listing_avail_id": "int32",
    "location_id": "int32",
    "modified": "timestamp[ns]",
    "sitelink_corp_id": "int32",
    "sitelink_location_code": "string"
}

schema_attributes:

{
    "anniversary_billing": "smallint",
    "created": "timestamp",
    "email": "string",
    "id": "int",
    "last_polled_ticks": "string",
    "listing_avail_id": "int",
    "location_id": "int",
    "modified": "timestamp",
    "sitelink_corp_id": "int",
    "sitelink_location_code": "string"
}

schema_name_id: 1396
schema_scan_id: 6412298
updated: 2026-04-11 00:40:29

Version 905099

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_sitelink_facilities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_sitelink_facilities`\n(\n `anniversary_billing`  smallint , `created`  timestamp , `email`  string , `id`  int , `last_polled_ticks`  string , `listing_avail_id`  int , `location_id`  int , `modified`  timestamp , `sitelink_corp_id`  int , `sitelink_location_code`  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_sitelink_facilities/2026-04-10/1775797984'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_sitelink_facilities"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_sitelink_facilities/2026-04-10/1775797984
id: 905099
processed: 1

raw_data:

{
    "anniversary_billing": "int16",
    "created": "timestamp[ns]",
    "email": "string",
    "id": "int32",
    "last_polled_ticks": "string",
    "listing_avail_id": "int32",
    "location_id": "int32",
    "modified": "timestamp[ns]",
    "sitelink_corp_id": "int32",
    "sitelink_location_code": "string"
}

schema_attributes:

{
    "anniversary_billing": "smallint",
    "created": "timestamp",
    "email": "string",
    "id": "int",
    "last_polled_ticks": "string",
    "listing_avail_id": "int",
    "location_id": "int",
    "modified": "timestamp",
    "sitelink_corp_id": "int",
    "sitelink_location_code": "string"
}

schema_name_id: 1396
schema_scan_id: 6411782
updated: 2026-04-10 00:13:31

Version 904889

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_sitelink_facilities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_sitelink_facilities`\n(\n `anniversary_billing`  smallint , `created`  timestamp , `email`  string , `id`  int , `last_polled_ticks`  string , `listing_avail_id`  int , `location_id`  int , `modified`  timestamp , `sitelink_corp_id`  int , `sitelink_location_code`  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_sitelink_facilities/2026-04-09/1775711775'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_sitelink_facilities"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_sitelink_facilities/2026-04-09/1775711775
id: 904889
processed: 1

raw_data:

{
    "anniversary_billing": "int16",
    "created": "timestamp[ns]",
    "email": "string",
    "id": "int32",
    "last_polled_ticks": "string",
    "listing_avail_id": "int32",
    "location_id": "int32",
    "modified": "timestamp[ns]",
    "sitelink_corp_id": "int32",
    "sitelink_location_code": "string"
}

schema_attributes:

{
    "anniversary_billing": "smallint",
    "created": "timestamp",
    "email": "string",
    "id": "int",
    "last_polled_ticks": "string",
    "listing_avail_id": "int",
    "location_id": "int",
    "modified": "timestamp",
    "sitelink_corp_id": "int",
    "sitelink_location_code": "string"
}

schema_name_id: 1396
schema_scan_id: 6411276
updated: 2026-04-09 00:16:41

Version 904683

created: 2026-04-08 00:33:37

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_sitelink_facilities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_sitelink_facilities`\n(\n `anniversary_billing`  smallint , `created`  timestamp , `email`  string , `id`  int , `last_polled_ticks`  string , `listing_avail_id`  int , `location_id`  int , `modified`  timestamp , `sitelink_corp_id`  int , `sitelink_location_code`  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_sitelink_facilities/2026-04-08/1775626407'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_sitelink_facilities"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_sitelink_facilities/2026-04-08/1775626407
id: 904683
processed: 1

raw_data:

{
    "anniversary_billing": "int16",
    "created": "timestamp[ns]",
    "email": "string",
    "id": "int32",
    "last_polled_ticks": "string",
    "listing_avail_id": "int32",
    "location_id": "int32",
    "modified": "timestamp[ns]",
    "sitelink_corp_id": "int32",
    "sitelink_location_code": "string"
}

schema_attributes:

{
    "anniversary_billing": "smallint",
    "created": "timestamp",
    "email": "string",
    "id": "int",
    "last_polled_ticks": "string",
    "listing_avail_id": "int",
    "location_id": "int",
    "modified": "timestamp",
    "sitelink_corp_id": "int",
    "sitelink_location_code": "string"
}

schema_name_id: 1396
schema_scan_id: 6410786
updated: 2026-04-08 00:33:48

Version 904472

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_sitelink_facilities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_sitelink_facilities`\n(\n `anniversary_billing`  smallint , `created`  timestamp , `email`  string , `id`  int , `last_polled_ticks`  string , `listing_avail_id`  int , `location_id`  int , `modified`  timestamp , `sitelink_corp_id`  int , `sitelink_location_code`  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_sitelink_facilities/2026-04-07/1775540575'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_sitelink_facilities"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_sitelink_facilities/2026-04-07/1775540575
id: 904472
processed: 1

raw_data:

{
    "anniversary_billing": "int16",
    "created": "timestamp[ns]",
    "email": "string",
    "id": "int32",
    "last_polled_ticks": "string",
    "listing_avail_id": "int32",
    "location_id": "int32",
    "modified": "timestamp[ns]",
    "sitelink_corp_id": "int32",
    "sitelink_location_code": "string"
}

schema_attributes:

{
    "anniversary_billing": "smallint",
    "created": "timestamp",
    "email": "string",
    "id": "int",
    "last_polled_ticks": "string",
    "listing_avail_id": "int",
    "location_id": "int",
    "modified": "timestamp",
    "sitelink_corp_id": "int",
    "sitelink_location_code": "string"
}

schema_name_id: 1396
schema_scan_id: 6410276
updated: 2026-04-07 00:43:26

Version 904243

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_sitelink_facilities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_sitelink_facilities`\n(\n `anniversary_billing`  smallint , `created`  timestamp , `email`  string , `id`  int , `last_polled_ticks`  string , `listing_avail_id`  int , `location_id`  int , `modified`  timestamp , `sitelink_corp_id`  int , `sitelink_location_code`  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_sitelink_facilities/2026-04-06/1775452406'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_sitelink_facilities"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_sitelink_facilities/2026-04-06/1775452406
id: 904243
processed: 1

raw_data:

{
    "anniversary_billing": "int16",
    "created": "timestamp[ns]",
    "email": "string",
    "id": "int32",
    "last_polled_ticks": "string",
    "listing_avail_id": "int32",
    "location_id": "int32",
    "modified": "timestamp[ns]",
    "sitelink_corp_id": "int32",
    "sitelink_location_code": "string"
}

schema_attributes:

{
    "anniversary_billing": "smallint",
    "created": "timestamp",
    "email": "string",
    "id": "int",
    "last_polled_ticks": "string",
    "listing_avail_id": "int",
    "location_id": "int",
    "modified": "timestamp",
    "sitelink_corp_id": "int",
    "sitelink_location_code": "string"
}

schema_name_id: 1396
schema_scan_id: 6409716
updated: 2026-04-06 00:13:46

Version 904044

created: 2026-04-05 00:16:29

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_sitelink_facilities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_sitelink_facilities`\n(\n `anniversary_billing`  smallint , `created`  timestamp , `email`  string , `id`  int , `last_polled_ticks`  string , `listing_avail_id`  int , `location_id`  int , `modified`  timestamp , `sitelink_corp_id`  int , `sitelink_location_code`  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_sitelink_facilities/2026-04-05/1775366185'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_sitelink_facilities"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_sitelink_facilities/2026-04-05/1775366185
id: 904044
processed: 1

raw_data:

{
    "anniversary_billing": "int16",
    "created": "timestamp[ns]",
    "email": "string",
    "id": "int32",
    "last_polled_ticks": "string",
    "listing_avail_id": "int32",
    "location_id": "int32",
    "modified": "timestamp[ns]",
    "sitelink_corp_id": "int32",
    "sitelink_location_code": "string"
}

schema_attributes:

{
    "anniversary_billing": "smallint",
    "created": "timestamp",
    "email": "string",
    "id": "int",
    "last_polled_ticks": "string",
    "listing_avail_id": "int",
    "location_id": "int",
    "modified": "timestamp",
    "sitelink_corp_id": "int",
    "sitelink_location_code": "string"
}

schema_name_id: 1396
schema_scan_id: 6409340
updated: 2026-04-05 00:16:43

Version 903841

created: 2026-04-04 00:12:49

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_sitelink_facilities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_sitelink_facilities`\n(\n `anniversary_billing`  smallint , `created`  timestamp , `email`  string , `id`  int , `last_polled_ticks`  string , `listing_avail_id`  int , `location_id`  int , `modified`  timestamp , `sitelink_corp_id`  int , `sitelink_location_code`  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_sitelink_facilities/2026-04-04/1775279559'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_sitelink_facilities"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_sitelink_facilities/2026-04-04/1775279559
id: 903841
processed: 1

raw_data:

{
    "anniversary_billing": "int16",
    "created": "timestamp[ns]",
    "email": "string",
    "id": "int32",
    "last_polled_ticks": "string",
    "listing_avail_id": "int32",
    "location_id": "int32",
    "modified": "timestamp[ns]",
    "sitelink_corp_id": "int32",
    "sitelink_location_code": "string"
}

schema_attributes:

{
    "anniversary_billing": "smallint",
    "created": "timestamp",
    "email": "string",
    "id": "int",
    "last_polled_ticks": "string",
    "listing_avail_id": "int",
    "location_id": "int",
    "modified": "timestamp",
    "sitelink_corp_id": "int",
    "sitelink_location_code": "string"
}

schema_name_id: 1396
schema_scan_id: 6408958
updated: 2026-04-04 00:13:03

Version 903625

created: 2026-04-03 00:13:00

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_sitelink_facilities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_sitelink_facilities`\n(\n `anniversary_billing`  smallint , `created`  timestamp , `email`  string , `id`  int , `last_polled_ticks`  string , `listing_avail_id`  int , `location_id`  int , `modified`  timestamp , `sitelink_corp_id`  int , `sitelink_location_code`  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_sitelink_facilities/2026-04-03/1775193168'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_sitelink_facilities"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_sitelink_facilities/2026-04-03/1775193168
id: 903625
processed: 1

raw_data:

{
    "anniversary_billing": "int16",
    "created": "timestamp[ns]",
    "email": "string",
    "id": "int32",
    "last_polled_ticks": "string",
    "listing_avail_id": "int32",
    "location_id": "int32",
    "modified": "timestamp[ns]",
    "sitelink_corp_id": "int32",
    "sitelink_location_code": "string"
}

schema_attributes:

{
    "anniversary_billing": "smallint",
    "created": "timestamp",
    "email": "string",
    "id": "int",
    "last_polled_ticks": "string",
    "listing_avail_id": "int",
    "location_id": "int",
    "modified": "timestamp",
    "sitelink_corp_id": "int",
    "sitelink_location_code": "string"
}

schema_name_id: 1396
schema_scan_id: 6408460
updated: 2026-04-03 00:13:12

Schema Scans: 15

Last at 2026-04-17 00:36:39

Scan 6415154

duration: 0:00:14.385126

exit_message:

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

id: 6415154

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_sitelink_facilities/2026-04-17/1776404196",
        "key": "raw/sparefoot_sitelink_facilities/2026-04-17/1776404196/sitelink_facilities.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_sitelink_facilities",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 10235730088939572209,
        "service_name": "sparefoot",
        "span_id": 16737678040467581499,
        "trace_id": 10235730088939572209
    }
}

running: False
schema_name_id: 1396
start_time: 2026-04-17 00:36:39
success: True
trace_id: 10235730088939572209

Scan 6414599

duration: 0:00:11.798082

exit_message:

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

id: 6414599

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_sitelink_facilities/2026-04-16/1776316355",
        "key": "raw/sparefoot_sitelink_facilities/2026-04-16/1776316355/sitelink_facilities.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_sitelink_facilities",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 1565052183893257821,
        "service_name": "sparefoot",
        "span_id": 8706289251748272637,
        "trace_id": 1565052183893257821
    }
}

running: False
schema_name_id: 1396
start_time: 2026-04-16 00:12:57
success: True
trace_id: 1565052183893257821

Scan 6414119

duration: 0:00:11.793441

exit_message:

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

id: 6414119

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_sitelink_facilities/2026-04-15/1776230958",
        "key": "raw/sparefoot_sitelink_facilities/2026-04-15/1776230958/sitelink_facilities.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_sitelink_facilities",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 14406287857914532697,
        "service_name": "sparefoot",
        "span_id": 12513705799739992578,
        "trace_id": 14406287857914532697
    }
}

running: False
schema_name_id: 1396
start_time: 2026-04-15 00:29:34
success: True
trace_id: 14406287857914532697

Scan 6413606

duration: 0:00:14.482941

exit_message:

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

id: 6413606

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_sitelink_facilities/2026-04-14/1776143650",
        "key": "raw/sparefoot_sitelink_facilities/2026-04-14/1776143650/sitelink_facilities.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_sitelink_facilities",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 3114686837225592652,
        "service_name": "sparefoot",
        "span_id": 11691381110689578939,
        "trace_id": 3114686837225592652
    }
}

running: False
schema_name_id: 1396
start_time: 2026-04-14 00:14:15
success: True
trace_id: 3114686837225592652

Scan 6413059

duration: 0:00:14.550004

exit_message:

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

id: 6413059

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_sitelink_facilities/2026-04-13/1776057570",
        "key": "raw/sparefoot_sitelink_facilities/2026-04-13/1776057570/sitelink_facilities.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_sitelink_facilities",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 6931169442521786113,
        "service_name": "sparefoot",
        "span_id": 7600553375329975900,
        "trace_id": 6931169442521786113
    }
}

running: False
schema_name_id: 1396
start_time: 2026-04-13 00:19:58
success: True
trace_id: 6931169442521786113

Scan 6412674

duration: 0:00:11.907862

exit_message:

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

id: 6412674

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_sitelink_facilities/2026-04-12/1775970951",
        "key": "raw/sparefoot_sitelink_facilities/2026-04-12/1775970951/sitelink_facilities.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_sitelink_facilities",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 12742574304136674697,
        "service_name": "sparefoot",
        "span_id": 4488082203457053325,
        "trace_id": 12742574304136674697
    }
}

running: False
schema_name_id: 1396
start_time: 2026-04-12 00:16:00
success: True
trace_id: 12742574304136674697

Scan 6412298

duration: 0:00:14.511223

exit_message:

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

id: 6412298

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_sitelink_facilities/2026-04-11/1775885982",
        "key": "raw/sparefoot_sitelink_facilities/2026-04-11/1775885982/sitelink_facilities.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_sitelink_facilities",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 7507379779801515057,
        "service_name": "sparefoot",
        "span_id": 8527984660843927490,
        "trace_id": 7507379779801515057
    }
}

running: False
schema_name_id: 1396
start_time: 2026-04-11 00:40:15
success: True
trace_id: 7507379779801515057

Scan 6411782

duration: 0:00:14.521281

exit_message:

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

id: 6411782

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_sitelink_facilities/2026-04-10/1775797984",
        "key": "raw/sparefoot_sitelink_facilities/2026-04-10/1775797984/sitelink_facilities.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_sitelink_facilities",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 15901696164371989299,
        "service_name": "sparefoot",
        "span_id": 18074888920959631476,
        "trace_id": 15901696164371989299
    }
}

running: False
schema_name_id: 1396
start_time: 2026-04-10 00:13:17
success: True
trace_id: 15901696164371989299

Scan 6411276

duration: 0:00:11.913409

exit_message:

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

id: 6411276

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_sitelink_facilities/2026-04-09/1775711775",
        "key": "raw/sparefoot_sitelink_facilities/2026-04-09/1775711775/sitelink_facilities.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_sitelink_facilities",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 5193913566856890222,
        "service_name": "sparefoot",
        "span_id": 14791783771006096189,
        "trace_id": 5193913566856890222
    }
}

running: False
schema_name_id: 1396
start_time: 2026-04-09 00:16:29
success: True
trace_id: 5193913566856890222

Scan 6410786

duration: 0:00:11.926890

exit_message:

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

id: 6410786

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_sitelink_facilities/2026-04-08/1775626407",
        "key": "raw/sparefoot_sitelink_facilities/2026-04-08/1775626407/sitelink_facilities.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_sitelink_facilities",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 4834403387621099911,
        "service_name": "sparefoot",
        "span_id": 3218331898790015292,
        "trace_id": 4834403387621099911
    }
}

running: False
schema_name_id: 1396
start_time: 2026-04-08 00:33:36
success: True
trace_id: 4834403387621099911

Scan 6410276

duration: 0:00:11.968959

exit_message:

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

id: 6410276

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_sitelink_facilities/2026-04-07/1775540575",
        "key": "raw/sparefoot_sitelink_facilities/2026-04-07/1775540575/sitelink_facilities.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_sitelink_facilities",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 10928099781942376287,
        "service_name": "sparefoot",
        "span_id": 18357714062805896413,
        "trace_id": 10928099781942376287
    }
}

running: False
schema_name_id: 1396
start_time: 2026-04-07 00:43:14
success: True
trace_id: 10928099781942376287

Scan 6409716

duration: 0:00:14.431201

exit_message:

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

id: 6409716

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_sitelink_facilities/2026-04-06/1775452406",
        "key": "raw/sparefoot_sitelink_facilities/2026-04-06/1775452406/sitelink_facilities.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_sitelink_facilities",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 12836178973041015589,
        "service_name": "sparefoot",
        "span_id": 16332918771412786705,
        "trace_id": 12836178973041015589
    }
}

running: False
schema_name_id: 1396
start_time: 2026-04-06 00:13:32
success: True
trace_id: 12836178973041015589

Scan 6409340

duration: 0:00:14.309544

exit_message:

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

id: 6409340

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_sitelink_facilities/2026-04-05/1775366185",
        "key": "raw/sparefoot_sitelink_facilities/2026-04-05/1775366185/sitelink_facilities.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_sitelink_facilities",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 7434641552568607428,
        "service_name": "sparefoot",
        "span_id": 7673841713448075212,
        "trace_id": 7434641552568607428
    }
}

running: False
schema_name_id: 1396
start_time: 2026-04-05 00:16:29
success: True
trace_id: 7434641552568607428

Scan 6408958

duration: 0:00:14.544046

exit_message:

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

id: 6408958

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_sitelink_facilities/2026-04-04/1775279559",
        "key": "raw/sparefoot_sitelink_facilities/2026-04-04/1775279559/sitelink_facilities.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_sitelink_facilities",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 14335690784943210987,
        "service_name": "sparefoot",
        "span_id": 11685811647402833442,
        "trace_id": 14335690784943210987
    }
}

running: False
schema_name_id: 1396
start_time: 2026-04-04 00:12:48
success: True
trace_id: 14335690784943210987

Scan 6408460

duration: 0:00:11.950371

exit_message:

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

id: 6408460

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_sitelink_facilities/2026-04-03/1775193168",
        "key": "raw/sparefoot_sitelink_facilities/2026-04-03/1775193168/sitelink_facilities.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_sitelink_facilities",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 4777346017025032058,
        "service_name": "sparefoot",
        "span_id": 7131022082749078582,
        "trace_id": 4777346017025032058
    }
}

running: False
schema_name_id: 1396
start_time: 2026-04-03 00:13:00
success: True
trace_id: 4777346017025032058

Partitions:

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

Schema:

attributes:

{
    "anniversary_billing": "smallint",
    "created": "timestamp",
    "email": "string",
    "id": "int",
    "last_polled_ticks": "string",
    "listing_avail_id": "int",
    "location_id": "int",
    "modified": "timestamp",
    "sitelink_corp_id": "int",
    "sitelink_location_code": "string"
}

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

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_sitelink_facilities`\n(\n `anniversary_billing`  smallint , `created`  timestamp , `email`  string , `id`  int , `last_polled_ticks`  string , `listing_avail_id`  int , `location_id`  int , `modified`  timestamp , `sitelink_corp_id`  int , `sitelink_location_code`  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_sitelink_facilities/2026-04-17/1776404196'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_sitelink_facilities`",
    "repair_table": "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_sitelink_facilities"
}

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 11:00:16",
        "disabled": false,
        "format": "raw",
        "id": 1396,
        "is_partitioned": false,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_stage_rds",
            "table": "sparefoot_sparefoot_sitelink_facilities"
        },
        "type": "rds"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "anniversary_billing": "smallint",
            "created": "timestamp",
            "email": "string",
            "id": "int",
            "last_polled_ticks": "string",
            "listing_avail_id": "int",
            "location_id": "int",
            "modified": "timestamp",
            "sitelink_corp_id": "int",
            "sitelink_location_code": "string"
        },
        "created": "2026-04-17 00:36:40",
        "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_sitelink_facilities`\n(\n `anniversary_billing`  smallint , `created`  timestamp , `email`  string , `id`  int , `last_polled_ticks`  string , `listing_avail_id`  int , `location_id`  int , `modified`  timestamp , `sitelink_corp_id`  int , `sitelink_location_code`  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_sitelink_facilities/2026-04-17/1776404196'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_sitelink_facilities`",
            "repair_table": "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_sitelink_facilities"
        }
    },
    "server": {
        "hostname": "schemamanager-5c55c886bf-h2ts4",
        "name": "schema_manager",
        "process_start": "2025-10-21 13:03:27",
        "sf_env": "stage",
        "version": "2112174301"
    }
}