Schema Info

Schema Name: sfdl_stage_csv.payrixess_bdr_fees

created: 2024-07-22 13:21:05
disabled: False
format: raw
id: 2181
is_partitioned: False
is_schema_datatyped: True

name:

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

type: csv

Schema Versions: 15

Version 906720

created: 2026-04-17 09:57:02

ddl:

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

hive_path: s3://sfdl-csv-payrixess-stage/raw/bdr_fees/2026-04-17/1776437766
id: 906720
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: 2181
schema_scan_id: 6415477
updated: 2026-04-17 09:57:14

Version 906502

created: 2026-04-16 09:49:38

ddl:

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

hive_path: s3://sfdl-csv-payrixess-stage/raw/bdr_fees/2026-04-16/1776350932
id: 906502
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: 2181
schema_scan_id: 6414948
updated: 2026-04-16 09:49:52

Version 906289

created: 2026-04-15 09:49:29

ddl:

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

hive_path: s3://sfdl-csv-payrixess-stage/raw/bdr_fees/2026-04-15/1776264513
id: 906289
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: 2181
schema_scan_id: 6414437
updated: 2026-04-15 09:49:42

Version 906076

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

ddl:

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

hive_path: s3://sfdl-csv-payrixess-stage/raw/bdr_fees/2026-04-14/1776178512
id: 906076
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: 2181
schema_scan_id: 6413949
updated: 2026-04-14 09:56:14

Version 905861

created: 2026-04-13 09:55:21

ddl:

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

hive_path: s3://sfdl-csv-payrixess-stage/raw/bdr_fees/2026-04-13/1776092061
id: 905861
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: 2181
schema_scan_id: 6413395
updated: 2026-04-13 09:55:33

Version 905654

created: 2026-04-12 09:51:35

ddl:

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

hive_path: s3://sfdl-csv-payrixess-stage/raw/bdr_fees/2026-04-12/1776005449
id: 905654
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: 2181
schema_scan_id: 6412960
updated: 2026-04-12 09:51:49

Version 905452

created: 2026-04-11 09:50:12

ddl:

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

hive_path: s3://sfdl-csv-payrixess-stage/raw/bdr_fees/2026-04-11/1775918948
id: 905452
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: 2181
schema_scan_id: 6412579
updated: 2026-04-11 09:50:23

Version 905242

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

ddl:

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

hive_path: s3://sfdl-csv-payrixess-stage/raw/bdr_fees/2026-04-10/1775832517
id: 905242
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: 2181
schema_scan_id: 6412129
updated: 2026-04-10 09:49:49

Version 905027

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

ddl:

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

hive_path: s3://sfdl-csv-payrixess-stage/raw/bdr_fees/2026-04-09/1775746159
id: 905027
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: 2181
schema_scan_id: 6411613
updated: 2026-04-09 09:50:25

Version 904814

created: 2026-04-08 09:57:27

ddl:

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

hive_path: s3://sfdl-csv-payrixess-stage/raw/bdr_fees/2026-04-08/1775660194
id: 904814
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: 2181
schema_scan_id: 6411108
updated: 2026-04-08 09:57:38

Version 904600

created: 2026-04-07 09:54:17

ddl:

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

hive_path: s3://sfdl-csv-payrixess-stage/raw/bdr_fees/2026-04-07/1775573595
id: 904600
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: 2181
schema_scan_id: 6410602
updated: 2026-04-07 09:54:28

Version 904386

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

ddl:

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

hive_path: s3://sfdl-csv-payrixess-stage/raw/bdr_fees/2026-04-06/1775487273
id: 904386
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: 2181
schema_scan_id: 6410059
updated: 2026-04-06 09:55:47

Version 904180

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

ddl:

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

hive_path: s3://sfdl-csv-payrixess-stage/raw/bdr_fees/2026-04-05/1775400769
id: 904180
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: 2181
schema_scan_id: 6409629
updated: 2026-04-05 09:53:40

Version 903973

created: 2026-04-04 09:52:06

ddl:

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

hive_path: s3://sfdl-csv-payrixess-stage/raw/bdr_fees/2026-04-04/1775314276
id: 903973
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: 2181
schema_scan_id: 6409243
updated: 2026-04-04 09:52:17

Version 903752

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

ddl:

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

hive_path: s3://sfdl-csv-payrixess-stage/raw/bdr_fees/2026-04-03/1775228021
id: 903752
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: 2181
schema_scan_id: 6408739
updated: 2026-04-03 09:54:41

