Schema Info

Schema Name: sfdl_stage_csv.payrixess_mms_processing_fees

created: 2024-07-22 13:16:54
disabled: False
format: raw
id: 2175
is_partitioned: False
is_schema_datatyped: True

name:

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

type: csv

Schema Versions: 15

Version 906689

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

ddl:

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

hive_path: s3://sfdl-csv-payrixess-stage/raw/mms_processing_fees/2026-04-17/1776436070
id: 906689
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: 2175
schema_scan_id: 6415363
updated: 2026-04-17 09:28:27

Version 906491

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

ddl:

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

hive_path: s3://sfdl-csv-payrixess-stage/raw/mms_processing_fees/2026-04-16/1776350747
id: 906491
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: 2175
schema_scan_id: 6414932
updated: 2026-04-16 09:46:18

Version 906273

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

ddl:

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

hive_path: s3://sfdl-csv-payrixess-stage/raw/mms_processing_fees/2026-04-15/1776263735
id: 906273
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: 2175
schema_scan_id: 6414419
updated: 2026-04-15 09:36:12

Version 906050

created: 2026-04-14 09:32:34

ddl:

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

hive_path: s3://sfdl-csv-payrixess-stage/raw/mms_processing_fees/2026-04-14/1776177141
id: 906050
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: 2175
schema_scan_id: 6413898
updated: 2026-04-14 09:32:48

Version 905833

created: 2026-04-13 09:31:08

ddl:

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

hive_path: s3://sfdl-csv-payrixess-stage/raw/mms_processing_fees/2026-04-13/1776090648
id: 905833
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: 2175
schema_scan_id: 6413267
updated: 2026-04-13 09:31:22

Version 905627

created: 2026-04-12 09:29:32

ddl:

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

hive_path: s3://sfdl-csv-payrixess-stage/raw/mms_processing_fees/2026-04-12/1776004151
id: 905627
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: 2175
schema_scan_id: 6412855
updated: 2026-04-12 09:29:43

Version 905446

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

ddl:

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

hive_path: s3://sfdl-csv-payrixess-stage/raw/mms_processing_fees/2026-04-11/1775918686
id: 905446
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: 2175
schema_scan_id: 6412565
updated: 2026-04-11 09:45:03

Version 905234

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

ddl:

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

hive_path: s3://sfdl-csv-payrixess-stage/raw/mms_processing_fees/2026-04-10/1775832218
id: 905234
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: 2175
schema_scan_id: 6412116
updated: 2026-04-10 09:45:08

Version 905026

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

ddl:

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

hive_path: s3://sfdl-csv-payrixess-stage/raw/mms_processing_fees/2026-04-09/1775746176
id: 905026
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: 2175
schema_scan_id: 6411609
updated: 2026-04-09 09:50:18

Version 904801

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

ddl:

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

hive_path: s3://sfdl-csv-payrixess-stage/raw/mms_processing_fees/2026-04-08/1775659349
id: 904801
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: 2175
schema_scan_id: 6411093
updated: 2026-04-08 09:44:17

Version 904584

created: 2026-04-07 09:39:52

ddl:

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

hive_path: s3://sfdl-csv-payrixess-stage/raw/mms_processing_fees/2026-04-07/1775572785
id: 904584
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: 2175
schema_scan_id: 6410544
updated: 2026-04-07 09:40:05

Version 904351

created: 2026-04-06 09:28:11

ddl:

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

hive_path: s3://sfdl-csv-payrixess-stage/raw/mms_processing_fees/2026-04-06/1775485677
id: 904351
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: 2175
schema_scan_id: 6409924
updated: 2026-04-06 09:28:25

Version 904173

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

ddl:

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

hive_path: s3://sfdl-csv-payrixess-stage/raw/mms_processing_fees/2026-04-05/1775400325
id: 904173
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: 2175
schema_scan_id: 6409621
updated: 2026-04-05 09:45:48

Version 903975

created: 2026-04-04 09:52:43

ddl:

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

hive_path: s3://sfdl-csv-payrixess-stage/raw/mms_processing_fees/2026-04-04/1775314358
id: 903975
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: 2175
schema_scan_id: 6409245
updated: 2026-04-04 09:52:54

Version 903757

created: 2026-04-03 09:56:33

ddl:

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

hive_path: s3://sfdl-csv-payrixess-stage/raw/mms_processing_fees/2026-04-03/1775228163
id: 903757
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: 2175
schema_scan_id: 6408762
updated: 2026-04-03 09:56:46

