Schema Info

Schema Name: sfdl_dev_csv.payrix_fee_rules

created: 2024-07-03 13:58:50
disabled: False
format: raw
id: 2302
is_partitioned: False
is_schema_datatyped: True

name:

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

type: csv

Schema Versions: 15

Version 4773351

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-dev/raw/fee_rules/2026-04-17/1776437022
id: 4773351
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: 2302
schema_scan_id: 6867723
updated: 2026-04-17 09:44:15

Version 4773275

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-dev/raw/fee_rules/2026-04-16/1776349865
id: 4773275
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: 2302
schema_scan_id: 6867413
updated: 2026-04-16 09:31:47

Version 4773224

created: 2026-04-15 09:40:19

ddl:

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

hive_path: s3://sfdl-csv-payrix-dev/raw/fee_rules/2026-04-15/1776263987
id: 4773224
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: 2302
schema_scan_id: 6867177
updated: 2026-04-15 09:40:30

Version 4773161

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-dev/raw/fee_rules/2026-04-14/1776177811
id: 4773161
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: 2302
schema_scan_id: 6866903
updated: 2026-04-14 09:43:56

Version 4773091

created: 2026-04-13 09:28:32

ddl:

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

hive_path: s3://sfdl-csv-payrix-dev/raw/fee_rules/2026-04-13/1776090508
id: 4773091
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: 2302
schema_scan_id: 6866575
updated: 2026-04-13 09:28:43

Version 4773039

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-dev/raw/fee_rules/2026-04-12/1776004073
id: 4773039
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: 2302
schema_scan_id: 6866372
updated: 2026-04-12 09:28:10

Version 4773000

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-dev/raw/fee_rules/2026-04-11/1775917811
id: 4773000
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: 2302
schema_scan_id: 6866254
updated: 2026-04-11 09:30:35

Version 4772941

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-dev/raw/fee_rules/2026-04-10/1775831301
id: 4772941
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: 2302
schema_scan_id: 6865991
updated: 2026-04-10 09:28:57

Version 4772880

created: 2026-04-09 09:34:50

ddl:

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

hive_path: s3://sfdl-csv-payrix-dev/raw/fee_rules/2026-04-09/1775745277
id: 4772880
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: 2302
schema_scan_id: 6865749
updated: 2026-04-09 09:35:04

Version 4772834

created: 2026-04-08 09:44:00

ddl:

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

hive_path: s3://sfdl-csv-payrix-dev/raw/fee_rules/2026-04-08/1775659434
id: 4772834
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: 2302
schema_scan_id: 6865516
updated: 2026-04-08 09:44:16

Version 4772765

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-dev/raw/fee_rules/2026-04-07/1775572976
id: 4772765
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: 2302
schema_scan_id: 6865260
updated: 2026-04-07 09:43:41

Version 4772692

created: 2026-04-06 09:30:52

ddl:

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

hive_path: s3://sfdl-csv-payrix-dev/raw/fee_rules/2026-04-06/1775485812
id: 4772692
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: 2302
schema_scan_id: 6864834
updated: 2026-04-06 09:31:06

Version 4772647

created: 2026-04-05 09:35:11

ddl:

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

hive_path: s3://sfdl-csv-payrix-dev/raw/fee_rules/2026-04-05/1775399699
id: 4772647
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: 2302
schema_scan_id: 6864667
updated: 2026-04-05 09:35:25

Version 4772600

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-dev/raw/fee_rules/2026-04-04/1775313771
id: 4772600
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: 2302
schema_scan_id: 6864506
updated: 2026-04-04 09:43:25

Version 4772552

created: 2026-04-03 09:55:26

ddl:

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

hive_path: s3://sfdl-csv-payrix-dev/raw/fee_rules/2026-04-03/1775228098
id: 4772552
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: 2302
schema_scan_id: 6864340
updated: 2026-04-03 09:55:40

Schema Scans: 15

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

Scan 6867723

duration: 0:00:14.923559

exit_message:

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

id: 6867723

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/fee_rules/2026-04-17/1776437022",
        "key": "raw/fee_rules/2026-04-17/1776437022/d0a8aec9-2592-46a4-bb32-473587166504.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_fee_rules",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 9186131274096130138,
        "service_name": "drive-thru",
        "span_id": 9266578101406717881,
        "trace_id": 1372646664470078792
    }
}

