Schema Info

Schema Name: sfdl_prod_rds.sparefoot_sparefoot_omnom_status

created: 2022-08-18 17:27:01
disabled: False
format: raw
id: 1142
is_partitioned: False
is_schema_datatyped: False

name:

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

type: rds

Schema Versions: 15

Version 1718415

created: 2026-04-17 14:17:33

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_omnom_status`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_omnom_status`\n(\n `job`  string , `last_pull_time`  timestamp , `last_success_time`  timestamp , `listing_avail_id`  int , `message`  string , `status`  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_omnom_status/2026-04-17/1776453449'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_omnom_status"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_omnom_status/2026-04-17/1776453449
id: 1718415
processed: 1

raw_data:

{
    "job": "string",
    "last_pull_time": "timestamp[ns]",
    "last_success_time": "timestamp[ns]",
    "listing_avail_id": "int32",
    "message": "string",
    "status": "string"
}

schema_attributes:

{
    "job": "string",
    "last_pull_time": "timestamp",
    "last_success_time": "timestamp",
    "listing_avail_id": "int",
    "message": "string",
    "status": "string"
}

schema_name_id: 1142
schema_scan_id: 162194059
updated: 2026-04-17 14:17:47

Version 1718234

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_omnom_status`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_omnom_status`\n(\n `job`  string , `last_pull_time`  timestamp , `last_success_time`  timestamp , `listing_avail_id`  int , `message`  string , `status`  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_omnom_status/2026-04-17/1776435980'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_omnom_status"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_omnom_status/2026-04-17/1776435980
id: 1718234
processed: 1

raw_data:

{
    "job": "string",
    "last_pull_time": "timestamp[ns]",
    "last_success_time": "timestamp[ns]",
    "listing_avail_id": "int32",
    "message": "string",
    "status": "string"
}

schema_attributes:

{
    "job": "string",
    "last_pull_time": "timestamp",
    "last_success_time": "timestamp",
    "listing_avail_id": "int",
    "message": "string",
    "status": "string"
}

schema_name_id: 1142
schema_scan_id: 162178342
updated: 2026-04-17 09:26:47

Version 1717480

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_omnom_status`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_omnom_status`\n(\n `job`  string , `last_pull_time`  timestamp , `last_success_time`  timestamp , `listing_avail_id`  int , `message`  string , `status`  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_omnom_status/2026-04-17/1776402964'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_omnom_status"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_omnom_status/2026-04-17/1776402964
id: 1717480
processed: 1

raw_data:

{
    "job": "string",
    "last_pull_time": "timestamp[ns]",
    "last_success_time": "timestamp[ns]",
    "listing_avail_id": "int32",
    "message": "string",
    "status": "string"
}

schema_attributes:

{
    "job": "string",
    "last_pull_time": "timestamp",
    "last_success_time": "timestamp",
    "listing_avail_id": "int",
    "message": "string",
    "status": "string"
}

schema_name_id: 1142
schema_scan_id: 162163664
updated: 2026-04-17 00:16:22

Version 1717366

created: 2026-04-16 20:39:49

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_omnom_status`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_omnom_status`\n(\n `job`  string , `last_pull_time`  timestamp , `last_success_time`  timestamp , `listing_avail_id`  int , `message`  string , `status`  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_omnom_status/2026-04-16/1776389982'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_omnom_status"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_omnom_status/2026-04-16/1776389982
id: 1717366
processed: 1

raw_data:

{
    "job": "string",
    "last_pull_time": "timestamp[ns]",
    "last_success_time": "timestamp[ns]",
    "listing_avail_id": "int32",
    "message": "string",
    "status": "string"
}

schema_attributes:

{
    "job": "string",
    "last_pull_time": "timestamp",
    "last_success_time": "timestamp",
    "listing_avail_id": "int",
    "message": "string",
    "status": "string"
}

schema_name_id: 1142
schema_scan_id: 162156248
updated: 2026-04-16 20:40:03

Version 1717183

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_omnom_status`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_omnom_status`\n(\n `job`  string , `last_pull_time`  timestamp , `last_success_time`  timestamp , `listing_avail_id`  int , `message`  string , `status`  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_omnom_status/2026-04-16/1776367204'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_omnom_status"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_omnom_status/2026-04-16/1776367204
id: 1717183
processed: 1

raw_data:

{
    "job": "string",
    "last_pull_time": "timestamp[ns]",
    "last_success_time": "timestamp[ns]",
    "listing_avail_id": "int32",
    "message": "string",
    "status": "string"
}

schema_attributes:

{
    "job": "string",
    "last_pull_time": "timestamp",
    "last_success_time": "timestamp",
    "listing_avail_id": "int",
    "message": "string",
    "status": "string"
}

schema_name_id: 1142
schema_scan_id: 162138135
updated: 2026-04-16 14:20:26

Version 1717050

created: 2026-04-16 09:44:58

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_omnom_status`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_omnom_status`\n(\n `job`  string , `last_pull_time`  timestamp , `last_success_time`  timestamp , `listing_avail_id`  int , `message`  string , `status`  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_omnom_status/2026-04-16/1776350682'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_omnom_status"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_omnom_status/2026-04-16/1776350682
id: 1717050
processed: 1

raw_data:

{
    "job": "string",
    "last_pull_time": "timestamp[ns]",
    "last_success_time": "timestamp[ns]",
    "listing_avail_id": "int32",
    "message": "string",
    "status": "string"
}

schema_attributes:

{
    "job": "string",
    "last_pull_time": "timestamp",
    "last_success_time": "timestamp",
    "listing_avail_id": "int",
    "message": "string",
    "status": "string"
}

schema_name_id: 1142
schema_scan_id: 162122909
updated: 2026-04-16 09:45:12

Version 1716240

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_omnom_status`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_omnom_status`\n(\n `job`  string , `last_pull_time`  timestamp , `last_success_time`  timestamp , `listing_avail_id`  int , `message`  string , `status`  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_omnom_status/2026-04-16/1776316757'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_omnom_status"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_omnom_status/2026-04-16/1776316757
id: 1716240
processed: 1

raw_data:

{
    "job": "string",
    "last_pull_time": "timestamp[ns]",
    "last_success_time": "timestamp[ns]",
    "listing_avail_id": "int32",
    "message": "string",
    "status": "string"
}

schema_attributes:

{
    "job": "string",
    "last_pull_time": "timestamp",
    "last_success_time": "timestamp",
    "listing_avail_id": "int",
    "message": "string",
    "status": "string"
}

schema_name_id: 1142
schema_scan_id: 162107830
updated: 2026-04-16 00:19:32

Version 1716135

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_omnom_status`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_omnom_status`\n(\n `job`  string , `last_pull_time`  timestamp , `last_success_time`  timestamp , `listing_avail_id`  int , `message`  string , `status`  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_omnom_status/2026-04-15/1776302981'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_omnom_status"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_omnom_status/2026-04-15/1776302981
id: 1716135
processed: 1

raw_data:

{
    "job": "string",
    "last_pull_time": "timestamp[ns]",
    "last_success_time": "timestamp[ns]",
    "listing_avail_id": "int32",
    "message": "string",
    "status": "string"
}

schema_attributes:

{
    "job": "string",
    "last_pull_time": "timestamp",
    "last_success_time": "timestamp",
    "listing_avail_id": "int",
    "message": "string",
    "status": "string"
}

schema_name_id: 1142
schema_scan_id: 162100369
updated: 2026-04-15 20:29:55

Version 1715999

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_omnom_status`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_omnom_status`\n(\n `job`  string , `last_pull_time`  timestamp , `last_success_time`  timestamp , `listing_avail_id`  int , `message`  string , `status`  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_omnom_status/2026-04-15/1776280870'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_omnom_status"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_omnom_status/2026-04-15/1776280870
id: 1715999
processed: 1

raw_data:

{
    "job": "string",
    "last_pull_time": "timestamp[ns]",
    "last_success_time": "timestamp[ns]",
    "listing_avail_id": "int32",
    "message": "string",
    "status": "string"
}

schema_attributes:

{
    "job": "string",
    "last_pull_time": "timestamp",
    "last_success_time": "timestamp",
    "listing_avail_id": "int",
    "message": "string",
    "status": "string"
}

schema_name_id: 1142
schema_scan_id: 162081824
updated: 2026-04-15 14:21:38

Version 1715786

created: 2026-04-15 08:44:32

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_omnom_status`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_omnom_status`\n(\n `job`  string , `last_pull_time`  timestamp , `last_success_time`  timestamp , `listing_avail_id`  int , `message`  string , `status`  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_omnom_status/2026-04-15/1776260610'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_omnom_status"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_omnom_status/2026-04-15/1776260610
id: 1715786
processed: 1

raw_data:

{
    "job": "string",
    "last_pull_time": "timestamp[ns]",
    "last_success_time": "timestamp[ns]",
    "listing_avail_id": "int32",
    "message": "string",
    "status": "string"
}

schema_attributes:

{
    "job": "string",
    "last_pull_time": "timestamp",
    "last_success_time": "timestamp",
    "listing_avail_id": "int",
    "message": "string",
    "status": "string"
}

schema_name_id: 1142
schema_scan_id: 162064546
updated: 2026-04-15 08:44:46

Version 1715050

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_omnom_status`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_omnom_status`\n(\n `job`  string , `last_pull_time`  timestamp , `last_success_time`  timestamp , `listing_avail_id`  int , `message`  string , `status`  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_omnom_status/2026-04-15/1776230680'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_omnom_status"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_omnom_status/2026-04-15/1776230680
id: 1715050
processed: 1

raw_data:

{
    "job": "string",
    "last_pull_time": "timestamp[ns]",
    "last_success_time": "timestamp[ns]",
    "listing_avail_id": "int32",
    "message": "string",
    "status": "string"
}

schema_attributes:

{
    "job": "string",
    "last_pull_time": "timestamp",
    "last_success_time": "timestamp",
    "listing_avail_id": "int",
    "message": "string",
    "status": "string"
}

schema_name_id: 1142
schema_scan_id: 162052022
updated: 2026-04-15 00:24:59

Version 1714920

created: 2026-04-14 20:26:54

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_omnom_status`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_omnom_status`\n(\n `job`  string , `last_pull_time`  timestamp , `last_success_time`  timestamp , `listing_avail_id`  int , `message`  string , `status`  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_omnom_status/2026-04-14/1776216411'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_omnom_status"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_omnom_status/2026-04-14/1776216411
id: 1714920
processed: 1

raw_data:

{
    "job": "string",
    "last_pull_time": "timestamp[ns]",
    "last_success_time": "timestamp[ns]",
    "listing_avail_id": "int32",
    "message": "string",
    "status": "string"
}

schema_attributes:

{
    "job": "string",
    "last_pull_time": "timestamp",
    "last_success_time": "timestamp",
    "listing_avail_id": "int",
    "message": "string",
    "status": "string"
}

schema_name_id: 1142
schema_scan_id: 162044345
updated: 2026-04-14 20:27:06

Version 1714762

created: 2026-04-14 14:20:04

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_omnom_status`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_omnom_status`\n(\n `job`  string , `last_pull_time`  timestamp , `last_success_time`  timestamp , `listing_avail_id`  int , `message`  string , `status`  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_omnom_status/2026-04-14/1776194228'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_omnom_status"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_omnom_status/2026-04-14/1776194228
id: 1714762
processed: 1

raw_data:

{
    "job": "string",
    "last_pull_time": "timestamp[ns]",
    "last_success_time": "timestamp[ns]",
    "listing_avail_id": "int32",
    "message": "string",
    "status": "string"
}

schema_attributes:

{
    "job": "string",
    "last_pull_time": "timestamp",
    "last_success_time": "timestamp",
    "listing_avail_id": "int",
    "message": "string",
    "status": "string"
}

schema_name_id: 1142
schema_scan_id: 162026184
updated: 2026-04-14 14:20:18

Version 1714608

created: 2026-04-14 09:14:58

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_omnom_status`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_omnom_status`\n(\n `job`  string , `last_pull_time`  timestamp , `last_success_time`  timestamp , `listing_avail_id`  int , `message`  string , `status`  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_omnom_status/2026-04-14/1776175879'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_omnom_status"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_omnom_status/2026-04-14/1776175879
id: 1714608
processed: 1

raw_data:

{
    "job": "string",
    "last_pull_time": "timestamp[ns]",
    "last_success_time": "timestamp[ns]",
    "listing_avail_id": "int32",
    "message": "string",
    "status": "string"
}

schema_attributes:

{
    "job": "string",
    "last_pull_time": "timestamp",
    "last_success_time": "timestamp",
    "listing_avail_id": "int",
    "message": "string",
    "status": "string"
}

schema_name_id: 1142
schema_scan_id: 162010986
updated: 2026-04-14 09:15:09

Version 1713844

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_omnom_status`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_omnom_status`\n(\n `job`  string , `last_pull_time`  timestamp , `last_success_time`  timestamp , `listing_avail_id`  int , `message`  string , `status`  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_omnom_status/2026-04-14/1776143782'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_omnom_status"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_omnom_status/2026-04-14/1776143782
id: 1713844
processed: 1

raw_data:

{
    "job": "string",
    "last_pull_time": "timestamp[ns]",
    "last_success_time": "timestamp[ns]",
    "listing_avail_id": "int32",
    "message": "string",
    "status": "string"
}

schema_attributes:

{
    "job": "string",
    "last_pull_time": "timestamp",
    "last_success_time": "timestamp",
    "listing_avail_id": "int",
    "message": "string",
    "status": "string"
}

schema_name_id: 1142
schema_scan_id: 161996389
updated: 2026-04-14 00:17:02

Schema Scans: 15

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

Scan 162194059

duration: 0:00:14.183902

exit_message:

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

id: 162194059

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_omnom_status/2026-04-17/1776453449",
        "key": "raw/sparefoot_omnom_status/2026-04-17/1776453449/omnom_status.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_omnom_status",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 16110613157265399783,
        "service_name": "sparefoot",
        "span_id": 3455529849449745195,
        "trace_id": 16110613157265399783
    }
}

running: False
schema_name_id: 1142
start_time: 2026-04-17 14:17:33
success: True
trace_id: 16110613157265399783

Scan 162178342

duration: 0:00:14.210975

exit_message:

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

id: 162178342

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_omnom_status/2026-04-17/1776435980",
        "key": "raw/sparefoot_omnom_status/2026-04-17/1776435980/omnom_status.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_omnom_status",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 16892446401011672842,
        "service_name": "sparefoot",
        "span_id": 11691410998439726296,
        "trace_id": 16892446401011672842
    }
}

running: False
schema_name_id: 1142
start_time: 2026-04-17 09:26:32
success: True
trace_id: 16892446401011672842

Scan 162163664

duration: 0:00:14.163856

exit_message:

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

id: 162163664

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_omnom_status/2026-04-17/1776402964",
        "key": "raw/sparefoot_omnom_status/2026-04-17/1776402964/omnom_status.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_omnom_status",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 16724019887295239181,
        "service_name": "sparefoot",
        "span_id": 10566982598741281116,
        "trace_id": 16724019887295239181
    }
}

running: False
schema_name_id: 1142
start_time: 2026-04-17 00:16:08
success: True
trace_id: 16724019887295239181

Scan 162156248

duration: 0:00:14.254152

exit_message:

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

id: 162156248

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_omnom_status/2026-04-16/1776389982",
        "key": "raw/sparefoot_omnom_status/2026-04-16/1776389982/omnom_status.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_omnom_status",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 14945918060243541336,
        "service_name": "sparefoot",
        "span_id": 7288236874387574787,
        "trace_id": 14945918060243541336
    }
}

running: False
schema_name_id: 1142
start_time: 2026-04-16 20:39:49
success: True
trace_id: 14945918060243541336

Scan 162138135

duration: 0:00:14.319555

exit_message:

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

id: 162138135

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_omnom_status/2026-04-16/1776367204",
        "key": "raw/sparefoot_omnom_status/2026-04-16/1776367204/omnom_status.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_omnom_status",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 3098824961729226797,
        "service_name": "sparefoot",
        "span_id": 7630029523811034695,
        "trace_id": 3098824961729226797
    }
}

running: False
schema_name_id: 1142
start_time: 2026-04-16 14:20:12
success: True
trace_id: 3098824961729226797

Scan 162122909

duration: 0:00:14.340879

exit_message:

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

id: 162122909

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_omnom_status/2026-04-16/1776350682",
        "key": "raw/sparefoot_omnom_status/2026-04-16/1776350682/omnom_status.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_omnom_status",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 7343520289902681561,
        "service_name": "sparefoot",
        "span_id": 516108872893793605,
        "trace_id": 7343520289902681561
    }
}

running: False
schema_name_id: 1142
start_time: 2026-04-16 09:44:57
success: True
trace_id: 7343520289902681561

Scan 162107830

duration: 0:00:11.635984

exit_message:

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

id: 162107830

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_omnom_status/2026-04-16/1776316757",
        "key": "raw/sparefoot_omnom_status/2026-04-16/1776316757/omnom_status.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_omnom_status",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 16251407655525766754,
        "service_name": "sparefoot",
        "span_id": 13701962299056983873,
        "trace_id": 16251407655525766754
    }
}

running: False
schema_name_id: 1142
start_time: 2026-04-16 00:19:20
success: True
trace_id: 16251407655525766754

Scan 162100369

duration: 0:00:11.615758

exit_message:

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

id: 162100369

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_omnom_status/2026-04-15/1776302981",
        "key": "raw/sparefoot_omnom_status/2026-04-15/1776302981/omnom_status.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_omnom_status",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 6739600346327953471,
        "service_name": "sparefoot",
        "span_id": 17316450856406166598,
        "trace_id": 6739600346327953471
    }
}

