Schema Info

Schema Name: sfdl_prod_csv.payrixess_mms_processing_fees

created: 2024-07-24 10:22:27
disabled: False
format: raw
id: 1969
is_partitioned: False
is_schema_datatyped: True

name:

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

type: csv

Schema Versions: 15

Version 1718238

created: 2026-04-17 09:28:20

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_mms_processing_fees`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrixess_mms_processing_fees`\n(\n `year`  string , `month`  string , `entity`  string , `card_brand`  string , `card_type`  string , `funded`  string , `percent`  string , `flat`  string , `count`  string , `txn`  string , `fee`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrixess-prod/raw/mms_processing_fees/2026-04-17/1776436093'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_mms_processing_fees"
]

hive_path: s3://sfdl-csv-payrixess-prod/raw/mms_processing_fees/2026-04-17/1776436093
id: 1718238
processed: 1

raw_data:

{
    "card_brand": 3,
    "card_type": 4,
    "count": 8,
    "entity": 2,
    "fee": 10,
    "flat": 7,
    "funded": 5,
    "month": 1,
    "percent": 6,
    "txn": 9,
    "year": 0
}

schema_attributes:

{
    "card_brand": "string",
    "card_type": "string",
    "count": "string",
    "entity": "string",
    "fee": "string",
    "flat": "string",
    "funded": "string",
    "month": "string",
    "percent": "string",
    "txn": "string",
    "year": "string"
}

schema_name_id: 1969
schema_scan_id: 162178372
updated: 2026-04-17 09:28:34

Version 1717056

created: 2026-04-16 09:46:44

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_mms_processing_fees`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrixess_mms_processing_fees`\n(\n `year`  string , `month`  string , `entity`  string , `card_brand`  string , `card_type`  string , `funded`  string , `percent`  string , `flat`  string , `count`  string , `txn`  string , `fee`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrixess-prod/raw/mms_processing_fees/2026-04-16/1776350799'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_mms_processing_fees"
]

hive_path: s3://sfdl-csv-payrixess-prod/raw/mms_processing_fees/2026-04-16/1776350799
id: 1717056
processed: 1

raw_data:

{
    "card_brand": 3,
    "card_type": 4,
    "count": 8,
    "entity": 2,
    "fee": 10,
    "flat": 7,
    "funded": 5,
    "month": 1,
    "percent": 6,
    "txn": 9,
    "year": 0
}

schema_attributes:

{
    "card_brand": "string",
    "card_type": "string",
    "count": "string",
    "entity": "string",
    "fee": "string",
    "flat": "string",
    "funded": "string",
    "month": "string",
    "percent": "string",
    "txn": "string",
    "year": "string"
}

schema_name_id: 1969
schema_scan_id: 162122987
updated: 2026-04-16 09:46:55

Version 1715832

created: 2026-04-15 09:44:16

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_mms_processing_fees`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrixess_mms_processing_fees`\n(\n `year`  string , `month`  string , `entity`  string , `card_brand`  string , `card_type`  string , `funded`  string , `percent`  string , `flat`  string , `count`  string , `txn`  string , `fee`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrixess-prod/raw/mms_processing_fees/2026-04-15/1776264239'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_mms_processing_fees"
]

hive_path: s3://sfdl-csv-payrixess-prod/raw/mms_processing_fees/2026-04-15/1776264239
id: 1715832
processed: 1

raw_data:

{
    "card_brand": 3,
    "card_type": 4,
    "count": 8,
    "entity": 2,
    "fee": 10,
    "flat": 7,
    "funded": 5,
    "month": 1,
    "percent": 6,
    "txn": 9,
    "year": 0
}

schema_attributes:

{
    "card_brand": "string",
    "card_type": "string",
    "count": "string",
    "entity": "string",
    "fee": "string",
    "flat": "string",
    "funded": "string",
    "month": "string",
    "percent": "string",
    "txn": "string",
    "year": "string"
}

schema_name_id: 1969
schema_scan_id: 162067333
updated: 2026-04-15 09:44:27

Version 1714634

