Schema Info

Schema Name: sfdl_prod_csv.payrixess_bdr_fees

created: 2024-07-24 10:34:25
disabled: False
format: raw
id: 1975
is_partitioned: False
is_schema_datatyped: True

name:

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

type: csv

Schema Versions: 15

Version 1718285

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_bdr_fees`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrixess_bdr_fees`\n(\n `entry`  string , `forentity`  string , `fee_name`  string , `type_amount`  string , `fee_amount`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrixess-prod/raw/bdr_fees/2026-04-17/1776437758'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_bdr_fees"
]

hive_path: s3://sfdl-csv-payrixess-prod/raw/bdr_fees/2026-04-17/1776437758
id: 1718285
processed: 1

raw_data:

{
    "entry": 0,
    "fee_amount": 4,
    "fee_name": 2,
    "forentity": 1,
    "type_amount": 3
}

schema_attributes:

{
    "entry": "string",
    "fee_amount": "string",
    "fee_name": "string",
    "forentity": "string",
    "type_amount": "string"
}

schema_name_id: 1975
schema_scan_id: 162179513
updated: 2026-04-17 09:59:18

Version 1717066

created: 2026-04-16 09:55:19

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_bdr_fees`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrixess_bdr_fees`\n(\n `entry`  string , `forentity`  string , `fee_name`  string , `type_amount`  string , `fee_amount`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrixess-prod/raw/bdr_fees/2026-04-16/1776351269'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_bdr_fees"
]

hive_path: s3://sfdl-csv-payrixess-prod/raw/bdr_fees/2026-04-16/1776351269
id: 1717066
processed: 1

raw_data:

{
    "entry": 0,
    "fee_amount": 4,
    "fee_name": 2,
    "forentity": 1,
    "type_amount": 3
}

schema_attributes:

{
    "entry": "string",
    "fee_amount": "string",
    "fee_name": "string",
    "forentity": "string",
    "type_amount": "string"
}

schema_name_id: 1975
schema_scan_id: 162123419
updated: 2026-04-16 09:55:33

Version 1715843

created: 2026-04-15 09:50:18

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_bdr_fees`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrixess_bdr_fees`\n(\n `entry`  string , `forentity`  string , `fee_name`  string , `type_amount`  string , `fee_amount`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrixess-prod/raw/bdr_fees/2026-04-15/1776264563'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_bdr_fees"
]

hive_path: s3://sfdl-csv-payrixess-prod/raw/bdr_fees/2026-04-15/1776264563
id: 1715843
processed: 1

raw_data:

{
    "entry": 0,
    "fee_amount": 4,
    "fee_name": 2,
    "forentity": 1,
    "type_amount": 3
}

schema_attributes:

{
    "entry": "string",
    "fee_amount": "string",
    "fee_name": "string",
    "forentity": "string",
    "type_amount": "string"
}

schema_name_id: 1975
schema_scan_id: 162067779
updated: 2026-04-15 09:50:29

Version 1714638

created: 2026-04-14 09:51:50

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_bdr_fees`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrixess_bdr_fees`\n(\n `entry`  string , `forentity`  string , `fee_name`  string , `type_amount`  string , `fee_amount`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrixess-prod/raw/bdr_fees/2026-04-14/1776178260'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_bdr_fees"
]

hive_path: s3://sfdl-csv-payrixess-prod/raw/bdr_fees/2026-04-14/1776178260
id: 1714638
processed: 1

raw_data:

{
    "entry": 0,
    "fee_amount": 4,
    "fee_name": 2,
    "forentity": 1,
    "type_amount": 3
}

schema_attributes:

{
    "entry": "string",
    "fee_amount": "string",
    "fee_name": "string",
    "forentity": "string",
    "type_amount": "string"
}

schema_name_id: 1975
schema_scan_id: 162012065
updated: 2026-04-14 09:52:04

Version 1713446

