Schema Info

Schema Name: sfdl_prod_rds.incentive_incentive_redemption_request_document

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

name:

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

type: rds

Schema Versions: 15

Version 1718363

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.incentive_incentive_redemption_request_document`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.incentive_incentive_redemption_request_document`\n(\n `created_dtm`  timestamp , `object_key`  string , `redemption_request_document_id`  int , `redemption_request_id`  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_document/2026-04-17/1776452993'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.incentive_incentive_redemption_request_document"
]

hive_path: s3://sfdl-rds-incentive-prod/raw/incentive_redemption_request_document/2026-04-17/1776452993
id: 1718363
processed: 1

raw_data:

{
    "created_dtm": "timestamp[ns]",
    "object_key": "string",
    "redemption_request_document_id": "int32",
    "redemption_request_id": "string"
}

schema_attributes:

{
    "created_dtm": "timestamp",
    "object_key": "string",
    "redemption_request_document_id": "int",
    "redemption_request_id": "string"
}

schema_name_id: 1073
schema_scan_id: 162193955
updated: 2026-04-17 14:10:14

Version 1718196

created: 2026-04-17 09:18:29

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.incentive_incentive_redemption_request_document`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.incentive_incentive_redemption_request_document`\n(\n `created_dtm`  timestamp , `object_key`  string , `redemption_request_document_id`  int , `redemption_request_id`  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_document/2026-04-17/1776435506'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.incentive_incentive_redemption_request_document"
]

hive_path: s3://sfdl-rds-incentive-prod/raw/incentive_redemption_request_document/2026-04-17/1776435506
id: 1718196
processed: 1

raw_data:

{
    "created_dtm": "timestamp[ns]",
    "object_key": "string",
    "redemption_request_document_id": "int32",
    "redemption_request_id": "string"
}

schema_attributes:

{
    "created_dtm": "timestamp",
    "object_key": "string",
    "redemption_request_document_id": "int",
    "redemption_request_id": "string"
}

schema_name_id: 1073
schema_scan_id: 162178283
updated: 2026-04-17 09:18:40

Version 1717427

created: 2026-04-17 00:06:14

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.incentive_incentive_redemption_request_document`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.incentive_incentive_redemption_request_document`\n(\n `created_dtm`  timestamp , `object_key`  string , `redemption_request_document_id`  int , `redemption_request_id`  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_document/2026-04-17/1776402357'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.incentive_incentive_redemption_request_document"
]

hive_path: s3://sfdl-rds-incentive-prod/raw/incentive_redemption_request_document/2026-04-17/1776402357
id: 1717427
processed: 1

raw_data:

{
    "created_dtm": "timestamp[ns]",
    "object_key": "string",
    "redemption_request_document_id": "int32",
    "redemption_request_id": "string"
}

schema_attributes:

{
    "created_dtm": "timestamp",
    "object_key": "string",
    "redemption_request_document_id": "int",
    "redemption_request_id": "string"
}

schema_name_id: 1073
schema_scan_id: 162163558
updated: 2026-04-17 00:06:25

Version 1717301

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.incentive_incentive_redemption_request_document`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.incentive_incentive_redemption_request_document`\n(\n `created_dtm`  timestamp , `object_key`  string , `redemption_request_document_id`  int , `redemption_request_id`  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_document/2026-04-16/1776388284'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.incentive_incentive_redemption_request_document"
]

hive_path: s3://sfdl-rds-incentive-prod/raw/incentive_redemption_request_document/2026-04-16/1776388284
id: 1717301
processed: 1

raw_data:

{
    "created_dtm": "timestamp[ns]",
    "object_key": "string",
    "redemption_request_document_id": "int32",
    "redemption_request_id": "string"
}

schema_attributes:

{
    "created_dtm": "timestamp",
    "object_key": "string",
    "redemption_request_document_id": "int",
    "redemption_request_id": "string"
}

schema_name_id: 1073
schema_scan_id: 162156016
updated: 2026-04-16 20:14:38