created: 2026-04-14 09:47:04

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_mms_processing_fees`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrixess_mms_processing_fees`\n(\n `year`  string , `month`  string , `entity`  string , `card_brand`  string , `card_type`  string , `funded`  string , `percent`  string , `flat`  string , `count`  string , `txn`  string , `fee`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrixess-prod/raw/mms_processing_fees/2026-04-14/1776178018'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_mms_processing_fees"
]

hive_path: s3://sfdl-csv-payrixess-prod/raw/mms_processing_fees/2026-04-14/1776178018
id: 1714634
processed: 1

raw_data:

{
    "card_brand": 3,
    "card_type": 4,
    "count": 8,
    "entity": 2,
    "fee": 10,
    "flat": 7,
    "funded": 5,
    "month": 1,
    "percent": 6,
    "txn": 9,
    "year": 0
}

schema_attributes:

{
    "card_brand": "string",
    "card_type": "string",
    "count": "string",
    "entity": "string",
    "fee": "string",
    "flat": "string",
    "funded": "string",
    "month": "string",
    "percent": "string",
    "txn": "string",
    "year": "string"
}

schema_name_id: 1969
schema_scan_id: 162011664
updated: 2026-04-14 09:47:18

Version 1713440

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_mms_processing_fees`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrixess_mms_processing_fees`\n(\n `year`  string , `month`  string , `entity`  string , `card_brand`  string , `card_type`  string , `funded`  string , `percent`  string , `flat`  string , `count`  string , `txn`  string , `fee`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrixess-prod/raw/mms_processing_fees/2026-04-13/1776091766'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_mms_processing_fees"
]

hive_path: s3://sfdl-csv-payrixess-prod/raw/mms_processing_fees/2026-04-13/1776091766
id: 1713440
processed: 1

raw_data:

{
    "card_brand": 3,
    "card_type": 4,
    "count": 8,
    "entity": 2,
    "fee": 10,
    "flat": 7,
    "funded": 5,
    "month": 1,
    "percent": 6,
    "txn": 9,
    "year": 0
}

schema_attributes:

{
    "card_brand": "string",
    "card_type": "string",
    "count": "string",
    "entity": "string",
    "fee": "string",
    "flat": "string",
    "funded": "string",
    "month": "string",
    "percent": "string",
    "txn": "string",
    "year": "string"
}

schema_name_id: 1969
schema_scan_id: 161954286
updated: 2026-04-13 09:51:46

Version 1712230

created: 2026-04-12 09:36:14

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_mms_processing_fees`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrixess_mms_processing_fees`\n(\n `year`  string , `month`  string , `entity`  string , `card_brand`  string , `card_type`  string , `funded`  string , `percent`  string , `flat`  string , `count`  string , `txn`  string , `fee`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrixess-prod/raw/mms_processing_fees/2026-04-12/1776004558'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_mms_processing_fees"
]

hive_path: s3://sfdl-csv-payrixess-prod/raw/mms_processing_fees/2026-04-12/1776004558
id: 1712230
processed: 1

raw_data:

{
    "card_brand": 3,
    "card_type": 4,
    "count": 8,
    "entity": 2,
    "fee": 10,
    "flat": 7,
    "funded": 5,
    "month": 1,
    "percent": 6,
    "txn": 9,
    "year": 0
}

schema_attributes:

{
    "card_brand": "string",
    "card_type": "string",
    "count": "string",
    "entity": "string",
    "fee": "string",
    "flat": "string",
    "funded": "string",
    "month": "string",
    "percent": "string",
    "txn": "string",
    "year": "string"
}

schema_name_id: 1969
schema_scan_id: 161903571
updated: 2026-04-12 09:36:25

Version 1711016

created: 2026-04-11 09:29:26

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_mms_processing_fees`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrixess_mms_processing_fees`\n(\n `year`  string , `month`  string , `entity`  string , `card_brand`  string , `card_type`  string , `funded`  string , `percent`  string , `flat`  string , `count`  string , `txn`  string , `fee`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrixess-prod/raw/mms_processing_fees/2026-04-11/1775917761'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_mms_processing_fees"
]

hive_path: s3://sfdl-csv-payrixess-prod/raw/mms_processing_fees/2026-04-11/1775917761
id: 1711016
processed: 1

raw_data:

