Schema Info

Schema Name: sfdl_prod_csv.payrix_fee_rules

created: 2024-07-10 09:32:25
disabled: False
format: raw
id: 1916
is_partitioned: False
is_schema_datatyped: True

name:

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

type: csv

Schema Versions: 15

Version 1718237

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/fee_rules/2026-04-17/1776436052
id: 1718237
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: 1916
schema_scan_id: 162178363
updated: 2026-04-17 09:27:50

Version 1717037

created: 2026-04-16 09:40:14

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/fee_rules/2026-04-16/1776350409
id: 1717037
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: 1916
schema_scan_id: 162122879
updated: 2026-04-16 09:40:25

Version 1715886

created: 2026-04-15 11:28:10

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/fee_rules/2026-04-15/1776270472
id: 1715886
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: 1916
schema_scan_id: 162072821
updated: 2026-04-15 11:28:24

Version 1714952

created: 2026-04-14 21:11:59

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/fee_rules/2026-04-14/1776219109
id: 1714952
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: 1916
schema_scan_id: 162046410
updated: 2026-04-14 21:12:13

Version 1713419

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/fee_rules/2026-04-13/1776090889
id: 1713419
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: 1916
schema_scan_id: 161953755
updated: 2026-04-13 09:35:04

Version 1712246

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/fee_rules/2026-04-12/1776005035
id: 1712246
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: 1916
schema_scan_id: 161903644
updated: 2026-04-12 09:44:11

Version 1711001

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/fee_rules/2026-04-11/1775917454
id: 1711001
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: 1916
schema_scan_id: 161851865
updated: 2026-04-11 09:24:33

Version 1709832

created: 2026-04-10 09:26:44

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/fee_rules/2026-04-10/1775831200
id: 1709832
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: 1916
schema_scan_id: 161797242
updated: 2026-04-10 09:26:57

Version 1708676

created: 2026-04-09 09:28:01

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/fee_rules/2026-04-09/1775744870
id: 1708676
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: 1916
schema_scan_id: 161741334
updated: 2026-04-09 09:28:15

Version 1707504

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/fee_rules/2026-04-08/1775658490
id: 1707504
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: 1916
schema_scan_id: 161686177
updated: 2026-04-08 09:28:28

Version 1706299

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/fee_rules/2026-04-07/1775572066
id: 1706299
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: 1916
schema_scan_id: 161630185
updated: 2026-04-07 09:28:07

Version 1705116

created: 2026-04-06 09:44:26

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/fee_rules/2026-04-06/1775486637
id: 1705116
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: 1916
schema_scan_id: 161572948
updated: 2026-04-06 09:44:38

Version 1703850

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/fee_rules/2026-04-05/1775399259
id: 1703850
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: 1916
schema_scan_id: 161523745
updated: 2026-04-05 09:28:00

Version 1702744

created: 2026-04-04 10:02:56

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/fee_rules/2026-04-04/1775314836
id: 1702744
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: 1916
schema_scan_id: 161474140
updated: 2026-04-04 10:03:07

Version 1701523

created: 2026-04-03 09:31:20

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/fee_rules/2026-04-03/1775226676
id: 1701523
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: 1916
schema_scan_id: 161414339
updated: 2026-04-03 09:31:33

Schema Scans: 15

Last at 2026-04-17 09:27:35

Scan 162178363

duration: 0:00:14.625774

exit_message:

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

id: 162178363

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/fee_rules/2026-04-17/1776436052",
        "key": "raw/fee_rules/2026-04-17/1776436052/fa7e4487-2766-497a-b1b2-15e391a94b67.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_fee_rules",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 629440262144706258,
        "service_name": "drive-thru",
        "span_id": 7394637963753051072,
        "trace_id": 12006311657181636930
    }
}

running: False
schema_name_id: 1916
start_time: 2026-04-17 09:27:35
success: True
trace_id: 12006311657181636930

Scan 162122879

duration: 0:00:11.994152

exit_message:

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

id: 162122879

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/fee_rules/2026-04-16/1776350409",
        "key": "raw/fee_rules/2026-04-16/1776350409/0c14545a-8251-403b-85db-81316121f90d.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_fee_rules",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 4393854436233832205,
        "service_name": "drive-thru",
        "span_id": 11822343865401336463,
        "trace_id": 3799782534669974064
    }
}

