Schema Info

Schema Name: sfdl_stage_rds.incentive_incentive_redemption_request

created: 2022-08-12 14:18:56
disabled: False
format: raw
id: 1408
is_partitioned: False
is_schema_datatyped: False

name:

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

type: rds

Schema Versions: 15

Version 906539

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.incentive_incentive_redemption_request`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.incentive_incentive_redemption_request`\n(\n `cost`  double , `created_dtm`  timestamp , `item_value`  double , `modified_dtm`  timestamp , `offer_id`  string , `redemption_request_id`  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-incentive-stage/raw/incentive_redemption_request/2026-04-17/1776402942'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.incentive_incentive_redemption_request"
]

hive_path: s3://sfdl-rds-incentive-stage/raw/incentive_redemption_request/2026-04-17/1776402942
id: 906539
processed: 1

raw_data:

{
    "cost": "double",
    "created_dtm": "timestamp[ns]",
    "item_value": "double",
    "modified_dtm": "timestamp[ns]",
    "offer_id": "string",
    "redemption_request_id": "string",
    "status": "string"
}

schema_attributes:

{
    "cost": "double",
    "created_dtm": "timestamp",
    "item_value": "double",
    "modified_dtm": "timestamp",
    "offer_id": "string",
    "redemption_request_id": "string",
    "status": "string"
}

schema_name_id: 1408
schema_scan_id: 6415107
updated: 2026-04-17 00:16:21

Version 906345

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.incentive_incentive_redemption_request`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.incentive_incentive_redemption_request`\n(\n `cost`  double , `created_dtm`  timestamp , `item_value`  double , `modified_dtm`  timestamp , `offer_id`  string , `redemption_request_id`  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-incentive-stage/raw/incentive_redemption_request/2026-04-16/1776316272'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.incentive_incentive_redemption_request"
]

hive_path: s3://sfdl-rds-incentive-stage/raw/incentive_redemption_request/2026-04-16/1776316272
id: 906345
processed: 1

raw_data:

{
    "cost": "double",
    "created_dtm": "timestamp[ns]",
    "item_value": "double",
    "modified_dtm": "timestamp[ns]",
    "offer_id": "string",
    "redemption_request_id": "string",
    "status": "string"
}

schema_attributes:

{
    "cost": "double",
    "created_dtm": "timestamp",
    "item_value": "double",
    "modified_dtm": "timestamp",
    "offer_id": "string",
    "redemption_request_id": "string",
    "status": "string"
}

schema_name_id: 1408
schema_scan_id: 6414580
updated: 2026-04-16 00:11:27

Version 906148

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.incentive_incentive_redemption_request`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.incentive_incentive_redemption_request`\n(\n `cost`  double , `created_dtm`  timestamp , `item_value`  double , `modified_dtm`  timestamp , `offer_id`  string , `redemption_request_id`  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-incentive-stage/raw/incentive_redemption_request/2026-04-15/1776230894'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.incentive_incentive_redemption_request"
]

hive_path: s3://sfdl-rds-incentive-stage/raw/incentive_redemption_request/2026-04-15/1776230894
id: 906148
processed: 1

raw_data:

{
    "cost": "double",
    "created_dtm": "timestamp[ns]",
    "item_value": "double",
    "modified_dtm": "timestamp[ns]",
    "offer_id": "string",
    "redemption_request_id": "string",
    "status": "string"
}

schema_attributes:

{
    "cost": "double",
    "created_dtm": "timestamp",
    "item_value": "double",
    "modified_dtm": "timestamp",
    "offer_id": "string",
    "redemption_request_id": "string",
    "status": "string"
}

schema_name_id: 1408
schema_scan_id: 6414112
updated: 2026-04-15 00:28:28

Version 905915

created: 2026-04-14 00:11:47

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.incentive_incentive_redemption_request`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.incentive_incentive_redemption_request`\n(\n `cost`  double , `created_dtm`  timestamp , `item_value`  double , `modified_dtm`  timestamp , `offer_id`  string , `redemption_request_id`  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-incentive-stage/raw/incentive_redemption_request/2026-04-14/1776143504'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.incentive_incentive_redemption_request"
]

hive_path: s3://sfdl-rds-incentive-stage/raw/incentive_redemption_request/2026-04-14/1776143504
id: 905915
processed: 1