{
    "card_brand": 3,
    "card_type": 4,
    "count": 8,
    "entity": 2,
    "fee": 10,
    "flat": 7,
    "funded": 5,
    "month": 1,
    "percent": 6,
    "txn": 9,
    "year": 0
}

schema_attributes:

{
    "card_brand": "string",
    "card_type": "string",
    "count": "string",
    "entity": "string",
    "fee": "string",
    "flat": "string",
    "funded": "string",
    "month": "string",
    "percent": "string",
    "txn": "string",
    "year": "string"
}

schema_name_id: 1969
schema_scan_id: 161852010
updated: 2026-04-11 09:29:39

Version 1709839

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_mms_processing_fees`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrixess_mms_processing_fees`\n(\n `year`  string , `month`  string , `entity`  string , `card_brand`  string , `card_type`  string , `funded`  string , `percent`  string , `flat`  string , `count`  string , `txn`  string , `fee`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrixess-prod/raw/mms_processing_fees/2026-04-10/1775831325'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_mms_processing_fees"
]

hive_path: s3://sfdl-csv-payrixess-prod/raw/mms_processing_fees/2026-04-10/1775831325
id: 1709839
processed: 1

raw_data:

{
    "card_brand": 3,
    "card_type": 4,
    "count": 8,
    "entity": 2,
    "fee": 10,
    "flat": 7,
    "funded": 5,
    "month": 1,
    "percent": 6,
    "txn": 9,
    "year": 0
}

schema_attributes:

{
    "card_brand": "string",
    "card_type": "string",
    "count": "string",
    "entity": "string",
    "fee": "string",
    "flat": "string",
    "funded": "string",
    "month": "string",
    "percent": "string",
    "txn": "string",
    "year": "string"
}

schema_name_id: 1969
schema_scan_id: 161797297
updated: 2026-04-10 09:29:07

Version 1708711

created: 2026-04-09 09:47:47

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_mms_processing_fees`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrixess_mms_processing_fees`\n(\n `year`  string , `month`  string , `entity`  string , `card_brand`  string , `card_type`  string , `funded`  string , `percent`  string , `flat`  string , `count`  string , `txn`  string , `fee`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrixess-prod/raw/mms_processing_fees/2026-04-09/1775746044'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_mms_processing_fees"
]

hive_path: s3://sfdl-csv-payrixess-prod/raw/mms_processing_fees/2026-04-09/1775746044
id: 1708711
processed: 1

raw_data:

{
    "card_brand": 3,
    "card_type": 4,
    "count": 8,
    "entity": 2,
    "fee": 10,
    "flat": 7,
    "funded": 5,
    "month": 1,
    "percent": 6,
    "txn": 9,
    "year": 0
}

schema_attributes:

{
    "card_brand": "string",
    "card_type": "string",
    "count": "string",
    "entity": "string",
    "fee": "string",
    "flat": "string",
    "funded": "string",
    "month": "string",
    "percent": "string",
    "txn": "string",
    "year": "string"
}

schema_name_id: 1969
schema_scan_id: 161741747
updated: 2026-04-09 09:48:01

Version 1707549

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_mms_processing_fees`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrixess_mms_processing_fees`\n(\n `year`  string , `month`  string , `entity`  string , `card_brand`  string , `card_type`  string , `funded`  string , `percent`  string , `flat`  string , `count`  string , `txn`  string , `fee`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrixess-prod/raw/mms_processing_fees/2026-04-08/1775659904'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_mms_processing_fees"
]

hive_path: s3://sfdl-csv-payrixess-prod/raw/mms_processing_fees/2026-04-08/1775659904
id: 1707549
processed: 1

raw_data:

{
    "card_brand": 3,
    "card_type": 4,
    "count": 8,
    "entity": 2,
    "fee": 10,
    "flat": 7,
    "funded": 5,
    "month": 1,
    "percent": 6,
    "txn": 9,
    "year": 0
}

schema_attributes:

{
    "card_brand": "string",
    "card_type": "string",
    "count": "string",
    "entity": "string",
    "fee": "string",
    "flat": "string",
    "funded": "string",
    "month": "string",
    "percent": "string",
    "txn": "string",
    "year": "string"
}

schema_name_id: 1969
schema_scan_id: 161687409
updated: 2026-04-08 09:54:58

