Schema Info

Schema Name: sfdl_stage_csv.payrixess_fee_rules

created: 2024-07-22 13:08:39
disabled: False
format: raw
id: 2164
is_partitioned: False
is_schema_datatyped: True

name:

{
    "database": "sfdl_stage_csv",
    "table": "payrixess_fee_rules"
}

type: csv

Schema Versions: 15

Version 906694

created: 2026-04-17 09:34:16

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "DROP TABLE IF EXISTS `sfdl_stage_csv.payrixess_fee_rules`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.payrixess_fee_rules`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `creator`  string , `created`  string , `modifier`  string , `description`  string , `frozen`  string , `type`  string , `grouping`  string , `inactive`  string , `application`  string , `name`  string , `modified`  string , `fee_rule_id`  string , `value`  string , `fee_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrixess-stage/raw/fee_rules/2026-04-17/1776436436'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_csv.payrixess_fee_rules"
]

hive_path: s3://sfdl-csv-payrixess-stage/raw/fee_rules/2026-04-17/1776436436
id: 906694
processed: 1

raw_data:

{
    "_hoodie_commit_seqno": 1,
    "_hoodie_commit_time": 0,
    "_hoodie_file_name": 4,
    "_hoodie_partition_path": 3,
    "_hoodie_record_key": 2,
    "application": 13,
    "created": 6,
    "creator": 5,
    "description": 8,
    "fee_id": 18,
    "fee_rule_id": 16,
    "frozen": 9,
    "grouping": 11,
    "inactive": 12,
    "modified": 15,
    "modifier": 7,
    "name": 14,
    "type": 10,
    "value": 17
}

schema_attributes:

{
    "_hoodie_commit_seqno": "string",
    "_hoodie_commit_time": "string",
    "_hoodie_file_name": "string",
    "_hoodie_partition_path": "string",
    "_hoodie_record_key": "string",
    "application": "string",
    "created": "string",
    "creator": "string",
    "description": "string",
    "fee_id": "string",
    "fee_rule_id": "string",
    "frozen": "string",
    "grouping": "string",
    "inactive": "string",
    "modified": "string",
    "modifier": "string",
    "name": "string",
    "type": "string",
    "value": "string"
}

schema_name_id: 2164
schema_scan_id: 6415442
updated: 2026-04-17 09:34:28

Version 906498

created: 2026-04-16 09:48:04

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "DROP TABLE IF EXISTS `sfdl_stage_csv.payrixess_fee_rules`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.payrixess_fee_rules`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `creator`  string , `created`  string , `modifier`  string , `description`  string , `frozen`  string , `type`  string , `grouping`  string , `inactive`  string , `application`  string , `name`  string , `modified`  string , `fee_rule_id`  string , `value`  string , `fee_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrixess-stage/raw/fee_rules/2026-04-16/1776350878'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_csv.payrixess_fee_rules"
]

hive_path: s3://sfdl-csv-payrixess-stage/raw/fee_rules/2026-04-16/1776350878
id: 906498
processed: 1

raw_data:

{
    "_hoodie_commit_seqno": 1,
    "_hoodie_commit_time": 0,
    "_hoodie_file_name": 4,
    "_hoodie_partition_path": 3,
    "_hoodie_record_key": 2,
    "application": 13,
    "created": 6,
    "creator": 5,
    "description": 8,
    "fee_id": 18,
    "fee_rule_id": 16,
    "frozen": 9,
    "grouping": 11,
    "inactive": 12,
    "modified": 15,
    "modifier": 7,
    "name": 14,
    "type": 10,
    "value": 17
}

schema_attributes:

{
    "_hoodie_commit_seqno": "string",
    "_hoodie_commit_time": "string",
    "_hoodie_file_name": "string",
    "_hoodie_partition_path": "string",
    "_hoodie_record_key": "string",
    "application": "string",
    "created": "string",
    "creator": "string",
    "description": "string",
    "fee_id": "string",
    "fee_rule_id": "string",
    "frozen": "string",
    "grouping": "string",
    "inactive": "string",
    "modified": "string",
    "modifier": "string",
    "name": "string",
    "type": "string",
    "value": "string"
}

schema_name_id: 2164
schema_scan_id: 6414943
updated: 2026-04-16 09:48:15

Version 906282

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "DROP TABLE IF EXISTS `sfdl_stage_csv.payrixess_fee_rules`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.payrixess_fee_rules`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `creator`  string , `created`  string , `modifier`  string , `description`  string , `frozen`  string , `type`  string , `grouping`  string , `inactive`  string , `application`  string , `name`  string , `modified`  string , `fee_rule_id`  string , `value`  string , `fee_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrixess-stage/raw/fee_rules/2026-04-15/1776264416'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_csv.payrixess_fee_rules"
]

hive_path: s3://sfdl-csv-payrixess-stage/raw/fee_rules/2026-04-15/1776264416
id: 906282
processed: 1

raw_data:

{
    "_hoodie_commit_seqno": 1,
    "_hoodie_commit_time": 0,
    "_hoodie_file_name": 4,
    "_hoodie_partition_path": 3,
    "_hoodie_record_key": 2,
    "application": 13,
    "created": 6,
    "creator": 5,
    "description": 8,
    "fee_id": 18,
    "fee_rule_id": 16,
    "frozen": 9,
    "grouping": 11,
    "inactive": 12,
    "modified": 15,
    "modifier": 7,
    "name": 14,
    "type": 10,
    "value": 17
}

schema_attributes:

{
    "_hoodie_commit_seqno": "string",
    "_hoodie_commit_time": "string",
    "_hoodie_file_name": "string",
    "_hoodie_partition_path": "string",
    "_hoodie_record_key": "string",
    "application": "string",
    "created": "string",
    "creator": "string",
    "description": "string",
    "fee_id": "string",
    "fee_rule_id": "string",
    "frozen": "string",
    "grouping": "string",
    "inactive": "string",
    "modified": "string",
    "modifier": "string",
    "name": "string",
    "type": "string",
    "value": "string"
}

schema_name_id: 2164
schema_scan_id: 6414429
updated: 2026-04-15 09:47:22

Version 906070

created: 2026-04-14 09:45:31

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "DROP TABLE IF EXISTS `sfdl_stage_csv.payrixess_fee_rules`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.payrixess_fee_rules`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `creator`  string , `created`  string , `modifier`  string , `description`  string , `frozen`  string , `type`  string , `grouping`  string , `inactive`  string , `application`  string , `name`  string , `modified`  string , `fee_rule_id`  string , `value`  string , `fee_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrixess-stage/raw/fee_rules/2026-04-14/1776177914'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_csv.payrixess_fee_rules"
]

hive_path: s3://sfdl-csv-payrixess-stage/raw/fee_rules/2026-04-14/1776177914
id: 906070
processed: 1

raw_data:

{
    "_hoodie_commit_seqno": 1,
    "_hoodie_commit_time": 0,
    "_hoodie_file_name": 4,
    "_hoodie_partition_path": 3,
    "_hoodie_record_key": 2,
    "application": 13,
    "created": 6,
    "creator": 5,
    "description": 8,
    "fee_id": 18,
    "fee_rule_id": 16,
    "frozen": 9,
    "grouping": 11,
    "inactive": 12,
    "modified": 15,
    "modifier": 7,
    "name": 14,
    "type": 10,
    "value": 17
}

schema_attributes:

{
    "_hoodie_commit_seqno": "string",
    "_hoodie_commit_time": "string",
    "_hoodie_file_name": "string",
    "_hoodie_partition_path": "string",
    "_hoodie_record_key": "string",
    "application": "string",
    "created": "string",
    "creator": "string",
    "description": "string",
    "fee_id": "string",
    "fee_rule_id": "string",
    "frozen": "string",
    "grouping": "string",
    "inactive": "string",
    "modified": "string",
    "modifier": "string",
    "name": "string",
    "type": "string",
    "value": "string"
}

schema_name_id: 2164
schema_scan_id: 6413940
updated: 2026-04-14 09:45:45

Version 905834

created: 2026-04-13 09:31:14

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "DROP TABLE IF EXISTS `sfdl_stage_csv.payrixess_fee_rules`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.payrixess_fee_rules`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `creator`  string , `created`  string , `modifier`  string , `description`  string , `frozen`  string , `type`  string , `grouping`  string , `inactive`  string , `application`  string , `name`  string , `modified`  string , `fee_rule_id`  string , `value`  string , `fee_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrixess-stage/raw/fee_rules/2026-04-13/1776090646'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_csv.payrixess_fee_rules"
]

hive_path: s3://sfdl-csv-payrixess-stage/raw/fee_rules/2026-04-13/1776090646
id: 905834
processed: 1

raw_data:

{
    "_hoodie_commit_seqno": 1,
    "_hoodie_commit_time": 0,
    "_hoodie_file_name": 4,
    "_hoodie_partition_path": 3,
    "_hoodie_record_key": 2,
    "application": 13,
    "created": 6,
    "creator": 5,
    "description": 8,
    "fee_id": 18,
    "fee_rule_id": 16,
    "frozen": 9,
    "grouping": 11,
    "inactive": 12,
    "modified": 15,
    "modifier": 7,
    "name": 14,
    "type": 10,
    "value": 17
}

schema_attributes:

{
    "_hoodie_commit_seqno": "string",
    "_hoodie_commit_time": "string",
    "_hoodie_file_name": "string",
    "_hoodie_partition_path": "string",
    "_hoodie_record_key": "string",
    "application": "string",
    "created": "string",
    "creator": "string",
    "description": "string",
    "fee_id": "string",
    "fee_rule_id": "string",
    "frozen": "string",
    "grouping": "string",
    "inactive": "string",
    "modified": "string",
    "modifier": "string",
    "name": "string",
    "type": "string",
    "value": "string"
}

schema_name_id: 2164
schema_scan_id: 6413268
updated: 2026-04-13 09:31:28

Version 905623