created: 2026-04-13 09:57:11

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_bdr_fees`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrixess_bdr_fees`\n(\n `entry`  string , `forentity`  string , `fee_name`  string , `type_amount`  string , `fee_amount`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrixess-prod/raw/bdr_fees/2026-04-13/1776092152'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_bdr_fees"
]

hive_path: s3://sfdl-csv-payrixess-prod/raw/bdr_fees/2026-04-13/1776092152
id: 1713446
processed: 1

raw_data:

{
    "entry": 0,
    "fee_amount": 4,
    "fee_name": 2,
    "forentity": 1,
    "type_amount": 3
}

schema_attributes:

{
    "entry": "string",
    "fee_amount": "string",
    "fee_name": "string",
    "forentity": "string",
    "type_amount": "string"
}

schema_name_id: 1975
schema_scan_id: 161954879
updated: 2026-04-13 09:57:25

Version 1712261

created: 2026-04-12 10:04:40

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_bdr_fees`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrixess_bdr_fees`\n(\n `entry`  string , `forentity`  string , `fee_name`  string , `type_amount`  string , `fee_amount`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrixess-prod/raw/bdr_fees/2026-04-12/1776006100'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_bdr_fees"
]

hive_path: s3://sfdl-csv-payrixess-prod/raw/bdr_fees/2026-04-12/1776006100
id: 1712261
processed: 1

raw_data:

{
    "entry": 0,
    "fee_amount": 4,
    "fee_name": 2,
    "forentity": 1,
    "type_amount": 3
}

schema_attributes:

{
    "entry": "string",
    "fee_amount": "string",
    "fee_name": "string",
    "forentity": "string",
    "type_amount": "string"
}

schema_name_id: 1975
schema_scan_id: 161905844
updated: 2026-04-12 10:04:54

Version 1711044

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_bdr_fees`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrixess_bdr_fees`\n(\n `entry`  string , `forentity`  string , `fee_name`  string , `type_amount`  string , `fee_amount`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrixess-prod/raw/bdr_fees/2026-04-11/1775919337'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_bdr_fees"
]

hive_path: s3://sfdl-csv-payrixess-prod/raw/bdr_fees/2026-04-11/1775919337
id: 1711044
processed: 1

raw_data:

{
    "entry": 0,
    "fee_amount": 4,
    "fee_name": 2,
    "forentity": 1,
    "type_amount": 3
}

schema_attributes:

{
    "entry": "string",
    "fee_amount": "string",
    "fee_name": "string",
    "forentity": "string",
    "type_amount": "string"
}

schema_name_id: 1975
schema_scan_id: 161852772
updated: 2026-04-11 09:57:40

Version 1709871

created: 2026-04-10 09:54:48

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_bdr_fees`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrixess_bdr_fees`\n(\n `entry`  string , `forentity`  string , `fee_name`  string , `type_amount`  string , `fee_amount`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrixess-prod/raw/bdr_fees/2026-04-10/1775832839'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_bdr_fees"
]

hive_path: s3://sfdl-csv-payrixess-prod/raw/bdr_fees/2026-04-10/1775832839
id: 1709871
processed: 1

raw_data:

{
    "entry": 0,
    "fee_amount": 4,
    "fee_name": 2,
    "forentity": 1,
    "type_amount": 3
}

schema_attributes:

{
    "entry": "string",
    "fee_amount": "string",
    "fee_name": "string",
    "forentity": "string",
    "type_amount": "string"
}

schema_name_id: 1975
schema_scan_id: 161798570
updated: 2026-04-10 09:55:02

Version 1708714

created: 2026-04-09 09:55:45

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_bdr_fees`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrixess_bdr_fees`\n(\n `entry`  string , `forentity`  string , `fee_name`  string , `type_amount`  string , `fee_amount`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrixess-prod/raw/bdr_fees/2026-04-09/1775746488'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_bdr_fees"
]

hive_path: s3://sfdl-csv-payrixess-prod/raw/bdr_fees/2026-04-09/1775746488
id: 1708714
processed: 1

