Schema Info

Schema Name: sfdl_dev_csv.payrixess_fee_rules

created: 2024-07-22 13:06:55
disabled: False
format: raw
id: 2370
is_partitioned: False
is_schema_datatyped: True

name:

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

type: csv

Schema Versions: 15

Version 4773352

created: 2026-04-17 09:44:01

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_fee_rules`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/fee_rules/2026-04-17/1776437028'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_fee_rules"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/fee_rules/2026-04-17/1776437028
id: 4773352
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: 2370
schema_scan_id: 6867724
updated: 2026-04-17 09:44:15

Version 4773294

created: 2026-04-16 09:39:22

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_fee_rules`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/fee_rules/2026-04-16/1776350351'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_fee_rules"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/fee_rules/2026-04-16/1776350351
id: 4773294
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: 2370
schema_scan_id: 6867524
updated: 2026-04-16 09:39:36

Version 4773213

created: 2026-04-15 09:34:14

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_fee_rules`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/fee_rules/2026-04-15/1776263638'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_fee_rules"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/fee_rules/2026-04-15/1776263638
id: 4773213
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: 2370
schema_scan_id: 6867146
updated: 2026-04-15 09:34:26

Version 4773178

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_fee_rules`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/fee_rules/2026-04-14/1776178920'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_fee_rules"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/fee_rules/2026-04-14/1776178920
id: 4773178
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: 2370
schema_scan_id: 6866996
updated: 2026-04-14 10:03:04

Version 4773102

created: 2026-04-13 09:33:53

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_fee_rules`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/fee_rules/2026-04-13/1776090801'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_fee_rules"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/fee_rules/2026-04-13/1776090801
id: 4773102
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: 2370
schema_scan_id: 6866595
updated: 2026-04-13 09:34:07

Version 4773055

created: 2026-04-12 09:43:28

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_fee_rules`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/fee_rules/2026-04-12/1776005000'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_fee_rules"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/fee_rules/2026-04-12/1776005000
id: 4773055
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: 2370
schema_scan_id: 6866476
updated: 2026-04-12 09:43:42

Version 4772999

created: 2026-04-11 09:30:22

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_fee_rules`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/fee_rules/2026-04-11/1775917810'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_fee_rules"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/fee_rules/2026-04-11/1775917810
id: 4772999
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: 2370
schema_scan_id: 6866252
updated: 2026-04-11 09:30:33

Version 4772952

created: 2026-04-10 09:43:14

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_fee_rules`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/fee_rules/2026-04-10/1775832164'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_fee_rules"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/fee_rules/2026-04-10/1775832164
id: 4772952
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: 2370
schema_scan_id: 6866081
updated: 2026-04-10 09:45:02

Version 4772871

created: 2026-04-09 09:29:55

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_fee_rules`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/fee_rules/2026-04-09/1775744956'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_fee_rules"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/fee_rules/2026-04-09/1775744956
id: 4772871
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: 2370
schema_scan_id: 6865683
updated: 2026-04-09 09:30:09

Version 4772818

created: 2026-04-08 09:28:59

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_fee_rules`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/fee_rules/2026-04-08/1775658505'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_fee_rules"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/fee_rules/2026-04-08/1775658505
id: 4772818
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: 2370
schema_scan_id: 6865448
updated: 2026-04-08 09:29:10

Version 4772768

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_fee_rules`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/fee_rules/2026-04-07/1775573091'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_fee_rules"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/fee_rules/2026-04-07/1775573091
id: 4772768
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: 2370
schema_scan_id: 6865264
updated: 2026-04-07 09:45:14

Version 4772711

created: 2026-04-06 09:45:29

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_fee_rules`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/fee_rules/2026-04-06/1775486712'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_fee_rules"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/fee_rules/2026-04-06/1775486712
id: 4772711
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: 2370
schema_scan_id: 6864929
updated: 2026-04-06 09:45:41

Version 4772662

created: 2026-04-05 09:48:54

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_fee_rules`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/fee_rules/2026-04-05/1775400524'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_fee_rules"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/fee_rules/2026-04-05/1775400524
id: 4772662
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: 2370
schema_scan_id: 6864742
updated: 2026-04-05 09:49:08

Version 4772592

created: 2026-04-04 09:27:18

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_fee_rules`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/fee_rules/2026-04-04/1775312798'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_fee_rules"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/fee_rules/2026-04-04/1775312798
id: 4772592
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: 2370
schema_scan_id: 6864462
updated: 2026-04-04 09:27:32