raw_data:

{
    "cost": "double",
    "created_dtm": "timestamp[ns]",
    "item_value": "double",
    "modified_dtm": "timestamp[ns]",
    "offer_id": "string",
    "redemption_request_id": "string",
    "status": "string"
}

schema_attributes:

{
    "cost": "double",
    "created_dtm": "timestamp",
    "item_value": "double",
    "modified_dtm": "timestamp",
    "offer_id": "string",
    "redemption_request_id": "string",
    "status": "string"
}

schema_name_id: 1408
schema_scan_id: 6413583
updated: 2026-04-14 00:11:59

Version 905696

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.incentive_incentive_redemption_request`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.incentive_incentive_redemption_request`\n(\n `cost`  double , `created_dtm`  timestamp , `item_value`  double , `modified_dtm`  timestamp , `offer_id`  string , `redemption_request_id`  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-incentive-stage/raw/incentive_redemption_request/2026-04-13/1776057378'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.incentive_incentive_redemption_request"
]

hive_path: s3://sfdl-rds-incentive-stage/raw/incentive_redemption_request/2026-04-13/1776057378
id: 905696
processed: 1

raw_data:

{
    "cost": "double",
    "created_dtm": "timestamp[ns]",
    "item_value": "double",
    "modified_dtm": "timestamp[ns]",
    "offer_id": "string",
    "redemption_request_id": "string",
    "status": "string"
}

schema_attributes:

{
    "cost": "double",
    "created_dtm": "timestamp",
    "item_value": "double",
    "modified_dtm": "timestamp",
    "offer_id": "string",
    "redemption_request_id": "string",
    "status": "string"
}

schema_name_id: 1408
schema_scan_id: 6413031
updated: 2026-04-13 00:16:32

Version 905478

created: 2026-04-12 00:08:12

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.incentive_incentive_redemption_request`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.incentive_incentive_redemption_request`\n(\n `cost`  double , `created_dtm`  timestamp , `item_value`  double , `modified_dtm`  timestamp , `offer_id`  string , `redemption_request_id`  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-incentive-stage/raw/incentive_redemption_request/2026-04-12/1775970483'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.incentive_incentive_redemption_request"
]

hive_path: s3://sfdl-rds-incentive-stage/raw/incentive_redemption_request/2026-04-12/1775970483
id: 905478
processed: 1

raw_data:

{
    "cost": "double",
    "created_dtm": "timestamp[ns]",
    "item_value": "double",
    "modified_dtm": "timestamp[ns]",
    "offer_id": "string",
    "redemption_request_id": "string",
    "status": "string"
}

schema_attributes:

{
    "cost": "double",
    "created_dtm": "timestamp",
    "item_value": "double",
    "modified_dtm": "timestamp",
    "offer_id": "string",
    "redemption_request_id": "string",
    "status": "string"
}

schema_name_id: 1408
schema_scan_id: 6412628
updated: 2026-04-12 00:08:23

Version 905276

created: 2026-04-11 00:08:56

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.incentive_incentive_redemption_request`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.incentive_incentive_redemption_request`\n(\n `cost`  double , `created_dtm`  timestamp , `item_value`  double , `modified_dtm`  timestamp , `offer_id`  string , `redemption_request_id`  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-incentive-stage/raw/incentive_redemption_request/2026-04-11/1775884122'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.incentive_incentive_redemption_request"
]

hive_path: s3://sfdl-rds-incentive-stage/raw/incentive_redemption_request/2026-04-11/1775884122
id: 905276
processed: 1

raw_data:

{
    "cost": "double",
    "created_dtm": "timestamp[ns]",
    "item_value": "double",
    "modified_dtm": "timestamp[ns]",
    "offer_id": "string",
    "redemption_request_id": "string",
    "status": "string"
}

schema_attributes:

{
    "cost": "double",
    "created_dtm": "timestamp",
    "item_value": "double",
    "modified_dtm": "timestamp",
    "offer_id": "string",
    "redemption_request_id": "string",
    "status": "string"
}

schema_name_id: 1408
schema_scan_id: 6412248
updated: 2026-04-11 00:09:10

Version 905097

