Schema Info

Schema Name: sfdl_dev_csv.payrix_mms_processing_fees

created: 2024-07-03 14:00:59
disabled: False
format: raw
id: 2309
is_partitioned: False
is_schema_datatyped: True

name:

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

type: csv

Schema Versions: 15

Version 4773341

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-dev/raw/mms_processing_fees/2026-04-17/1776436398
id: 4773341
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: 2309
schema_scan_id: 6867678
updated: 2026-04-17 09:34:20

Version 4773301

created: 2026-04-16 09:50:23

ddl:

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

hive_path: s3://sfdl-csv-payrix-dev/raw/mms_processing_fees/2026-04-16/1776351005
id: 4773301
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: 2309
schema_scan_id: 6867543
updated: 2026-04-16 09:50:37

Version 4773222

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-dev/raw/mms_processing_fees/2026-04-15/1776263976
id: 4773222
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: 2309
schema_scan_id: 6867175
updated: 2026-04-15 09:40:18

Version 4773183

created: 2026-04-14 10:04:20

ddl:

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

hive_path: s3://sfdl-csv-payrix-dev/raw/mms_processing_fees/2026-04-14/1776179022
id: 4773183
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: 2309
schema_scan_id: 6867012
updated: 2026-04-14 10:04:34

Version 4773096

created: 2026-04-13 09:30:10

ddl:

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

hive_path: s3://sfdl-csv-payrix-dev/raw/mms_processing_fees/2026-04-13/1776090594
id: 4773096
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: 2309
schema_scan_id: 6866584
updated: 2026-04-13 09:30:21

Version 4773066

created: 2026-04-12 09:47:51

ddl:

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

hive_path: s3://sfdl-csv-payrix-dev/raw/mms_processing_fees/2026-04-12/1776005231
id: 4773066
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: 2309
schema_scan_id: 6866500
updated: 2026-04-12 09:48:02

Version 4772998

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-dev/raw/mms_processing_fees/2026-04-11/1775917769
id: 4772998
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: 2309
schema_scan_id: 6866249
updated: 2026-04-11 09:30:23

Version 4772939

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-dev/raw/mms_processing_fees/2026-04-10/1775831295
id: 4772939
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: 2309
schema_scan_id: 6865989
updated: 2026-04-10 09:28:42

Version 4772889

created: 2026-04-09 09:48:07

ddl:

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

hive_path: s3://sfdl-csv-payrix-dev/raw/mms_processing_fees/2026-04-09/1775746071
id: 4772889
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: 2309
schema_scan_id: 6865806
updated: 2026-04-09 09:48:18

Version 4772833

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-dev/raw/mms_processing_fees/2026-04-08/1775659409
id: 4772833
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: 2309
schema_scan_id: 6865514
updated: 2026-04-08 09:44:21

Version 4772763

created: 2026-04-07 09:34:34

ddl:

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

hive_path: s3://sfdl-csv-payrix-dev/raw/mms_processing_fees/2026-04-07/1775572456
id: 4772763
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: 2309
schema_scan_id: 6865256
updated: 2026-04-07 09:34:45

Version 4772697

created: 2026-04-06 09:32:21

ddl:

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

hive_path: s3://sfdl-csv-payrix-dev/raw/mms_processing_fees/2026-04-06/1775485933
id: 4772697
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: 2309
schema_scan_id: 6864845
updated: 2026-04-06 09:32:34

Version 4772649

created: 2026-04-05 09:37:46

ddl:

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

hive_path: s3://sfdl-csv-payrix-dev/raw/mms_processing_fees/2026-04-05/1775399846
id: 4772649
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: 2309
schema_scan_id: 6864670
updated: 2026-04-05 09:37:59

Version 4772598

created: 2026-04-04 09:32:46

ddl:

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

hive_path: s3://sfdl-csv-payrix-dev/raw/mms_processing_fees/2026-04-04/1775313152
id: 4772598
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: 2309
schema_scan_id: 6864478
updated: 2026-04-04 09:32:57

Version 4772561

created: 2026-04-03 10:03:25

ddl:

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

hive_path: s3://sfdl-csv-payrix-dev/raw/mms_processing_fees/2026-04-03/1775228560
id: 4772561
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: 2309
schema_scan_id: 6864350
updated: 2026-04-03 10:03:39

Schema Scans: 15

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

Scan 6867678

duration: 0:00:14.458132

exit_message:

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

