Schema Info

Schema Name: sfdl_stage_csv.payrix_mms_processing_fees

created: 2024-07-08 15:33:28
disabled: False
format: raw
id: 2118
is_partitioned: False
is_schema_datatyped: True

name:

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

type: csv

Schema Versions: 15

Version 906714

created: 2026-04-17 09:42:15

ddl:

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

hive_path: s3://sfdl-csv-payrix-stage/raw/mms_processing_fees/2026-04-17/1776436922
id: 906714
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: 2118
schema_scan_id: 6415468
updated: 2026-04-17 09:42:29

Version 906482

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-stage/raw/mms_processing_fees/2026-04-16/1776350160
id: 906482
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: 2118
schema_scan_id: 6414867
updated: 2026-04-16 09:36:35

Version 906288

created: 2026-04-15 09:47:58

ddl:

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

hive_path: s3://sfdl-csv-payrix-stage/raw/mms_processing_fees/2026-04-15/1776264464
id: 906288
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: 2118
schema_scan_id: 6414436
updated: 2026-04-15 09:48:09

Version 906062

created: 2026-04-14 09:39:18

ddl:

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

hive_path: s3://sfdl-csv-payrix-stage/raw/mms_processing_fees/2026-04-14/1776177550
id: 906062
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: 2118
schema_scan_id: 6413931
updated: 2026-04-14 09:39:29

Version 905830

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-stage/raw/mms_processing_fees/2026-04-13/1776090585
id: 905830
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: 2118
schema_scan_id: 6413254
updated: 2026-04-13 09:30:12

Version 905643

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-stage/raw/mms_processing_fees/2026-04-12/1776004996
id: 905643
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: 2118
schema_scan_id: 6412928
updated: 2026-04-12 09:43:35

Version 905445

created: 2026-04-11 09:44:47

ddl:

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

hive_path: s3://sfdl-csv-payrix-stage/raw/mms_processing_fees/2026-04-11/1775918680
id: 905445
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: 2118
schema_scan_id: 6412563
updated: 2026-04-11 09:45:01

Version 905237

created: 2026-04-10 09:45:09

ddl:

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

hive_path: s3://sfdl-csv-payrix-stage/raw/mms_processing_fees/2026-04-10/1775832234
id: 905237
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: 2118
schema_scan_id: 6412119
updated: 2026-04-10 09:45:23

Version 905006

created: 2026-04-09 09:39:33

ddl:

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

hive_path: s3://sfdl-csv-payrix-stage/raw/mms_processing_fees/2026-04-09/1775745553
id: 905006
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: 2118
schema_scan_id: 6411518
updated: 2026-04-09 09:39:44

Version 904789

created: 2026-04-08 09:32:51

ddl:

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

hive_path: s3://sfdl-csv-payrix-stage/raw/mms_processing_fees/2026-04-08/1775658749
id: 904789
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: 2118
schema_scan_id: 6411044
updated: 2026-04-08 09:33:05

Version 904577

created: 2026-04-07 09:37:37

ddl:

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

hive_path: s3://sfdl-csv-payrix-stage/raw/mms_processing_fees/2026-04-07/1775572648
id: 904577
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: 2118
schema_scan_id: 6410522
updated: 2026-04-07 09:37:51

Version 904373

created: 2026-04-06 09:35:33

ddl:

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

hive_path: s3://sfdl-csv-payrix-stage/raw/mms_processing_fees/2026-04-06/1775486115
id: 904373
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: 2118
schema_scan_id: 6410041
updated: 2026-04-06 09:35:44

Version 904152

created: 2026-04-05 09:29:29

ddl:

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

hive_path: s3://sfdl-csv-payrix-stage/raw/mms_processing_fees/2026-04-05/1775399359
id: 904152
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: 2118
schema_scan_id: 6409522
updated: 2026-04-05 09:29:40

Version 903960

created: 2026-04-04 09:41:03

ddl:

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