created: 2026-04-10 00:12:44

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.incentive_incentive_redemption_request`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.incentive_incentive_redemption_request`\n(\n `cost`  double , `created_dtm`  timestamp , `item_value`  double , `modified_dtm`  timestamp , `offer_id`  string , `redemption_request_id`  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-incentive-stage/raw/incentive_redemption_request/2026-04-10/1775797961'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.incentive_incentive_redemption_request"
]

hive_path: s3://sfdl-rds-incentive-stage/raw/incentive_redemption_request/2026-04-10/1775797961
id: 905097
processed: 1

raw_data:

{
    "cost": "double",
    "created_dtm": "timestamp[ns]",
    "item_value": "double",
    "modified_dtm": "timestamp[ns]",
    "offer_id": "string",
    "redemption_request_id": "string",
    "status": "string"
}

schema_attributes:

{
    "cost": "double",
    "created_dtm": "timestamp",
    "item_value": "double",
    "modified_dtm": "timestamp",
    "offer_id": "string",
    "redemption_request_id": "string",
    "status": "string"
}

schema_name_id: 1408
schema_scan_id: 6411780
updated: 2026-04-10 00:12:58

Version 904876

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.incentive_incentive_redemption_request`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.incentive_incentive_redemption_request`\n(\n `cost`  double , `created_dtm`  timestamp , `item_value`  double , `modified_dtm`  timestamp , `offer_id`  string , `redemption_request_id`  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-incentive-stage/raw/incentive_redemption_request/2026-04-09/1775711670'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.incentive_incentive_redemption_request"
]

hive_path: s3://sfdl-rds-incentive-stage/raw/incentive_redemption_request/2026-04-09/1775711670
id: 904876
processed: 1

raw_data:

{
    "cost": "double",
    "created_dtm": "timestamp[ns]",
    "item_value": "double",
    "modified_dtm": "timestamp[ns]",
    "offer_id": "string",
    "redemption_request_id": "string",
    "status": "string"
}

schema_attributes:

{
    "cost": "double",
    "created_dtm": "timestamp",
    "item_value": "double",
    "modified_dtm": "timestamp",
    "offer_id": "string",
    "redemption_request_id": "string",
    "status": "string"
}

schema_name_id: 1408
schema_scan_id: 6411263
updated: 2026-04-09 00:15:16

Version 904651

created: 2026-04-08 00:12:29

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.incentive_incentive_redemption_request`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.incentive_incentive_redemption_request`\n(\n `cost`  double , `created_dtm`  timestamp , `item_value`  double , `modified_dtm`  timestamp , `offer_id`  string , `redemption_request_id`  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-incentive-stage/raw/incentive_redemption_request/2026-04-08/1775625119'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.incentive_incentive_redemption_request"
]

hive_path: s3://sfdl-rds-incentive-stage/raw/incentive_redemption_request/2026-04-08/1775625119
id: 904651
processed: 1

raw_data:

{
    "cost": "double",
    "created_dtm": "timestamp[ns]",
    "item_value": "double",
    "modified_dtm": "timestamp[ns]",
    "offer_id": "string",
    "redemption_request_id": "string",
    "status": "string"
}

schema_attributes:

{
    "cost": "double",
    "created_dtm": "timestamp",
    "item_value": "double",
    "modified_dtm": "timestamp",
    "offer_id": "string",
    "redemption_request_id": "string",
    "status": "string"
}

schema_name_id: 1408
schema_scan_id: 6410748
updated: 2026-04-08 00:12:40

Version 904405

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.incentive_incentive_redemption_request`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.incentive_incentive_redemption_request`\n(\n `cost`  double , `created_dtm`  timestamp , `item_value`  double , `modified_dtm`  timestamp , `offer_id`  string , `redemption_request_id`  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-incentive-stage/raw/incentive_redemption_request/2026-04-07/1775538370'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.incentive_incentive_redemption_request"
]

hive_path: s3://sfdl-rds-incentive-stage/raw/incentive_redemption_request/2026-04-07/1775538370
id: 904405
processed: 1

raw_data:

{
    "cost": "double",
    "created_dtm": "timestamp[ns]",
    "item_value": "double",
    "modified_dtm": "timestamp[ns]",
    "offer_id": "string",
    "redemption_request_id": "string",
    "status": "string"
}