Version 1706333

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_mms_processing_fees`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrixess_mms_processing_fees`\n(\n `year`  string , `month`  string , `entity`  string , `card_brand`  string , `card_type`  string , `funded`  string , `percent`  string , `flat`  string , `count`  string , `txn`  string , `fee`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrixess-prod/raw/mms_processing_fees/2026-04-07/1775573078'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_mms_processing_fees"
]

hive_path: s3://sfdl-csv-payrixess-prod/raw/mms_processing_fees/2026-04-07/1775573078
id: 1706333
processed: 1

raw_data:

{
    "card_brand": 3,
    "card_type": 4,
    "count": 8,
    "entity": 2,
    "fee": 10,
    "flat": 7,
    "funded": 5,
    "month": 1,
    "percent": 6,
    "txn": 9,
    "year": 0
}

schema_attributes:

{
    "card_brand": "string",
    "card_type": "string",
    "count": "string",
    "entity": "string",
    "fee": "string",
    "flat": "string",
    "funded": "string",
    "month": "string",
    "percent": "string",
    "txn": "string",
    "year": "string"
}

schema_name_id: 1969
schema_scan_id: 161630610
updated: 2026-04-07 09:45:30

Version 1705114

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_mms_processing_fees`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrixess_mms_processing_fees`\n(\n `year`  string , `month`  string , `entity`  string , `card_brand`  string , `card_type`  string , `funded`  string , `percent`  string , `flat`  string , `count`  string , `txn`  string , `fee`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrixess-prod/raw/mms_processing_fees/2026-04-06/1775486634'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_mms_processing_fees"
]

hive_path: s3://sfdl-csv-payrixess-prod/raw/mms_processing_fees/2026-04-06/1775486634
id: 1705114
processed: 1

raw_data:

{
    "card_brand": 3,
    "card_type": 4,
    "count": 8,
    "entity": 2,
    "fee": 10,
    "flat": 7,
    "funded": 5,
    "month": 1,
    "percent": 6,
    "txn": 9,
    "year": 0
}

schema_attributes:

{
    "card_brand": "string",
    "card_type": "string",
    "count": "string",
    "entity": "string",
    "fee": "string",
    "flat": "string",
    "funded": "string",
    "month": "string",
    "percent": "string",
    "txn": "string",
    "year": "string"
}

schema_name_id: 1969
schema_scan_id: 161572943
updated: 2026-04-06 09:44:23

Version 1703891

created: 2026-04-05 09:47:10

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_mms_processing_fees`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrixess_mms_processing_fees`\n(\n `year`  string , `month`  string , `entity`  string , `card_brand`  string , `card_type`  string , `funded`  string , `percent`  string , `flat`  string , `count`  string , `txn`  string , `fee`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrixess-prod/raw/mms_processing_fees/2026-04-05/1775400413'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_mms_processing_fees"
]

hive_path: s3://sfdl-csv-payrixess-prod/raw/mms_processing_fees/2026-04-05/1775400413
id: 1703891
processed: 1

raw_data:

{
    "card_brand": 3,
    "card_type": 4,
    "count": 8,
    "entity": 2,
    "fee": 10,
    "flat": 7,
    "funded": 5,
    "month": 1,
    "percent": 6,
    "txn": 9,
    "year": 0
}

schema_attributes:

{
    "card_brand": "string",
    "card_type": "string",
    "count": "string",
    "entity": "string",
    "fee": "string",
    "flat": "string",
    "funded": "string",
    "month": "string",
    "percent": "string",
    "txn": "string",
    "year": "string"
}

schema_name_id: 1969
schema_scan_id: 161524027
updated: 2026-04-05 09:47:21

Version 1702725

created: 2026-04-04 09:40:02

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_mms_processing_fees`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrixess_mms_processing_fees`\n(\n `year`  string , `month`  string , `entity`  string , `card_brand`  string , `card_type`  string , `funded`  string , `percent`  string , `flat`  string , `count`  string , `txn`  string , `fee`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrixess-prod/raw/mms_processing_fees/2026-04-04/1775313597'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_mms_processing_fees"
]

hive_path: s3://sfdl-csv-payrixess-prod/raw/mms_processing_fees/2026-04-04/1775313597
id: 1702725
processed: 1

