Schema Info

Schema Name: sfdl_dev_csv.payrixess_bdr_fees

created: 2024-07-22 13:12:33
disabled: False
format: raw
id: 2380
is_partitioned: False
is_schema_datatyped: True

name:

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

type: csv

Schema Versions: 15

Version 4773369

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

ddl:

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

hive_path: s3://sfdl-csv-payrixess-dev/raw/bdr_fees/2026-04-17/1776437716
id: 4773369
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: 2380
schema_scan_id: 6867818
updated: 2026-04-17 09:56:27

Version 4773308

created: 2026-04-16 10:03:46

ddl:

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

hive_path: s3://sfdl-csv-payrixess-dev/raw/bdr_fees/2026-04-16/1776351754
id: 4773308
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: 2380
schema_scan_id: 6867555
updated: 2026-04-16 10:03:57

Version 4773239

created: 2026-04-15 10:03:04

ddl:

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

hive_path: s3://sfdl-csv-payrixess-dev/raw/bdr_fees/2026-04-15/1776265331
id: 4773239
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: 2380
schema_scan_id: 6867271
updated: 2026-04-15 10:03:18

Version 4773186

created: 2026-04-14 10:07:51

ddl:

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

hive_path: s3://sfdl-csv-payrixess-dev/raw/bdr_fees/2026-04-14/1776179218
id: 4773186
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: 2380
schema_scan_id: 6867029
updated: 2026-04-14 10:08:02

Version 4773125

created: 2026-04-13 09:54:59

ddl:

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

hive_path: s3://sfdl-csv-payrixess-dev/raw/bdr_fees/2026-04-13/1776092028
id: 4773125
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: 2380
schema_scan_id: 6866722
updated: 2026-04-13 09:55:10

Version 4773072

created: 2026-04-12 09:55:10

ddl:

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

hive_path: s3://sfdl-csv-payrixess-dev/raw/bdr_fees/2026-04-12/1776005659
id: 4773072
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: 2380
schema_scan_id: 6866514
updated: 2026-04-12 09:55:21

Version 4773023

created: 2026-04-11 09:55:09

ddl:

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

hive_path: s3://sfdl-csv-payrixess-dev/raw/bdr_fees/2026-04-11/1775919265
id: 4773023
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: 2380
schema_scan_id: 6866341
updated: 2026-04-11 09:55:21

Version 4772966

created: 2026-04-10 09:53:53

ddl:

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

hive_path: s3://sfdl-csv-payrixess-dev/raw/bdr_fees/2026-04-10/1775832781
id: 4772966
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: 2380
schema_scan_id: 6866104
updated: 2026-04-10 09:54:07

Version 4772905

created: 2026-04-09 09:53:42

ddl:

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

hive_path: s3://sfdl-csv-payrixess-dev/raw/bdr_fees/2026-04-09/1775746375
id: 4772905
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: 2380
schema_scan_id: 6865831
updated: 2026-04-09 09:53:53

Version 4772844

created: 2026-04-08 09:55:46

ddl:

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

hive_path: s3://sfdl-csv-payrixess-dev/raw/bdr_fees/2026-04-08/1775660077
id: 4772844
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: 2380
schema_scan_id: 6865562
updated: 2026-04-08 09:55:57

Version 4772783

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

ddl:

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

hive_path: s3://sfdl-csv-payrixess-dev/raw/bdr_fees/2026-04-07/1775573466
id: 4772783
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: 2380
schema_scan_id: 6865293
updated: 2026-04-07 09:52:28

Version 4772722

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

ddl:

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

hive_path: s3://sfdl-csv-payrixess-dev/raw/bdr_fees/2026-04-06/1775487507
id: 4772722
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: 2380
schema_scan_id: 6864974
updated: 2026-04-06 09:59:42

Version 4772669

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

ddl:

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

hive_path: s3://sfdl-csv-payrixess-dev/raw/bdr_fees/2026-04-05/1775400757
id: 4772669
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: 2380
schema_scan_id: 6864767
updated: 2026-04-05 09:53:48

Version 4772612

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

ddl:

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

hive_path: s3://sfdl-csv-payrixess-dev/raw/bdr_fees/2026-04-04/1775314255
id: 4772612
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: 2380
schema_scan_id: 6864544
updated: 2026-04-04 09:52:02

Version 4772560

created: 2026-04-03 10:01:13

ddl:

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

hive_path: s3://sfdl-csv-payrixess-dev/raw/bdr_fees/2026-04-03/1775228429
id: 4772560
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: 2380
schema_scan_id: 6864349
updated: 2026-04-03 10:01:25