schema_attributes:

{
    "cost": "double",
    "created_dtm": "timestamp",
    "item_value": "double",
    "modified_dtm": "timestamp",
    "offer_id": "string",
    "redemption_request_id": "string",
    "status": "string"
}

schema_name_id: 1408
schema_scan_id: 6410206
updated: 2026-04-07 00:06:44

Version 904215

created: 2026-04-06 00:07:55

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.incentive_incentive_redemption_request`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.incentive_incentive_redemption_request`\n(\n `cost`  double , `created_dtm`  timestamp , `item_value`  double , `modified_dtm`  timestamp , `offer_id`  string , `redemption_request_id`  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-incentive-stage/raw/incentive_redemption_request/2026-04-06/1775452072'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.incentive_incentive_redemption_request"
]

hive_path: s3://sfdl-rds-incentive-stage/raw/incentive_redemption_request/2026-04-06/1775452072
id: 904215
processed: 1

raw_data:

{
    "cost": "double",
    "created_dtm": "timestamp[ns]",
    "item_value": "double",
    "modified_dtm": "timestamp[ns]",
    "offer_id": "string",
    "redemption_request_id": "string",
    "status": "string"
}

schema_attributes:

{
    "cost": "double",
    "created_dtm": "timestamp",
    "item_value": "double",
    "modified_dtm": "timestamp",
    "offer_id": "string",
    "redemption_request_id": "string",
    "status": "string"
}

schema_name_id: 1408
schema_scan_id: 6409688
updated: 2026-04-06 00:08:09

Version 904031

created: 2026-04-05 00:12:42

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.incentive_incentive_redemption_request`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.incentive_incentive_redemption_request`\n(\n `cost`  double , `created_dtm`  timestamp , `item_value`  double , `modified_dtm`  timestamp , `offer_id`  string , `redemption_request_id`  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-incentive-stage/raw/incentive_redemption_request/2026-04-05/1775365958'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.incentive_incentive_redemption_request"
]

hive_path: s3://sfdl-rds-incentive-stage/raw/incentive_redemption_request/2026-04-05/1775365958
id: 904031
processed: 1

raw_data:

{
    "cost": "double",
    "created_dtm": "timestamp[ns]",
    "item_value": "double",
    "modified_dtm": "timestamp[ns]",
    "offer_id": "string",
    "redemption_request_id": "string",
    "status": "string"
}

schema_attributes:

{
    "cost": "double",
    "created_dtm": "timestamp",
    "item_value": "double",
    "modified_dtm": "timestamp",
    "offer_id": "string",
    "redemption_request_id": "string",
    "status": "string"
}

schema_name_id: 1408
schema_scan_id: 6409327
updated: 2026-04-05 00:12:56

Version 903823

created: 2026-04-04 00:10:19

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.incentive_incentive_redemption_request`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.incentive_incentive_redemption_request`\n(\n `cost`  double , `created_dtm`  timestamp , `item_value`  double , `modified_dtm`  timestamp , `offer_id`  string , `redemption_request_id`  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-incentive-stage/raw/incentive_redemption_request/2026-04-04/1775279416'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.incentive_incentive_redemption_request"
]

hive_path: s3://sfdl-rds-incentive-stage/raw/incentive_redemption_request/2026-04-04/1775279416
id: 903823
processed: 1

raw_data:

{
    "cost": "double",
    "created_dtm": "timestamp[ns]",
    "item_value": "double",
    "modified_dtm": "timestamp[ns]",
    "offer_id": "string",
    "redemption_request_id": "string",
    "status": "string"
}

schema_attributes:

{
    "cost": "double",
    "created_dtm": "timestamp",
    "item_value": "double",
    "modified_dtm": "timestamp",
    "offer_id": "string",
    "redemption_request_id": "string",
    "status": "string"
}

schema_name_id: 1408
schema_scan_id: 6408939
updated: 2026-04-04 00:10:33

Version 903603

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.incentive_incentive_redemption_request`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.incentive_incentive_redemption_request`\n(\n `cost`  double , `created_dtm`  timestamp , `item_value`  double , `modified_dtm`  timestamp , `offer_id`  string , `redemption_request_id`  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-incentive-stage/raw/incentive_redemption_request/2026-04-03/1775192965'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.incentive_incentive_redemption_request"
]