raw_data:

{
    "card_brand": 3,
    "card_type": 4,
    "count": 8,
    "entity": 2,
    "fee": 10,
    "flat": 7,
    "funded": 5,
    "month": 1,
    "percent": 6,
    "txn": 9,
    "year": 0
}

schema_attributes:

{
    "card_brand": "string",
    "card_type": "string",
    "count": "string",
    "entity": "string",
    "fee": "string",
    "flat": "string",
    "funded": "string",
    "month": "string",
    "percent": "string",
    "txn": "string",
    "year": "string"
}

schema_name_id: 1969
schema_scan_id: 161471798
updated: 2026-04-04 09:40:13

Version 1701529

created: 2026-04-03 09:36:43

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_mms_processing_fees`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrixess_mms_processing_fees`\n(\n `year`  string , `month`  string , `entity`  string , `card_brand`  string , `card_type`  string , `funded`  string , `percent`  string , `flat`  string , `count`  string , `txn`  string , `fee`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrixess-prod/raw/mms_processing_fees/2026-04-03/1775226985'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_mms_processing_fees"
]

hive_path: s3://sfdl-csv-payrixess-prod/raw/mms_processing_fees/2026-04-03/1775226985
id: 1701529
processed: 1

raw_data:

{
    "card_brand": 3,
    "card_type": 4,
    "count": 8,
    "entity": 2,
    "fee": 10,
    "flat": 7,
    "funded": 5,
    "month": 1,
    "percent": 6,
    "txn": 9,
    "year": 0
}

schema_attributes:

{
    "card_brand": "string",
    "card_type": "string",
    "count": "string",
    "entity": "string",
    "fee": "string",
    "flat": "string",
    "funded": "string",
    "month": "string",
    "percent": "string",
    "txn": "string",
    "year": "string"
}

schema_name_id: 1969
schema_scan_id: 161414424
updated: 2026-04-03 09:36:54

Schema Scans: 15

Last at 2026-04-17 09:28:19

Scan 162178372

duration: 0:00:14.459986

exit_message:

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

id: 162178372

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/mms_processing_fees/2026-04-17/1776436093",
        "key": "raw/mms_processing_fees/2026-04-17/1776436093/36780201-f66f-480e-9b02-79eaf8ab23a8.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_mms_processing_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 12715147989966678511,
        "service_name": "drive-thru",
        "span_id": 2073529659660088250,
        "trace_id": 7171366634946626305
    }
}

running: False
schema_name_id: 1969
start_time: 2026-04-17 09:28:19
success: True
trace_id: 7171366634946626305

Scan 162122987

duration: 0:00:11.802803

exit_message:

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

id: 162122987

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/mms_processing_fees/2026-04-16/1776350799",
        "key": "raw/mms_processing_fees/2026-04-16/1776350799/c82353b6-faff-47b6-85d3-717bb4aec62e.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_mms_processing_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 14294233642004034199,
        "service_name": "drive-thru",
        "span_id": 3100988630593780614,
        "trace_id": 4287372930774614979
    }
}

running: False
schema_name_id: 1969
start_time: 2026-04-16 09:46:44
success: True
trace_id: 4287372930774614979

Scan 162067333

duration: 0:00:11.957486

exit_message:

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

id: 162067333

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/mms_processing_fees/2026-04-15/1776264239",
        "key": "raw/mms_processing_fees/2026-04-15/1776264239/4c05d2e6-0fea-4c23-9ff7-db6b058c0389.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_mms_processing_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 9119190397409980911,
        "service_name": "drive-thru",
        "span_id": 5750248562902965940,
        "trace_id": 18216619382929262869
    }
}

running: False
schema_name_id: 1969
start_time: 2026-04-15 09:44:15
success: True
trace_id: 18216619382929262869

Scan 162011664

duration: 0:00:14.452266

exit_message:

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

id: 162011664

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/mms_processing_fees/2026-04-14/1776178018",
        "key": "raw/mms_processing_fees/2026-04-14/1776178018/2a8caf56-2744-464f-ab08-9511123602f0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_mms_processing_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 10790639133287370247,
        "service_name": "drive-thru",
        "span_id": 12926271729805611428,
        "trace_id": 16081510505417468695
    }
}

