Schema Info

Schema Name: sfdl_prod_rds.sparefoot_sparefoot_sitelink_facilities

created: 2022-08-18 17:25:45
disabled: False
format: raw
id: 1137
is_partitioned: False
is_schema_datatyped: False

name:

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

type: rds

Schema Versions: 15

Version 1718414

created: 2026-04-17 14:17:31

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_sitelink_facilities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/sparefoot_sitelink_facilities/2026-04-17/1776453443'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_sitelink_facilities"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_sitelink_facilities/2026-04-17/1776453443
id: 1718414
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: 1137
schema_scan_id: 162194057
updated: 2026-04-17 14:17:42

Version 1718230

created: 2026-04-17 09:26:22

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_sitelink_facilities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/sparefoot_sitelink_facilities/2026-04-17/1776435968'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_sitelink_facilities"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_sitelink_facilities/2026-04-17/1776435968
id: 1718230
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: 1137
schema_scan_id: 162178336
updated: 2026-04-17 09:26:36

Version 1717475

created: 2026-04-17 00:15:38

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_sitelink_facilities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/sparefoot_sitelink_facilities/2026-04-17/1776402932'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_sitelink_facilities"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_sitelink_facilities/2026-04-17/1776402932
id: 1717475
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: 1137
schema_scan_id: 162163653
updated: 2026-04-17 00:15:51

Version 1717371

created: 2026-04-16 20:40:17

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_sitelink_facilities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/sparefoot_sitelink_facilities/2026-04-16/1776390013'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_sitelink_facilities"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_sitelink_facilities/2026-04-16/1776390013
id: 1717371
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: 1137
schema_scan_id: 162156253
updated: 2026-04-16 20:40:31

Version 1717187

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_sitelink_facilities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/sparefoot_sitelink_facilities/2026-04-16/1776367186'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_sitelink_facilities"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_sitelink_facilities/2026-04-16/1776367186
id: 1717187
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: 1137
schema_scan_id: 162138143
updated: 2026-04-16 14:20:55

Version 1717041

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_sitelink_facilities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/sparefoot_sitelink_facilities/2026-04-16/1776350480'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_sitelink_facilities"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_sitelink_facilities/2026-04-16/1776350480
id: 1717041
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: 1137
schema_scan_id: 162122886
updated: 2026-04-16 09:41:41

Version 1716238

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_sitelink_facilities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/sparefoot_sitelink_facilities/2026-04-16/1776316746'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_sitelink_facilities"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_sitelink_facilities/2026-04-16/1776316746
id: 1716238
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: 1137
schema_scan_id: 162107828
updated: 2026-04-16 00:19:26

Version 1716134

created: 2026-04-15 20:29:40

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_sitelink_facilities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/sparefoot_sitelink_facilities/2026-04-15/1776302976'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_sitelink_facilities"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_sitelink_facilities/2026-04-15/1776302976
id: 1716134
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: 1137
schema_scan_id: 162100368
updated: 2026-04-15 20:29:52

Version 1715996

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_sitelink_facilities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/sparefoot_sitelink_facilities/2026-04-15/1776280835'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_sitelink_facilities"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_sitelink_facilities/2026-04-15/1776280835
id: 1715996
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: 1137
schema_scan_id: 162081816
updated: 2026-04-15 14:21:13

Version 1715779

created: 2026-04-15 08:43:55

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_sitelink_facilities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/sparefoot_sitelink_facilities/2026-04-15/1776260630'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_sitelink_facilities"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_sitelink_facilities/2026-04-15/1776260630
id: 1715779
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: 1137
schema_scan_id: 162064530
updated: 2026-04-15 08:44:06

Version 1715046

created: 2026-04-15 00:24:12

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_sitelink_facilities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/sparefoot_sitelink_facilities/2026-04-15/1776230649'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_sitelink_facilities"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_sitelink_facilities/2026-04-15/1776230649
id: 1715046
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: 1137
schema_scan_id: 162052018
updated: 2026-04-15 00:24:25

Version 1714924

created: 2026-04-14 20:27:22

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_sitelink_facilities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/sparefoot_sitelink_facilities/2026-04-14/1776216438'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_sitelink_facilities"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_sitelink_facilities/2026-04-14/1776216438
id: 1714924
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: 1137
schema_scan_id: 162044353
updated: 2026-04-14 20:27:33

Version 1714761

created: 2026-04-14 14:19:40

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_sitelink_facilities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/sparefoot_sitelink_facilities/2026-04-14/1776194219'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_sitelink_facilities"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_sitelink_facilities/2026-04-14/1776194219
id: 1714761
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: 1137
schema_scan_id: 162026176
updated: 2026-04-14 14:19:51

Version 1714605

