Schema Info

Schema Name: sfdl_prod_csv.payrixess_bdr_assessments

created: 2024-07-24 10:29:10
disabled: False
format: raw
id: 1973
is_partitioned: False
is_schema_datatyped: True

name:

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

type: csv

Schema Versions: 15

Version 1718276

created: 2026-04-17 09:49:18

ddl:

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

hive_path: s3://sfdl-csv-payrixess-prod/raw/bdr_assessments/2026-04-17/1776437275
id: 1718276
processed: 1

raw_data:

{
    "assessment_id": 0,
    "fee_amount": 3,
    "fee_name": 1,
    "type_amount": 2
}

schema_attributes:

{
    "assessment_id": "string",
    "fee_amount": "string",
    "fee_name": "string",
    "type_amount": "string"
}

schema_name_id: 1973
schema_scan_id: 162179058
updated: 2026-04-17 09:49:30

Version 1717055

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

ddl:

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

hive_path: s3://sfdl-csv-payrixess-prod/raw/bdr_assessments/2026-04-16/1776350719
id: 1717055
processed: 1

raw_data:

{
    "assessment_id": 0,
    "fee_amount": 3,
    "fee_name": 1,
    "type_amount": 2
}

schema_attributes:

{
    "assessment_id": "string",
    "fee_amount": "string",
    "fee_name": "string",
    "type_amount": "string"
}

schema_name_id: 1973
schema_scan_id: 162122975
updated: 2026-04-16 09:46:49

Version 1715829

created: 2026-04-15 09:40:38

ddl:

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

hive_path: s3://sfdl-csv-payrixess-prod/raw/bdr_assessments/2026-04-15/1776263970
id: 1715829
processed: 1

raw_data:

{
    "assessment_id": 0,
    "fee_amount": 3,
    "fee_name": 1,
    "type_amount": 2
}

schema_attributes:

{
    "assessment_id": "string",
    "fee_amount": "string",
    "fee_name": "string",
    "type_amount": "string"
}

schema_name_id: 1973
schema_scan_id: 162067246
updated: 2026-04-15 09:40:52

Version 1714631

created: 2026-04-14 09:40:59

ddl:

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

hive_path: s3://sfdl-csv-payrixess-prod/raw/bdr_assessments/2026-04-14/1776177585
id: 1714631
processed: 1

raw_data:

{
    "assessment_id": 0,
    "fee_amount": 3,
    "fee_name": 1,
    "type_amount": 2
}

schema_attributes:

{
    "assessment_id": "string",
    "fee_amount": "string",
    "fee_name": "string",
    "type_amount": "string"
}

schema_name_id: 1973
schema_scan_id: 162011388
updated: 2026-04-14 09:41:10

Version 1713430

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

ddl:

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

hive_path: s3://sfdl-csv-payrixess-prod/raw/bdr_assessments/2026-04-13/1776091466
id: 1713430
processed: 1

raw_data:

{
    "assessment_id": 0,
    "fee_amount": 3,
    "fee_name": 1,
    "type_amount": 2
}

schema_attributes:

{
    "assessment_id": "string",
    "fee_amount": "string",
    "fee_name": "string",
    "type_amount": "string"
}

schema_name_id: 1973
schema_scan_id: 161953899
updated: 2026-04-13 09:45:52

Version 1712248

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

ddl:

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

hive_path: s3://sfdl-csv-payrixess-prod/raw/bdr_assessments/2026-04-12/1776005004
id: 1712248
processed: 1

raw_data:

{
    "assessment_id": 0,
    "fee_amount": 3,
    "fee_name": 1,
    "type_amount": 2
}

schema_attributes:

{
    "assessment_id": "string",
    "fee_amount": "string",
    "fee_name": "string",
    "type_amount": "string"
}

schema_name_id: 1973
schema_scan_id: 161903647
updated: 2026-04-12 09:44:24

Version 1711032

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

ddl:

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

hive_path: s3://sfdl-csv-payrixess-prod/raw/bdr_assessments/2026-04-11/1775918610
id: 1711032
processed: 1

raw_data:

{
    "assessment_id": 0,
    "fee_amount": 3,
    "fee_name": 1,
    "type_amount": 2
}

schema_attributes:

{
    "assessment_id": "string",
    "fee_amount": "string",
    "fee_name": "string",
    "type_amount": "string"
}

schema_name_id: 1973
schema_scan_id: 161852119
updated: 2026-04-11 09:44:46

Version 1709866

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

ddl:

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

hive_path: s3://sfdl-csv-payrixess-prod/raw/bdr_assessments/2026-04-10/1775832239
id: 1709866
processed: 1