Schema Scans: 15

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

Scan 6867818

duration: 0:00:14.586537

exit_message:

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

id: 6867818

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/bdr_fees/2026-04-17/1776437716",
        "key": "raw/bdr_fees/2026-04-17/1776437716/dd5ed0aa-82a3-46e1-8b82-e8bd8349071b.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_bdr_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 7481628527343868229,
        "service_name": "drive-thru",
        "span_id": 3987724184505974990,
        "trace_id": 1066194211796263232
    }
}

running: False
schema_name_id: 2380
start_time: 2026-04-17 09:56:12
success: True
trace_id: 1066194211796263232

Scan 6867555

duration: 0:00:12.005983

exit_message:

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

id: 6867555

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/bdr_fees/2026-04-16/1776351754",
        "key": "raw/bdr_fees/2026-04-16/1776351754/ac761fe6-54a8-434f-8c23-fe911796e265.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_bdr_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 480002361277693703,
        "service_name": "drive-thru",
        "span_id": 8206384753731426092,
        "trace_id": 15833057185972580775
    }
}

running: False
schema_name_id: 2380
start_time: 2026-04-16 10:03:45
success: True
trace_id: 15833057185972580775

Scan 6867271

duration: 0:00:14.410113

exit_message:

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

id: 6867271

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/bdr_fees/2026-04-15/1776265331",
        "key": "raw/bdr_fees/2026-04-15/1776265331/6a530e2b-db2b-4225-8780-8a3a476b38c3.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_bdr_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 18438493152126645573,
        "service_name": "drive-thru",
        "span_id": 5502243542398262750,
        "trace_id": 12724241601882557249
    }
}

running: False
schema_name_id: 2380
start_time: 2026-04-15 10:03:04
success: True
trace_id: 12724241601882557249

Scan 6867029

duration: 0:00:11.996537

exit_message:

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

id: 6867029

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/bdr_fees/2026-04-14/1776179218",
        "key": "raw/bdr_fees/2026-04-14/1776179218/8046b6a6-bcbb-4c38-b182-0e64214b9640.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_bdr_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 10095868323604150135,
        "service_name": "drive-thru",
        "span_id": 103704087747110167,
        "trace_id": 5020869422722372087
    }
}

running: False
schema_name_id: 2380
start_time: 2026-04-14 10:07:50
success: True
trace_id: 5020869422722372087

Scan 6866722

duration: 0:00:11.856888

exit_message:

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

id: 6866722

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/bdr_fees/2026-04-13/1776092028",
        "key": "raw/bdr_fees/2026-04-13/1776092028/23e25f09-9d7b-4ddc-99d0-d1869893a868.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_bdr_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 3501102530236173754,
        "service_name": "drive-thru",
        "span_id": 15529314097239476163,
        "trace_id": 12139649849789474616
    }
}

running: False
schema_name_id: 2380
start_time: 2026-04-13 09:54:58
success: True
trace_id: 12139649849789474616

Scan 6866514

duration: 0:00:11.733399

exit_message:

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

id: 6866514

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/bdr_fees/2026-04-12/1776005659",
        "key": "raw/bdr_fees/2026-04-12/1776005659/d160af5f-cad6-430f-b20f-446de258573a.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_bdr_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 946116592323821435,
        "service_name": "drive-thru",
        "span_id": 2327864412364843760,
        "trace_id": 10539425037818013404
    }
}

running: False
schema_name_id: 2380
start_time: 2026-04-12 09:55:09
success: True
trace_id: 10539425037818013404

Scan 6866341

duration: 0:00:11.886201

exit_message:

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

id: 6866341

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/bdr_fees/2026-04-11/1775919265",
        "key": "raw/bdr_fees/2026-04-11/1775919265/b39e2dea-b15b-4458-83b2-8aa447d13ac6.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_bdr_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 10687837347089325283,
        "service_name": "drive-thru",
        "span_id": 8665546905276939390,
        "trace_id": 3065438465262062051
    }
}

running: False
schema_name_id: 2380
start_time: 2026-04-11 09:55:09
success: True
trace_id: 3065438465262062051

Scan 6866104

duration: 0:00:14.472762

exit_message:

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

id: 6866104

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/bdr_fees/2026-04-10/1775832781",
        "key": "raw/bdr_fees/2026-04-10/1775832781/e00ca9a3-48da-4f64-ada8-b3e528ab7215.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_bdr_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 7868962652754520403,
        "service_name": "drive-thru",
        "span_id": 8416099597631988150,
        "trace_id": 11919921360734076931
    }
}