hive_path: s3://sfdl-csv-payrix-stage/raw/mms_processing_fees/2026-04-04/1775313657
id: 903960
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: 2118
schema_scan_id: 6409182
updated: 2026-04-04 09:41:15

Version 903768

created: 2026-04-03 10:06:35

ddl:

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

hive_path: s3://sfdl-csv-payrix-stage/raw/mms_processing_fees/2026-04-03/1775228773
id: 903768
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: 2118
schema_scan_id: 6408798
updated: 2026-04-03 10:06:47

Schema Scans: 15

Last at 2026-04-17 09:42:15

Scan 6415468

duration: 0:00:14.611065

exit_message:

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

id: 6415468

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-stage",
        "hive_path": "s3://sfdl-csv-payrix-stage/raw/mms_processing_fees/2026-04-17/1776436922",
        "key": "raw/mms_processing_fees/2026-04-17/1776436922/5879dd0d-e0f2-470e-b61d-7477512cc451.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrix_mms_processing_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 4279869870442877326,
        "service_name": "drive-thru",
        "span_id": 12128039099181232120,
        "trace_id": 9271970196222740181
    }
}

running: False
schema_name_id: 2118
start_time: 2026-04-17 09:42:15
success: True
trace_id: 9271970196222740181

Scan 6414867

duration: 0:00:12.105690

exit_message:

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

id: 6414867

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-stage",
        "hive_path": "s3://sfdl-csv-payrix-stage/raw/mms_processing_fees/2026-04-16/1776350160",
        "key": "raw/mms_processing_fees/2026-04-16/1776350160/d493ea8b-d366-4743-9bc7-3b5b3d10b842.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrix_mms_processing_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 213726423696110101,
        "service_name": "drive-thru",
        "span_id": 9993308664377399480,
        "trace_id": 5682145855129812103
    }
}

running: False
schema_name_id: 2118
start_time: 2026-04-16 09:36:23
success: True
trace_id: 5682145855129812103

Scan 6414436

duration: 0:00:11.914266

exit_message:

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

id: 6414436

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-stage",
        "hive_path": "s3://sfdl-csv-payrix-stage/raw/mms_processing_fees/2026-04-15/1776264464",
        "key": "raw/mms_processing_fees/2026-04-15/1776264464/e0c0f5aa-4eac-477b-ac1a-cbb17898117a.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrix_mms_processing_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 8821214902142994070,
        "service_name": "drive-thru",
        "span_id": 17317278686037703874,
        "trace_id": 13264450962910391528
    }
}

running: False
schema_name_id: 2118
start_time: 2026-04-15 09:47:58
success: True
trace_id: 13264450962910391528

Scan 6413931

duration: 0:00:11.948291

exit_message:

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

id: 6413931

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-stage",
        "hive_path": "s3://sfdl-csv-payrix-stage/raw/mms_processing_fees/2026-04-14/1776177550",
        "key": "raw/mms_processing_fees/2026-04-14/1776177550/f677a6d7-7bf1-4240-9e5a-cf4143dd606c.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrix_mms_processing_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 3761694235859293412,
        "service_name": "drive-thru",
        "span_id": 5036214576876564895,
        "trace_id": 15776517533509496500
    }
}

running: False
schema_name_id: 2118
start_time: 2026-04-14 09:39:17
success: True
trace_id: 15776517533509496500

Scan 6413254

duration: 0:00:12.096831

exit_message:

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

id: 6413254

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-stage",
        "hive_path": "s3://sfdl-csv-payrix-stage/raw/mms_processing_fees/2026-04-13/1776090585",
        "key": "raw/mms_processing_fees/2026-04-13/1776090585/52f3d580-e8d8-4170-9cfb-eff89b1c179b.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrix_mms_processing_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 2344103958998434253,
        "service_name": "drive-thru",
        "span_id": 12672114362646589167,
        "trace_id": 5553393296149831427
    }
}