raw_data:

{
    "assessment_id": 0,
    "fee_amount": 3,
    "fee_name": 1,
    "type_amount": 2
}

schema_attributes:

{
    "assessment_id": "string",
    "fee_amount": "string",
    "fee_name": "string",
    "type_amount": "string"
}

schema_name_id: 1973
schema_scan_id: 161797588
updated: 2026-04-10 09:47:03

Version 1708708

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

ddl:

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

hive_path: s3://sfdl-csv-payrixess-prod/raw/bdr_assessments/2026-04-09/1775745963
id: 1708708
processed: 1

raw_data:

{
    "assessment_id": 0,
    "fee_amount": 3,
    "fee_name": 1,
    "type_amount": 2
}

schema_attributes:

{
    "assessment_id": "string",
    "fee_amount": "string",
    "fee_name": "string",
    "type_amount": "string"
}

schema_name_id: 1973
schema_scan_id: 161741713
updated: 2026-04-09 09:47:08

Version 1707531

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

ddl:

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

hive_path: s3://sfdl-csv-payrixess-prod/raw/bdr_assessments/2026-04-08/1775659479
id: 1707531
processed: 1

raw_data:

{
    "assessment_id": 0,
    "fee_amount": 3,
    "fee_name": 1,
    "type_amount": 2
}

schema_attributes:

{
    "assessment_id": "string",
    "fee_amount": "string",
    "fee_name": "string",
    "type_amount": "string"
}

schema_name_id: 1973
schema_scan_id: 161686654
updated: 2026-04-08 09:48:32

Version 1706329

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

ddl:

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

hive_path: s3://sfdl-csv-payrixess-prod/raw/bdr_assessments/2026-04-07/1775572983
id: 1706329
processed: 1

raw_data:

{
    "assessment_id": 0,
    "fee_amount": 3,
    "fee_name": 1,
    "type_amount": 2
}

schema_attributes:

{
    "assessment_id": "string",
    "fee_amount": "string",
    "fee_name": "string",
    "type_amount": "string"
}

schema_name_id: 1973
schema_scan_id: 161630575
updated: 2026-04-07 09:44:40

Version 1705102

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

ddl:

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

hive_path: s3://sfdl-csv-payrixess-prod/raw/bdr_assessments/2026-04-06/1775486439
id: 1705102
processed: 1

raw_data:

{
    "assessment_id": 0,
    "fee_amount": 3,
    "fee_name": 1,
    "type_amount": 2
}

schema_attributes:

{
    "assessment_id": "string",
    "fee_amount": "string",
    "fee_name": "string",
    "type_amount": "string"
}

schema_name_id: 1973
schema_scan_id: 161572916
updated: 2026-04-06 09:41:56

Version 1703884

created: 2026-04-05 09:44:16

ddl:

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

hive_path: s3://sfdl-csv-payrixess-prod/raw/bdr_assessments/2026-04-05/1775400208
id: 1703884
processed: 1

raw_data:

{
    "assessment_id": 0,
    "fee_amount": 3,
    "fee_name": 1,
    "type_amount": 2
}

schema_attributes:

{
    "assessment_id": "string",
    "fee_amount": "string",
    "fee_name": "string",
    "type_amount": "string"
}

schema_name_id: 1973
schema_scan_id: 161523919
updated: 2026-04-05 09:44:30

Version 1702738

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

ddl:

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

hive_path: s3://sfdl-csv-payrixess-prod/raw/bdr_assessments/2026-04-04/1775314277
id: 1702738
processed: 1

raw_data:

{
    "assessment_id": 0,
    "fee_amount": 3,
    "fee_name": 1,
    "type_amount": 2
}

schema_attributes:

{
    "assessment_id": "string",
    "fee_amount": "string",
    "fee_name": "string",
    "type_amount": "string"
}

schema_name_id: 1973
schema_scan_id: 161472186
updated: 2026-04-04 09:52:25

Version 1701536

created: 2026-04-03 09:42:26

ddl:

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

hive_path: s3://sfdl-csv-payrixess-prod/raw/bdr_assessments/2026-04-03/1775227293
id: 1701536
processed: 1

raw_data:

{
    "assessment_id": 0,
    "fee_amount": 3,
    "fee_name": 1,
    "type_amount": 2
}

schema_attributes:

{
    "assessment_id": "string",
    "fee_amount": "string",
    "fee_name": "string",
    "type_amount": "string"
}

schema_name_id: 1973
schema_scan_id: 161414596
updated: 2026-04-03 09:42:37

Schema Scans: 15

Last at 2026-04-17 09:49:18