Schema Scans: 15

Last at 2026-04-17 09:57:02

Scan 6415477

duration: 0:00:12.012881

exit_message:

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

id: 6415477

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/bdr_fees/2026-04-17/1776437766",
        "key": "raw/bdr_fees/2026-04-17/1776437766/83c4b876-db59-41cd-aa0f-05d86ee9bc06.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_bdr_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 12061320012149171711,
        "service_name": "drive-thru",
        "span_id": 13306210461340519728,
        "trace_id": 6275730610143247590
    }
}

running: False
schema_name_id: 2181
start_time: 2026-04-17 09:57:02
success: True
trace_id: 6275730610143247590

Scan 6414948

duration: 0:00:14.365233

exit_message:

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

id: 6414948

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/bdr_fees/2026-04-16/1776350932",
        "key": "raw/bdr_fees/2026-04-16/1776350932/d878a94e-1fb4-4394-927f-e7dd20d5f28c.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_bdr_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 13185473791988825460,
        "service_name": "drive-thru",
        "span_id": 7032591663944601433,
        "trace_id": 17828520098115857380
    }
}

running: False
schema_name_id: 2181
start_time: 2026-04-16 09:49:37
success: True
trace_id: 17828520098115857380

Scan 6414437

duration: 0:00:14.481269

exit_message:

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

id: 6414437

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/bdr_fees/2026-04-15/1776264513",
        "key": "raw/bdr_fees/2026-04-15/1776264513/9a076bd1-745d-44f9-b943-99e8668dde40.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_bdr_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 13594197539928872725,
        "service_name": "drive-thru",
        "span_id": 15963619214656640759,
        "trace_id": 9941738779519999291
    }
}

running: False
schema_name_id: 2181
start_time: 2026-04-15 09:49:28
success: True
trace_id: 9941738779519999291

Scan 6413949

duration: 0:00:14.692853

exit_message:

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

id: 6413949

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/bdr_fees/2026-04-14/1776178512",
        "key": "raw/bdr_fees/2026-04-14/1776178512/1939b6fb-e4c8-4e0c-86d5-d2cee1bcd16d.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_bdr_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 3411523109262284192,
        "service_name": "drive-thru",
        "span_id": 4237344237204104858,
        "trace_id": 12054632486617682106
    }
}

running: False
schema_name_id: 2181
start_time: 2026-04-14 09:55:59
success: True
trace_id: 12054632486617682106

Scan 6413395

duration: 0:00:12.016531

exit_message:

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

id: 6413395

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/bdr_fees/2026-04-13/1776092061",
        "key": "raw/bdr_fees/2026-04-13/1776092061/0e5abf27-f556-4ea7-9ee4-5062baf18abb.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_bdr_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 8224885581257859186,
        "service_name": "drive-thru",
        "span_id": 11982505416671223198,
        "trace_id": 5160127182434738951
    }
}

running: False
schema_name_id: 2181
start_time: 2026-04-13 09:55:21
success: True
trace_id: 5160127182434738951

Scan 6412960

duration: 0:00:14.502976

exit_message:

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

id: 6412960

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/bdr_fees/2026-04-12/1776005449",
        "key": "raw/bdr_fees/2026-04-12/1776005449/4b2523f6-a17f-412b-97a4-11f275b0c84d.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_bdr_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 10342215375673003729,
        "service_name": "drive-thru",
        "span_id": 13109352483555207282,
        "trace_id": 17683721940635377184
    }
}

running: False
schema_name_id: 2181
start_time: 2026-04-12 09:51:34
success: True
trace_id: 17683721940635377184

Scan 6412579

duration: 0:00:11.977411

exit_message:

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

id: 6412579

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/bdr_fees/2026-04-11/1775918948",
        "key": "raw/bdr_fees/2026-04-11/1775918948/6856f0b6-cb92-43fe-8c39-d418742dd0cb.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_bdr_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 13765984061643769412,
        "service_name": "drive-thru",
        "span_id": 4131804243858991451,
        "trace_id": 9443881848489870062
    }
}

running: False
schema_name_id: 2181
start_time: 2026-04-11 09:50:11
success: True
trace_id: 9443881848489870062

Scan 6412129

duration: 0:00:12.241515

exit_message:

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

