Schema Info

Schema Name: sfdl_prod_rds.incentive_incentive_redemption_request

created: 2022-08-18 17:13:13
disabled: False
format: raw
id: 1070
is_partitioned: False
is_schema_datatyped: False

name:

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

type: rds

Schema Versions: 15

Version 1718365

created: 2026-04-17 14:10:08

ddl:

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

hive_path: s3://sfdl-rds-incentive-prod/raw/incentive_redemption_request/2026-04-17/1776452997
id: 1718365
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: 1070
schema_scan_id: 162193957
updated: 2026-04-17 14:10:19

Version 1718210

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

ddl:

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

hive_path: s3://sfdl-rds-incentive-prod/raw/incentive_redemption_request/2026-04-17/1776435756
id: 1718210
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: 1070
schema_scan_id: 162178306
updated: 2026-04-17 09:23:01

Version 1717450

created: 2026-04-17 00:11:58

ddl:

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

hive_path: s3://sfdl-rds-incentive-prod/raw/incentive_redemption_request/2026-04-17/1776402557
id: 1717450
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: 1070
schema_scan_id: 162163605
updated: 2026-04-17 00:12:12

Version 1717300

created: 2026-04-16 20:11:50

ddl:

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

hive_path: s3://sfdl-rds-incentive-prod/raw/incentive_redemption_request/2026-04-16/1776388295
id: 1717300
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: 1070
schema_scan_id: 162156015
updated: 2026-04-16 20:14:24

Version 1717169

created: 2026-04-16 14:16:10

ddl:

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

hive_path: s3://sfdl-rds-incentive-prod/raw/incentive_redemption_request/2026-04-16/1776366954
id: 1717169
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: 1070
schema_scan_id: 162138068
updated: 2026-04-16 14:16:21

Version 1717000

created: 2026-04-16 09:15:21

ddl:

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

hive_path: s3://sfdl-rds-incentive-prod/raw/incentive_redemption_request/2026-04-16/1776348916
id: 1717000
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: 1070
schema_scan_id: 162122542
updated: 2026-04-16 09:15:33

Version 1716189

created: 2026-04-16 00:06:02

ddl:

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

hive_path: s3://sfdl-rds-incentive-prod/raw/incentive_redemption_request/2026-04-16/1776315950
id: 1716189
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: 1070
schema_scan_id: 162107739
updated: 2026-04-16 00:06:15

Version 1716080

created: 2026-04-15 20:18:11

ddl:

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

hive_path: s3://sfdl-rds-incentive-prod/raw/incentive_redemption_request/2026-04-15/1776302277
id: 1716080
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: 1070
schema_scan_id: 162100286
updated: 2026-04-15 20:18:23

Version 1715956

created: 2026-04-15 14:12:46

ddl:

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

hive_path: s3://sfdl-rds-incentive-prod/raw/incentive_redemption_request/2026-04-15/1776280352
id: 1715956
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: 1070
schema_scan_id: 162081684
updated: 2026-04-15 14:13:00

Version 1715774

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

ddl:

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

hive_path: s3://sfdl-rds-incentive-prod/raw/incentive_redemption_request/2026-04-15/1776260575
id: 1715774
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: 1070
schema_scan_id: 162064512
updated: 2026-04-15 08:43:22

Version 1715030

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

ddl:

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

hive_path: s3://sfdl-rds-incentive-prod/raw/incentive_redemption_request/2026-04-15/1776230290
id: 1715030
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: 1070
schema_scan_id: 162052001
updated: 2026-04-15 00:18:35

Version 1714894

created: 2026-04-14 20:15:53

ddl:

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

hive_path: s3://sfdl-rds-incentive-prod/raw/incentive_redemption_request/2026-04-14/1776215727
id: 1714894
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: 1070
schema_scan_id: 162044254
updated: 2026-04-14 20:16:07

Version 1714741

created: 2026-04-14 14:16:19

ddl:

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

hive_path: s3://sfdl-rds-incentive-prod/raw/incentive_redemption_request/2026-04-14/1776194147
id: 1714741
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: 1070
schema_scan_id: 162026123
updated: 2026-04-14 14:16:32

Version 1714542

created: 2026-04-14 08:54:55

ddl:

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

hive_path: s3://sfdl-rds-incentive-prod/raw/incentive_redemption_request/2026-04-14/1776174886
id: 1714542
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: 1070
schema_scan_id: 162009394
updated: 2026-04-14 08:55:08

Version 1713799

created: 2026-04-14 00:07:08

ddl:

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

hive_path: s3://sfdl-rds-incentive-prod/raw/incentive_redemption_request/2026-04-14/1776143224
id: 1713799
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: 1070
schema_scan_id: 161996313
updated: 2026-04-14 00:07:19

Schema Scans: 15

Last at 2026-04-17 14:10:07

Scan 162193957

duration: 0:00:11.881383

exit_message:

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