created: 2026-04-14 09:14:24

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_sitelink_facilities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/sparefoot_sitelink_facilities/2026-04-14/1776175848'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_sitelink_facilities"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_sitelink_facilities/2026-04-14/1776175848
id: 1714605
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: 1137
schema_scan_id: 162010979
updated: 2026-04-14 09:14:37

Version 1713837

created: 2026-04-14 00:16:35

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_sitelink_facilities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/sparefoot_sitelink_facilities/2026-04-14/1776143786'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_sitelink_facilities"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_sitelink_facilities/2026-04-14/1776143786
id: 1713837
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: 1137
schema_scan_id: 161996382
updated: 2026-04-14 00:16:48

Schema Scans: 15

Last at 2026-04-17 14:17:30

Scan 162194057

duration: 0:00:11.903519

exit_message:

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

id: 162194057

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

running: False
schema_name_id: 1137
start_time: 2026-04-17 14:17:30
success: True
trace_id: 662616554057135212

Scan 162178336

duration: 0:00:14.432224

exit_message:

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

id: 162178336

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

running: False
schema_name_id: 1137
start_time: 2026-04-17 09:26:22
success: True
trace_id: 18313191947900228019

Scan 162163653

duration: 0:00:14.339869

exit_message:

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

id: 162163653

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

running: False
schema_name_id: 1137
start_time: 2026-04-17 00:15:37
success: True
trace_id: 13055156942361187995

Scan 162156253

duration: 0:00:14.495634

exit_message:

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

id: 162156253

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

running: False
schema_name_id: 1137
start_time: 2026-04-16 20:40:16
success: True
trace_id: 15638327877466361531

Scan 162138143

duration: 0:00:14.357621

exit_message:

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

id: 162138143

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

running: False
schema_name_id: 1137
start_time: 2026-04-16 14:20:41
success: True
trace_id: 5025424660084583102

Scan 162122886

duration: 0:00:11.876350

exit_message:

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

id: 162122886

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

running: False
schema_name_id: 1137
start_time: 2026-04-16 09:41:29
success: True
trace_id: 1438050943900574198

Scan 162107828

duration: 0:00:14.275458

exit_message:

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

id: 162107828

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

running: False
schema_name_id: 1137
start_time: 2026-04-16 00:19:12
success: True
trace_id: 16306100025147841991

Scan 162100368

duration: 0:00:11.777598

exit_message:

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

id: 162100368

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

running: False
schema_name_id: 1137
start_time: 2026-04-15 20:29:40
success: True
trace_id: 6403018074703586824

Scan 162081816

duration: 0:00:14.620000

exit_message:

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

id: 162081816

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

running: False
schema_name_id: 1137
start_time: 2026-04-15 14:20:59
success: True
trace_id: 2315060110938264086

Scan 162064530

duration: 0:00:11.672022

exit_message:

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

id: 162064530

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

running: False
schema_name_id: 1137
start_time: 2026-04-15 08:43:54
success: True
trace_id: 16460321405439584173

Scan 162052018

duration: 0:00:14.360686

exit_message:

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

id: 162052018

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

running: False
schema_name_id: 1137
start_time: 2026-04-15 00:24:11
success: True
trace_id: 10411142610544067507

Scan 162044353

duration: 0:00:11.722624

exit_message:

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

id: 162044353

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

running: False
schema_name_id: 1137
start_time: 2026-04-14 20:27:21
success: True
trace_id: 3041652863436187800

Scan 162026176

duration: 0:00:11.924929

exit_message:

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

id: 162026176

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

running: False
schema_name_id: 1137
start_time: 2026-04-14 14:19:39
success: True
trace_id: 45826021137544153

Scan 162010979

duration: 0:00:14.368528

exit_message:

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

id: 162010979

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

running: False
schema_name_id: 1137
start_time: 2026-04-14 09:14:23
success: True
trace_id: 8444651315643864940

Scan 161996382

duration: 0:00:14.362737

exit_message:

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

id: 161996382

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

running: False
schema_name_id: 1137
start_time: 2026-04-14 00:16:34
success: True
trace_id: 8848484701034989663

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 14:17:31

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_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-prod/raw/sparefoot_sitelink_facilities/2026-04-17/1776453443'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_sitelink_facilities`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_sitelink_facilities"
}

Server:

hostname: schemamanager-5475496c57-7dpqb
name: schema_manager
process_start: 2026-01-09 11:27:47
sf_env: prod
version: 2112174301

Raw:

{
    "name": {
        "created": "2022-08-18 17:25:45",
        "disabled": false,
        "format": "raw",
        "id": 1137,
        "is_partitioned": false,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_prod_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 14:17:31",
        "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_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-prod/raw/sparefoot_sitelink_facilities/2026-04-17/1776453443'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_sitelink_facilities`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_sitelink_facilities"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}