id: 6412129

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/bdr_fees/2026-04-10/1775832517",
        "key": "raw/bdr_fees/2026-04-10/1775832517/2bfdd0fd-b568-4a86-8518-91a67b0fade6.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_bdr_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 16739414657570775253,
        "service_name": "drive-thru",
        "span_id": 17593354737726278878,
        "trace_id": 14977488788232639658
    }
}

running: False
schema_name_id: 2181
start_time: 2026-04-10 09:49:37
success: True
trace_id: 14977488788232639658

Scan 6411613

duration: 0:00:11.852524

exit_message:

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

id: 6411613

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/bdr_fees/2026-04-09/1775746159",
        "key": "raw/bdr_fees/2026-04-09/1775746159/2d4a9630-edde-49fb-a04b-796197336b3f.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_bdr_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 4775948154308832494,
        "service_name": "drive-thru",
        "span_id": 12687755436033165256,
        "trace_id": 14266622196679130694
    }
}

running: False
schema_name_id: 2181
start_time: 2026-04-09 09:50:13
success: True
trace_id: 14266622196679130694

Scan 6411108

duration: 0:00:11.905439

exit_message:

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

id: 6411108

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/bdr_fees/2026-04-08/1775660194",
        "key": "raw/bdr_fees/2026-04-08/1775660194/5747231f-9ad9-4240-b9bd-80d38f733546.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_bdr_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 14600065434853757509,
        "service_name": "drive-thru",
        "span_id": 1674414578960983645,
        "trace_id": 9610837876281687697
    }
}

running: False
schema_name_id: 2181
start_time: 2026-04-08 09:57:26
success: True
trace_id: 9610837876281687697

Scan 6410602

duration: 0:00:12.121673

exit_message:

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

id: 6410602

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/bdr_fees/2026-04-07/1775573595",
        "key": "raw/bdr_fees/2026-04-07/1775573595/e48c0e35-7aaa-4034-9d7f-f9cea5d43537.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_bdr_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 4729065621387965840,
        "service_name": "drive-thru",
        "span_id": 15907225883902311426,
        "trace_id": 607892327465934133
    }
}

running: False
schema_name_id: 2181
start_time: 2026-04-07 09:54:16
success: True
trace_id: 607892327465934133

Scan 6410059

duration: 0:00:14.479539

exit_message:

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

id: 6410059

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/bdr_fees/2026-04-06/1775487273",
        "key": "raw/bdr_fees/2026-04-06/1775487273/00087afd-969b-4fd4-83c4-375173b83c97.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_bdr_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 1421976980100456277,
        "service_name": "drive-thru",
        "span_id": 15104117819655942068,
        "trace_id": 9578103449088437814
    }
}

running: False
schema_name_id: 2181
start_time: 2026-04-06 09:55:32
success: True
trace_id: 9578103449088437814

Scan 6409629

duration: 0:00:11.727686

exit_message:

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

id: 6409629

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/bdr_fees/2026-04-05/1775400769",
        "key": "raw/bdr_fees/2026-04-05/1775400769/4838aa45-d4ce-4f39-84ed-f076790afc7d.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_bdr_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 3293538120411341055,
        "service_name": "drive-thru",
        "span_id": 7546697047687352127,
        "trace_id": 7223865923608784759
    }
}

running: False
schema_name_id: 2181
start_time: 2026-04-05 09:53:29
success: True
trace_id: 7223865923608784759

Scan 6409243

duration: 0:00:11.799712

exit_message:

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

id: 6409243

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/bdr_fees/2026-04-04/1775314276",
        "key": "raw/bdr_fees/2026-04-04/1775314276/496ce91b-4e35-4290-9638-7511fe94f4c1.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_bdr_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 10453473319936539491,
        "service_name": "drive-thru",
        "span_id": 9648161399354252727,
        "trace_id": 1816625803612603970
    }
}

running: False
schema_name_id: 2181
start_time: 2026-04-04 09:52:05
success: True
trace_id: 1816625803612603970

Scan 6408739

duration: 0:00:11.830917

exit_message:

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

id: 6408739

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/bdr_fees/2026-04-03/1775228021",
        "key": "raw/bdr_fees/2026-04-03/1775228021/d360a3c8-8673-434f-968f-8de65de9fada.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_bdr_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 10366336306242559404,
        "service_name": "drive-thru",
        "span_id": 17266828811881951315,
        "trace_id": 12584459770063392751
    }
}

running: False
schema_name_id: 2181
start_time: 2026-04-03 09:54:29
success: True
trace_id: 12584459770063392751

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:57:02

ddl:

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

Server:

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

Raw:

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