created: 2026-04-12 09:27:11

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "DROP TABLE IF EXISTS `sfdl_stage_csv.payrixess_fee_rules`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.payrixess_fee_rules`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `creator`  string , `created`  string , `modifier`  string , `description`  string , `frozen`  string , `type`  string , `grouping`  string , `inactive`  string , `application`  string , `name`  string , `modified`  string , `fee_rule_id`  string , `value`  string , `fee_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrixess-stage/raw/fee_rules/2026-04-12/1776004026'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_csv.payrixess_fee_rules"
]

hive_path: s3://sfdl-csv-payrixess-stage/raw/fee_rules/2026-04-12/1776004026
id: 905623
processed: 1

raw_data:

{
    "_hoodie_commit_seqno": 1,
    "_hoodie_commit_time": 0,
    "_hoodie_file_name": 4,
    "_hoodie_partition_path": 3,
    "_hoodie_record_key": 2,
    "application": 13,
    "created": 6,
    "creator": 5,
    "description": 8,
    "fee_id": 18,
    "fee_rule_id": 16,
    "frozen": 9,
    "grouping": 11,
    "inactive": 12,
    "modified": 15,
    "modifier": 7,
    "name": 14,
    "type": 10,
    "value": 17
}

schema_attributes:

{
    "_hoodie_commit_seqno": "string",
    "_hoodie_commit_time": "string",
    "_hoodie_file_name": "string",
    "_hoodie_partition_path": "string",
    "_hoodie_record_key": "string",
    "application": "string",
    "created": "string",
    "creator": "string",
    "description": "string",
    "fee_id": "string",
    "fee_rule_id": "string",
    "frozen": "string",
    "grouping": "string",
    "inactive": "string",
    "modified": "string",
    "modifier": "string",
    "name": "string",
    "type": "string",
    "value": "string"
}

schema_name_id: 2164
schema_scan_id: 6412829
updated: 2026-04-12 09:27:25

Version 905442

created: 2026-04-11 09:43:51

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "DROP TABLE IF EXISTS `sfdl_stage_csv.payrixess_fee_rules`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.payrixess_fee_rules`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `creator`  string , `created`  string , `modifier`  string , `description`  string , `frozen`  string , `type`  string , `grouping`  string , `inactive`  string , `application`  string , `name`  string , `modified`  string , `fee_rule_id`  string , `value`  string , `fee_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrixess-stage/raw/fee_rules/2026-04-11/1775918621'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_csv.payrixess_fee_rules"
]

hive_path: s3://sfdl-csv-payrixess-stage/raw/fee_rules/2026-04-11/1775918621
id: 905442
processed: 1

raw_data:

{
    "_hoodie_commit_seqno": 1,
    "_hoodie_commit_time": 0,
    "_hoodie_file_name": 4,
    "_hoodie_partition_path": 3,
    "_hoodie_record_key": 2,
    "application": 13,
    "created": 6,
    "creator": 5,
    "description": 8,
    "fee_id": 18,
    "fee_rule_id": 16,
    "frozen": 9,
    "grouping": 11,
    "inactive": 12,
    "modified": 15,
    "modifier": 7,
    "name": 14,
    "type": 10,
    "value": 17
}

schema_attributes:

{
    "_hoodie_commit_seqno": "string",
    "_hoodie_commit_time": "string",
    "_hoodie_file_name": "string",
    "_hoodie_partition_path": "string",
    "_hoodie_record_key": "string",
    "application": "string",
    "created": "string",
    "creator": "string",
    "description": "string",
    "fee_id": "string",
    "fee_rule_id": "string",
    "frozen": "string",
    "grouping": "string",
    "inactive": "string",
    "modified": "string",
    "modifier": "string",
    "name": "string",
    "type": "string",
    "value": "string"
}

schema_name_id: 2164
schema_scan_id: 6412555
updated: 2026-04-11 09:44:05

Version 905213

created: 2026-04-10 09:27:36

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "DROP TABLE IF EXISTS `sfdl_stage_csv.payrixess_fee_rules`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.payrixess_fee_rules`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `creator`  string , `created`  string , `modifier`  string , `description`  string , `frozen`  string , `type`  string , `grouping`  string , `inactive`  string , `application`  string , `name`  string , `modified`  string , `fee_rule_id`  string , `value`  string , `fee_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrixess-stage/raw/fee_rules/2026-04-10/1775831249'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_csv.payrixess_fee_rules"
]

hive_path: s3://sfdl-csv-payrixess-stage/raw/fee_rules/2026-04-10/1775831249
id: 905213
processed: 1

raw_data:

{
    "_hoodie_commit_seqno": 1,
    "_hoodie_commit_time": 0,
    "_hoodie_file_name": 4,
    "_hoodie_partition_path": 3,
    "_hoodie_record_key": 2,
    "application": 13,
    "created": 6,
    "creator": 5,
    "description": 8,
    "fee_id": 18,
    "fee_rule_id": 16,
    "frozen": 9,
    "grouping": 11,
    "inactive": 12,
    "modified": 15,
    "modifier": 7,
    "name": 14,
    "type": 10,
    "value": 17
}

schema_attributes:

{
    "_hoodie_commit_seqno": "string",
    "_hoodie_commit_time": "string",
    "_hoodie_file_name": "string",
    "_hoodie_partition_path": "string",
    "_hoodie_record_key": "string",
    "application": "string",
    "created": "string",
    "creator": "string",
    "description": "string",
    "fee_id": "string",
    "fee_rule_id": "string",
    "frozen": "string",
    "grouping": "string",
    "inactive": "string",
    "modified": "string",
    "modifier": "string",
    "name": "string",
    "type": "string",
    "value": "string"
}

schema_name_id: 2164
schema_scan_id: 6412013
updated: 2026-04-10 09:27:47

Version 905015

created: 2026-04-09 09:44:34

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "DROP TABLE IF EXISTS `sfdl_stage_csv.payrixess_fee_rules`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.payrixess_fee_rules`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `creator`  string , `created`  string , `modifier`  string , `description`  string , `frozen`  string , `type`  string , `grouping`  string , `inactive`  string , `application`  string , `name`  string , `modified`  string , `fee_rule_id`  string , `value`  string , `fee_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrixess-stage/raw/fee_rules/2026-04-09/1775745863'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_csv.payrixess_fee_rules"
]

hive_path: s3://sfdl-csv-payrixess-stage/raw/fee_rules/2026-04-09/1775745863
id: 905015
processed: 1

raw_data:

{
    "_hoodie_commit_seqno": 1,
    "_hoodie_commit_time": 0,
    "_hoodie_file_name": 4,
    "_hoodie_partition_path": 3,
    "_hoodie_record_key": 2,
    "application": 13,
    "created": 6,
    "creator": 5,
    "description": 8,
    "fee_id": 18,
    "fee_rule_id": 16,
    "frozen": 9,
    "grouping": 11,
    "inactive": 12,
    "modified": 15,
    "modifier": 7,
    "name": 14,
    "type": 10,
    "value": 17
}

schema_attributes:

{
    "_hoodie_commit_seqno": "string",
    "_hoodie_commit_time": "string",
    "_hoodie_file_name": "string",
    "_hoodie_partition_path": "string",
    "_hoodie_record_key": "string",
    "application": "string",
    "created": "string",
    "creator": "string",
    "description": "string",
    "fee_id": "string",
    "fee_rule_id": "string",
    "frozen": "string",
    "grouping": "string",
    "inactive": "string",
    "modified": "string",
    "modifier": "string",
    "name": "string",
    "type": "string",
    "value": "string"
}

schema_name_id: 2164
schema_scan_id: 6411544
updated: 2026-04-09 09:44:47

Version 904796

created: 2026-04-08 09:40:01

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "DROP TABLE IF EXISTS `sfdl_stage_csv.payrixess_fee_rules`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.payrixess_fee_rules`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `creator`  string , `created`  string , `modifier`  string , `description`  string , `frozen`  string , `type`  string , `grouping`  string , `inactive`  string , `application`  string , `name`  string , `modified`  string , `fee_rule_id`  string , `value`  string , `fee_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrixess-stage/raw/fee_rules/2026-04-08/1775659193'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_csv.payrixess_fee_rules"
]

hive_path: s3://sfdl-csv-payrixess-stage/raw/fee_rules/2026-04-08/1775659193
id: 904796
processed: 1

raw_data:

{
    "_hoodie_commit_seqno": 1,
    "_hoodie_commit_time": 0,
    "_hoodie_file_name": 4,
    "_hoodie_partition_path": 3,
    "_hoodie_record_key": 2,
    "application": 13,
    "created": 6,
    "creator": 5,
    "description": 8,
    "fee_id": 18,
    "fee_rule_id": 16,
    "frozen": 9,
    "grouping": 11,
    "inactive": 12,
    "modified": 15,
    "modifier": 7,
    "name": 14,
    "type": 10,
    "value": 17
}

schema_attributes:

{
    "_hoodie_commit_seqno": "string",
    "_hoodie_commit_time": "string",
    "_hoodie_file_name": "string",
    "_hoodie_partition_path": "string",
    "_hoodie_record_key": "string",
    "application": "string",
    "created": "string",
    "creator": "string",
    "description": "string",
    "fee_id": "string",
    "fee_rule_id": "string",
    "frozen": "string",
    "grouping": "string",
    "inactive": "string",
    "modified": "string",
    "modifier": "string",
    "name": "string",
    "type": "string",
    "value": "string"
}

schema_name_id: 2164
schema_scan_id: 6411085
updated: 2026-04-08 09:40:14

Version 904567

created: 2026-04-07 09:27:20

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "DROP TABLE IF EXISTS `sfdl_stage_csv.payrixess_fee_rules`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.payrixess_fee_rules`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `creator`  string , `created`  string , `modifier`  string , `description`  string , `frozen`  string , `type`  string , `grouping`  string , `inactive`  string , `application`  string , `name`  string , `modified`  string , `fee_rule_id`  string , `value`  string , `fee_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrixess-stage/raw/fee_rules/2026-04-07/1775572028'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_csv.payrixess_fee_rules"
]

hive_path: s3://sfdl-csv-payrixess-stage/raw/fee_rules/2026-04-07/1775572028
id: 904567
processed: 1

raw_data:

{
    "_hoodie_commit_seqno": 1,
    "_hoodie_commit_time": 0,
    "_hoodie_file_name": 4,
    "_hoodie_partition_path": 3,
    "_hoodie_record_key": 2,
    "application": 13,
    "created": 6,
    "creator": 5,
    "description": 8,
    "fee_id": 18,
    "fee_rule_id": 16,
    "frozen": 9,
    "grouping": 11,
    "inactive": 12,
    "modified": 15,
    "modifier": 7,
    "name": 14,
    "type": 10,
    "value": 17
}

schema_attributes:

{
    "_hoodie_commit_seqno": "string",
    "_hoodie_commit_time": "string",
    "_hoodie_file_name": "string",
    "_hoodie_partition_path": "string",
    "_hoodie_record_key": "string",
    "application": "string",
    "created": "string",
    "creator": "string",
    "description": "string",
    "fee_id": "string",
    "fee_rule_id": "string",
    "frozen": "string",
    "grouping": "string",
    "inactive": "string",
    "modified": "string",
    "modifier": "string",
    "name": "string",
    "type": "string",
    "value": "string"
}

schema_name_id: 2164
schema_scan_id: 6410459
updated: 2026-04-07 09:27:31

Version 904353

created: 2026-04-06 09:28:49

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "DROP TABLE IF EXISTS `sfdl_stage_csv.payrixess_fee_rules`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.payrixess_fee_rules`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `creator`  string , `created`  string , `modifier`  string , `description`  string , `frozen`  string , `type`  string , `grouping`  string , `inactive`  string , `application`  string , `name`  string , `modified`  string , `fee_rule_id`  string , `value`  string , `fee_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrixess-stage/raw/fee_rules/2026-04-06/1775485719'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_csv.payrixess_fee_rules"
]

hive_path: s3://sfdl-csv-payrixess-stage/raw/fee_rules/2026-04-06/1775485719
id: 904353
processed: 1

raw_data:

{
    "_hoodie_commit_seqno": 1,
    "_hoodie_commit_time": 0,
    "_hoodie_file_name": 4,
    "_hoodie_partition_path": 3,
    "_hoodie_record_key": 2,
    "application": 13,
    "created": 6,
    "creator": 5,
    "description": 8,
    "fee_id": 18,
    "fee_rule_id": 16,
    "frozen": 9,
    "grouping": 11,
    "inactive": 12,
    "modified": 15,
    "modifier": 7,
    "name": 14,
    "type": 10,
    "value": 17
}

schema_attributes:

{
    "_hoodie_commit_seqno": "string",
    "_hoodie_commit_time": "string",
    "_hoodie_file_name": "string",
    "_hoodie_partition_path": "string",
    "_hoodie_record_key": "string",
    "application": "string",
    "created": "string",
    "creator": "string",
    "description": "string",
    "fee_id": "string",
    "fee_rule_id": "string",
    "frozen": "string",
    "grouping": "string",
    "inactive": "string",
    "modified": "string",
    "modifier": "string",
    "name": "string",
    "type": "string",
    "value": "string"
}

schema_name_id: 2164
schema_scan_id: 6409940
updated: 2026-04-06 09:29:01

Version 904166

created: 2026-04-05 09:42:43

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "DROP TABLE IF EXISTS `sfdl_stage_csv.payrixess_fee_rules`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.payrixess_fee_rules`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `creator`  string , `created`  string , `modifier`  string , `description`  string , `frozen`  string , `type`  string , `grouping`  string , `inactive`  string , `application`  string , `name`  string , `modified`  string , `fee_rule_id`  string , `value`  string , `fee_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrixess-stage/raw/fee_rules/2026-04-05/1775400147'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_csv.payrixess_fee_rules"
]

hive_path: s3://sfdl-csv-payrixess-stage/raw/fee_rules/2026-04-05/1775400147
id: 904166
processed: 1

raw_data:

{
    "_hoodie_commit_seqno": 1,
    "_hoodie_commit_time": 0,
    "_hoodie_file_name": 4,
    "_hoodie_partition_path": 3,
    "_hoodie_record_key": 2,
    "application": 13,
    "created": 6,
    "creator": 5,
    "description": 8,
    "fee_id": 18,
    "fee_rule_id": 16,
    "frozen": 9,
    "grouping": 11,
    "inactive": 12,
    "modified": 15,
    "modifier": 7,
    "name": 14,
    "type": 10,
    "value": 17
}

schema_attributes:

{
    "_hoodie_commit_seqno": "string",
    "_hoodie_commit_time": "string",
    "_hoodie_file_name": "string",
    "_hoodie_partition_path": "string",
    "_hoodie_record_key": "string",
    "application": "string",
    "created": "string",
    "creator": "string",
    "description": "string",
    "fee_id": "string",
    "fee_rule_id": "string",
    "frozen": "string",
    "grouping": "string",
    "inactive": "string",
    "modified": "string",
    "modifier": "string",
    "name": "string",
    "type": "string",
    "value": "string"
}

schema_name_id: 2164
schema_scan_id: 6409611
updated: 2026-04-05 09:42:57

Version 903956