Version 1717134

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.incentive_incentive_redemption_request_document`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.incentive_incentive_redemption_request_document`\n(\n `created_dtm`  timestamp , `object_key`  string , `redemption_request_document_id`  int , `redemption_request_id`  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_document/2026-04-16/1776366634'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.incentive_incentive_redemption_request_document"
]

hive_path: s3://sfdl-rds-incentive-prod/raw/incentive_redemption_request_document/2026-04-16/1776366634
id: 1717134
processed: 1

raw_data:

{
    "created_dtm": "timestamp[ns]",
    "object_key": "string",
    "redemption_request_document_id": "int32",
    "redemption_request_id": "string"
}

schema_attributes:

{
    "created_dtm": "timestamp",
    "object_key": "string",
    "redemption_request_document_id": "int",
    "redemption_request_id": "string"
}

schema_name_id: 1073
schema_scan_id: 162138004
updated: 2026-04-16 14:14:06

Version 1716969

created: 2026-04-16 09:08:47

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.incentive_incentive_redemption_request_document`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.incentive_incentive_redemption_request_document`\n(\n `created_dtm`  timestamp , `object_key`  string , `redemption_request_document_id`  int , `redemption_request_id`  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_document/2026-04-16/1776348519'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.incentive_incentive_redemption_request_document"
]

hive_path: s3://sfdl-rds-incentive-prod/raw/incentive_redemption_request_document/2026-04-16/1776348519
id: 1716969
processed: 1

raw_data:

{
    "created_dtm": "timestamp[ns]",
    "object_key": "string",
    "redemption_request_document_id": "int32",
    "redemption_request_id": "string"
}

schema_attributes:

{
    "created_dtm": "timestamp",
    "object_key": "string",
    "redemption_request_document_id": "int",
    "redemption_request_id": "string"
}

schema_name_id: 1073
schema_scan_id: 162122489
updated: 2026-04-16 09:08:58

Version 1716188

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.incentive_incentive_redemption_request_document`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.incentive_incentive_redemption_request_document`\n(\n `created_dtm`  timestamp , `object_key`  string , `redemption_request_document_id`  int , `redemption_request_id`  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_document/2026-04-16/1776315956'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.incentive_incentive_redemption_request_document"
]

hive_path: s3://sfdl-rds-incentive-prod/raw/incentive_redemption_request_document/2026-04-16/1776315956
id: 1716188
processed: 1

raw_data:

{
    "created_dtm": "timestamp[ns]",
    "object_key": "string",
    "redemption_request_document_id": "int32",
    "redemption_request_id": "string"
}

schema_attributes:

{
    "created_dtm": "timestamp",
    "object_key": "string",
    "redemption_request_document_id": "int",
    "redemption_request_id": "string"
}

schema_name_id: 1073
schema_scan_id: 162107738
updated: 2026-04-16 00:06:11

Version 1716086

created: 2026-04-15 20:19:08

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.incentive_incentive_redemption_request_document`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.incentive_incentive_redemption_request_document`\n(\n `created_dtm`  timestamp , `object_key`  string , `redemption_request_document_id`  int , `redemption_request_id`  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_document/2026-04-15/1776302342'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.incentive_incentive_redemption_request_document"
]

hive_path: s3://sfdl-rds-incentive-prod/raw/incentive_redemption_request_document/2026-04-15/1776302342
id: 1716086
processed: 1

raw_data:

{
    "created_dtm": "timestamp[ns]",
    "object_key": "string",
    "redemption_request_document_id": "int32",
    "redemption_request_id": "string"
}

schema_attributes:

{
    "created_dtm": "timestamp",
    "object_key": "string",
    "redemption_request_document_id": "int",
    "redemption_request_id": "string"
}

schema_name_id: 1073
schema_scan_id: 162100292
updated: 2026-04-15 20:19:20

Version 1715941

created: 2026-04-15 14:11:11

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.incentive_incentive_redemption_request_document`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.incentive_incentive_redemption_request_document`\n(\n `created_dtm`  timestamp , `object_key`  string , `redemption_request_document_id`  int , `redemption_request_id`  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_document/2026-04-15/1776280261'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.incentive_incentive_redemption_request_document"
]