raw_data:

{
    "entry": 0,
    "fee_amount": 4,
    "fee_name": 2,
    "forentity": 1,
    "type_amount": 3
}

schema_attributes:

{
    "entry": "string",
    "fee_amount": "string",
    "fee_name": "string",
    "forentity": "string",
    "type_amount": "string"
}

schema_name_id: 1975
schema_scan_id: 161742116
updated: 2026-04-09 09:55:57

Version 1707551

created: 2026-04-08 09:56:38

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_bdr_fees`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrixess_bdr_fees`\n(\n `entry`  string , `forentity`  string , `fee_name`  string , `type_amount`  string , `fee_amount`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrixess-prod/raw/bdr_fees/2026-04-08/1775660135'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_bdr_fees"
]

hive_path: s3://sfdl-csv-payrixess-prod/raw/bdr_fees/2026-04-08/1775660135
id: 1707551
processed: 1

raw_data:

{
    "entry": 0,
    "fee_amount": 4,
    "fee_name": 2,
    "forentity": 1,
    "type_amount": 3
}

schema_attributes:

{
    "entry": "string",
    "fee_amount": "string",
    "fee_name": "string",
    "forentity": "string",
    "type_amount": "string"
}

schema_name_id: 1975
schema_scan_id: 161687656
updated: 2026-04-08 09:56:52

Version 1706342

created: 2026-04-07 09:55:31

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_bdr_fees`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrixess_bdr_fees`\n(\n `entry`  string , `forentity`  string , `fee_name`  string , `type_amount`  string , `fee_amount`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrixess-prod/raw/bdr_fees/2026-04-07/1775573673'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_bdr_fees"
]

hive_path: s3://sfdl-csv-payrixess-prod/raw/bdr_fees/2026-04-07/1775573673
id: 1706342
processed: 1

raw_data:

{
    "entry": 0,
    "fee_amount": 4,
    "fee_name": 2,
    "forentity": 1,
    "type_amount": 3
}

schema_attributes:

{
    "entry": "string",
    "fee_amount": "string",
    "fee_name": "string",
    "forentity": "string",
    "type_amount": "string"
}

schema_name_id: 1975
schema_scan_id: 161631220
updated: 2026-04-07 09:55:45

Version 1705123

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_bdr_fees`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrixess_bdr_fees`\n(\n `entry`  string , `forentity`  string , `fee_name`  string , `type_amount`  string , `fee_amount`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrixess-prod/raw/bdr_fees/2026-04-06/1775487177'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_bdr_fees"
]

hive_path: s3://sfdl-csv-payrixess-prod/raw/bdr_fees/2026-04-06/1775487177
id: 1705123
processed: 1

raw_data:

{
    "entry": 0,
    "fee_amount": 4,
    "fee_name": 2,
    "forentity": 1,
    "type_amount": 3
}

schema_attributes:

{
    "entry": "string",
    "fee_amount": "string",
    "fee_name": "string",
    "forentity": "string",
    "type_amount": "string"
}

schema_name_id: 1975
schema_scan_id: 161573475
updated: 2026-04-06 09:53:55

Version 1703899

created: 2026-04-05 09:56:14

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_bdr_fees`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrixess_bdr_fees`\n(\n `entry`  string , `forentity`  string , `fee_name`  string , `type_amount`  string , `fee_amount`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrixess-prod/raw/bdr_fees/2026-04-05/1775400891'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_bdr_fees"
]

hive_path: s3://sfdl-csv-payrixess-prod/raw/bdr_fees/2026-04-05/1775400891
id: 1703899
processed: 1

raw_data:

{
    "entry": 0,
    "fee_amount": 4,
    "fee_name": 2,
    "forentity": 1,
    "type_amount": 3
}

schema_attributes:

{
    "entry": "string",
    "fee_amount": "string",
    "fee_name": "string",
    "forentity": "string",
    "type_amount": "string"
}

