Schema Info

Schema Name: sfdl_stage_rds.sparefoot_sparefoot_omnom_status

created: 2022-08-12 11:00:51
disabled: False
format: raw
id: 1397
is_partitioned: False
is_schema_datatyped: False

name:

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

type: rds

Schema Versions: 15

Version 906587

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_omnom_status`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_omnom_status/2026-04-17/1776404202'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_omnom_status"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_omnom_status/2026-04-17/1776404202
id: 906587
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: 1397
schema_scan_id: 6415155
updated: 2026-04-17 00:37:04

Version 906359

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_omnom_status`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_omnom_status/2026-04-16/1776316351'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_omnom_status"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_omnom_status/2026-04-16/1776316351
id: 906359
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: 1397
schema_scan_id: 6414596
updated: 2026-04-16 00:13:04

Version 906154

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_omnom_status`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_omnom_status/2026-04-15/1776230967'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_omnom_status"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_omnom_status/2026-04-15/1776230967
id: 906154
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: 1397
schema_scan_id: 6414118
updated: 2026-04-15 00:29:46

Version 905935

created: 2026-04-14 00:14:03

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_omnom_status`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_omnom_status/2026-04-14/1776143638'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_omnom_status"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_omnom_status/2026-04-14/1776143638
id: 905935
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: 1397
schema_scan_id: 6413603
updated: 2026-04-14 00:14:15

Version 905719

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_omnom_status`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_omnom_status/2026-04-13/1776057555'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_omnom_status"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_omnom_status/2026-04-13/1776057555
id: 905719
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: 1397
schema_scan_id: 6413055
updated: 2026-04-13 00:19:32

Version 905523

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_omnom_status`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_omnom_status/2026-04-12/1775970959'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_omnom_status"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_omnom_status/2026-04-12/1775970959
id: 905523
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: 1397
schema_scan_id: 6412675
updated: 2026-04-12 00:16:16

Version 905324

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_omnom_status`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_omnom_status/2026-04-11/1775885977'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_omnom_status"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_omnom_status/2026-04-11/1775885977
id: 905324
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: 1397
schema_scan_id: 6412297
updated: 2026-04-11 00:40:29

Version 905104

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_omnom_status`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_omnom_status/2026-04-10/1775797989'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_omnom_status"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_omnom_status/2026-04-10/1775797989
id: 905104
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: 1397
schema_scan_id: 6411787
updated: 2026-04-10 00:13:48

Version 904887

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_omnom_status`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_omnom_status/2026-04-09/1775711759'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_omnom_status"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_omnom_status/2026-04-09/1775711759
id: 904887
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: 1397
schema_scan_id: 6411274
updated: 2026-04-09 00:16:29

Version 904678

created: 2026-04-08 00:32:41

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_omnom_status`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_omnom_status/2026-04-08/1775626358'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_omnom_status"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_omnom_status/2026-04-08/1775626358
id: 904678
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: 1397
schema_scan_id: 6410781
updated: 2026-04-08 00:32:55

Version 904460

created: 2026-04-07 00:16:45

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_omnom_status`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_omnom_status/2026-04-07/1775538996'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_omnom_status"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_omnom_status/2026-04-07/1775538996
id: 904460
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: 1397
schema_scan_id: 6410264
updated: 2026-04-07 00:16:59

Version 904250

created: 2026-04-06 00:15:09

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_omnom_status`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_omnom_status/2026-04-06/1775452493'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_omnom_status"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_omnom_status/2026-04-06/1775452493
id: 904250
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: 1397
schema_scan_id: 6409723
updated: 2026-04-06 00:15:20

Version 904048

created: 2026-04-05 00:17:31

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_omnom_status`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_omnom_status/2026-04-05/1775366248'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_omnom_status"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_omnom_status/2026-04-05/1775366248
id: 904048
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: 1397
schema_scan_id: 6409344
updated: 2026-04-05 00:17:45

Version 903842

created: 2026-04-04 00:12:58

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_omnom_status`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_omnom_status/2026-04-04/1775279569'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_omnom_status"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_omnom_status/2026-04-04/1775279569
id: 903842
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: 1397
schema_scan_id: 6408959
updated: 2026-04-04 00:13:09