running: False
schema_name_id: 1916
start_time: 2026-04-16 09:40:13
success: True
trace_id: 3799782534669974064

Scan 162072821

duration: 0:00:14.506360

exit_message:

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

id: 162072821

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/fee_rules/2026-04-15/1776270472",
        "key": "raw/fee_rules/2026-04-15/1776270472/407b9d0d-ba57-406e-bd80-a5a3d9e2b634.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_fee_rules",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 5932072505376405452,
        "service_name": "drive-thru",
        "span_id": 15018092485250141428,
        "trace_id": 7142618977206226592
    }
}

running: False
schema_name_id: 1916
start_time: 2026-04-15 11:28:10
success: True
trace_id: 7142618977206226592

Scan 162046410

duration: 0:00:14.562943

exit_message:

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

id: 162046410

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/fee_rules/2026-04-14/1776219109",
        "key": "raw/fee_rules/2026-04-14/1776219109/52862853-0cec-42bf-a1cc-94cbb28781d0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_fee_rules",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 15466670317536387800,
        "service_name": "drive-thru",
        "span_id": 16784658859315324508,
        "trace_id": 4987086936016759376
    }
}

running: False
schema_name_id: 1916
start_time: 2026-04-14 21:11:58
success: True
trace_id: 4987086936016759376

Scan 161953755

duration: 0:00:12.078792

exit_message:

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

id: 161953755

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/fee_rules/2026-04-13/1776090889",
        "key": "raw/fee_rules/2026-04-13/1776090889/48903e6b-548a-458d-ac14-9216bb9cd2f9.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_fee_rules",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 18395024735344682355,
        "service_name": "drive-thru",
        "span_id": 14779025741566267092,
        "trace_id": 11377375835884927766
    }
}

running: False
schema_name_id: 1916
start_time: 2026-04-13 09:34:52
success: True
trace_id: 11377375835884927766

Scan 161903644

duration: 0:00:12.160036

exit_message:

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

id: 161903644

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/fee_rules/2026-04-12/1776005035",
        "key": "raw/fee_rules/2026-04-12/1776005035/ce886096-9f63-4ba3-a6b2-8776f153fd38.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_fee_rules",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 15450868403104126349,
        "service_name": "drive-thru",
        "span_id": 9737488520802930352,
        "trace_id": 18341270114107164094
    }
}

running: False
schema_name_id: 1916
start_time: 2026-04-12 09:43:59
success: True
trace_id: 18341270114107164094

Scan 161851865

duration: 0:00:11.940058

exit_message:

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

id: 161851865

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/fee_rules/2026-04-11/1775917454",
        "key": "raw/fee_rules/2026-04-11/1775917454/df48d566-e4e7-46d2-9950-4086a7a15392.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_fee_rules",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 17784680687828875570,
        "service_name": "drive-thru",
        "span_id": 6063287882086318160,
        "trace_id": 8438907086580573591
    }
}

running: False
schema_name_id: 1916
start_time: 2026-04-11 09:24:21
success: True
trace_id: 8438907086580573591

Scan 161797242

duration: 0:00:14.526898

exit_message:

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

id: 161797242

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/fee_rules/2026-04-10/1775831200",
        "key": "raw/fee_rules/2026-04-10/1775831200/2f42199d-cc7d-4849-a3fb-8782e8b584ee.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_fee_rules",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 4469130667417863177,
        "service_name": "drive-thru",
        "span_id": 11483276037348974048,
        "trace_id": 8393791079506864118
    }
}

running: False
schema_name_id: 1916
start_time: 2026-04-10 09:26:43
success: True
trace_id: 8393791079506864118

Scan 161741334

duration: 0:00:14.632282

exit_message:

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

id: 161741334

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/fee_rules/2026-04-09/1775744870",
        "key": "raw/fee_rules/2026-04-09/1775744870/086f8ee0-1ec3-415a-8220-ac0ed48061e0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_fee_rules",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 3009133858012827297,
        "service_name": "drive-thru",
        "span_id": 3108808063039871273,
        "trace_id": 9857065034124291337
    }
}