running: False
schema_name_id: 1142
start_time: 2026-04-15 20:29:44
success: True
trace_id: 6739600346327953471

Scan 162081824

duration: 0:00:11.870912

exit_message:

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

id: 162081824

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_omnom_status/2026-04-15/1776280870",
        "key": "raw/sparefoot_omnom_status/2026-04-15/1776280870/omnom_status.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_omnom_status",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 3619727148026214696,
        "service_name": "sparefoot",
        "span_id": 10129258403471164667,
        "trace_id": 3619727148026214696
    }
}

running: False
schema_name_id: 1142
start_time: 2026-04-15 14:21:26
success: True
trace_id: 3619727148026214696

Scan 162064546

duration: 0:00:14.250438

exit_message:

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

id: 162064546

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_omnom_status/2026-04-15/1776260610",
        "key": "raw/sparefoot_omnom_status/2026-04-15/1776260610/omnom_status.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_omnom_status",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 18014674449458610422,
        "service_name": "sparefoot",
        "span_id": 10340683743925351411,
        "trace_id": 18014674449458610422
    }
}

running: False
schema_name_id: 1142
start_time: 2026-04-15 08:44:32
success: True
trace_id: 18014674449458610422

Scan 162052022

duration: 0:00:14.117883

exit_message:

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