created: 2026-04-04 09:32:53

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "DROP TABLE IF EXISTS `sfdl_stage_csv.payrixess_fee_rules`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.payrixess_fee_rules`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `creator`  string , `created`  string , `modifier`  string , `description`  string , `frozen`  string , `type`  string , `grouping`  string , `inactive`  string , `application`  string , `name`  string , `modified`  string , `fee_rule_id`  string , `value`  string , `fee_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrixess-stage/raw/fee_rules/2026-04-04/1775313145'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_csv.payrixess_fee_rules"
]

hive_path: s3://sfdl-csv-payrixess-stage/raw/fee_rules/2026-04-04/1775313145
id: 903956
processed: 1

raw_data:

{
    "_hoodie_commit_seqno": 1,
    "_hoodie_commit_time": 0,
    "_hoodie_file_name": 4,
    "_hoodie_partition_path": 3,
    "_hoodie_record_key": 2,
    "application": 13,
    "created": 6,
    "creator": 5,
    "description": 8,
    "fee_id": 18,
    "fee_rule_id": 16,
    "frozen": 9,
    "grouping": 11,
    "inactive": 12,
    "modified": 15,
    "modifier": 7,
    "name": 14,
    "type": 10,
    "value": 17
}

schema_attributes:

{
    "_hoodie_commit_seqno": "string",
    "_hoodie_commit_time": "string",
    "_hoodie_file_name": "string",
    "_hoodie_partition_path": "string",
    "_hoodie_record_key": "string",
    "application": "string",
    "created": "string",
    "creator": "string",
    "description": "string",
    "fee_id": "string",
    "fee_rule_id": "string",
    "frozen": "string",
    "grouping": "string",
    "inactive": "string",
    "modified": "string",
    "modifier": "string",
    "name": "string",
    "type": "string",
    "value": "string"
}

schema_name_id: 2164
schema_scan_id: 6409135
updated: 2026-04-04 09:33:04

Version 903733

created: 2026-04-03 09:32:08

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "DROP TABLE IF EXISTS `sfdl_stage_csv.payrixess_fee_rules`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.payrixess_fee_rules`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `creator`  string , `created`  string , `modifier`  string , `description`  string , `frozen`  string , `type`  string , `grouping`  string , `inactive`  string , `application`  string , `name`  string , `modified`  string , `fee_rule_id`  string , `value`  string , `fee_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrixess-stage/raw/fee_rules/2026-04-03/1775226717'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_csv.payrixess_fee_rules"
]

hive_path: s3://sfdl-csv-payrixess-stage/raw/fee_rules/2026-04-03/1775226717
id: 903733
processed: 1

raw_data:

{
    "_hoodie_commit_seqno": 1,
    "_hoodie_commit_time": 0,
    "_hoodie_file_name": 4,
    "_hoodie_partition_path": 3,
    "_hoodie_record_key": 2,
    "application": 13,
    "created": 6,
    "creator": 5,
    "description": 8,
    "fee_id": 18,
    "fee_rule_id": 16,
    "frozen": 9,
    "grouping": 11,
    "inactive": 12,
    "modified": 15,
    "modifier": 7,
    "name": 14,
    "type": 10,
    "value": 17
}

schema_attributes:

{
    "_hoodie_commit_seqno": "string",
    "_hoodie_commit_time": "string",
    "_hoodie_file_name": "string",
    "_hoodie_partition_path": "string",
    "_hoodie_record_key": "string",
    "application": "string",
    "created": "string",
    "creator": "string",
    "description": "string",
    "fee_id": "string",
    "fee_rule_id": "string",
    "frozen": "string",
    "grouping": "string",
    "inactive": "string",
    "modified": "string",
    "modifier": "string",
    "name": "string",
    "type": "string",
    "value": "string"
}

schema_name_id: 2164
schema_scan_id: 6408652
updated: 2026-04-03 09:32:22

Schema Scans: 15

Last at 2026-04-17 09:34:16

Scan 6415442

duration: 0:00:12.110826

exit_message:

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

id: 6415442

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/fee_rules/2026-04-17/1776436436",
        "key": "raw/fee_rules/2026-04-17/1776436436/997914e7-2883-4f2d-8cea-e5eda2b4affc.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_fee_rules",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 10826729178987581859,
        "service_name": "drive-thru",
        "span_id": 3715619567196310704,
        "trace_id": 12884304753336886140
    }
}

running: False
schema_name_id: 2164
start_time: 2026-04-17 09:34:16
success: True
trace_id: 12884304753336886140

Scan 6414943

duration: 0:00:12.117291

exit_message:

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

id: 6414943

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/fee_rules/2026-04-16/1776350878",
        "key": "raw/fee_rules/2026-04-16/1776350878/c49fd2b8-0dfd-4f82-8911-1a243657e3c7.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_fee_rules",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 15994011388033307046,
        "service_name": "drive-thru",
        "span_id": 6035471889310249615,
        "trace_id": 1058998519577514377
    }
}

running: False
schema_name_id: 2164
start_time: 2026-04-16 09:48:03
success: True
trace_id: 1058998519577514377

Scan 6414429

duration: 0:00:14.721468

exit_message:

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