Schema Scans: 15

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

Scan 6415363

duration: 0:00:14.674871

exit_message:

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

id: 6415363

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/mms_processing_fees/2026-04-17/1776436070",
        "key": "raw/mms_processing_fees/2026-04-17/1776436070/ad0d5b0f-69f4-40c4-b682-d069e1d324b5.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_mms_processing_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 14294645307151392546,
        "service_name": "drive-thru",
        "span_id": 4818657643509995576,
        "trace_id": 10568964938398906451
    }
}

running: False
schema_name_id: 2175
start_time: 2026-04-17 09:28:12
success: True
trace_id: 10568964938398906451

Scan 6414932

duration: 0:00:12.134495

exit_message:

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

id: 6414932

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/mms_processing_fees/2026-04-16/1776350747",
        "key": "raw/mms_processing_fees/2026-04-16/1776350747/4e1cc58c-bc35-4f1e-95a8-8db4dd2789ea.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_mms_processing_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 13447066347992616459,
        "service_name": "drive-thru",
        "span_id": 442111533896690617,
        "trace_id": 9800969023052625904
    }
}

running: False
schema_name_id: 2175
start_time: 2026-04-16 09:46:06
success: True
trace_id: 9800969023052625904

Scan 6414419

duration: 0:00:14.654540

exit_message:

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

id: 6414419

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/mms_processing_fees/2026-04-15/1776263735",
        "key": "raw/mms_processing_fees/2026-04-15/1776263735/d95790ce-fe4a-4e12-9f79-951d731c1852.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_mms_processing_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 2818820671430200323,
        "service_name": "drive-thru",
        "span_id": 12143640508041130552,
        "trace_id": 9408736641010598217
    }
}

running: False
schema_name_id: 2175
start_time: 2026-04-15 09:35:58
success: True
trace_id: 9408736641010598217

Scan 6413898

duration: 0:00:14.726179

exit_message:

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

id: 6413898

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/mms_processing_fees/2026-04-14/1776177141",
        "key": "raw/mms_processing_fees/2026-04-14/1776177141/6fa64af0-236e-4ca6-8bf8-af26448ab4ae.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_mms_processing_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 487603847151793394,
        "service_name": "drive-thru",
        "span_id": 8588849504519627200,
        "trace_id": 3797455995791275109
    }
}

running: False
schema_name_id: 2175
start_time: 2026-04-14 09:32:33
success: True
trace_id: 3797455995791275109

Scan 6413267

duration: 0:00:14.649777

exit_message:

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

id: 6413267

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/mms_processing_fees/2026-04-13/1776090648",
        "key": "raw/mms_processing_fees/2026-04-13/1776090648/df2e86d4-e670-4b52-a0ec-9d76c3246ff8.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_mms_processing_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 6058886096766082592,
        "service_name": "drive-thru",
        "span_id": 16777957403608956245,
        "trace_id": 676161019499259501
    }
}

running: False
schema_name_id: 2175
start_time: 2026-04-13 09:31:08
success: True
trace_id: 676161019499259501

Scan 6412855

duration: 0:00:11.951702

exit_message:

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

id: 6412855

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/mms_processing_fees/2026-04-12/1776004151",
        "key": "raw/mms_processing_fees/2026-04-12/1776004151/fc13b22d-16c4-4426-b504-bd092f513eb4.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_mms_processing_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 15860506362849120649,
        "service_name": "drive-thru",
        "span_id": 13916826288999359065,
        "trace_id": 15408184563197452404
    }
}

running: False
schema_name_id: 2175
start_time: 2026-04-12 09:29:31
success: True
trace_id: 15408184563197452404

Scan 6412565

duration: 0:00:11.932960

exit_message:

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

id: 6412565

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/mms_processing_fees/2026-04-11/1775918686",
        "key": "raw/mms_processing_fees/2026-04-11/1775918686/b0e2b3c0-a31c-4477-b7c7-605b6f8dfc12.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_mms_processing_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 3736929232786079931,
        "service_name": "drive-thru",
        "span_id": 15811459282428917437,
        "trace_id": 10357001055663415169
    }
}

running: False
schema_name_id: 2175
start_time: 2026-04-11 09:44:51
success: True
trace_id: 10357001055663415169

Scan 6412116

duration: 0:00:11.951207

exit_message:

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

id: 6412116

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/mms_processing_fees/2026-04-10/1775832218",
        "key": "raw/mms_processing_fees/2026-04-10/1775832218/17785830-28c8-46ad-a25c-24fae8503f62.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_mms_processing_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 4733325237350362164,
        "service_name": "drive-thru",
        "span_id": 17577261878483076618,
        "trace_id": 15643746964486133226
    }
}