schema_name_id: 1975
schema_scan_id: 161524390
updated: 2026-04-05 09:56:28

Version 1702734

created: 2026-04-04 09:51:04

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_bdr_fees`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrixess_bdr_fees`\n(\n `entry`  string , `forentity`  string , `fee_name`  string , `type_amount`  string , `fee_amount`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrixess-prod/raw/bdr_fees/2026-04-04/1775314213'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_bdr_fees"
]

hive_path: s3://sfdl-csv-payrixess-prod/raw/bdr_fees/2026-04-04/1775314213
id: 1702734
processed: 1

raw_data:

{
    "entry": 0,
    "fee_amount": 4,
    "fee_name": 2,
    "forentity": 1,
    "type_amount": 3
}

schema_attributes:

{
    "entry": "string",
    "fee_amount": "string",
    "fee_name": "string",
    "forentity": "string",
    "type_amount": "string"
}

schema_name_id: 1975
schema_scan_id: 161472166
updated: 2026-04-04 09:51:18

Version 1701556

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_bdr_fees`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrixess_bdr_fees`\n(\n `entry`  string , `forentity`  string , `fee_name`  string , `type_amount`  string , `fee_amount`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrixess-prod/raw/bdr_fees/2026-04-03/1775228740'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_bdr_fees"
]

hive_path: s3://sfdl-csv-payrixess-prod/raw/bdr_fees/2026-04-03/1775228740
id: 1701556
processed: 1

raw_data:

{
    "entry": 0,
    "fee_amount": 4,
    "fee_name": 2,
    "forentity": 1,
    "type_amount": 3
}

schema_attributes:

{
    "entry": "string",
    "fee_amount": "string",
    "fee_name": "string",
    "forentity": "string",
    "type_amount": "string"
}

schema_name_id: 1975
schema_scan_id: 161417249
updated: 2026-04-03 10:06:42

Schema Scans: 15

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

Scan 162179513

duration: 0:00:11.772917

exit_message:

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

id: 162179513

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/bdr_fees/2026-04-17/1776437758",
        "key": "raw/bdr_fees/2026-04-17/1776437758/552675e6-797b-4d86-9940-6a104a706157.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_bdr_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 17183760036026724922,
        "service_name": "drive-thru",
        "span_id": 3179653185589820297,
        "trace_id": 8940383775768119984
    }
}

running: False
schema_name_id: 1975
start_time: 2026-04-17 09:59:06
success: True
trace_id: 8940383775768119984

Scan 162123419

duration: 0:00:14.308354

exit_message:

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

id: 162123419

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/bdr_fees/2026-04-16/1776351269",
        "key": "raw/bdr_fees/2026-04-16/1776351269/4dfa4011-a732-42e2-b0e7-a7d56d9c6efe.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_bdr_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 7396750781339247172,
        "service_name": "drive-thru",
        "span_id": 83876354978583827,
        "trace_id": 421257440148580718
    }
}

running: False
schema_name_id: 1975
start_time: 2026-04-16 09:55:19
success: True
trace_id: 421257440148580718

Scan 162067779

duration: 0:00:11.716584

exit_message:

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

id: 162067779

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/bdr_fees/2026-04-15/1776264563",
        "key": "raw/bdr_fees/2026-04-15/1776264563/0e44d772-2833-410f-aa82-388e9177378f.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_bdr_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 13776401493228635881,
        "service_name": "drive-thru",
        "span_id": 6157556267774592702,
        "trace_id": 13521784459269735639
    }
}

running: False
schema_name_id: 1975
start_time: 2026-04-15 09:50:17
success: True
trace_id: 13521784459269735639

Scan 162012065

duration: 0:00:14.681409

exit_message:

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

id: 162012065

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/bdr_fees/2026-04-14/1776178260",
        "key": "raw/bdr_fees/2026-04-14/1776178260/1514d2ed-e12d-4f8b-a941-40353b933d6d.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_bdr_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 12040268645605811923,
        "service_name": "drive-thru",
        "span_id": 18269500797593158975,
        "trace_id": 134469053648760304
    }
}