id: 6414429

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/fee_rules/2026-04-15/1776264416",
        "key": "raw/fee_rules/2026-04-15/1776264416/b31a1618-7770-4787-84fd-69e88d5e51d2.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_fee_rules",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 8420947320797028996,
        "service_name": "drive-thru",
        "span_id": 8134814904110162996,
        "trace_id": 847248996636921818
    }
}

running: False
schema_name_id: 2164
start_time: 2026-04-15 09:47:08
success: True
trace_id: 847248996636921818

Scan 6413940

duration: 0:00:14.762233

exit_message:

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

id: 6413940

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/fee_rules/2026-04-14/1776177914",
        "key": "raw/fee_rules/2026-04-14/1776177914/a40eecc7-74b7-4f2c-83fa-ce47b379ca44.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_fee_rules",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 6978136842543339832,
        "service_name": "drive-thru",
        "span_id": 7960310337540289306,
        "trace_id": 12264617721300329484
    }
}

running: False
schema_name_id: 2164
start_time: 2026-04-14 09:45:31
success: True
trace_id: 12264617721300329484

Scan 6413268

duration: 0:00:14.585289

exit_message:

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

id: 6413268

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/fee_rules/2026-04-13/1776090646",
        "key": "raw/fee_rules/2026-04-13/1776090646/4977f3f8-6af3-4940-9108-7325bc617931.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_fee_rules",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 1754700716381701896,
        "service_name": "drive-thru",
        "span_id": 15658914742516364253,
        "trace_id": 3416506154660400368
    }
}

running: False
schema_name_id: 2164
start_time: 2026-04-13 09:31:14
success: True
trace_id: 3416506154660400368

Scan 6412829

duration: 0:00:14.616709

exit_message:

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

id: 6412829

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/fee_rules/2026-04-12/1776004026",
        "key": "raw/fee_rules/2026-04-12/1776004026/6649555f-c91d-4ff0-8bc5-01bc7296ad60.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_fee_rules",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 1880653642115540420,
        "service_name": "drive-thru",
        "span_id": 5809483932734655743,
        "trace_id": 7906665225935587717
    }
}

running: False
schema_name_id: 2164
start_time: 2026-04-12 09:27:11
success: True
trace_id: 7906665225935587717

Scan 6412555

duration: 0:00:14.572521

exit_message:

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

id: 6412555

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/fee_rules/2026-04-11/1775918621",
        "key": "raw/fee_rules/2026-04-11/1775918621/9ab15114-71de-4194-a720-269eb45691a9.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_fee_rules",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 5396242761910621697,
        "service_name": "drive-thru",
        "span_id": 12794301616579204067,
        "trace_id": 17562539178669646350
    }
}

running: False
schema_name_id: 2164
start_time: 2026-04-11 09:43:50
success: True
trace_id: 17562539178669646350

Scan 6412013

duration: 0:00:12.113583

exit_message:

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

id: 6412013

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/fee_rules/2026-04-10/1775831249",
        "key": "raw/fee_rules/2026-04-10/1775831249/17e0758d-7763-4880-b3d2-ae17b1ddc316.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_fee_rules",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 7462371219460050651,
        "service_name": "drive-thru",
        "span_id": 14483023615634976834,
        "trace_id": 1494422956556803008
    }
}

running: False
schema_name_id: 2164
start_time: 2026-04-10 09:27:35
success: True
trace_id: 1494422956556803008

Scan 6411544

duration: 0:00:14.564876

exit_message:

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

id: 6411544

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/fee_rules/2026-04-09/1775745863",
        "key": "raw/fee_rules/2026-04-09/1775745863/123c5589-5239-4bf2-b9e1-446a80b75bd6.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_fee_rules",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 12378717350998757325,
        "service_name": "drive-thru",
        "span_id": 9088706420919468263,
        "trace_id": 15152983445983488676
    }
}

running: False
schema_name_id: 2164
start_time: 2026-04-09 09:44:33
success: True
trace_id: 15152983445983488676

Scan 6411085

duration: 0:00:14.602754

exit_message:

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

id: 6411085

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/fee_rules/2026-04-08/1775659193",
        "key": "raw/fee_rules/2026-04-08/1775659193/00633143-72f6-4aea-b5dd-8718fd5beca8.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_fee_rules",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 16426347061281718975,
        "service_name": "drive-thru",
        "span_id": 11538796966295688502,
        "trace_id": 10405357825103488814
    }
}

running: False
schema_name_id: 2164
start_time: 2026-04-08 09:40:00
success: True
trace_id: 10405357825103488814

Scan 6410459

duration: 0:00:12.165298

exit_message:

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

id: 6410459

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/fee_rules/2026-04-07/1775572028",
        "key": "raw/fee_rules/2026-04-07/1775572028/fbe48209-8ed3-40a7-900d-efe95227e423.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_fee_rules",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 1601053174083709259,
        "service_name": "drive-thru",
        "span_id": 2056015500248598804,
        "trace_id": 9392290606650603269
    }
}

running: False
schema_name_id: 2164
start_time: 2026-04-07 09:27:19
success: True
trace_id: 9392290606650603269

Scan 6409940

duration: 0:00:12.106189

exit_message:

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