id: 6867678

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/mms_processing_fees/2026-04-17/1776436398",
        "key": "raw/mms_processing_fees/2026-04-17/1776436398/ce2cd532-a81d-4a07-bb23-877f1578bc16.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_mms_processing_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 7184501480234883310,
        "service_name": "drive-thru",
        "span_id": 2042674009409056336,
        "trace_id": 10647111470045726430
    }
}

running: False
schema_name_id: 2309
start_time: 2026-04-17 09:34:06
success: True
trace_id: 10647111470045726430

Scan 6867543

duration: 0:00:14.685926

exit_message:

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

id: 6867543

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/mms_processing_fees/2026-04-16/1776351005",
        "key": "raw/mms_processing_fees/2026-04-16/1776351005/2c7579f0-b24b-4f3d-aba7-77d4c6b1554a.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_mms_processing_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 18435458025777256732,
        "service_name": "drive-thru",
        "span_id": 8807252900603279325,
        "trace_id": 17137377803182480006
    }
}

running: False
schema_name_id: 2309
start_time: 2026-04-16 09:50:23
success: True
trace_id: 17137377803182480006

Scan 6867175

duration: 0:00:14.692987

exit_message:

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

id: 6867175

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/mms_processing_fees/2026-04-15/1776263976",
        "key": "raw/mms_processing_fees/2026-04-15/1776263976/3aa6c254-a549-404c-b43a-7d69b021aa63.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_mms_processing_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 1397403416170398969,
        "service_name": "drive-thru",
        "span_id": 4200730107040043052,
        "trace_id": 4159971374921816180
    }
}

running: False
schema_name_id: 2309
start_time: 2026-04-15 09:40:03
success: True
trace_id: 4159971374921816180

Scan 6867012

duration: 0:00:14.665038

exit_message:

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

id: 6867012

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/mms_processing_fees/2026-04-14/1776179022",
        "key": "raw/mms_processing_fees/2026-04-14/1776179022/b26a9343-a1c3-4023-b35d-f4f91d8b458f.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_mms_processing_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 11287855762035526372,
        "service_name": "drive-thru",
        "span_id": 5858031206834653587,
        "trace_id": 9264760322564405608
    }
}

running: False
schema_name_id: 2309
start_time: 2026-04-14 10:04:20
success: True
trace_id: 9264760322564405608

Scan 6866584

duration: 0:00:12.205665

exit_message:

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

id: 6866584

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/mms_processing_fees/2026-04-13/1776090594",
        "key": "raw/mms_processing_fees/2026-04-13/1776090594/dbfb8501-79b2-4039-adf3-71863650caf1.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_mms_processing_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 2989643408249196248,
        "service_name": "drive-thru",
        "span_id": 5499782586283107508,
        "trace_id": 4742819235460162943
    }
}

running: False
schema_name_id: 2309
start_time: 2026-04-13 09:30:09
success: True
trace_id: 4742819235460162943

Scan 6866500

duration: 0:00:11.931543

exit_message:

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

id: 6866500

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/mms_processing_fees/2026-04-12/1776005231",
        "key": "raw/mms_processing_fees/2026-04-12/1776005231/593dc372-29e4-4277-8d95-4a540261ec26.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_mms_processing_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 7685290778069134841,
        "service_name": "drive-thru",
        "span_id": 1097741267809418100,
        "trace_id": 6509120651042896232
    }
}

running: False
schema_name_id: 2309
start_time: 2026-04-12 09:47:50
success: True
trace_id: 6509120651042896232

Scan 6866249

duration: 0:00:11.903655

exit_message:

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

id: 6866249

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/mms_processing_fees/2026-04-11/1775917769",
        "key": "raw/mms_processing_fees/2026-04-11/1775917769/d45842cc-7c9c-4b16-aca1-70b2537814a8.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_mms_processing_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 4512216762143756690,
        "service_name": "drive-thru",
        "span_id": 13105952947961492283,
        "trace_id": 12243866627529703747
    }
}

running: False
schema_name_id: 2309
start_time: 2026-04-11 09:30:11
success: True
trace_id: 12243866627529703747

Scan 6865989

duration: 0:00:12.078754

exit_message:

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

id: 6865989

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/mms_processing_fees/2026-04-10/1775831295",
        "key": "raw/mms_processing_fees/2026-04-10/1775831295/0c56c363-6cf9-4bd7-8a36-42ffbefbcc24.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_mms_processing_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 1546327871997784226,
        "service_name": "drive-thru",
        "span_id": 9011889109605031521,
        "trace_id": 5091592901805493615
    }
}

running: False
schema_name_id: 2309
start_time: 2026-04-10 09:28:30
success: True
trace_id: 5091592901805493615

Scan 6865806

duration: 0:00:12.036381