hive_path: s3://sfdl-rds-incentive-stage/raw/incentive_redemption_request/2026-04-03/1775192965
id: 903603
processed: 1

raw_data:

{
    "cost": "double",
    "created_dtm": "timestamp[ns]",
    "item_value": "double",
    "modified_dtm": "timestamp[ns]",
    "offer_id": "string",
    "redemption_request_id": "string",
    "status": "string"
}

schema_attributes:

{
    "cost": "double",
    "created_dtm": "timestamp",
    "item_value": "double",
    "modified_dtm": "timestamp",
    "offer_id": "string",
    "redemption_request_id": "string",
    "status": "string"
}

schema_name_id: 1408
schema_scan_id: 6408436
updated: 2026-04-03 00:09:46

Schema Scans: 15

Last at 2026-04-17 00:16:07

Scan 6415107

duration: 0:00:14.369496

exit_message:

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

id: 6415107

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-incentive-stage",
        "hive_path": "s3://sfdl-rds-incentive-stage/raw/incentive_redemption_request/2026-04-17/1776402942",
        "key": "raw/incentive_redemption_request/2026-04-17/1776402942/redemption_request.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.incentive_incentive_redemption_request",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 15023425040760910933,
        "service_name": "incentive",
        "span_id": 1938244992341146725,
        "trace_id": 15023425040760910933
    }
}

running: False
schema_name_id: 1408
start_time: 2026-04-17 00:16:07
success: True
trace_id: 15023425040760910933

Scan 6414580

duration: 0:00:11.703124

exit_message:

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

id: 6414580

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-incentive-stage",
        "hive_path": "s3://sfdl-rds-incentive-stage/raw/incentive_redemption_request/2026-04-16/1776316272",
        "key": "raw/incentive_redemption_request/2026-04-16/1776316272/redemption_request.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.incentive_incentive_redemption_request",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 10225235230966716157,
        "service_name": "incentive",
        "span_id": 6758591505869955981,
        "trace_id": 10225235230966716157
    }
}

running: False
schema_name_id: 1408
start_time: 2026-04-16 00:11:15
success: True
trace_id: 10225235230966716157

Scan 6414112

duration: 0:00:11.629132

exit_message:

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

id: 6414112

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-incentive-stage",
        "hive_path": "s3://sfdl-rds-incentive-stage/raw/incentive_redemption_request/2026-04-15/1776230894",
        "key": "raw/incentive_redemption_request/2026-04-15/1776230894/redemption_request.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.incentive_incentive_redemption_request",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 12115343639888352162,
        "service_name": "incentive",
        "span_id": 510761920288224551,
        "trace_id": 12115343639888352162
    }
}

running: False
schema_name_id: 1408
start_time: 2026-04-15 00:28:17
success: True
trace_id: 12115343639888352162

Scan 6413583

duration: 0:00:11.830746

exit_message:

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

id: 6413583

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-incentive-stage",
        "hive_path": "s3://sfdl-rds-incentive-stage/raw/incentive_redemption_request/2026-04-14/1776143504",
        "key": "raw/incentive_redemption_request/2026-04-14/1776143504/redemption_request.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.incentive_incentive_redemption_request",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 8257861731429722912,
        "service_name": "incentive",
        "span_id": 11191813603343866843,
        "trace_id": 8257861731429722912
    }
}

running: False
schema_name_id: 1408
start_time: 2026-04-14 00:11:47
success: True
trace_id: 8257861731429722912

Scan 6413031

duration: 0:00:11.671281

exit_message:

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

id: 6413031

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-incentive-stage",
        "hive_path": "s3://sfdl-rds-incentive-stage/raw/incentive_redemption_request/2026-04-13/1776057378",
        "key": "raw/incentive_redemption_request/2026-04-13/1776057378/redemption_request.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.incentive_incentive_redemption_request",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 7688581591206942915,
        "service_name": "incentive",
        "span_id": 3611537376914186114,
        "trace_id": 7688581591206942915
    }
}

running: False
schema_name_id: 1408
start_time: 2026-04-13 00:16:20
success: True
trace_id: 7688581591206942915

Scan 6412628

duration: 0:00:11.679351