hive_path: s3://sfdl-rds-incentive-prod/raw/incentive_redemption_request_document/2026-04-15/1776280261
id: 1715941
processed: 1

raw_data:

{
    "created_dtm": "timestamp[ns]",
    "object_key": "string",
    "redemption_request_document_id": "int32",
    "redemption_request_id": "string"
}

schema_attributes:

{
    "created_dtm": "timestamp",
    "object_key": "string",
    "redemption_request_document_id": "int",
    "redemption_request_id": "string"
}

schema_name_id: 1073
schema_scan_id: 162081664
updated: 2026-04-15 14:11:22

Version 1715765

created: 2026-04-15 08:41:20

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.incentive_incentive_redemption_request_document`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.incentive_incentive_redemption_request_document`\n(\n `created_dtm`  timestamp , `object_key`  string , `redemption_request_document_id`  int , `redemption_request_id`  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_document/2026-04-15/1776260421'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.incentive_incentive_redemption_request_document"
]

hive_path: s3://sfdl-rds-incentive-prod/raw/incentive_redemption_request_document/2026-04-15/1776260421
id: 1715765
processed: 1

raw_data:

{
    "created_dtm": "timestamp[ns]",
    "object_key": "string",
    "redemption_request_document_id": "int32",
    "redemption_request_id": "string"
}

schema_attributes:

{
    "created_dtm": "timestamp",
    "object_key": "string",
    "redemption_request_document_id": "int",
    "redemption_request_id": "string"
}

schema_name_id: 1073
schema_scan_id: 162064466
updated: 2026-04-15 08:41:32

Version 1715014

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.incentive_incentive_redemption_request_document`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.incentive_incentive_redemption_request_document`\n(\n `created_dtm`  timestamp , `object_key`  string , `redemption_request_document_id`  int , `redemption_request_id`  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_document/2026-04-15/1776230059'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.incentive_incentive_redemption_request_document"
]

hive_path: s3://sfdl-rds-incentive-prod/raw/incentive_redemption_request_document/2026-04-15/1776230059
id: 1715014
processed: 1

raw_data:

{
    "created_dtm": "timestamp[ns]",
    "object_key": "string",
    "redemption_request_document_id": "int32",
    "redemption_request_id": "string"
}

schema_attributes:

{
    "created_dtm": "timestamp",
    "object_key": "string",
    "redemption_request_document_id": "int",
    "redemption_request_id": "string"
}

schema_name_id: 1073
schema_scan_id: 162051968
updated: 2026-04-15 00:14:41

Version 1714898

created: 2026-04-14 20:19:43

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.incentive_incentive_redemption_request_document`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.incentive_incentive_redemption_request_document`\n(\n `created_dtm`  timestamp , `object_key`  string , `redemption_request_document_id`  int , `redemption_request_id`  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_document/2026-04-14/1776215976'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.incentive_incentive_redemption_request_document"
]

hive_path: s3://sfdl-rds-incentive-prod/raw/incentive_redemption_request_document/2026-04-14/1776215976
id: 1714898
processed: 1

raw_data:

{
    "created_dtm": "timestamp[ns]",
    "object_key": "string",
    "redemption_request_document_id": "int32",
    "redemption_request_id": "string"
}

schema_attributes:

{
    "created_dtm": "timestamp",
    "object_key": "string",
    "redemption_request_document_id": "int",
    "redemption_request_id": "string"
}

schema_name_id: 1073
schema_scan_id: 162044298
updated: 2026-04-14 20:19:55

Version 1714736

created: 2026-04-14 14:15:51

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.incentive_incentive_redemption_request_document`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.incentive_incentive_redemption_request_document`\n(\n `created_dtm`  timestamp , `object_key`  string , `redemption_request_document_id`  int , `redemption_request_id`  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_document/2026-04-14/1776194143'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.incentive_incentive_redemption_request_document"
]

