Schema Info

Schema Name: sfdl_prod_csv.payrix_bdr_fees

created: 2024-07-10 09:39:39
disabled: False
format: raw
id: 1929
is_partitioned: False
is_schema_datatyped: True

name:

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

type: csv

Schema Versions: 15

Version 1718270

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/bdr_fees/2026-04-17/1776437056
id: 1718270
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: 1929
schema_scan_id: 162178726
updated: 2026-04-17 09:45:40

Version 1717039

created: 2026-04-16 09:41:14

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/bdr_fees/2026-04-16/1776350389
id: 1717039
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: 1929
schema_scan_id: 162122884
updated: 2026-04-16 09:41:25

Version 1715891

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/bdr_fees/2026-04-15/1776270818
id: 1715891
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: 1929
schema_scan_id: 162072915
updated: 2026-04-15 11:36:12

Version 1714960

created: 2026-04-14 21:22:45

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/bdr_fees/2026-04-14/1776219683
id: 1714960
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: 1929
schema_scan_id: 162046479
updated: 2026-04-14 21:22:59

Version 1713429

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/bdr_fees/2026-04-13/1776091452
id: 1713429
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: 1929
schema_scan_id: 161953895
updated: 2026-04-13 09:45:45

Version 1712245

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/bdr_fees/2026-04-12/1776004970
id: 1712245
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: 1929
schema_scan_id: 161903643
updated: 2026-04-12 09:44:14

Version 1711025

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/bdr_fees/2026-04-11/1775918518
id: 1711025
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: 1929
schema_scan_id: 161852096
updated: 2026-04-11 09:43:19

Version 1709852

created: 2026-04-10 09:38:17

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/bdr_fees/2026-04-10/1775831822
id: 1709852
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: 1929
schema_scan_id: 161797453
updated: 2026-04-10 09:38:31

Version 1708698

created: 2026-04-09 09:38:42

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/bdr_fees/2026-04-09/1775745461
id: 1708698
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: 1929
schema_scan_id: 161741484
updated: 2026-04-09 09:38:53

Version 1707532

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/bdr_fees/2026-04-08/1775659494
id: 1707532
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: 1929
schema_scan_id: 161686680
updated: 2026-04-08 09:48:54

Version 1706315

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/bdr_fees/2026-04-07/1775572688
id: 1706315
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: 1929
schema_scan_id: 161630484
updated: 2026-04-07 09:39:38

Version 1705103

created: 2026-04-06 09:41:48

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/bdr_fees/2026-04-06/1775486445
id: 1705103
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: 1929
schema_scan_id: 161572919
updated: 2026-04-06 09:41:59

Version 1703897

created: 2026-04-05 09:51:23

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/bdr_fees/2026-04-05/1775400620
id: 1703897
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: 1929
schema_scan_id: 161524113
updated: 2026-04-05 09:51:34

Version 1702731

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/bdr_fees/2026-04-04/1775314135
id: 1702731
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: 1929
schema_scan_id: 161472139
updated: 2026-04-04 09:50:41

Version 1701539

created: 2026-04-03 09:46:54

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/bdr_fees/2026-04-03/1775227546
id: 1701539
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: 1929
schema_scan_id: 161414846
updated: 2026-04-03 09:47:08

Schema Scans: 15

Last at 2026-04-17 09:45:26

Scan 162178726

duration: 0:00:14.359559

exit_message:

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

id: 162178726

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/bdr_fees/2026-04-17/1776437056",
        "key": "raw/bdr_fees/2026-04-17/1776437056/8aaf366c-8bb5-4291-ac83-2b3ae84bd26e.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_bdr_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 6740472315034095478,
        "service_name": "drive-thru",
        "span_id": 16543832260100294983,
        "trace_id": 4782868512646492630
    }
}

running: False
schema_name_id: 1929
start_time: 2026-04-17 09:45:26
success: True
trace_id: 4782868512646492630

Scan 162122884

duration: 0:00:11.859771

exit_message:

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

id: 162122884

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/bdr_fees/2026-04-16/1776350389",
        "key": "raw/bdr_fees/2026-04-16/1776350389/a7cba576-8ddf-4f9a-8e24-4d772b098fe5.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_bdr_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 17167829874802216249,
        "service_name": "drive-thru",
        "span_id": 11810976602419014061,
        "trace_id": 8058304086136562842
    }
}