running: False
schema_name_id: 1975
start_time: 2026-04-14 09:51:50
success: True
trace_id: 134469053648760304

Scan 161954879

duration: 0:00:14.346759

exit_message:

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

id: 161954879

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/bdr_fees/2026-04-13/1776092152",
        "key": "raw/bdr_fees/2026-04-13/1776092152/d02e5ce4-fb8b-419b-881c-ff7aa776b937.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_bdr_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 15316238873017431024,
        "service_name": "drive-thru",
        "span_id": 14551789230618445311,
        "trace_id": 12321690621799425321
    }
}

running: False
schema_name_id: 1975
start_time: 2026-04-13 09:57:10
success: True
trace_id: 12321690621799425321

Scan 161905844

duration: 0:00:14.232426

exit_message:

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

id: 161905844

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/bdr_fees/2026-04-12/1776006100",
        "key": "raw/bdr_fees/2026-04-12/1776006100/ec98c936-ae4c-439f-bea0-c02109ae82ac.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_bdr_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 2882402424384483270,
        "service_name": "drive-thru",
        "span_id": 3779438983484917981,
        "trace_id": 14915559487737606748
    }
}

running: False
schema_name_id: 1975
start_time: 2026-04-12 10:04:40
success: True
trace_id: 14915559487737606748

Scan 161852772

duration: 0:00:14.306999

exit_message:

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

id: 161852772

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/bdr_fees/2026-04-11/1775919337",
        "key": "raw/bdr_fees/2026-04-11/1775919337/16ed8b1c-95a3-485b-bbde-20bea47048d3.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_bdr_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 11359918758535810252,
        "service_name": "drive-thru",
        "span_id": 8600956968723074587,
        "trace_id": 18416677299717774524
    }
}

running: False
schema_name_id: 1975
start_time: 2026-04-11 09:57:25
success: True
trace_id: 18416677299717774524

Scan 161798570

duration: 0:00:14.606094

exit_message:

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

id: 161798570

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/bdr_fees/2026-04-10/1775832839",
        "key": "raw/bdr_fees/2026-04-10/1775832839/11b068bd-b0af-4693-96d0-5c29d5012b76.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_bdr_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 14145590288237146211,
        "service_name": "drive-thru",
        "span_id": 2412254785508339611,
        "trace_id": 833349108730961519
    }
}

running: False
schema_name_id: 1975
start_time: 2026-04-10 09:54:48
success: True
trace_id: 833349108730961519

Scan 161742116

duration: 0:00:11.828023

exit_message:

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

id: 161742116

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/bdr_fees/2026-04-09/1775746488",
        "key": "raw/bdr_fees/2026-04-09/1775746488/5ae9be18-40c1-4c0a-865e-40f714e9c1ec.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_bdr_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 12994299422998914059,
        "service_name": "drive-thru",
        "span_id": 10477256013149806019,
        "trace_id": 16090739767686171599
    }
}

running: False
schema_name_id: 1975
start_time: 2026-04-09 09:55:45
success: True
trace_id: 16090739767686171599

Scan 161687656

duration: 0:00:14.428803

exit_message:

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

id: 161687656

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/bdr_fees/2026-04-08/1775660135",
        "key": "raw/bdr_fees/2026-04-08/1775660135/92f915f9-8945-4745-98eb-a065a6d190b6.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_bdr_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 2475382553695574325,
        "service_name": "drive-thru",
        "span_id": 8050366377252499462,
        "trace_id": 9505740737128362435
    }
}

running: False
schema_name_id: 1975
start_time: 2026-04-08 09:56:37
success: True
trace_id: 9505740737128362435

Scan 161631220

duration: 0:00:14.338720

exit_message:

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