exit_message:

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

id: 6412628

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-incentive-stage",
        "hive_path": "s3://sfdl-rds-incentive-stage/raw/incentive_redemption_request/2026-04-12/1775970483",
        "key": "raw/incentive_redemption_request/2026-04-12/1775970483/redemption_request.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.incentive_incentive_redemption_request",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 14103858175726397982,
        "service_name": "incentive",
        "span_id": 11820366157079749017,
        "trace_id": 14103858175726397982
    }
}

running: False
schema_name_id: 1408
start_time: 2026-04-12 00:08:11
success: True
trace_id: 14103858175726397982

Scan 6412248

duration: 0:00:14.320521

exit_message:

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

id: 6412248

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-incentive-stage",
        "hive_path": "s3://sfdl-rds-incentive-stage/raw/incentive_redemption_request/2026-04-11/1775884122",
        "key": "raw/incentive_redemption_request/2026-04-11/1775884122/redemption_request.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.incentive_incentive_redemption_request",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 9224450573566076430,
        "service_name": "incentive",
        "span_id": 15193295874101232425,
        "trace_id": 9224450573566076430
    }
}

running: False
schema_name_id: 1408
start_time: 2026-04-11 00:08:55
success: True
trace_id: 9224450573566076430

Scan 6411780

duration: 0:00:14.149799

exit_message:

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

id: 6411780

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-incentive-stage",
        "hive_path": "s3://sfdl-rds-incentive-stage/raw/incentive_redemption_request/2026-04-10/1775797961",
        "key": "raw/incentive_redemption_request/2026-04-10/1775797961/redemption_request.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.incentive_incentive_redemption_request",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 12172646945255837234,
        "service_name": "incentive",
        "span_id": 7329777534796745061,
        "trace_id": 12172646945255837234
    }
}

running: False
schema_name_id: 1408
start_time: 2026-04-10 00:12:43
success: True
trace_id: 12172646945255837234

Scan 6411263

duration: 0:00:14.572496

exit_message:

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

id: 6411263

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-incentive-stage",
        "hive_path": "s3://sfdl-rds-incentive-stage/raw/incentive_redemption_request/2026-04-09/1775711670",
        "key": "raw/incentive_redemption_request/2026-04-09/1775711670/redemption_request.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.incentive_incentive_redemption_request",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 15448198684889586067,
        "service_name": "incentive",
        "span_id": 3086929781993131740,
        "trace_id": 15448198684889586067
    }
}

running: False
schema_name_id: 1408
start_time: 2026-04-09 00:15:01
success: True
trace_id: 15448198684889586067

Scan 6410748

duration: 0:00:11.741913

exit_message:

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

id: 6410748

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-incentive-stage",
        "hive_path": "s3://sfdl-rds-incentive-stage/raw/incentive_redemption_request/2026-04-08/1775625119",
        "key": "raw/incentive_redemption_request/2026-04-08/1775625119/redemption_request.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.incentive_incentive_redemption_request",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 17023868065775633670,
        "service_name": "incentive",
        "span_id": 10131750287447473922,
        "trace_id": 17023868065775633670
    }
}

running: False
schema_name_id: 1408
start_time: 2026-04-08 00:12:28
success: True
trace_id: 17023868065775633670

Scan 6410206

duration: 0:00:11.920989

exit_message:

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

id: 6410206

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-incentive-stage",
        "hive_path": "s3://sfdl-rds-incentive-stage/raw/incentive_redemption_request/2026-04-07/1775538370",
        "key": "raw/incentive_redemption_request/2026-04-07/1775538370/redemption_request.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.incentive_incentive_redemption_request",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 252000412873543802,
        "service_name": "incentive",
        "span_id": 9262537495599644533,
        "trace_id": 252000412873543802
    }
}

running: False
schema_name_id: 1408
start_time: 2026-04-07 00:06:32
success: True
trace_id: 252000412873543802

Scan 6409688

duration: 0:00:14.314858

exit_message:

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

id: 6409688

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-incentive-stage",
        "hive_path": "s3://sfdl-rds-incentive-stage/raw/incentive_redemption_request/2026-04-06/1775452072",
        "key": "raw/incentive_redemption_request/2026-04-06/1775452072/redemption_request.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.incentive_incentive_redemption_request",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 4386041535629175505,
        "service_name": "incentive",
        "span_id": 4592183692767924647,
        "trace_id": 4386041535629175505
    }
}