Scan 162179058

duration: 0:00:11.659940

exit_message:

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

id: 162179058

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/bdr_assessments/2026-04-17/1776437275",
        "key": "raw/bdr_assessments/2026-04-17/1776437275/049450af-51a8-44f2-8927-f9d702d79c5f.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_bdr_assessments",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 2269916605550296334,
        "service_name": "drive-thru",
        "span_id": 16843469888573395479,
        "trace_id": 10928393930948468983
    }
}

running: False
schema_name_id: 1973
start_time: 2026-04-17 09:49:18
success: True
trace_id: 10928393930948468983

Scan 162122975

duration: 0:00:14.348463

exit_message:

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

id: 162122975

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/bdr_assessments/2026-04-16/1776350719",
        "key": "raw/bdr_assessments/2026-04-16/1776350719/f1b3b0a6-ae0b-49f8-a56d-fa1282855c2a.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_bdr_assessments",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 1911072823935968862,
        "service_name": "drive-thru",
        "span_id": 159922865228096684,
        "trace_id": 12773692997487855453
    }
}

running: False
schema_name_id: 1973
start_time: 2026-04-16 09:46:34
success: True
trace_id: 12773692997487855453

Scan 162067246

duration: 0:00:14.239072

exit_message:

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

id: 162067246

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/bdr_assessments/2026-04-15/1776263970",
        "key": "raw/bdr_assessments/2026-04-15/1776263970/3c27b6b4-d484-4b1d-b5dd-4801e2c7af8a.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_bdr_assessments",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 4226291686852145733,
        "service_name": "drive-thru",
        "span_id": 18247977941575993933,
        "trace_id": 14100568519033735784
    }
}

running: False
schema_name_id: 1973
start_time: 2026-04-15 09:40:38
success: True
trace_id: 14100568519033735784

Scan 162011388

duration: 0:00:11.655485

exit_message:

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

id: 162011388

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/bdr_assessments/2026-04-14/1776177585",
        "key": "raw/bdr_assessments/2026-04-14/1776177585/a21e0a3b-a5c8-4e70-ab5e-abd9edf0e081.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_bdr_assessments",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 8432878878321392341,
        "service_name": "drive-thru",
        "span_id": 15056698888602448446,
        "trace_id": 6119533011468925470
    }
}

running: False
schema_name_id: 1973
start_time: 2026-04-14 09:40:58
success: True
trace_id: 6119533011468925470

Scan 161953899

duration: 0:00:14.318324

exit_message:

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

id: 161953899

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/bdr_assessments/2026-04-13/1776091466",
        "key": "raw/bdr_assessments/2026-04-13/1776091466/cb3e0cf7-c3cf-4b3e-aa63-03cad87de05b.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_bdr_assessments",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 8557351297165541947,
        "service_name": "drive-thru",
        "span_id": 14947955473883834342,
        "trace_id": 5500049973040644907
    }
}

running: False
schema_name_id: 1973
start_time: 2026-04-13 09:45:38
success: True
trace_id: 5500049973040644907

Scan 161903647

duration: 0:00:11.689606

exit_message:

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

id: 161903647

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/bdr_assessments/2026-04-12/1776005004",
        "key": "raw/bdr_assessments/2026-04-12/1776005004/327e7702-aa12-4e6f-b5aa-2613de648552.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_bdr_assessments",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 10308186073441375353,
        "service_name": "drive-thru",
        "span_id": 8066947794636527046,
        "trace_id": 18393653202123214295
    }
}

running: False
schema_name_id: 1973
start_time: 2026-04-12 09:44:12
success: True
trace_id: 18393653202123214295

Scan 161852119

duration: 0:00:11.660598

exit_message:

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

id: 161852119

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/bdr_assessments/2026-04-11/1775918610",
        "key": "raw/bdr_assessments/2026-04-11/1775918610/e3ed622d-fd63-48a7-8468-4f5039819b6c.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_bdr_assessments",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 10503112492825075076,
        "service_name": "drive-thru",
        "span_id": 6378864709561814661,
        "trace_id": 1510256163027519839
    }
}

running: False
schema_name_id: 1973
start_time: 2026-04-11 09:44:34
success: True
trace_id: 1510256163027519839

Scan 161797588

duration: 0:00:14.234531

exit_message:

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

id: 161797588

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/bdr_assessments/2026-04-10/1775832239",
        "key": "raw/bdr_assessments/2026-04-10/1775832239/fae8d986-be62-4102-bbf6-ec2474aa50f2.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_bdr_assessments",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 17029945434184275296,
        "service_name": "drive-thru",
        "span_id": 15331084944116859266,
        "trace_id": 14510344025878848741
    }
}