hive_path: s3://sfdl-rds-incentive-prod/raw/incentive_redemption_request_document/2026-04-14/1776194143
id: 1714736
processed: 1

raw_data:

{
    "created_dtm": "timestamp[ns]",
    "object_key": "string",
    "redemption_request_document_id": "int32",
    "redemption_request_id": "string"
}

schema_attributes:

{
    "created_dtm": "timestamp",
    "object_key": "string",
    "redemption_request_document_id": "int",
    "redemption_request_id": "string"
}

schema_name_id: 1073
schema_scan_id: 162026117
updated: 2026-04-14 14:16:02

Version 1714549

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.incentive_incentive_redemption_request_document`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.incentive_incentive_redemption_request_document`\n(\n `created_dtm`  timestamp , `object_key`  string , `redemption_request_document_id`  int , `redemption_request_id`  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_document/2026-04-14/1776174913'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.incentive_incentive_redemption_request_document"
]

hive_path: s3://sfdl-rds-incentive-prod/raw/incentive_redemption_request_document/2026-04-14/1776174913
id: 1714549
processed: 1

raw_data:

{
    "created_dtm": "timestamp[ns]",
    "object_key": "string",
    "redemption_request_document_id": "int32",
    "redemption_request_id": "string"
}

schema_attributes:

{
    "created_dtm": "timestamp",
    "object_key": "string",
    "redemption_request_document_id": "int",
    "redemption_request_id": "string"
}

schema_name_id: 1073
schema_scan_id: 162009426
updated: 2026-04-14 08:55:33

Version 1713788

created: 2026-04-14 00:06:36

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.incentive_incentive_redemption_request_document`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.incentive_incentive_redemption_request_document`\n(\n `created_dtm`  timestamp , `object_key`  string , `redemption_request_document_id`  int , `redemption_request_id`  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_document/2026-04-14/1776143177'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.incentive_incentive_redemption_request_document"
]

hive_path: s3://sfdl-rds-incentive-prod/raw/incentive_redemption_request_document/2026-04-14/1776143177
id: 1713788
processed: 1

raw_data:

{
    "created_dtm": "timestamp[ns]",
    "object_key": "string",
    "redemption_request_document_id": "int32",
    "redemption_request_id": "string"
}

schema_attributes:

{
    "created_dtm": "timestamp",
    "object_key": "string",
    "redemption_request_document_id": "int",
    "redemption_request_id": "string"
}

schema_name_id: 1073
schema_scan_id: 161996300
updated: 2026-04-14 00:06:47

Schema Scans: 15

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

Scan 162193955

duration: 0:00:11.691220

exit_message:

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

id: 162193955

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_document/2026-04-17/1776452993",
        "key": "raw/incentive_redemption_request_document/2026-04-17/1776452993/redemption_request_document.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.incentive_incentive_redemption_request_document",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 16170062697802812946,
        "service_name": "incentive",
        "span_id": 9293887145265190238,
        "trace_id": 16170062697802812946
    }
}

running: False
schema_name_id: 1073
start_time: 2026-04-17 14:10:02
success: True
trace_id: 16170062697802812946

Scan 162178283

duration: 0:00:11.612949

exit_message:

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

id: 162178283

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_document/2026-04-17/1776435506",
        "key": "raw/incentive_redemption_request_document/2026-04-17/1776435506/redemption_request_document.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.incentive_incentive_redemption_request_document",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 14804739625197822940,
        "service_name": "incentive",
        "span_id": 17313287032028199156,
        "trace_id": 14804739625197822940
    }
}

running: False
schema_name_id: 1073
start_time: 2026-04-17 09:18:29
success: True
trace_id: 14804739625197822940

Scan 162163558

duration: 0:00:11.704204

exit_message:

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

id: 162163558

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_document/2026-04-17/1776402357",
        "key": "raw/incentive_redemption_request_document/2026-04-17/1776402357/redemption_request_document.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.incentive_incentive_redemption_request_document",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 1856787885215411692,
        "service_name": "incentive",
        "span_id": 13072090359530333455,
        "trace_id": 1856787885215411692
    }
}