running: False
schema_name_id: 1969
start_time: 2026-04-14 09:47:04
success: True
trace_id: 16081510505417468695

Scan 161954286

duration: 0:00:12.053765

exit_message:

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

id: 161954286

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/mms_processing_fees/2026-04-13/1776091766",
        "key": "raw/mms_processing_fees/2026-04-13/1776091766/a3cccd28-f11c-4bcd-aa34-75e4281e0cd3.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_mms_processing_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 12911100431805083851,
        "service_name": "drive-thru",
        "span_id": 5131258822676395335,
        "trace_id": 17721109743346909583
    }
}

running: False
schema_name_id: 1969
start_time: 2026-04-13 09:51:34
success: True
trace_id: 17721109743346909583

Scan 161903571

duration: 0:00:11.885339

exit_message:

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

id: 161903571

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/mms_processing_fees/2026-04-12/1776004558",
        "key": "raw/mms_processing_fees/2026-04-12/1776004558/1384873a-70d9-444a-9750-f5f04ca87880.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_mms_processing_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 18157119002776775285,
        "service_name": "drive-thru",
        "span_id": 18404279825765773341,
        "trace_id": 10345076423970474689
    }
}

running: False
schema_name_id: 1969
start_time: 2026-04-12 09:36:13
success: True
trace_id: 10345076423970474689

Scan 161852010

duration: 0:00:14.314198

exit_message:

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

id: 161852010

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/mms_processing_fees/2026-04-11/1775917761",
        "key": "raw/mms_processing_fees/2026-04-11/1775917761/fbb3918e-8a33-40d2-991d-e0b6023f3195.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_mms_processing_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 13965081725792982177,
        "service_name": "drive-thru",
        "span_id": 6366246523701649670,
        "trace_id": 6749954528024366897
    }
}

running: False
schema_name_id: 1969
start_time: 2026-04-11 09:29:25
success: True
trace_id: 6749954528024366897

Scan 161797297

duration: 0:00:12.002801

exit_message:

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

id: 161797297

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/mms_processing_fees/2026-04-10/1775831325",
        "key": "raw/mms_processing_fees/2026-04-10/1775831325/c5add4d4-fa7c-46e5-a8a5-07b1d17942fd.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_mms_processing_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 14909115820898357800,
        "service_name": "drive-thru",
        "span_id": 2874797097322484923,
        "trace_id": 10717700188575681648
    }
}

running: False
schema_name_id: 1969
start_time: 2026-04-10 09:28:55
success: True
trace_id: 10717700188575681648

Scan 161741747

duration: 0:00:14.684730

exit_message:

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

id: 161741747

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/mms_processing_fees/2026-04-09/1775746044",
        "key": "raw/mms_processing_fees/2026-04-09/1775746044/b9c3a404-ebad-41ef-9683-18480a177b42.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_mms_processing_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 241447507658040883,
        "service_name": "drive-thru",
        "span_id": 3131174325876716152,
        "trace_id": 12377977618040858991
    }
}

running: False
schema_name_id: 1969
start_time: 2026-04-09 09:47:47
success: True
trace_id: 12377977618040858991

Scan 161687409

duration: 0:00:11.946910

exit_message:

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

id: 161687409

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/mms_processing_fees/2026-04-08/1775659904",
        "key": "raw/mms_processing_fees/2026-04-08/1775659904/71ea591a-bce4-45c6-b4ff-0b1619be7ac8.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_mms_processing_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 12364587086651530975,
        "service_name": "drive-thru",
        "span_id": 14580003214122975704,
        "trace_id": 4201715087584288587
    }
}

running: False
schema_name_id: 1969
start_time: 2026-04-08 09:54:46
success: True
trace_id: 4201715087584288587

Scan 161630610

duration: 0:00:14.568400

exit_message:

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

id: 161630610

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/mms_processing_fees/2026-04-07/1775573078",
        "key": "raw/mms_processing_fees/2026-04-07/1775573078/6fdf4fb7-d38e-4565-af51-d99c3ed92423.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_mms_processing_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 7997037818422583031,
        "service_name": "drive-thru",
        "span_id": 741649278577956191,
        "trace_id": 3029453645983987757
    }
}