id: 6409940

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/fee_rules/2026-04-06/1775485719",
        "key": "raw/fee_rules/2026-04-06/1775485719/f0734667-b050-4d20-90c8-b1b8512a934e.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_fee_rules",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 4699447712351983160,
        "service_name": "drive-thru",
        "span_id": 7960695960650267176,
        "trace_id": 4668402044807015378
    }
}

running: False
schema_name_id: 2164
start_time: 2026-04-06 09:28:49
success: True
trace_id: 4668402044807015378

Scan 6409611

duration: 0:00:14.511639

exit_message:

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

id: 6409611

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/fee_rules/2026-04-05/1775400147",
        "key": "raw/fee_rules/2026-04-05/1775400147/b6e30293-bfac-461a-9dd4-ab74aab209bd.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_fee_rules",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 11702360885933126402,
        "service_name": "drive-thru",
        "span_id": 13099494310460958677,
        "trace_id": 8424412640053647121
    }
}

running: False
schema_name_id: 2164
start_time: 2026-04-05 09:42:42
success: True
trace_id: 8424412640053647121

Scan 6409135

duration: 0:00:12.024782

exit_message:

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

id: 6409135

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/fee_rules/2026-04-04/1775313145",
        "key": "raw/fee_rules/2026-04-04/1775313145/01ed4a7a-9001-4532-9078-f6a3e520699c.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_fee_rules",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 1850600639432664219,
        "service_name": "drive-thru",
        "span_id": 13962451828118429976,
        "trace_id": 4668050300618102773
    }
}

running: False
schema_name_id: 2164
start_time: 2026-04-04 09:32:52
success: True
trace_id: 4668050300618102773

Scan 6408652

duration: 0:00:14.693885

exit_message:

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

id: 6408652

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/fee_rules/2026-04-03/1775226717",
        "key": "raw/fee_rules/2026-04-03/1775226717/6a01650c-7b7d-4455-a08a-930bdc22bb0d.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_fee_rules",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 14928600343772560260,
        "service_name": "drive-thru",
        "span_id": 16943735258970314238,
        "trace_id": 1382879439041217638
    }
}

running: False
schema_name_id: 2164
start_time: 2026-04-03 09:32:07
success: True
trace_id: 1382879439041217638

Partitions:

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

Schema:

attributes:

{
    "_hoodie_commit_seqno": "string",
    "_hoodie_commit_time": "string",
    "_hoodie_file_name": "string",
    "_hoodie_partition_path": "string",
    "_hoodie_record_key": "string",
    "application": "string",
    "created": "string",
    "creator": "string",
    "description": "string",
    "fee_id": "string",
    "fee_rule_id": "string",
    "frozen": "string",
    "grouping": "string",
    "inactive": "string",
    "modified": "string",
    "modifier": "string",
    "name": "string",
    "type": "string",
    "value": "string"
}

created: 2026-04-17 09:34:16

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.payrixess_fee_rules`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `creator`  string , `created`  string , `modifier`  string , `description`  string , `frozen`  string , `type`  string , `grouping`  string , `inactive`  string , `application`  string , `name`  string , `modified`  string , `fee_rule_id`  string , `value`  string , `fee_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrixess-stage/raw/fee_rules/2026-04-17/1776436436'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_csv.payrixess_fee_rules`",
    "repair_table": "MSCK REPAIR TABLE sfdl_stage_csv.payrixess_fee_rules"
}

Server:

hostname: schemamanager-5c55c886bf-h2ts4
name: schema_manager
process_start: 2025-10-21 13:03:27
sf_env: stage
version: 2112174301

Raw:

{
    "name": {
        "created": "2024-07-22 13:08:39",
        "disabled": false,
        "format": "raw",
        "id": 2164,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_stage_csv",
            "table": "payrixess_fee_rules"
        },
        "type": "csv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "_hoodie_commit_seqno": "string",
            "_hoodie_commit_time": "string",
            "_hoodie_file_name": "string",
            "_hoodie_partition_path": "string",
            "_hoodie_record_key": "string",
            "application": "string",
            "created": "string",
            "creator": "string",
            "description": "string",
            "fee_id": "string",
            "fee_rule_id": "string",
            "frozen": "string",
            "grouping": "string",
            "inactive": "string",
            "modified": "string",
            "modifier": "string",
            "name": "string",
            "type": "string",
            "value": "string"
        },
        "created": "2026-04-17 09:34:16",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.payrixess_fee_rules`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `creator`  string , `created`  string , `modifier`  string , `description`  string , `frozen`  string , `type`  string , `grouping`  string , `inactive`  string , `application`  string , `name`  string , `modified`  string , `fee_rule_id`  string , `value`  string , `fee_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrixess-stage/raw/fee_rules/2026-04-17/1776436436'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_csv.payrixess_fee_rules`",
            "repair_table": "MSCK REPAIR TABLE sfdl_stage_csv.payrixess_fee_rules"
        }
    },
    "server": {
        "hostname": "schemamanager-5c55c886bf-h2ts4",
        "name": "schema_manager",
        "process_start": "2025-10-21 13:03:27",
        "sf_env": "stage",
        "version": "2112174301"
    }
}