running: False
schema_name_id: 1073
start_time: 2026-04-17 00:06:13
success: True
trace_id: 1856787885215411692

Scan 162156016

duration: 0:00:14.234841

exit_message:

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

id: 162156016

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_document/2026-04-16/1776388284",
        "key": "raw/incentive_redemption_request_document/2026-04-16/1776388284/redemption_request_document.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.incentive_incentive_redemption_request_document",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 16294143976604289523,
        "service_name": "incentive",
        "span_id": 7394511621481109915,
        "trace_id": 16294143976604289523
    }
}

running: False
schema_name_id: 1073
start_time: 2026-04-16 20:14:24
success: True
trace_id: 16294143976604289523

Scan 162138004

duration: 0:00:14.177915

exit_message:

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

id: 162138004

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_document/2026-04-16/1776366634",
        "key": "raw/incentive_redemption_request_document/2026-04-16/1776366634/redemption_request_document.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.incentive_incentive_redemption_request_document",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 1812240245243192079,
        "service_name": "incentive",
        "span_id": 14614335934844163086,
        "trace_id": 1812240245243192079
    }
}

running: False
schema_name_id: 1073
start_time: 2026-04-16 14:13:52
success: True
trace_id: 1812240245243192079

Scan 162122489

duration: 0:00:11.677699

exit_message:

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

id: 162122489

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_document/2026-04-16/1776348519",
        "key": "raw/incentive_redemption_request_document/2026-04-16/1776348519/redemption_request_document.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.incentive_incentive_redemption_request_document",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 7217956067749937614,
        "service_name": "incentive",
        "span_id": 17895895798273786275,
        "trace_id": 7217956067749937614
    }
}

running: False
schema_name_id: 1073
start_time: 2026-04-16 09:08:46
success: True
trace_id: 7217956067749937614

Scan 162107738

duration: 0:00:11.635704

exit_message:

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

id: 162107738

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_document/2026-04-16/1776315956",
        "key": "raw/incentive_redemption_request_document/2026-04-16/1776315956/redemption_request_document.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.incentive_incentive_redemption_request_document",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 14476076758798501611,
        "service_name": "incentive",
        "span_id": 6720699089134964106,
        "trace_id": 14476076758798501611
    }
}

running: False
schema_name_id: 1073
start_time: 2026-04-16 00:05:59
success: True
trace_id: 14476076758798501611

Scan 162100292

duration: 0:00:11.584750

exit_message:

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

id: 162100292

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_document/2026-04-15/1776302342",
        "key": "raw/incentive_redemption_request_document/2026-04-15/1776302342/redemption_request_document.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.incentive_incentive_redemption_request_document",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 2013645588898634366,
        "service_name": "incentive",
        "span_id": 9768184909061381212,
        "trace_id": 2013645588898634366
    }
}

running: False
schema_name_id: 1073
start_time: 2026-04-15 20:19:08
success: True
trace_id: 2013645588898634366

Scan 162081664

duration: 0:00:11.609022

exit_message:

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

id: 162081664

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_document/2026-04-15/1776280261",
        "key": "raw/incentive_redemption_request_document/2026-04-15/1776280261/redemption_request_document.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.incentive_incentive_redemption_request_document",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 3063738219392328347,
        "service_name": "incentive",
        "span_id": 1679549460413703284,
        "trace_id": 3063738219392328347
    }
}

running: False
schema_name_id: 1073
start_time: 2026-04-15 14:11:10
success: True
trace_id: 3063738219392328347

Scan 162064466

duration: 0:00:11.629527

exit_message:

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

id: 162064466

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_document/2026-04-15/1776260421",
        "key": "raw/incentive_redemption_request_document/2026-04-15/1776260421/redemption_request_document.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.incentive_incentive_redemption_request_document",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 11669133182650592554,
        "service_name": "incentive",
        "span_id": 16857296852008381119,
        "trace_id": 11669133182650592554
    }
}

running: False
schema_name_id: 1073
start_time: 2026-04-15 08:41:20
success: True
trace_id: 11669133182650592554