id: 162052022

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_omnom_status/2026-04-15/1776230680",
        "key": "raw/sparefoot_omnom_status/2026-04-15/1776230680/omnom_status.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_omnom_status",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 5829556879305407341,
        "service_name": "sparefoot",
        "span_id": 17998778221835400811,
        "trace_id": 5829556879305407341
    }
}

running: False
schema_name_id: 1142
start_time: 2026-04-15 00:24:45
success: True
trace_id: 5829556879305407341

Scan 162044345

duration: 0:00:11.722077

exit_message:

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

id: 162044345

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_omnom_status/2026-04-14/1776216411",
        "key": "raw/sparefoot_omnom_status/2026-04-14/1776216411/omnom_status.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_omnom_status",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 16268358339830607805,
        "service_name": "sparefoot",
        "span_id": 1415196568671486263,
        "trace_id": 16268358339830607805
    }
}

running: False
schema_name_id: 1142
start_time: 2026-04-14 20:26:54
success: True
trace_id: 16268358339830607805

Scan 162026184

duration: 0:00:14.255807

exit_message:

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

id: 162026184

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_omnom_status/2026-04-14/1776194228",
        "key": "raw/sparefoot_omnom_status/2026-04-14/1776194228/omnom_status.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_omnom_status",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 15518888676419831733,
        "service_name": "sparefoot",
        "span_id": 4021780871293759032,
        "trace_id": 15518888676419831733
    }
}