running: False
schema_name_id: 2380
start_time: 2026-04-10 09:53:52
success: True
trace_id: 11919921360734076931

Scan 6865831

duration: 0:00:11.913317

exit_message:

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

id: 6865831

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/bdr_fees/2026-04-09/1775746375",
        "key": "raw/bdr_fees/2026-04-09/1775746375/03c50902-65c3-44d0-9209-ddce1b1d4c22.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_bdr_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 7519142863683758032,
        "service_name": "drive-thru",
        "span_id": 11809875678198628466,
        "trace_id": 11901154293571979270
    }
}

running: False
schema_name_id: 2380
start_time: 2026-04-09 09:53:42
success: True
trace_id: 11901154293571979270

Scan 6865562

duration: 0:00:11.948650

exit_message:

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

id: 6865562

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/bdr_fees/2026-04-08/1775660077",
        "key": "raw/bdr_fees/2026-04-08/1775660077/55df8013-64ab-418c-8922-fd6fe701586b.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_bdr_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 18034383302143269401,
        "service_name": "drive-thru",
        "span_id": 829156777543443569,
        "trace_id": 14174976209692077999
    }
}

running: False
schema_name_id: 2380
start_time: 2026-04-08 09:55:46
success: True
trace_id: 14174976209692077999

Scan 6865293

duration: 0:00:12.115458

exit_message:

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

id: 6865293

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/bdr_fees/2026-04-07/1775573466",
        "key": "raw/bdr_fees/2026-04-07/1775573466/5c27e6d3-7095-4511-a3ab-8b5a44c8cbb2.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_bdr_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 3072529825734498784,
        "service_name": "drive-thru",
        "span_id": 3530857170617863640,
        "trace_id": 8740867243995488028
    }
}

running: False
schema_name_id: 2380
start_time: 2026-04-07 09:52:16
success: True
trace_id: 8740867243995488028

Scan 6864974

duration: 0:00:11.896757

exit_message:

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

id: 6864974

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/bdr_fees/2026-04-06/1775487507",
        "key": "raw/bdr_fees/2026-04-06/1775487507/8e1cea6b-005c-4271-a9b2-e49e91f5d47c.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_bdr_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 17090322444903359862,
        "service_name": "drive-thru",
        "span_id": 3255797824504678533,
        "trace_id": 18000662303553885459
    }
}

running: False
schema_name_id: 2380
start_time: 2026-04-06 09:59:30
success: True
trace_id: 18000662303553885459

Scan 6864767

duration: 0:00:11.776267

exit_message:

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

id: 6864767

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/bdr_fees/2026-04-05/1775400757",
        "key": "raw/bdr_fees/2026-04-05/1775400757/954d3e92-791e-471b-8f7f-cc8002a493d4.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_bdr_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 10706069261913357773,
        "service_name": "drive-thru",
        "span_id": 16994287399681157392,
        "trace_id": 16249357948158046865
    }
}

running: False
schema_name_id: 2380
start_time: 2026-04-05 09:53:36
success: True
trace_id: 16249357948158046865

Scan 6864544

duration: 0:00:14.365394

exit_message:

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

id: 6864544

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/bdr_fees/2026-04-04/1775314255",
        "key": "raw/bdr_fees/2026-04-04/1775314255/62f5c502-a143-4cf1-9779-710e829975e6.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_bdr_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 13007391590127422197,
        "service_name": "drive-thru",
        "span_id": 14307119538554559874,
        "trace_id": 15531701258541320250
    }
}

running: False
schema_name_id: 2380
start_time: 2026-04-04 09:51:48
success: True
trace_id: 15531701258541320250

Scan 6864349

duration: 0:00:11.834861

exit_message:

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

id: 6864349

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/bdr_fees/2026-04-03/1775228429",
        "key": "raw/bdr_fees/2026-04-03/1775228429/13d7f383-5848-4b92-bb16-0547fa747bd9.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_bdr_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 12954340115493200052,
        "service_name": "drive-thru",
        "span_id": 14399647621903917739,
        "trace_id": 18379234380598172364
    }
}

running: False
schema_name_id: 2380
start_time: 2026-04-03 10:01:13
success: True
trace_id: 18379234380598172364

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

ddl:

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

Server:

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

Raw:

{
    "name": {
        "created": "2024-07-22 13:12:33",
        "disabled": false,
        "format": "raw",
        "id": 2380,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_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:56:13",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/bdr_fees/2026-04-17/1776437716'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_bdr_fees`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_bdr_fees"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}