running: False
schema_name_id: 2302
start_time: 2026-04-17 09:44:00
success: True
trace_id: 1372646664470078792

Scan 6867413

duration: 0:00:14.575597

exit_message:

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

id: 6867413

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/fee_rules/2026-04-16/1776349865",
        "key": "raw/fee_rules/2026-04-16/1776349865/fe31f4c0-d26c-4dc1-bb82-dad2421e6768.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_fee_rules",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 12696239402480642383,
        "service_name": "drive-thru",
        "span_id": 735797827043047695,
        "trace_id": 15893883560000169267
    }
}

running: False
schema_name_id: 2302
start_time: 2026-04-16 09:31:33
success: True
trace_id: 15893883560000169267

Scan 6867177

duration: 0:00:12.061065

exit_message:

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

id: 6867177

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/fee_rules/2026-04-15/1776263987",
        "key": "raw/fee_rules/2026-04-15/1776263987/18f87fe9-8ae6-4471-88b5-f5b7d88ee166.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_fee_rules",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 9193442119352239601,
        "service_name": "drive-thru",
        "span_id": 6633537404768301544,
        "trace_id": 10896519607473030151
    }
}

running: False
schema_name_id: 2302
start_time: 2026-04-15 09:40:18
success: True
trace_id: 10896519607473030151

Scan 6866903

duration: 0:00:12.081421

exit_message:

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

id: 6866903

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/fee_rules/2026-04-14/1776177811",
        "key": "raw/fee_rules/2026-04-14/1776177811/42425c26-55ac-42f1-8c6e-b434f293c127.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_fee_rules",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 8807640441411302383,
        "service_name": "drive-thru",
        "span_id": 14940509523522970169,
        "trace_id": 15280462648273328731
    }
}

running: False
schema_name_id: 2302
start_time: 2026-04-14 09:43:44
success: True
trace_id: 15280462648273328731

Scan 6866575

duration: 0:00:11.936575

exit_message:

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

id: 6866575

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/fee_rules/2026-04-13/1776090508",
        "key": "raw/fee_rules/2026-04-13/1776090508/bc5a45d7-b70f-4338-8c7f-45ecbb3b9666.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_fee_rules",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 13453540429477164705,
        "service_name": "drive-thru",
        "span_id": 3938541202425821473,
        "trace_id": 12197454073134351000
    }
}

running: False
schema_name_id: 2302
start_time: 2026-04-13 09:28:31
success: True
trace_id: 12197454073134351000

Scan 6866372

duration: 0:00:14.573398

exit_message:

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

id: 6866372

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/fee_rules/2026-04-12/1776004073",
        "key": "raw/fee_rules/2026-04-12/1776004073/39492918-f291-4905-b4ce-6b5d8139d1bf.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_fee_rules",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 11827784199894736156,
        "service_name": "drive-thru",
        "span_id": 15285469828293847890,
        "trace_id": 11944858226461158157
    }
}

running: False
schema_name_id: 2302
start_time: 2026-04-12 09:27:55
success: True
trace_id: 11944858226461158157

Scan 6866254

duration: 0:00:11.953715

exit_message:

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

id: 6866254

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/fee_rules/2026-04-11/1775917811",
        "key": "raw/fee_rules/2026-04-11/1775917811/dd06ba7e-fa97-46b2-975f-326be882b05c.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_fee_rules",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 8021362056513437467,
        "service_name": "drive-thru",
        "span_id": 12279020280075942068,
        "trace_id": 16004504269223626119
    }
}

running: False
schema_name_id: 2302
start_time: 2026-04-11 09:30:23
success: True
trace_id: 16004504269223626119

Scan 6865991

duration: 0:00:14.552099

exit_message:

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

id: 6865991

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/fee_rules/2026-04-10/1775831301",
        "key": "raw/fee_rules/2026-04-10/1775831301/ecea97da-44bf-4095-9cd6-043e03a81f73.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_fee_rules",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 14292903311940754580,
        "service_name": "drive-thru",
        "span_id": 18027734326557398598,
        "trace_id": 12814798742548874150
    }
}

running: False
schema_name_id: 2302
start_time: 2026-04-10 09:28:42
success: True
trace_id: 12814798742548874150

Scan 6865749

duration: 0:00:14.543838

exit_message:

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