exit_message:

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

id: 6865806

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/mms_processing_fees/2026-04-09/1775746071",
        "key": "raw/mms_processing_fees/2026-04-09/1775746071/5d4b7964-8ae9-42f5-8e3a-510f40ad4335.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_mms_processing_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 1072865695963797512,
        "service_name": "drive-thru",
        "span_id": 14139860115697992590,
        "trace_id": 9286877593214388072
    }
}

running: False
schema_name_id: 2309
start_time: 2026-04-09 09:48:06
success: True
trace_id: 9286877593214388072

Scan 6865514

duration: 0:00:39.964410

exit_message:

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

id: 6865514

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/mms_processing_fees/2026-04-08/1775659409",
        "key": "raw/mms_processing_fees/2026-04-08/1775659409/c37b2a1d-19d6-4f6a-8bbd-5afb43d9375e.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_mms_processing_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 14894148652886012297,
        "service_name": "drive-thru",
        "span_id": 7413541757182238906,
        "trace_id": 2375192365103213694
    }
}

running: False
schema_name_id: 2309
start_time: 2026-04-08 09:43:41
success: True
trace_id: 2375192365103213694

Scan 6865256

duration: 0:00:12.125139

exit_message:

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

id: 6865256

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/mms_processing_fees/2026-04-07/1775572456",
        "key": "raw/mms_processing_fees/2026-04-07/1775572456/89d9e27e-276d-473b-a2ba-1d52b3ad87c2.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_mms_processing_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 9880328849218420491,
        "service_name": "drive-thru",
        "span_id": 7324608675859311819,
        "trace_id": 3714474332702848464
    }
}

running: False
schema_name_id: 2309
start_time: 2026-04-07 09:34:33
success: True
trace_id: 3714474332702848464

Scan 6864845

duration: 0:00:14.520365

exit_message:

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

id: 6864845

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/mms_processing_fees/2026-04-06/1775485933",
        "key": "raw/mms_processing_fees/2026-04-06/1775485933/1450054e-de85-434e-bf92-c383f79766fa.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_mms_processing_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 7443450501579193343,
        "service_name": "drive-thru",
        "span_id": 6349354871027149921,
        "trace_id": 18168682117271681791
    }
}

running: False
schema_name_id: 2309
start_time: 2026-04-06 09:32:20
success: True
trace_id: 18168682117271681791

Scan 6864670

duration: 0:00:14.374525

exit_message:

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

id: 6864670

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/mms_processing_fees/2026-04-05/1775399846",
        "key": "raw/mms_processing_fees/2026-04-05/1775399846/729ca297-3228-4bd3-b9a7-19c9d58a833f.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_mms_processing_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 5811970089062127044,
        "service_name": "drive-thru",
        "span_id": 3764599120298260435,
        "trace_id": 17489741577909404638
    }
}

running: False
schema_name_id: 2309
start_time: 2026-04-05 09:37:45
success: True
trace_id: 17489741577909404638

Scan 6864478

duration: 0:00:11.890450

exit_message:

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

id: 6864478

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/mms_processing_fees/2026-04-04/1775313152",
        "key": "raw/mms_processing_fees/2026-04-04/1775313152/1cf930c3-63d5-48bd-9abc-b30b236d4d42.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_mms_processing_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 10786411888402146336,
        "service_name": "drive-thru",
        "span_id": 10805190027420139026,
        "trace_id": 18172454668261554138
    }
}

running: False
schema_name_id: 2309
start_time: 2026-04-04 09:32:45
success: True
trace_id: 18172454668261554138

Scan 6864350

duration: 0:00:14.649165

exit_message:

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

id: 6864350

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/mms_processing_fees/2026-04-03/1775228560",
        "key": "raw/mms_processing_fees/2026-04-03/1775228560/c56e09b2-027a-4830-bf15-3cd946c5acec.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_mms_processing_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 7298695070693225937,
        "service_name": "drive-thru",
        "span_id": 1053607270265231777,
        "trace_id": 11913893028568480080
    }
}

running: False
schema_name_id: 2309
start_time: 2026-04-03 10:03:25
success: True
trace_id: 11913893028568480080

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:34:06

ddl:

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

Server:

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

Raw:

{
    "name": {
        "created": "2024-07-03 14:00:59",
        "disabled": false,
        "format": "raw",
        "id": 2309,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_csv",
            "table": "payrix_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:34:06",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrix_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-payrix-dev/raw/mms_processing_fees/2026-04-17/1776436398'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_csv.payrix_mms_processing_fees`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_csv.payrix_mms_processing_fees"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}