running: False
schema_name_id: 1142
start_time: 2026-04-14 14:20:04
success: True
trace_id: 15518888676419831733

Scan 162010986

duration: 0:00:11.565519

exit_message:

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

id: 162010986

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_omnom_status/2026-04-14/1776175879",
        "key": "raw/sparefoot_omnom_status/2026-04-14/1776175879/omnom_status.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_omnom_status",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 12166714718498390869,
        "service_name": "sparefoot",
        "span_id": 16144967930352668610,
        "trace_id": 12166714718498390869
    }
}

running: False
schema_name_id: 1142
start_time: 2026-04-14 09:14:57
success: True
trace_id: 12166714718498390869

Scan 161996389

duration: 0:00:11.791335

exit_message:

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

id: 161996389

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_omnom_status/2026-04-14/1776143782",
        "key": "raw/sparefoot_omnom_status/2026-04-14/1776143782/omnom_status.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_omnom_status",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 2602474814039179694,
        "service_name": "sparefoot",
        "span_id": 16465512588286984606,
        "trace_id": 2602474814039179694
    }
}

running: False
schema_name_id: 1142
start_time: 2026-04-14 00:16:51
success: True
trace_id: 2602474814039179694

Partitions:

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

Schema:

attributes:

{
    "job": "string",
    "last_pull_time": "timestamp",
    "last_success_time": "timestamp",
    "listing_avail_id": "int",
    "message": "string",
    "status": "string"
}

created: 2026-04-17 14:17:33

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_omnom_status`\n(\n `job`  string , `last_pull_time`  timestamp , `last_success_time`  timestamp , `listing_avail_id`  int , `message`  string , `status`  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_omnom_status/2026-04-17/1776453449'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_omnom_status`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_omnom_status"
}

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:27:01",
        "disabled": false,
        "format": "raw",
        "id": 1142,
        "is_partitioned": false,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_prod_rds",
            "table": "sparefoot_sparefoot_omnom_status"
        },
        "type": "rds"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "job": "string",
            "last_pull_time": "timestamp",
            "last_success_time": "timestamp",
            "listing_avail_id": "int",
            "message": "string",
            "status": "string"
        },
        "created": "2026-04-17 14:17:33",
        "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_omnom_status`\n(\n `job`  string , `last_pull_time`  timestamp , `last_success_time`  timestamp , `listing_avail_id`  int , `message`  string , `status`  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_omnom_status/2026-04-17/1776453449'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_omnom_status`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_omnom_status"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}