running: False
schema_name_id: 1969
start_time: 2026-04-07 09:45:16
success: True
trace_id: 3029453645983987757

Scan 161572943

duration: 0:00:12.015958

exit_message:

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

id: 161572943

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/mms_processing_fees/2026-04-06/1775486634",
        "key": "raw/mms_processing_fees/2026-04-06/1775486634/3c0a0599-0025-4f44-b9f6-7bfd517a5daf.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_mms_processing_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 4609425690279908871,
        "service_name": "drive-thru",
        "span_id": 5063479613156058274,
        "trace_id": 18061787829788658269
    }
}

running: False
schema_name_id: 1969
start_time: 2026-04-06 09:44:11
success: True
trace_id: 18061787829788658269

Scan 161524027

duration: 0:00:11.919678

exit_message:

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

id: 161524027

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/mms_processing_fees/2026-04-05/1775400413",
        "key": "raw/mms_processing_fees/2026-04-05/1775400413/65061eb8-7db7-49f4-9c87-7d8969e1a61a.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_mms_processing_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 15146109844377715585,
        "service_name": "drive-thru",
        "span_id": 9278856992135679094,
        "trace_id": 11185334379187061380
    }
}

running: False
schema_name_id: 1969
start_time: 2026-04-05 09:47:09
success: True
trace_id: 11185334379187061380

Scan 161471798

duration: 0:00:12.151286

exit_message:

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

id: 161471798

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/mms_processing_fees/2026-04-04/1775313597",
        "key": "raw/mms_processing_fees/2026-04-04/1775313597/43b345de-d470-4f5b-b7e9-fa997bd18a1c.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_mms_processing_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 2864218566764867515,
        "service_name": "drive-thru",
        "span_id": 18334650209368599855,
        "trace_id": 5876288078955798731
    }
}

running: False
schema_name_id: 1969
start_time: 2026-04-04 09:40:01
success: True
trace_id: 5876288078955798731

Scan 161414424

duration: 0:00:11.940112

exit_message:

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

id: 161414424

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/mms_processing_fees/2026-04-03/1775226985",
        "key": "raw/mms_processing_fees/2026-04-03/1775226985/e155bcc8-09ae-40ca-a83c-c447986a08ae.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_mms_processing_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 6557311303338785382,
        "service_name": "drive-thru",
        "span_id": 2473616924956722149,
        "trace_id": 15909343904052667374
    }
}

running: False
schema_name_id: 1969
start_time: 2026-04-03 09:36:42
success: True
trace_id: 15909343904052667374

Partitions:

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

Schema:

attributes:

{
    "card_brand": "string",
    "card_type": "string",
    "count": "string",
    "entity": "string",
    "fee": "string",
    "flat": "string",
    "funded": "string",
    "month": "string",
    "percent": "string",
    "txn": "string",
    "year": "string"
}

created: 2026-04-17 09:28:20

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrixess_mms_processing_fees`\n(\n `year`  string , `month`  string , `entity`  string , `card_brand`  string , `card_type`  string , `funded`  string , `percent`  string , `flat`  string , `count`  string , `txn`  string , `fee`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrixess-prod/raw/mms_processing_fees/2026-04-17/1776436093'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_mms_processing_fees`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_mms_processing_fees"
}

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-24 10:22:27",
        "disabled": false,
        "format": "raw",
        "id": 1969,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_csv",
            "table": "payrixess_mms_processing_fees"
        },
        "type": "csv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "card_brand": "string",
            "card_type": "string",
            "count": "string",
            "entity": "string",
            "fee": "string",
            "flat": "string",
            "funded": "string",
            "month": "string",
            "percent": "string",
            "txn": "string",
            "year": "string"
        },
        "created": "2026-04-17 09:28:20",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrixess_mms_processing_fees`\n(\n `year`  string , `month`  string , `entity`  string , `card_brand`  string , `card_type`  string , `funded`  string , `percent`  string , `flat`  string , `count`  string , `txn`  string , `fee`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrixess-prod/raw/mms_processing_fees/2026-04-17/1776436093'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_mms_processing_fees`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_mms_processing_fees"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}