id: 162193957

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-incentive-prod",
        "hive_path": "s3://sfdl-rds-incentive-prod/raw/incentive_redemption_request/2026-04-17/1776452997",
        "key": "raw/incentive_redemption_request/2026-04-17/1776452997/redemption_request.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.incentive_incentive_redemption_request",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 2799800721539680731,
        "service_name": "incentive",
        "span_id": 14255930826957233625,
        "trace_id": 2799800721539680731
    }
}

running: False
schema_name_id: 1070
start_time: 2026-04-17 14:10:07
success: True
trace_id: 2799800721539680731

Scan 162178306

duration: 0:00:14.279569

exit_message:

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

id: 162178306

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-incentive-prod",
        "hive_path": "s3://sfdl-rds-incentive-prod/raw/incentive_redemption_request/2026-04-17/1776435756",
        "key": "raw/incentive_redemption_request/2026-04-17/1776435756/redemption_request.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.incentive_incentive_redemption_request",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 7089961908228921288,
        "service_name": "incentive",
        "span_id": 10298247125373839362,
        "trace_id": 7089961908228921288
    }
}

running: False
schema_name_id: 1070
start_time: 2026-04-17 09:22:47
success: True
trace_id: 7089961908228921288

Scan 162163605

duration: 0:00:14.289709

exit_message:

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

id: 162163605

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-incentive-prod",
        "hive_path": "s3://sfdl-rds-incentive-prod/raw/incentive_redemption_request/2026-04-17/1776402557",
        "key": "raw/incentive_redemption_request/2026-04-17/1776402557/redemption_request.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.incentive_incentive_redemption_request",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 7206117029818187618,
        "service_name": "incentive",
        "span_id": 16607425628813576690,
        "trace_id": 7206117029818187618
    }
}

running: False
schema_name_id: 1070
start_time: 2026-04-17 00:11:58
success: True
trace_id: 7206117029818187618

Scan 162156015

duration: 0:02:34.110425

exit_message:

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

id: 162156015

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-incentive-prod",
        "hive_path": "s3://sfdl-rds-incentive-prod/raw/incentive_redemption_request/2026-04-16/1776388295",
        "key": "raw/incentive_redemption_request/2026-04-16/1776388295/redemption_request.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.incentive_incentive_redemption_request",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 16306676022992000537,
        "service_name": "incentive",
        "span_id": 4166044605292268690,
        "trace_id": 16306676022992000537
    }
}

running: False
schema_name_id: 1070
start_time: 2026-04-16 20:11:50
success: True
trace_id: 16306676022992000537

Scan 162138068

duration: 0:00:11.719198

exit_message:

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

id: 162138068

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-incentive-prod",
        "hive_path": "s3://sfdl-rds-incentive-prod/raw/incentive_redemption_request/2026-04-16/1776366954",
        "key": "raw/incentive_redemption_request/2026-04-16/1776366954/redemption_request.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.incentive_incentive_redemption_request",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 11385917564667574450,
        "service_name": "incentive",
        "span_id": 15862319674681646813,
        "trace_id": 11385917564667574450
    }
}

running: False
schema_name_id: 1070
start_time: 2026-04-16 14:16:10
success: True
trace_id: 11385917564667574450

Scan 162122542

duration: 0:00:11.585688

exit_message:

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

id: 162122542

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-incentive-prod",
        "hive_path": "s3://sfdl-rds-incentive-prod/raw/incentive_redemption_request/2026-04-16/1776348916",
        "key": "raw/incentive_redemption_request/2026-04-16/1776348916/redemption_request.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.incentive_incentive_redemption_request",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 8350780984593389116,
        "service_name": "incentive",
        "span_id": 11984380325633777723,
        "trace_id": 8350780984593389116
    }
}

running: False
schema_name_id: 1070
start_time: 2026-04-16 09:15:21
success: True
trace_id: 8350780984593389116

Scan 162107739

duration: 0:00:14.086984

exit_message:

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

id: 162107739

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-incentive-prod",
        "hive_path": "s3://sfdl-rds-incentive-prod/raw/incentive_redemption_request/2026-04-16/1776315950",
        "key": "raw/incentive_redemption_request/2026-04-16/1776315950/redemption_request.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.incentive_incentive_redemption_request",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 11485219241302988587,
        "service_name": "incentive",
        "span_id": 6847149357025811473,
        "trace_id": 11485219241302988587
    }
}

running: False
schema_name_id: 1070
start_time: 2026-04-16 00:06:01
success: True
trace_id: 11485219241302988587

Scan 162100286

duration: 0:00:11.770049

exit_message:

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

id: 162100286

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-incentive-prod",
        "hive_path": "s3://sfdl-rds-incentive-prod/raw/incentive_redemption_request/2026-04-15/1776302277",
        "key": "raw/incentive_redemption_request/2026-04-15/1776302277/redemption_request.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.incentive_incentive_redemption_request",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 1109768275440834471,
        "service_name": "incentive",
        "span_id": 10640496295454214851,
        "trace_id": 1109768275440834471
    }
}

running: False
schema_name_id: 1070
start_time: 2026-04-15 20:18:11
success: True
trace_id: 1109768275440834471

Scan 162081684