running: False
schema_name_id: 1973
start_time: 2026-04-10 09:46:49
success: True
trace_id: 14510344025878848741

Scan 161741713

duration: 0:00:14.171756

exit_message:

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

id: 161741713

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/bdr_assessments/2026-04-09/1775745963",
        "key": "raw/bdr_assessments/2026-04-09/1775745963/33353312-9e20-4e91-8f2b-f01df388ce76.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_bdr_assessments",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 943696638375640498,
        "service_name": "drive-thru",
        "span_id": 3368123419928573471,
        "trace_id": 14210427776303861226
    }
}

running: False
schema_name_id: 1973
start_time: 2026-04-09 09:46:54
success: True
trace_id: 14210427776303861226

Scan 161686654

duration: 0:00:14.267731

exit_message:

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

id: 161686654

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/bdr_assessments/2026-04-08/1775659479",
        "key": "raw/bdr_assessments/2026-04-08/1775659479/8e9ee9d0-6f9d-451d-9262-d52e9847ba3d.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_bdr_assessments",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 11410751912032160329,
        "service_name": "drive-thru",
        "span_id": 18111783218212028892,
        "trace_id": 7187863450860754628
    }
}

running: False
schema_name_id: 1973
start_time: 2026-04-08 09:48:18
success: True
trace_id: 7187863450860754628

Scan 161630575

duration: 0:00:14.420728

exit_message:

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

id: 161630575

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/bdr_assessments/2026-04-07/1775572983",
        "key": "raw/bdr_assessments/2026-04-07/1775572983/3fd02880-c3ca-4be4-bb71-854989ba0f79.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_bdr_assessments",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 1117856333760881744,
        "service_name": "drive-thru",
        "span_id": 18090375684792246744,
        "trace_id": 1714623619509007715
    }
}

running: False
schema_name_id: 1973
start_time: 2026-04-07 09:44:26
success: True
trace_id: 1714623619509007715

Scan 161572916

duration: 0:00:11.712064

exit_message:

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

id: 161572916

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/bdr_assessments/2026-04-06/1775486439",
        "key": "raw/bdr_assessments/2026-04-06/1775486439/96a62d4a-8ce5-42d5-b76a-8e49e94d5eed.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_bdr_assessments",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 849390735333911965,
        "service_name": "drive-thru",
        "span_id": 12376567081907135306,
        "trace_id": 610826752987497147
    }
}

running: False
schema_name_id: 1973
start_time: 2026-04-06 09:41:45
success: True
trace_id: 610826752987497147

Scan 161523919

duration: 0:00:14.284219

exit_message:

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

id: 161523919

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/bdr_assessments/2026-04-05/1775400208",
        "key": "raw/bdr_assessments/2026-04-05/1775400208/d5213f8b-6b59-492b-b292-f750b34cfe65.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_bdr_assessments",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 15768354057092361369,
        "service_name": "drive-thru",
        "span_id": 3149109115922970899,
        "trace_id": 168629797490197898
    }
}

running: False
schema_name_id: 1973
start_time: 2026-04-05 09:44:16
success: True
trace_id: 168629797490197898

Scan 161472186

duration: 0:00:14.172397

exit_message:

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

id: 161472186

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/bdr_assessments/2026-04-04/1775314277",
        "key": "raw/bdr_assessments/2026-04-04/1775314277/2e258554-8387-495d-9574-33f650586a26.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_bdr_assessments",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 7260538375115082190,
        "service_name": "drive-thru",
        "span_id": 8876609222114019672,
        "trace_id": 127599496128418435
    }
}

running: False
schema_name_id: 1973
start_time: 2026-04-04 09:52:11
success: True
trace_id: 127599496128418435

Scan 161414596

duration: 0:00:11.773799

exit_message:

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

id: 161414596

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/bdr_assessments/2026-04-03/1775227293",
        "key": "raw/bdr_assessments/2026-04-03/1775227293/fc92286a-0932-4665-97db-b78852dd0494.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_bdr_assessments",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 3121581414284244098,
        "service_name": "drive-thru",
        "span_id": 15617113110180105960,
        "trace_id": 7184732885471092319
    }
}

running: False
schema_name_id: 1973
start_time: 2026-04-03 09:42:26
success: True
trace_id: 7184732885471092319

Partitions:

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

Schema:

attributes:

{
    "assessment_id": "string",
    "fee_amount": "string",
    "fee_name": "string",
    "type_amount": "string"
}

created: 2026-04-17 09:49:18

ddl:

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

Server:

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

Raw:

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