Scan 162051968

duration: 0:00:14.167524

exit_message:

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

id: 162051968

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_document/2026-04-15/1776230059",
        "key": "raw/incentive_redemption_request_document/2026-04-15/1776230059/redemption_request_document.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.incentive_incentive_redemption_request_document",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 13867835787023380971,
        "service_name": "incentive",
        "span_id": 7220360376038590019,
        "trace_id": 13867835787023380971
    }
}

running: False
schema_name_id: 1073
start_time: 2026-04-15 00:14:27
success: True
trace_id: 13867835787023380971

Scan 162044298

duration: 0:00:11.736797

exit_message:

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

id: 162044298

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_document/2026-04-14/1776215976",
        "key": "raw/incentive_redemption_request_document/2026-04-14/1776215976/redemption_request_document.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.incentive_incentive_redemption_request_document",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 4383706476799026450,
        "service_name": "incentive",
        "span_id": 2720815245709058322,
        "trace_id": 4383706476799026450
    }
}

running: False
schema_name_id: 1073
start_time: 2026-04-14 20:19:43
success: True
trace_id: 4383706476799026450

Scan 162026117

duration: 0:00:11.503569

exit_message:

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

id: 162026117

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_document/2026-04-14/1776194143",
        "key": "raw/incentive_redemption_request_document/2026-04-14/1776194143/redemption_request_document.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.incentive_incentive_redemption_request_document",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 17963568926386209239,
        "service_name": "incentive",
        "span_id": 11600865500667393400,
        "trace_id": 17963568926386209239
    }
}

running: False
schema_name_id: 1073
start_time: 2026-04-14 14:15:51
success: True
trace_id: 17963568926386209239

Scan 162009426

duration: 0:00:11.519259

exit_message:

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

id: 162009426

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_document/2026-04-14/1776174913",
        "key": "raw/incentive_redemption_request_document/2026-04-14/1776174913/redemption_request_document.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.incentive_incentive_redemption_request_document",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 4260081828771816249,
        "service_name": "incentive",
        "span_id": 8076602622165814806,
        "trace_id": 4260081828771816249
    }
}

running: False
schema_name_id: 1073
start_time: 2026-04-14 08:55:21
success: True
trace_id: 4260081828771816249

Scan 161996300

duration: 0:00:11.590824

exit_message:

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

id: 161996300

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_document/2026-04-14/1776143177",
        "key": "raw/incentive_redemption_request_document/2026-04-14/1776143177/redemption_request_document.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.incentive_incentive_redemption_request_document",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 10521189515910588560,
        "service_name": "incentive",
        "span_id": 2018071339647398818,
        "trace_id": 10521189515910588560
    }
}

running: False
schema_name_id: 1073
start_time: 2026-04-14 00:06:35
success: True
trace_id: 10521189515910588560

Partitions:

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

Schema:

attributes:

{
    "created_dtm": "timestamp",
    "object_key": "string",
    "redemption_request_document_id": "int",
    "redemption_request_id": "string"
}

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

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_document`\n(\n `created_dtm`  timestamp , `object_key`  string , `redemption_request_document_id`  int , `redemption_request_id`  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_document/2026-04-17/1776452993'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_rds.incentive_incentive_redemption_request_document`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_rds.incentive_incentive_redemption_request_document"
}

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:46",
        "disabled": false,
        "format": "raw",
        "id": 1073,
        "is_partitioned": false,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_prod_rds",
            "table": "incentive_incentive_redemption_request_document"
        },
        "type": "rds"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "created_dtm": "timestamp",
            "object_key": "string",
            "redemption_request_document_id": "int",
            "redemption_request_id": "string"
        },
        "created": "2026-04-17 14:10:02",
        "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_document`\n(\n `created_dtm`  timestamp , `object_key`  string , `redemption_request_document_id`  int , `redemption_request_id`  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_document/2026-04-17/1776452993'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_rds.incentive_incentive_redemption_request_document`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_rds.incentive_incentive_redemption_request_document"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}