running: False
schema_name_id: 1929
start_time: 2026-04-16 09:41:13
success: True
trace_id: 8058304086136562842

Scan 162072915

duration: 0:00:14.466655

exit_message:

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

id: 162072915

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/bdr_fees/2026-04-15/1776270818",
        "key": "raw/bdr_fees/2026-04-15/1776270818/173a75f3-3782-43e0-aeba-c6ac1faf83dc.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_bdr_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 1586258989641557014,
        "service_name": "drive-thru",
        "span_id": 608829043955259895,
        "trace_id": 11826236629186134673
    }
}

running: False
schema_name_id: 1929
start_time: 2026-04-15 11:35:57
success: True
trace_id: 11826236629186134673

Scan 162046479

duration: 0:00:14.537446

exit_message:

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

id: 162046479

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/bdr_fees/2026-04-14/1776219683",
        "key": "raw/bdr_fees/2026-04-14/1776219683/b9a1a49c-2a48-4095-9c70-e3db2ab57672.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_bdr_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 13481167927921820617,
        "service_name": "drive-thru",
        "span_id": 5393380865380447308,
        "trace_id": 14560941411323863712
    }
}

running: False
schema_name_id: 1929
start_time: 2026-04-14 21:22:45
success: True
trace_id: 14560941411323863712

Scan 161953895

duration: 0:00:11.780501

exit_message:

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

id: 161953895

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/bdr_fees/2026-04-13/1776091452",
        "key": "raw/bdr_fees/2026-04-13/1776091452/e80ddf5b-225b-4696-8b67-9fb4a1ed68b3.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_bdr_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 16395448058478450691,
        "service_name": "drive-thru",
        "span_id": 3994884492774011307,
        "trace_id": 799136283870254825
    }
}

running: False
schema_name_id: 1929
start_time: 2026-04-13 09:45:33
success: True
trace_id: 799136283870254825

Scan 161903643

duration: 0:00:14.377019

exit_message:

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

id: 161903643

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/bdr_fees/2026-04-12/1776004970",
        "key": "raw/bdr_fees/2026-04-12/1776004970/71e515b6-844c-42d4-8e0e-bab724746fc6.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_bdr_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 904419128286554507,
        "service_name": "drive-thru",
        "span_id": 3438919961000048190,
        "trace_id": 11211284010234107722
    }
}

running: False
schema_name_id: 1929
start_time: 2026-04-12 09:43:59
success: True
trace_id: 11211284010234107722

Scan 161852096

duration: 0:00:11.704214

exit_message:

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

id: 161852096

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/bdr_fees/2026-04-11/1775918518",
        "key": "raw/bdr_fees/2026-04-11/1775918518/06403e98-6d45-4ed3-8ced-972e617c95a4.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_bdr_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 14141595724989387385,
        "service_name": "drive-thru",
        "span_id": 9363376055846496704,
        "trace_id": 12132913595768200279
    }
}

running: False
schema_name_id: 1929
start_time: 2026-04-11 09:43:07
success: True
trace_id: 12132913595768200279

Scan 161797453

duration: 0:00:14.499666

exit_message:

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

id: 161797453

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/bdr_fees/2026-04-10/1775831822",
        "key": "raw/bdr_fees/2026-04-10/1775831822/bf160672-ec25-4b3e-a328-d8fe2a9bf0b1.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_bdr_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 18177074526481525315,
        "service_name": "drive-thru",
        "span_id": 16594312039535179043,
        "trace_id": 12456994511983044582
    }
}

running: False
schema_name_id: 1929
start_time: 2026-04-10 09:38:17
success: True
trace_id: 12456994511983044582

Scan 161741484

duration: 0:00:11.694099

exit_message:

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

id: 161741484

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/bdr_fees/2026-04-09/1775745461",
        "key": "raw/bdr_fees/2026-04-09/1775745461/249041a6-5a54-42fc-854c-e965aa84ba15.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_bdr_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 14826607544369572397,
        "service_name": "drive-thru",
        "span_id": 5731592536345345767,
        "trace_id": 7897572854836188387
    }
}