duration: 0:00:14.331975

exit_message:

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

id: 162081684

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-incentive-prod",
        "hive_path": "s3://sfdl-rds-incentive-prod/raw/incentive_redemption_request/2026-04-15/1776280352",
        "key": "raw/incentive_redemption_request/2026-04-15/1776280352/redemption_request.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.incentive_incentive_redemption_request",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 887423214175015442,
        "service_name": "incentive",
        "span_id": 514231492999225829,
        "trace_id": 887423214175015442
    }
}

running: False
schema_name_id: 1070
start_time: 2026-04-15 14:12:46
success: True
trace_id: 887423214175015442

Scan 162064512

duration: 0:00:14.247974

exit_message:

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

id: 162064512

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-incentive-prod",
        "hive_path": "s3://sfdl-rds-incentive-prod/raw/incentive_redemption_request/2026-04-15/1776260575",
        "key": "raw/incentive_redemption_request/2026-04-15/1776260575/redemption_request.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.incentive_incentive_redemption_request",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 6566509808326936261,
        "service_name": "incentive",
        "span_id": 4341026850388506,
        "trace_id": 6566509808326936261
    }
}

running: False
schema_name_id: 1070
start_time: 2026-04-15 08:43:08
success: True
trace_id: 6566509808326936261

Scan 162052001

duration: 0:00:14.393466

exit_message:

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

id: 162052001

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-incentive-prod",
        "hive_path": "s3://sfdl-rds-incentive-prod/raw/incentive_redemption_request/2026-04-15/1776230290",
        "key": "raw/incentive_redemption_request/2026-04-15/1776230290/redemption_request.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.incentive_incentive_redemption_request",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 5588178424487376660,
        "service_name": "incentive",
        "span_id": 7770782085426347566,
        "trace_id": 5588178424487376660
    }
}

running: False
schema_name_id: 1070
start_time: 2026-04-15 00:18:21
success: True
trace_id: 5588178424487376660

Scan 162044254

duration: 0:00:14.347844

exit_message:

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

id: 162044254

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-incentive-prod",
        "hive_path": "s3://sfdl-rds-incentive-prod/raw/incentive_redemption_request/2026-04-14/1776215727",
        "key": "raw/incentive_redemption_request/2026-04-14/1776215727/redemption_request.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.incentive_incentive_redemption_request",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 1717779836510837423,
        "service_name": "incentive",
        "span_id": 18221073984548614624,
        "trace_id": 1717779836510837423
    }
}

running: False
schema_name_id: 1070
start_time: 2026-04-14 20:15:53
success: True
trace_id: 1717779836510837423

Scan 162026123

duration: 0:00:14.326313

exit_message:

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

id: 162026123

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-incentive-prod",
        "hive_path": "s3://sfdl-rds-incentive-prod/raw/incentive_redemption_request/2026-04-14/1776194147",
        "key": "raw/incentive_redemption_request/2026-04-14/1776194147/redemption_request.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.incentive_incentive_redemption_request",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 1677583778649040258,
        "service_name": "incentive",
        "span_id": 17367165259715391152,
        "trace_id": 1677583778649040258
    }
}

running: False
schema_name_id: 1070
start_time: 2026-04-14 14:16:18
success: True
trace_id: 1677583778649040258

Scan 162009394

duration: 0:00:14.313172

exit_message:

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

id: 162009394

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-incentive-prod",
        "hive_path": "s3://sfdl-rds-incentive-prod/raw/incentive_redemption_request/2026-04-14/1776174886",
        "key": "raw/incentive_redemption_request/2026-04-14/1776174886/redemption_request.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.incentive_incentive_redemption_request",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 4505874922350275259,
        "service_name": "incentive",
        "span_id": 11495420060574188177,
        "trace_id": 4505874922350275259
    }
}

running: False
schema_name_id: 1070
start_time: 2026-04-14 08:54:54
success: True
trace_id: 4505874922350275259

Scan 161996313

duration: 0:00:11.645034

exit_message:

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

id: 161996313

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-incentive-prod",
        "hive_path": "s3://sfdl-rds-incentive-prod/raw/incentive_redemption_request/2026-04-14/1776143224",
        "key": "raw/incentive_redemption_request/2026-04-14/1776143224/redemption_request.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.incentive_incentive_redemption_request",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 8830631401627412872,
        "service_name": "incentive",
        "span_id": 2750184282416260540,
        "trace_id": 8830631401627412872
    }
}

running: False
schema_name_id: 1070
start_time: 2026-04-14 00:07:07
success: True
trace_id: 8830631401627412872

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 14:10:08

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/incentive_redemption_request/2026-04-17/1776452997'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_rds.incentive_incentive_redemption_request`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_rds.incentive_incentive_redemption_request"
}

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:13:13",
        "disabled": false,
        "format": "raw",
        "id": 1070,
        "is_partitioned": false,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_prod_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 14:10:08",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/incentive_redemption_request/2026-04-17/1776452997'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_rds.incentive_incentive_redemption_request`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_rds.incentive_incentive_redemption_request"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}