Version 4772532

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_fee_rules`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/fee_rules/2026-04-03/1775226893'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_fee_rules"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/fee_rules/2026-04-03/1775226893
id: 4772532
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: 2370
schema_scan_id: 6864269
updated: 2026-04-03 09:35:18

Schema Scans: 15

Last at 2026-04-17 09:44:01

Scan 6867724

duration: 0:00:14.817763

exit_message:

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

id: 6867724

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/fee_rules/2026-04-17/1776437028",
        "key": "raw/fee_rules/2026-04-17/1776437028/12000ded-987a-4f0f-b9f4-124d015c7e86.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_fee_rules",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 17717116663392095067,
        "service_name": "drive-thru",
        "span_id": 15332764642061541226,
        "trace_id": 15860361452928096812
    }
}

running: False
schema_name_id: 2370
start_time: 2026-04-17 09:44:01
success: True
trace_id: 15860361452928096812

Scan 6867524

duration: 0:00:14.597904

exit_message:

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

id: 6867524

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/fee_rules/2026-04-16/1776350351",
        "key": "raw/fee_rules/2026-04-16/1776350351/48048d6c-c0b4-4911-bfdc-b268efd06242.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_fee_rules",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 5500107170805851090,
        "service_name": "drive-thru",
        "span_id": 5184499116129739675,
        "trace_id": 1028054956141563489
    }
}

running: False
schema_name_id: 2370
start_time: 2026-04-16 09:39:21
success: True
trace_id: 1028054956141563489

Scan 6867146

duration: 0:00:12.114003

exit_message:

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

id: 6867146

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/fee_rules/2026-04-15/1776263638",
        "key": "raw/fee_rules/2026-04-15/1776263638/50d51370-ebdc-4397-b004-683584296161.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_fee_rules",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 9514927006228833681,
        "service_name": "drive-thru",
        "span_id": 17911811748938941437,
        "trace_id": 13382312851591431614
    }
}

running: False
schema_name_id: 2370
start_time: 2026-04-15 09:34:14
success: True
trace_id: 13382312851591431614

Scan 6866996

duration: 0:00:12.171224

exit_message:

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

id: 6866996

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/fee_rules/2026-04-14/1776178920",
        "key": "raw/fee_rules/2026-04-14/1776178920/9bb4cf55-0c92-45f6-b42c-9b8f863c0850.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_fee_rules",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 9098066381648490911,
        "service_name": "drive-thru",
        "span_id": 8669605071787558949,
        "trace_id": 8365138148214082034
    }
}

running: False
schema_name_id: 2370
start_time: 2026-04-14 10:02:52
success: True
trace_id: 8365138148214082034

Scan 6866595

duration: 0:00:14.593955

exit_message:

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

id: 6866595

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/fee_rules/2026-04-13/1776090801",
        "key": "raw/fee_rules/2026-04-13/1776090801/27ecab87-9026-42f1-b2d7-daaf2a663f4a.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_fee_rules",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 8476607772888605779,
        "service_name": "drive-thru",
        "span_id": 13866798060285839768,
        "trace_id": 12737460839823862091
    }
}

running: False
schema_name_id: 2370
start_time: 2026-04-13 09:33:52
success: True
trace_id: 12737460839823862091

Scan 6866476

duration: 0:00:14.529127

exit_message:

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

id: 6866476

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/fee_rules/2026-04-12/1776005000",
        "key": "raw/fee_rules/2026-04-12/1776005000/fb471b2a-3d34-4122-bfef-527ac31dc443.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_fee_rules",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 1653454980152880585,
        "service_name": "drive-thru",
        "span_id": 4098590265420117445,
        "trace_id": 8576673609616387071
    }
}

running: False
schema_name_id: 2370
start_time: 2026-04-12 09:43:28
success: True
trace_id: 8576673609616387071

Scan 6866252

duration: 0:00:11.939934

exit_message:

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

id: 6866252

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/fee_rules/2026-04-11/1775917810",
        "key": "raw/fee_rules/2026-04-11/1775917810/d382994f-9f4e-4895-b72c-0836a3d099ff.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_fee_rules",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 8859364183785038865,
        "service_name": "drive-thru",
        "span_id": 7869513080760154956,
        "trace_id": 16085450568440482053
    }
}

running: False
schema_name_id: 2370
start_time: 2026-04-11 09:30:21
success: True
trace_id: 16085450568440482053

Scan 6866081

duration: 0:01:48.767169

exit_message:

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

id: 6866081

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/fee_rules/2026-04-10/1775832164",
        "key": "raw/fee_rules/2026-04-10/1775832164/626c1c9c-fc00-4693-9504-64cc1c235cc9.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_fee_rules",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 10731333943760306406,
        "service_name": "drive-thru",
        "span_id": 16407742497924306689,
        "trace_id": 15237705751150493152
    }
}

running: False
schema_name_id: 2370
start_time: 2026-04-10 09:43:13
success: True
trace_id: 15237705751150493152

Scan 6865683

duration: 0:00:14.529221

exit_message:

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

id: 6865683

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/fee_rules/2026-04-09/1775744956",
        "key": "raw/fee_rules/2026-04-09/1775744956/8ca4a98a-3b08-422d-87fa-83108dfbc00b.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_fee_rules",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 1317522826008317041,
        "service_name": "drive-thru",
        "span_id": 5182513425523557020,
        "trace_id": 2504945319877360570
    }
}

running: False
schema_name_id: 2370
start_time: 2026-04-09 09:29:55
success: True
trace_id: 2504945319877360570

Scan 6865448

duration: 0:00:11.959849

exit_message:

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

id: 6865448

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/fee_rules/2026-04-08/1775658505",
        "key": "raw/fee_rules/2026-04-08/1775658505/fff1b1fa-c60a-4a00-81e2-21fe7626dd9a.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_fee_rules",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 16747050104964106261,
        "service_name": "drive-thru",
        "span_id": 9248820355401354579,
        "trace_id": 16891931115717440186
    }
}

running: False
schema_name_id: 2370
start_time: 2026-04-08 09:28:58
success: True
trace_id: 16891931115717440186

Scan 6865264

duration: 0:00:14.955413

exit_message:

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

id: 6865264

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/fee_rules/2026-04-07/1775573091",
        "key": "raw/fee_rules/2026-04-07/1775573091/041d7dca-df44-4051-bd85-52fec9f4779f.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_fee_rules",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 3157387228577470462,
        "service_name": "drive-thru",
        "span_id": 1305608246827322650,
        "trace_id": 10617586719736530977
    }
}

running: False
schema_name_id: 2370
start_time: 2026-04-07 09:44:59
success: True
trace_id: 10617586719736530977

Scan 6864929

duration: 0:00:12.036590

exit_message:

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

id: 6864929

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/fee_rules/2026-04-06/1775486712",
        "key": "raw/fee_rules/2026-04-06/1775486712/2ef0051d-dc94-428d-8961-8868439499ad.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_fee_rules",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 2251095580974015815,
        "service_name": "drive-thru",
        "span_id": 2282458755477673659,
        "trace_id": 10692049942943707314
    }
}

running: False
schema_name_id: 2370
start_time: 2026-04-06 09:45:29
success: True
trace_id: 10692049942943707314

Scan 6864742

duration: 0:00:14.693593

exit_message:

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

id: 6864742

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/fee_rules/2026-04-05/1775400524",
        "key": "raw/fee_rules/2026-04-05/1775400524/85701503-ba93-41a5-a57b-5fb8537468c0.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_fee_rules",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 8498075067954697730,
        "service_name": "drive-thru",
        "span_id": 3058451674202455532,
        "trace_id": 6216559788313321234
    }
}

running: False
schema_name_id: 2370
start_time: 2026-04-05 09:48:53
success: True
trace_id: 6216559788313321234

Scan 6864462

duration: 0:00:14.627414

exit_message:

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

id: 6864462

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/fee_rules/2026-04-04/1775312798",
        "key": "raw/fee_rules/2026-04-04/1775312798/d42b0700-548e-4c02-a8bf-23bdc02af3b1.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_fee_rules",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 11234335961430669335,
        "service_name": "drive-thru",
        "span_id": 2063425939859904194,
        "trace_id": 15439298382800290083
    }
}

running: False
schema_name_id: 2370
start_time: 2026-04-04 09:27:18
success: True
trace_id: 15439298382800290083

Scan 6864269

duration: 0:00:14.689731

exit_message:

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

id: 6864269

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/fee_rules/2026-04-03/1775226893",
        "key": "raw/fee_rules/2026-04-03/1775226893/dfb57180-6237-4de0-8c1b-91aa73ea374e.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_fee_rules",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 2531152646308161632,
        "service_name": "drive-thru",
        "span_id": 9586120195736187085,
        "trace_id": 16610060876014885049
    }
}

running: False
schema_name_id: 2370
start_time: 2026-04-03 09:35:03
success: True
trace_id: 16610060876014885049

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:44:01

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/fee_rules/2026-04-17/1776437028'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_fee_rules`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_fee_rules"
}

Server:

hostname: schemamanager-5447774fc6-4w58v
name: schema_manager
process_start: 2026-04-02 21:43:44
sf_env: dev
version: 2427328685

Raw:

{
    "name": {
        "created": "2024-07-22 13:06:55",
        "disabled": false,
        "format": "raw",
        "id": 2370,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_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:44:01",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/fee_rules/2026-04-17/1776437028'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_fee_rules`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_fee_rules"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}