running: False
schema_name_id: 2175
start_time: 2026-04-10 09:44:56
success: True
trace_id: 15643746964486133226

Scan 6411609

duration: 0:00:14.615858

exit_message:

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

id: 6411609

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/mms_processing_fees/2026-04-09/1775746176",
        "key": "raw/mms_processing_fees/2026-04-09/1775746176/fb07f576-58aa-4aec-bf4b-113d1d866d2c.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_mms_processing_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 12534301343389553362,
        "service_name": "drive-thru",
        "span_id": 11584368380149597371,
        "trace_id": 6969035927167452912
    }
}

running: False
schema_name_id: 2175
start_time: 2026-04-09 09:50:03
success: True
trace_id: 6969035927167452912

Scan 6411093

duration: 0:01:38.531994

exit_message:

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

id: 6411093

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/mms_processing_fees/2026-04-08/1775659349",
        "key": "raw/mms_processing_fees/2026-04-08/1775659349/80b6818f-a685-4898-88bb-be303e1d0e09.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_mms_processing_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 2416152253035099743,
        "service_name": "drive-thru",
        "span_id": 13514677620031574728,
        "trace_id": 8051836390172040950
    }
}

running: False
schema_name_id: 2175
start_time: 2026-04-08 09:42:38
success: True
trace_id: 8051836390172040950

Scan 6410544

duration: 0:00:14.482593

exit_message:

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

id: 6410544

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/mms_processing_fees/2026-04-07/1775572785",
        "key": "raw/mms_processing_fees/2026-04-07/1775572785/7602ffa2-3206-460b-8d29-7c90ffde1472.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_mms_processing_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 8825612279359093020,
        "service_name": "drive-thru",
        "span_id": 18244136289094443600,
        "trace_id": 889376486708167642
    }
}

running: False
schema_name_id: 2175
start_time: 2026-04-07 09:39:51
success: True
trace_id: 889376486708167642

Scan 6409924

duration: 0:00:14.686466

exit_message:

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

id: 6409924

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/mms_processing_fees/2026-04-06/1775485677",
        "key": "raw/mms_processing_fees/2026-04-06/1775485677/3db11b08-5d2f-498a-b2ed-aa6b3f093d36.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_mms_processing_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 9724195594801320716,
        "service_name": "drive-thru",
        "span_id": 10689123527665433884,
        "trace_id": 7317152923238199033
    }
}

running: False
schema_name_id: 2175
start_time: 2026-04-06 09:28:10
success: True
trace_id: 7317152923238199033

Scan 6409621

duration: 0:00:11.948000

exit_message:

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

id: 6409621

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/mms_processing_fees/2026-04-05/1775400325",
        "key": "raw/mms_processing_fees/2026-04-05/1775400325/2273e743-6df3-46e0-aa3a-1e9764009c23.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_mms_processing_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 15790672937670765110,
        "service_name": "drive-thru",
        "span_id": 1085555236738056289,
        "trace_id": 5917112979472554610
    }
}

running: False
schema_name_id: 2175
start_time: 2026-04-05 09:45:36
success: True
trace_id: 5917112979472554610

Scan 6409245

duration: 0:00:11.758885

exit_message:

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

id: 6409245

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/mms_processing_fees/2026-04-04/1775314358",
        "key": "raw/mms_processing_fees/2026-04-04/1775314358/74cf1ba7-b8a8-4e27-9615-22edc97a681d.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_mms_processing_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 17385194880349609580,
        "service_name": "drive-thru",
        "span_id": 14646542155655488811,
        "trace_id": 4864056305685119054
    }
}

running: False
schema_name_id: 2175
start_time: 2026-04-04 09:52:42
success: True
trace_id: 4864056305685119054

Scan 6408762

duration: 0:00:14.581715

exit_message:

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

id: 6408762

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/mms_processing_fees/2026-04-03/1775228163",
        "key": "raw/mms_processing_fees/2026-04-03/1775228163/b762b6f1-110d-4314-9e06-e7ff68b6c597.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_mms_processing_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 5126590783769995291,
        "service_name": "drive-thru",
        "span_id": 14878538185477184895,
        "trace_id": 11191452470554620807
    }
}

running: False
schema_name_id: 2175
start_time: 2026-04-03 09:56:32
success: True
trace_id: 11191452470554620807

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:13

ddl:

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