running: False
schema_name_id: 1916
start_time: 2026-04-09 09:28:00
success: True
trace_id: 9857065034124291337

Scan 161686177

duration: 0:00:14.600025

exit_message:

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

id: 161686177

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/fee_rules/2026-04-08/1775658490",
        "key": "raw/fee_rules/2026-04-08/1775658490/b9895347-4f32-43df-b9be-bcc43a3dba28.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_fee_rules",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 690971329045372090,
        "service_name": "drive-thru",
        "span_id": 8746033058202272205,
        "trace_id": 5656989126682190840
    }
}

running: False
schema_name_id: 1916
start_time: 2026-04-08 09:28:13
success: True
trace_id: 5656989126682190840

Scan 161630185

duration: 0:00:12.112016

exit_message:

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

id: 161630185

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/fee_rules/2026-04-07/1775572066",
        "key": "raw/fee_rules/2026-04-07/1775572066/9dd617ba-c276-4aad-aca7-83689339ee3b.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_fee_rules",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 2098111681686984695,
        "service_name": "drive-thru",
        "span_id": 17935504640134262122,
        "trace_id": 6551683904290065472
    }
}

running: False
schema_name_id: 1916
start_time: 2026-04-07 09:27:55
success: True
trace_id: 6551683904290065472

Scan 161572948

duration: 0:00:11.968205

exit_message:

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

id: 161572948

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/fee_rules/2026-04-06/1775486637",
        "key": "raw/fee_rules/2026-04-06/1775486637/10bcdfe1-9215-4763-9e46-43be7782dc58.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_fee_rules",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 14879917440894064116,
        "service_name": "drive-thru",
        "span_id": 4605646746228796385,
        "trace_id": 12183146418586602398
    }
}

running: False
schema_name_id: 1916
start_time: 2026-04-06 09:44:26
success: True
trace_id: 12183146418586602398

Scan 161523745

duration: 0:00:12.059548

exit_message:

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

id: 161523745

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/fee_rules/2026-04-05/1775399259",
        "key": "raw/fee_rules/2026-04-05/1775399259/7d91f9c1-ef6f-4520-862f-51b3313e5ed5.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_fee_rules",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 15464336326230482932,
        "service_name": "drive-thru",
        "span_id": 12937976772896662452,
        "trace_id": 16799728618909708228
    }
}

running: False
schema_name_id: 1916
start_time: 2026-04-05 09:27:48
success: True
trace_id: 16799728618909708228

Scan 161474140

duration: 0:00:12.182926

exit_message:

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

id: 161474140

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/fee_rules/2026-04-04/1775314836",
        "key": "raw/fee_rules/2026-04-04/1775314836/26be8b5d-1461-43a8-b4a8-917dcf2dabcf.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_fee_rules",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 16370910654266039827,
        "service_name": "drive-thru",
        "span_id": 9106094467606114440,
        "trace_id": 6976036990072201057
    }
}

running: False
schema_name_id: 1916
start_time: 2026-04-04 10:02:55
success: True
trace_id: 6976036990072201057

Scan 161414339

duration: 0:00:14.553038

exit_message:

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

id: 161414339

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/fee_rules/2026-04-03/1775226676",
        "key": "raw/fee_rules/2026-04-03/1775226676/e595b580-e6fe-407d-b741-7bf3df257ba6.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_fee_rules",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 17713341688995144490,
        "service_name": "drive-thru",
        "span_id": 3461900630631779472,
        "trace_id": 6892382660157609920
    }
}

running: False
schema_name_id: 1916
start_time: 2026-04-03 09:31:19
success: True
trace_id: 6892382660157609920

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:27:36

ddl:

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

Server:

hostname: schemamanager-5475496c57-7dpqb
name: schema_manager
process_start: 2026-01-09 11:27:47
sf_env: prod
version: 2112174301

Raw:

{
    "name": {
        "created": "2024-07-10 09:32:25",
        "disabled": false,
        "format": "raw",
        "id": 1916,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_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:27:36",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/fee_rules/2026-04-17/1776436052'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_csv.payrix_fee_rules`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_csv.payrix_fee_rules"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}