running: False
schema_name_id: 1408
start_time: 2026-04-06 00:07:55
success: True
trace_id: 4386041535629175505

Scan 6409327

duration: 0:00:14.314427

exit_message:

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

id: 6409327

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-incentive-stage",
        "hive_path": "s3://sfdl-rds-incentive-stage/raw/incentive_redemption_request/2026-04-05/1775365958",
        "key": "raw/incentive_redemption_request/2026-04-05/1775365958/redemption_request.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.incentive_incentive_redemption_request",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 7996592965937017077,
        "service_name": "incentive",
        "span_id": 8575605858692130086,
        "trace_id": 7996592965937017077
    }
}

running: False
schema_name_id: 1408
start_time: 2026-04-05 00:12:41
success: True
trace_id: 7996592965937017077

Scan 6408939

duration: 0:00:14.205266

exit_message:

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

id: 6408939

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-incentive-stage",
        "hive_path": "s3://sfdl-rds-incentive-stage/raw/incentive_redemption_request/2026-04-04/1775279416",
        "key": "raw/incentive_redemption_request/2026-04-04/1775279416/redemption_request.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.incentive_incentive_redemption_request",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 14191943552719217489,
        "service_name": "incentive",
        "span_id": 6906159559068602863,
        "trace_id": 14191943552719217489
    }
}

running: False
schema_name_id: 1408
start_time: 2026-04-04 00:10:19
success: True
trace_id: 14191943552719217489

Scan 6408436

duration: 0:00:11.734934

exit_message:

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

id: 6408436

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-incentive-stage",
        "hive_path": "s3://sfdl-rds-incentive-stage/raw/incentive_redemption_request/2026-04-03/1775192965",
        "key": "raw/incentive_redemption_request/2026-04-03/1775192965/redemption_request.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.incentive_incentive_redemption_request",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 4414991371448274665,
        "service_name": "incentive",
        "span_id": 11555132486050039725,
        "trace_id": 4414991371448274665
    }
}

running: False
schema_name_id: 1408
start_time: 2026-04-03 00:09:35
success: True
trace_id: 4414991371448274665

Partitions:

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

Schema:

attributes:

{
    "cost": "double",
    "created_dtm": "timestamp",
    "item_value": "double",
    "modified_dtm": "timestamp",
    "offer_id": "string",
    "redemption_request_id": "string",
    "status": "string"
}

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

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.incentive_incentive_redemption_request`\n(\n `cost`  double , `created_dtm`  timestamp , `item_value`  double , `modified_dtm`  timestamp , `offer_id`  string , `redemption_request_id`  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-incentive-stage/raw/incentive_redemption_request/2026-04-17/1776402942'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_rds.incentive_incentive_redemption_request`",
    "repair_table": "MSCK REPAIR TABLE sfdl_stage_rds.incentive_incentive_redemption_request"
}

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 14:18:56",
        "disabled": false,
        "format": "raw",
        "id": 1408,
        "is_partitioned": false,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_stage_rds",
            "table": "incentive_incentive_redemption_request"
        },
        "type": "rds"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "cost": "double",
            "created_dtm": "timestamp",
            "item_value": "double",
            "modified_dtm": "timestamp",
            "offer_id": "string",
            "redemption_request_id": "string",
            "status": "string"
        },
        "created": "2026-04-17 00:16:08",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.incentive_incentive_redemption_request`\n(\n `cost`  double , `created_dtm`  timestamp , `item_value`  double , `modified_dtm`  timestamp , `offer_id`  string , `redemption_request_id`  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-incentive-stage/raw/incentive_redemption_request/2026-04-17/1776402942'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_rds.incentive_incentive_redemption_request`",
            "repair_table": "MSCK REPAIR TABLE sfdl_stage_rds.incentive_incentive_redemption_request"
        }
    },
    "server": {
        "hostname": "schemamanager-5c55c886bf-h2ts4",
        "name": "schema_manager",
        "process_start": "2025-10-21 13:03:27",
        "sf_env": "stage",
        "version": "2112174301"
    }
}