id: 6865749

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/fee_rules/2026-04-09/1775745277",
        "key": "raw/fee_rules/2026-04-09/1775745277/77bf49fe-949d-4eae-b4ac-3533493ac8a1.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_fee_rules",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 8144220775365747415,
        "service_name": "drive-thru",
        "span_id": 9602377653327234725,
        "trace_id": 12768302600170576865
    }
}

running: False
schema_name_id: 2302
start_time: 2026-04-09 09:34:49
success: True
trace_id: 12768302600170576865

Scan 6865516

duration: 0:00:17.233497

exit_message:

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

id: 6865516

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/fee_rules/2026-04-08/1775659434",
        "key": "raw/fee_rules/2026-04-08/1775659434/7e3130ba-738f-4d2b-ae4f-dbfaa854c234.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_fee_rules",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 7231551666351786867,
        "service_name": "drive-thru",
        "span_id": 3765009835761815113,
        "trace_id": 1350855326009036337
    }
}

running: False
schema_name_id: 2302
start_time: 2026-04-08 09:43:59
success: True
trace_id: 1350855326009036337

Scan 6865260

duration: 0:00:14.587078

exit_message:

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

id: 6865260

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/fee_rules/2026-04-07/1775572976",
        "key": "raw/fee_rules/2026-04-07/1775572976/750329c0-511e-45d4-8eef-1d973662070f.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_fee_rules",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 11562953452944824834,
        "service_name": "drive-thru",
        "span_id": 9573007805275594084,
        "trace_id": 7385048294709429520
    }
}

running: False
schema_name_id: 2302
start_time: 2026-04-07 09:43:27
success: True
trace_id: 7385048294709429520

Scan 6864834

duration: 0:00:14.757639

exit_message:

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

id: 6864834

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/fee_rules/2026-04-06/1775485812",
        "key": "raw/fee_rules/2026-04-06/1775485812/9b94ed13-4f45-4c49-abc8-a4e1ade68257.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_fee_rules",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 14986349714759927310,
        "service_name": "drive-thru",
        "span_id": 15758807146083523354,
        "trace_id": 13776378683079727838
    }
}

running: False
schema_name_id: 2302
start_time: 2026-04-06 09:30:51
success: True
trace_id: 13776378683079727838

Scan 6864667

duration: 0:00:14.535588

exit_message:

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

id: 6864667

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/fee_rules/2026-04-05/1775399699",
        "key": "raw/fee_rules/2026-04-05/1775399699/38f16290-b242-413e-bb38-1ef8c6324ded.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_fee_rules",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 4160077968028449738,
        "service_name": "drive-thru",
        "span_id": 11985594737602386821,
        "trace_id": 1856118558158421429
    }
}

running: False
schema_name_id: 2302
start_time: 2026-04-05 09:35:10
success: True
trace_id: 1856118558158421429

Scan 6864506

duration: 0:00:14.596420

exit_message:

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

id: 6864506

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/fee_rules/2026-04-04/1775313771",
        "key": "raw/fee_rules/2026-04-04/1775313771/d82cc2ff-5f6d-471d-9702-bca8490ae333.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_fee_rules",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 5892566881549977423,
        "service_name": "drive-thru",
        "span_id": 4279151921012500733,
        "trace_id": 7390939031891141177
    }
}

running: False
schema_name_id: 2302
start_time: 2026-04-04 09:43:10
success: True
trace_id: 7390939031891141177

Scan 6864340

duration: 0:00:14.605775

exit_message:

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

id: 6864340

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/fee_rules/2026-04-03/1775228098",
        "key": "raw/fee_rules/2026-04-03/1775228098/befba84c-dd9e-4424-a4f7-a6b00b6a392e.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_fee_rules",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 14568544024532481341,
        "service_name": "drive-thru",
        "span_id": 9232073711351122032,
        "trace_id": 12293794546802743668
    }
}

running: False
schema_name_id: 2302
start_time: 2026-04-03 09:55:25
success: True
trace_id: 12293794546802743668

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.payrix_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-payrix-dev/raw/fee_rules/2026-04-17/1776437022'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_csv.payrix_fee_rules`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_csv.payrix_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-03 13:58:50",
        "disabled": false,
        "format": "raw",
        "id": 2302,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_csv",
            "table": "payrix_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.payrix_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-payrix-dev/raw/fee_rules/2026-04-17/1776437022'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_csv.payrix_fee_rules`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_csv.payrix_fee_rules"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}