running: False
schema_name_id: 1929
start_time: 2026-04-09 09:38:42
success: True
trace_id: 7897572854836188387

Scan 161686680

duration: 0:00:11.863942

exit_message:

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

id: 161686680

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/bdr_fees/2026-04-08/1775659494",
        "key": "raw/bdr_fees/2026-04-08/1775659494/b44112c1-3882-4528-a709-0f07f3b9dc61.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_bdr_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 17924802151281920626,
        "service_name": "drive-thru",
        "span_id": 16917050579185211465,
        "trace_id": 649900403138993337
    }
}

running: False
schema_name_id: 1929
start_time: 2026-04-08 09:48:43
success: True
trace_id: 649900403138993337

Scan 161630484

duration: 0:00:11.704508

exit_message:

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

id: 161630484

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/bdr_fees/2026-04-07/1775572688",
        "key": "raw/bdr_fees/2026-04-07/1775572688/e0a88641-52ca-437d-bc25-f3b6fb0ea982.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_bdr_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 4848822971709249105,
        "service_name": "drive-thru",
        "span_id": 14753153857266071260,
        "trace_id": 3600919091934335822
    }
}

running: False
schema_name_id: 1929
start_time: 2026-04-07 09:39:27
success: True
trace_id: 3600919091934335822

Scan 161572919

duration: 0:00:11.640355

exit_message:

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

id: 161572919

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/bdr_fees/2026-04-06/1775486445",
        "key": "raw/bdr_fees/2026-04-06/1775486445/cc8c837a-1a25-49ca-b65a-2781e1cc5868.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_bdr_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 14113005073311810477,
        "service_name": "drive-thru",
        "span_id": 14765818950468673608,
        "trace_id": 444620795517037387
    }
}

running: False
schema_name_id: 1929
start_time: 2026-04-06 09:41:48
success: True
trace_id: 444620795517037387

Scan 161524113

duration: 0:00:11.656675

exit_message:

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

id: 161524113

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/bdr_fees/2026-04-05/1775400620",
        "key": "raw/bdr_fees/2026-04-05/1775400620/708aa921-4fef-4e89-a0a4-c4460b4dd41a.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_bdr_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 6257650833128973680,
        "service_name": "drive-thru",
        "span_id": 11420985549018595492,
        "trace_id": 11504950116103290328
    }
}

running: False
schema_name_id: 1929
start_time: 2026-04-05 09:51:22
success: True
trace_id: 11504950116103290328

Scan 161472139

duration: 0:00:14.252604

exit_message:

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

id: 161472139

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/bdr_fees/2026-04-04/1775314135",
        "key": "raw/bdr_fees/2026-04-04/1775314135/26088d81-0f4e-4999-8f0e-4511696dfdc8.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_bdr_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 8843459271364909722,
        "service_name": "drive-thru",
        "span_id": 13904156697775479539,
        "trace_id": 5512842775490493151
    }
}

running: False
schema_name_id: 1929
start_time: 2026-04-04 09:50:27
success: True
trace_id: 5512842775490493151

Scan 161414846

duration: 0:00:14.439268

exit_message:

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

id: 161414846

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/bdr_fees/2026-04-03/1775227546",
        "key": "raw/bdr_fees/2026-04-03/1775227546/c7d90c31-d9ad-4d82-a5e2-06ccef4b8691.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_bdr_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 5826596901798948341,
        "service_name": "drive-thru",
        "span_id": 9447612418702695054,
        "trace_id": 334255719751312907
    }
}

running: False
schema_name_id: 1929
start_time: 2026-04-03 09:46:53
success: True
trace_id: 334255719751312907

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:45:27

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrix_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-payrix-prod/raw/bdr_fees/2026-04-17/1776437056'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_csv.payrix_bdr_fees`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_csv.payrix_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-10 09:39:39",
        "disabled": false,
        "format": "raw",
        "id": 1929,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_csv",
            "table": "payrix_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:45:27",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrix_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-payrix-prod/raw/bdr_fees/2026-04-17/1776437056'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_csv.payrix_bdr_fees`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_csv.payrix_bdr_fees"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}