id: 161631220

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/bdr_fees/2026-04-07/1775573673",
        "key": "raw/bdr_fees/2026-04-07/1775573673/ce09e93b-82d7-4f55-858b-d8461a6b9e0e.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_bdr_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 5308463303987659275,
        "service_name": "drive-thru",
        "span_id": 7238600707674967922,
        "trace_id": 1148569835919206932
    }
}

running: False
schema_name_id: 1975
start_time: 2026-04-07 09:55:30
success: True
trace_id: 1148569835919206932

Scan 161573475

duration: 0:00:11.756119

exit_message:

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

id: 161573475

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/bdr_fees/2026-04-06/1775487177",
        "key": "raw/bdr_fees/2026-04-06/1775487177/3b3a7de6-a03d-4559-95c2-59e292b19a77.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_bdr_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 9286856401628170103,
        "service_name": "drive-thru",
        "span_id": 13071862653141239692,
        "trace_id": 11915987714267964415
    }
}

running: False
schema_name_id: 1975
start_time: 2026-04-06 09:53:44
success: True
trace_id: 11915987714267964415

Scan 161524390

duration: 0:00:14.294795

exit_message:

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

id: 161524390

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/bdr_fees/2026-04-05/1775400891",
        "key": "raw/bdr_fees/2026-04-05/1775400891/0c29854f-575f-4f6a-ae24-d1ad09bf2096.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_bdr_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 16515662179999897968,
        "service_name": "drive-thru",
        "span_id": 10685139396112377629,
        "trace_id": 12634900353252706180
    }
}

running: False
schema_name_id: 1975
start_time: 2026-04-05 09:56:14
success: True
trace_id: 12634900353252706180

Scan 161472166

duration: 0:00:14.463379

exit_message:

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

id: 161472166

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/bdr_fees/2026-04-04/1775314213",
        "key": "raw/bdr_fees/2026-04-04/1775314213/1b3b1de2-0587-4964-9c91-66ee4375ab71.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_bdr_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 7282690654060368024,
        "service_name": "drive-thru",
        "span_id": 9847834513195284612,
        "trace_id": 8780755957834627876
    }
}

running: False
schema_name_id: 1975
start_time: 2026-04-04 09:51:04
success: True
trace_id: 8780755957834627876

Scan 161417249

duration: 0:00:14.362526

exit_message:

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

id: 161417249

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/bdr_fees/2026-04-03/1775228740",
        "key": "raw/bdr_fees/2026-04-03/1775228740/f2311f4e-523c-4bf4-86af-02a27081cfa1.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_bdr_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 2613151952266397565,
        "service_name": "drive-thru",
        "span_id": 13552094627533410480,
        "trace_id": 12267929686230041940
    }
}

running: False
schema_name_id: 1975
start_time: 2026-04-03 10:06:28
success: True
trace_id: 12267929686230041940

Partitions:

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

Schema:

attributes:

{
    "entry": "string",
    "fee_amount": "string",
    "fee_name": "string",
    "forentity": "string",
    "type_amount": "string"
}

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

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrixess_bdr_fees`\n(\n `entry`  string , `forentity`  string , `fee_name`  string , `type_amount`  string , `fee_amount`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrixess-prod/raw/bdr_fees/2026-04-17/1776437758'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_bdr_fees`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_bdr_fees"
}

Server:

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

Raw:

{
    "name": {
        "created": "2024-07-24 10:34:25",
        "disabled": false,
        "format": "raw",
        "id": 1975,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_csv",
            "table": "payrixess_bdr_fees"
        },
        "type": "csv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "entry": "string",
            "fee_amount": "string",
            "fee_name": "string",
            "forentity": "string",
            "type_amount": "string"
        },
        "created": "2026-04-17 09:59:06",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrixess_bdr_fees`\n(\n `entry`  string , `forentity`  string , `fee_name`  string , `type_amount`  string , `fee_amount`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrixess-prod/raw/bdr_fees/2026-04-17/1776437758'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_bdr_fees`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_bdr_fees"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}