running: False
schema_name_id: 2118
start_time: 2026-04-13 09:30:00
success: True
trace_id: 5553393296149831427

Scan 6412928

duration: 0:00:11.829722

exit_message:

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

id: 6412928

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-stage",
        "hive_path": "s3://sfdl-csv-payrix-stage/raw/mms_processing_fees/2026-04-12/1776004996",
        "key": "raw/mms_processing_fees/2026-04-12/1776004996/514b2d95-7650-488e-901d-91ad4aa8390b.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrix_mms_processing_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 11869998022065674195,
        "service_name": "drive-thru",
        "span_id": 1994403221781253876,
        "trace_id": 2976606218188817209
    }
}

running: False
schema_name_id: 2118
start_time: 2026-04-12 09:43:23
success: True
trace_id: 2976606218188817209

Scan 6412563

duration: 0:00:14.438468

exit_message:

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

id: 6412563

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-stage",
        "hive_path": "s3://sfdl-csv-payrix-stage/raw/mms_processing_fees/2026-04-11/1775918680",
        "key": "raw/mms_processing_fees/2026-04-11/1775918680/5534fe29-f08b-4074-89ba-7b9923f4959c.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrix_mms_processing_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 9622282155859732604,
        "service_name": "drive-thru",
        "span_id": 7069684513947684380,
        "trace_id": 8127036966594387893
    }
}

running: False
schema_name_id: 2118
start_time: 2026-04-11 09:44:47
success: True
trace_id: 8127036966594387893

Scan 6412119

duration: 0:00:14.541713

exit_message:

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

id: 6412119

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-stage",
        "hive_path": "s3://sfdl-csv-payrix-stage/raw/mms_processing_fees/2026-04-10/1775832234",
        "key": "raw/mms_processing_fees/2026-04-10/1775832234/a49ed1cf-f16b-4df8-922b-13df65684081.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrix_mms_processing_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 16394615693992019273,
        "service_name": "drive-thru",
        "span_id": 14561090639484183882,
        "trace_id": 14873390082050976136
    }
}

running: False
schema_name_id: 2118
start_time: 2026-04-10 09:45:08
success: True
trace_id: 14873390082050976136

Scan 6411518

duration: 0:00:12.105310

exit_message:

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

id: 6411518

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-stage",
        "hive_path": "s3://sfdl-csv-payrix-stage/raw/mms_processing_fees/2026-04-09/1775745553",
        "key": "raw/mms_processing_fees/2026-04-09/1775745553/830a2f48-a789-45d4-a44e-40a848a1742b.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrix_mms_processing_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 4329283879641890424,
        "service_name": "drive-thru",
        "span_id": 5116224760517712744,
        "trace_id": 1220193993332150349
    }
}

running: False
schema_name_id: 2118
start_time: 2026-04-09 09:39:32
success: True
trace_id: 1220193993332150349

Scan 6411044

duration: 0:00:14.545733

exit_message:

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

id: 6411044

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-stage",
        "hive_path": "s3://sfdl-csv-payrix-stage/raw/mms_processing_fees/2026-04-08/1775658749",
        "key": "raw/mms_processing_fees/2026-04-08/1775658749/6d737d8f-ef57-4f48-a056-9017cc220fe9.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrix_mms_processing_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 13910017104825945087,
        "service_name": "drive-thru",
        "span_id": 7974744557422867292,
        "trace_id": 4084247013827472357
    }
}

running: False
schema_name_id: 2118
start_time: 2026-04-08 09:32:50
success: True
trace_id: 4084247013827472357

Scan 6410522

duration: 0:00:14.615024

exit_message:

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

id: 6410522

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-stage",
        "hive_path": "s3://sfdl-csv-payrix-stage/raw/mms_processing_fees/2026-04-07/1775572648",
        "key": "raw/mms_processing_fees/2026-04-07/1775572648/7053221f-28af-48eb-a223-32bd2654fec3.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrix_mms_processing_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 7072643242698842521,
        "service_name": "drive-thru",
        "span_id": 3935568371721430412,
        "trace_id": 14137123007694578249
    }
}