Version 903627

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_omnom_status`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_omnom_status/2026-04-03/1775193184'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_omnom_status"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_omnom_status/2026-04-03/1775193184
id: 903627
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: 1397
schema_scan_id: 6408462
updated: 2026-04-03 00:13:20

Schema Scans: 15

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

Scan 6415155

duration: 0:00:14.328933

exit_message:

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

id: 6415155

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

running: False
schema_name_id: 1397
start_time: 2026-04-17 00:36:49
success: True
trace_id: 10897073180276602003

Scan 6414596

duration: 0:00:14.302637

exit_message:

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

id: 6414596

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

running: False
schema_name_id: 1397
start_time: 2026-04-16 00:12:50
success: True
trace_id: 7701394124685720355

Scan 6414118

duration: 0:00:14.255309

exit_message:

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

id: 6414118

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

running: False
schema_name_id: 1397
start_time: 2026-04-15 00:29:31
success: True
trace_id: 3439438711348908850

Scan 6413603

duration: 0:00:11.903830

exit_message:

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

id: 6413603

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

running: False
schema_name_id: 1397
start_time: 2026-04-14 00:14:03
success: True
trace_id: 14936052916144098811

Scan 6413055

duration: 0:00:14.221792

exit_message:

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

id: 6413055

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_omnom_status/2026-04-13/1776057555",
        "key": "raw/sparefoot_omnom_status/2026-04-13/1776057555/omnom_status.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_omnom_status",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 1424852681065129101,
        "service_name": "sparefoot",
        "span_id": 7583832682170515558,
        "trace_id": 1424852681065129101
    }
}

running: False
schema_name_id: 1397
start_time: 2026-04-13 00:19:18
success: True
trace_id: 1424852681065129101

Scan 6412675

duration: 0:00:14.219706

exit_message:

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

id: 6412675

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_omnom_status/2026-04-12/1775970959",
        "key": "raw/sparefoot_omnom_status/2026-04-12/1775970959/omnom_status.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_omnom_status",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 12651434492190658542,
        "service_name": "sparefoot",
        "span_id": 1595989728069277606,
        "trace_id": 12651434492190658542
    }
}

running: False
schema_name_id: 1397
start_time: 2026-04-12 00:16:02
success: True
trace_id: 12651434492190658542

Scan 6412297

duration: 0:00:14.351555

exit_message:

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

id: 6412297

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_omnom_status/2026-04-11/1775885977",
        "key": "raw/sparefoot_omnom_status/2026-04-11/1775885977/omnom_status.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_omnom_status",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 3319365711431653143,
        "service_name": "sparefoot",
        "span_id": 2084659721771553851,
        "trace_id": 3319365711431653143
    }
}

running: False
schema_name_id: 1397
start_time: 2026-04-11 00:40:14
success: True
trace_id: 3319365711431653143

Scan 6411787

duration: 0:00:14.160556

exit_message:

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

id: 6411787

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_omnom_status/2026-04-10/1775797989",
        "key": "raw/sparefoot_omnom_status/2026-04-10/1775797989/omnom_status.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_omnom_status",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 14027574988739566417,
        "service_name": "sparefoot",
        "span_id": 3199707926579626697,
        "trace_id": 14027574988739566417
    }
}

running: False
schema_name_id: 1397
start_time: 2026-04-10 00:13:34
success: True
trace_id: 14027574988739566417

Scan 6411274

duration: 0:00:11.672674

exit_message:

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

id: 6411274

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_omnom_status/2026-04-09/1775711759",
        "key": "raw/sparefoot_omnom_status/2026-04-09/1775711759/omnom_status.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_omnom_status",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 5166708368957545790,
        "service_name": "sparefoot",
        "span_id": 12890074770642549445,
        "trace_id": 5166708368957545790
    }
}

running: False
schema_name_id: 1397
start_time: 2026-04-09 00:16:17
success: True
trace_id: 5166708368957545790

Scan 6410781

duration: 0:00:14.320543

exit_message:

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

id: 6410781

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_omnom_status/2026-04-08/1775626358",
        "key": "raw/sparefoot_omnom_status/2026-04-08/1775626358/omnom_status.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_omnom_status",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 8854729491644341046,
        "service_name": "sparefoot",
        "span_id": 6878152904575089458,
        "trace_id": 8854729491644341046
    }
}

running: False
schema_name_id: 1397
start_time: 2026-04-08 00:32:41
success: True
trace_id: 8854729491644341046

Scan 6410264

duration: 0:00:14.242638

exit_message:

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

id: 6410264

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_omnom_status/2026-04-07/1775538996",
        "key": "raw/sparefoot_omnom_status/2026-04-07/1775538996/omnom_status.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_omnom_status",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 11215576412854250186,
        "service_name": "sparefoot",
        "span_id": 6725117630231601131,
        "trace_id": 11215576412854250186
    }
}

running: False
schema_name_id: 1397
start_time: 2026-04-07 00:16:45
success: True
trace_id: 11215576412854250186

Scan 6409723

duration: 0:00:11.809758

exit_message:

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

id: 6409723

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_omnom_status/2026-04-06/1775452493",
        "key": "raw/sparefoot_omnom_status/2026-04-06/1775452493/omnom_status.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_omnom_status",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 10400877904863068999,
        "service_name": "sparefoot",
        "span_id": 4204129137302174764,
        "trace_id": 10400877904863068999
    }
}

running: False
schema_name_id: 1397
start_time: 2026-04-06 00:15:09
success: True
trace_id: 10400877904863068999

Scan 6409344

duration: 0:00:14.234045

exit_message:

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

id: 6409344

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_omnom_status/2026-04-05/1775366248",
        "key": "raw/sparefoot_omnom_status/2026-04-05/1775366248/omnom_status.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_omnom_status",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 12035714756211426756,
        "service_name": "sparefoot",
        "span_id": 15236370968293766973,
        "trace_id": 12035714756211426756
    }
}

running: False
schema_name_id: 1397
start_time: 2026-04-05 00:17:31
success: True
trace_id: 12035714756211426756

Scan 6408959

duration: 0:00:11.754679

exit_message:

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

id: 6408959

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_omnom_status/2026-04-04/1775279569",
        "key": "raw/sparefoot_omnom_status/2026-04-04/1775279569/omnom_status.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_omnom_status",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 12591055659079008311,
        "service_name": "sparefoot",
        "span_id": 11024526255170280374,
        "trace_id": 12591055659079008311
    }
}

running: False
schema_name_id: 1397
start_time: 2026-04-04 00:12:57
success: True
trace_id: 12591055659079008311

Scan 6408462

duration: 0:00:11.642128

exit_message:

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

id: 6408462

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_omnom_status/2026-04-03/1775193184",
        "key": "raw/sparefoot_omnom_status/2026-04-03/1775193184/omnom_status.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_omnom_status",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 7951190720833610353,
        "service_name": "sparefoot",
        "span_id": 8704279752344251238,
        "trace_id": 7951190720833610353
    }
}

running: False
schema_name_id: 1397
start_time: 2026-04-03 00:13:09
success: True
trace_id: 7951190720833610353

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 00:36:50

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_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-stage/raw/sparefoot_omnom_status/2026-04-17/1776404202'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_omnom_status`",
    "repair_table": "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_omnom_status"
}

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:51",
        "disabled": false,
        "format": "raw",
        "id": 1397,
        "is_partitioned": false,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_stage_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 00:36:50",
        "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_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-stage/raw/sparefoot_omnom_status/2026-04-17/1776404202'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_omnom_status`",
            "repair_table": "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_omnom_status"
        }
    },
    "server": {
        "hostname": "schemamanager-5c55c886bf-h2ts4",
        "name": "schema_manager",
        "process_start": "2025-10-21 13:03:27",
        "sf_env": "stage",
        "version": "2112174301"
    }
}