running: False
schema_name_id: 2118
start_time: 2026-04-07 09:37:36
success: True
trace_id: 14137123007694578249

Scan 6410041

duration: 0:00:12.060396

exit_message:

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

id: 6410041

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-stage",
        "hive_path": "s3://sfdl-csv-payrix-stage/raw/mms_processing_fees/2026-04-06/1775486115",
        "key": "raw/mms_processing_fees/2026-04-06/1775486115/bef5c89e-e1a0-4e7c-b7d8-2587d401d0a2.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrix_mms_processing_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 3811874472032410991,
        "service_name": "drive-thru",
        "span_id": 1645184306630734805,
        "trace_id": 14733085059259371542
    }
}

running: False
schema_name_id: 2118
start_time: 2026-04-06 09:35:32
success: True
trace_id: 14733085059259371542

Scan 6409522

duration: 0:00:12.083988

exit_message:

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

id: 6409522

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-stage",
        "hive_path": "s3://sfdl-csv-payrix-stage/raw/mms_processing_fees/2026-04-05/1775399359",
        "key": "raw/mms_processing_fees/2026-04-05/1775399359/a181f1f8-b732-48d7-98d1-602bbbc1a14d.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrix_mms_processing_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 17257059877332041695,
        "service_name": "drive-thru",
        "span_id": 14961554013377531504,
        "trace_id": 1773764187115369344
    }
}

running: False
schema_name_id: 2118
start_time: 2026-04-05 09:29:28
success: True
trace_id: 1773764187115369344

Scan 6409182

duration: 0:00:11.994080

exit_message:

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

id: 6409182

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-stage",
        "hive_path": "s3://sfdl-csv-payrix-stage/raw/mms_processing_fees/2026-04-04/1775313657",
        "key": "raw/mms_processing_fees/2026-04-04/1775313657/f50a7bb5-5774-4568-a81b-64d9fb8a50c5.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrix_mms_processing_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 6980017333508060865,
        "service_name": "drive-thru",
        "span_id": 13484115982224225789,
        "trace_id": 16290650734403278495
    }
}

running: False
schema_name_id: 2118
start_time: 2026-04-04 09:41:03
success: True
trace_id: 16290650734403278495

Scan 6408798

duration: 0:00:12.128838

exit_message:

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

id: 6408798

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-stage",
        "hive_path": "s3://sfdl-csv-payrix-stage/raw/mms_processing_fees/2026-04-03/1775228773",
        "key": "raw/mms_processing_fees/2026-04-03/1775228773/e0d6f8cc-4f0f-434d-91ff-430266582bbb.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrix_mms_processing_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 10935679080835501784,
        "service_name": "drive-thru",
        "span_id": 8386543701608623453,
        "trace_id": 17213758213463915649
    }
}

running: False
schema_name_id: 2118
start_time: 2026-04-03 10:06:34
success: True
trace_id: 17213758213463915649

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:42:15

ddl:

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

Server:

hostname: schemamanager-5c55c886bf-h2ts4
name: schema_manager
process_start: 2025-10-21 13:03:27
sf_env: stage
version: 2112174301

Raw:

{
    "name": {
        "created": "2024-07-08 15:33:28",
        "disabled": false,
        "format": "raw",
        "id": 2118,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_stage_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:42:15",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/mms_processing_fees/2026-04-17/1776436922'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_csv.payrix_mms_processing_fees`",
            "repair_table": "MSCK REPAIR TABLE sfdl_stage_csv.payrix_mms_processing_fees"
        }
    },
    "server": {
        "hostname": "schemamanager-5c55c886bf-h2ts4",
        "name": "schema_manager",
        "process_start": "2025-10-21 13:03:27",
        "sf_env": "stage",
        "version": "2112174301"
    }
}