Schema Info

Schema Name: sfdl_stage_csv.payrixess_bdr_assessments

created: 2024-07-22 13:15:29
disabled: False
format: raw
id: 2168
is_partitioned: False
is_schema_datatyped: True

name:

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

type: csv

Schema Versions: 15

Version 906710

created: 2026-04-17 09:39:35

ddl:

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

hive_path: s3://sfdl-csv-payrixess-stage/raw/bdr_assessments/2026-04-17/1776436719
id: 906710
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: 2168
schema_scan_id: 6415464
updated: 2026-04-17 09:39:49

Version 906487

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

ddl:

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

hive_path: s3://sfdl-csv-payrixess-stage/raw/bdr_assessments/2026-04-16/1776350406
id: 906487
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: 2168
schema_scan_id: 6414881
updated: 2026-04-16 09:41:28

Version 906286

created: 2026-04-15 09:47:48

ddl:

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

hive_path: s3://sfdl-csv-payrixess-stage/raw/bdr_assessments/2026-04-15/1776264399
id: 906286
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: 2168
schema_scan_id: 6414434
updated: 2026-04-15 09:47:59

Version 906071

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

ddl:

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

hive_path: s3://sfdl-csv-payrixess-stage/raw/bdr_assessments/2026-04-14/1776177896
id: 906071
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: 2168
schema_scan_id: 6413941
updated: 2026-04-14 09:46:14

Version 905858

created: 2026-04-13 09:47:01

ddl:

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

hive_path: s3://sfdl-csv-payrixess-stage/raw/bdr_assessments/2026-04-13/1776091552
id: 905858
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: 2168
schema_scan_id: 6413388
updated: 2026-04-13 09:47:13

Version 905644

created: 2026-04-12 09:43:29

ddl:

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

hive_path: s3://sfdl-csv-payrixess-stage/raw/bdr_assessments/2026-04-12/1776004947
id: 905644
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: 2168
schema_scan_id: 6412929
updated: 2026-04-12 09:43:43

Version 905438

created: 2026-04-11 09:41:39

ddl:

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

hive_path: s3://sfdl-csv-payrixess-stage/raw/bdr_assessments/2026-04-11/1775918449
id: 905438
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: 2168
schema_scan_id: 6412549
updated: 2026-04-11 09:41:53

Version 905218

created: 2026-04-10 09:39:28

ddl:

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

hive_path: s3://sfdl-csv-payrixess-stage/raw/bdr_assessments/2026-04-10/1775831910
id: 905218
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: 2168
schema_scan_id: 6412058
updated: 2026-04-10 09:39:39

Version 905010

created: 2026-04-09 09:42:16

ddl:

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

hive_path: s3://sfdl-csv-payrixess-stage/raw/bdr_assessments/2026-04-09/1775745683
id: 905010
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: 2168
schema_scan_id: 6411530
updated: 2026-04-09 09:42:28

Version 904799

created: 2026-04-08 09:40:42

ddl:

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

hive_path: s3://sfdl-csv-payrixess-stage/raw/bdr_assessments/2026-04-08/1775659181
id: 904799
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: 2168
schema_scan_id: 6411091
updated: 2026-04-08 09:41:16

Version 904583

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

ddl:

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

hive_path: s3://sfdl-csv-payrixess-stage/raw/bdr_assessments/2026-04-07/1775572695
id: 904583
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: 2168
schema_scan_id: 6410537
updated: 2026-04-07 09:39:52

Version 904381

created: 2026-04-06 09:43:28

ddl:

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

hive_path: s3://sfdl-csv-payrixess-stage/raw/bdr_assessments/2026-04-06/1775486545
id: 904381
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: 2168
schema_scan_id: 6410051
updated: 2026-04-06 09:43:42

Version 904167

created: 2026-04-05 09:42:52

ddl:

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

hive_path: s3://sfdl-csv-payrixess-stage/raw/bdr_assessments/2026-04-05/1775400121
id: 904167
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: 2168
schema_scan_id: 6409612
updated: 2026-04-05 09:43:05

Version 903965

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

ddl:

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

hive_path: s3://sfdl-csv-payrixess-stage/raw/bdr_assessments/2026-04-04/1775314155
id: 903965
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: 2168
schema_scan_id: 6409227
updated: 2026-04-04 09:50:25

Version 903743

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

ddl:

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

hive_path: s3://sfdl-csv-payrixess-stage/raw/bdr_assessments/2026-04-03/1775227534
id: 903743
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: 2168
schema_scan_id: 6408679
updated: 2026-04-03 09:46:47

Schema Scans: 15

Last at 2026-04-17 09:39:35

Scan 6415464

duration: 0:00:14.549756

exit_message:

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

id: 6415464

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_assessments/2026-04-17/1776436719",
        "key": "raw/bdr_assessments/2026-04-17/1776436719/c9e45b0a-367e-493b-90ad-b3926a0e976f.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_bdr_assessments",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 18303619353956259104,
        "service_name": "drive-thru",
        "span_id": 17144321294207297110,
        "trace_id": 7085563124623720625
    }
}

running: False
schema_name_id: 2168
start_time: 2026-04-17 09:39:35
success: True
trace_id: 7085563124623720625

Scan 6414881

duration: 0:00:14.389124

exit_message:

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

id: 6414881

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_assessments/2026-04-16/1776350406",
        "key": "raw/bdr_assessments/2026-04-16/1776350406/ac6c3721-415f-4bb0-9a48-7ed5397bff51.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_bdr_assessments",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 11952495083205569267,
        "service_name": "drive-thru",
        "span_id": 5301022303781751051,
        "trace_id": 12763217453226362591
    }
}

running: False
schema_name_id: 2168
start_time: 2026-04-16 09:41:13
success: True
trace_id: 12763217453226362591

Scan 6414434

duration: 0:00:11.814054

exit_message:

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

id: 6414434

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_assessments/2026-04-15/1776264399",
        "key": "raw/bdr_assessments/2026-04-15/1776264399/5d8a91d4-7add-4c1b-b011-56eeb5cd94e8.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_bdr_assessments",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 11614861784275172861,
        "service_name": "drive-thru",
        "span_id": 12127606335711325429,
        "trace_id": 10929159441356663169
    }
}

running: False
schema_name_id: 2168
start_time: 2026-04-15 09:47:48
success: True
trace_id: 10929159441356663169

Scan 6413941

duration: 0:00:11.942308

exit_message:

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

id: 6413941

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_assessments/2026-04-14/1776177896",
        "key": "raw/bdr_assessments/2026-04-14/1776177896/b5e7dd44-2a3d-4153-9e66-0013e58311db.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_bdr_assessments",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 5167369566659633208,
        "service_name": "drive-thru",
        "span_id": 13428767528670697531,
        "trace_id": 4281726348268101737
    }
}

running: False
schema_name_id: 2168
start_time: 2026-04-14 09:46:02
success: True
trace_id: 4281726348268101737

Scan 6413388

duration: 0:00:11.859370

exit_message:

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

id: 6413388

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_assessments/2026-04-13/1776091552",
        "key": "raw/bdr_assessments/2026-04-13/1776091552/341a2f9b-2482-487d-a267-31f66297a81d.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_bdr_assessments",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 8428831696527505709,
        "service_name": "drive-thru",
        "span_id": 13880742290506255596,
        "trace_id": 17235982367872070077
    }
}

running: False
schema_name_id: 2168
start_time: 2026-04-13 09:47:01
success: True
trace_id: 17235982367872070077

Scan 6412929

duration: 0:00:14.294452

exit_message:

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

id: 6412929

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_assessments/2026-04-12/1776004947",
        "key": "raw/bdr_assessments/2026-04-12/1776004947/e7c1e020-d62d-4561-ba1b-db755ab06989.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_bdr_assessments",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 8767727025953971984,
        "service_name": "drive-thru",
        "span_id": 2674718275825305164,
        "trace_id": 6838809429375698346
    }
}

running: False
schema_name_id: 2168
start_time: 2026-04-12 09:43:29
success: True
trace_id: 6838809429375698346

Scan 6412549

duration: 0:00:14.194929

exit_message:

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

id: 6412549

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_assessments/2026-04-11/1775918449",
        "key": "raw/bdr_assessments/2026-04-11/1775918449/201a7e61-3a96-4108-beba-bc75caec9169.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_bdr_assessments",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 17901817350950567693,
        "service_name": "drive-thru",
        "span_id": 9717571075554328456,
        "trace_id": 12385544252289647536
    }
}

running: False
schema_name_id: 2168
start_time: 2026-04-11 09:41:39
success: True
trace_id: 12385544252289647536

Scan 6412058

duration: 0:00:11.734933

exit_message:

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

id: 6412058

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_assessments/2026-04-10/1775831910",
        "key": "raw/bdr_assessments/2026-04-10/1775831910/dd50f812-ba5a-408c-a671-4eac124f0382.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_bdr_assessments",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 217091863141107931,
        "service_name": "drive-thru",
        "span_id": 11317128844377247777,
        "trace_id": 7378825657830855570
    }
}

running: False
schema_name_id: 2168
start_time: 2026-04-10 09:39:28
success: True
trace_id: 7378825657830855570

Scan 6411530

duration: 0:00:11.965061

exit_message:

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

id: 6411530

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_assessments/2026-04-09/1775745683",
        "key": "raw/bdr_assessments/2026-04-09/1775745683/89e289a4-07f3-4f80-9f75-6e9f11c2af93.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_bdr_assessments",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 4649121297802232874,
        "service_name": "drive-thru",
        "span_id": 5391294731271005817,
        "trace_id": 718420404505556400
    }
}

running: False
schema_name_id: 2168
start_time: 2026-04-09 09:42:16
success: True
trace_id: 718420404505556400

Scan 6411091

duration: 0:00:34.685089

exit_message:

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

id: 6411091

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_assessments/2026-04-08/1775659181",
        "key": "raw/bdr_assessments/2026-04-08/1775659181/7733a89e-ddd6-490e-a8f7-aaf5235dd626.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_bdr_assessments",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 8904454321258572798,
        "service_name": "drive-thru",
        "span_id": 13655359709080959220,
        "trace_id": 3489542927386185569
    }
}

running: False
schema_name_id: 2168
start_time: 2026-04-08 09:40:41
success: True
trace_id: 3489542927386185569

Scan 6410537

duration: 0:00:14.402047

exit_message:

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

id: 6410537

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_assessments/2026-04-07/1775572695",
        "key": "raw/bdr_assessments/2026-04-07/1775572695/e0f2ed82-d5eb-40e9-8095-1e112521d36e.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_bdr_assessments",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 6454830538044355925,
        "service_name": "drive-thru",
        "span_id": 5247082213602408822,
        "trace_id": 9773817077747571990
    }
}

running: False
schema_name_id: 2168
start_time: 2026-04-07 09:39:38
success: True
trace_id: 9773817077747571990

Scan 6410051

duration: 0:00:14.365507

exit_message:

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

id: 6410051

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_assessments/2026-04-06/1775486545",
        "key": "raw/bdr_assessments/2026-04-06/1775486545/da154537-a700-449e-bdb6-09a2f5438cf2.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_bdr_assessments",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 2983580511576198617,
        "service_name": "drive-thru",
        "span_id": 6910152871693315305,
        "trace_id": 8159587330940106765
    }
}

running: False
schema_name_id: 2168
start_time: 2026-04-06 09:43:27
success: True
trace_id: 8159587330940106765

Scan 6409612

duration: 0:00:14.299670

exit_message:

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

id: 6409612

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_assessments/2026-04-05/1775400121",
        "key": "raw/bdr_assessments/2026-04-05/1775400121/30a39e20-435a-49b5-94da-8401ccf7a8a9.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_bdr_assessments",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 13031764550471117331,
        "service_name": "drive-thru",
        "span_id": 7268146486879795349,
        "trace_id": 540284201878117296
    }
}

running: False
schema_name_id: 2168
start_time: 2026-04-05 09:42:51
success: True
trace_id: 540284201878117296

Scan 6409227

duration: 0:00:14.248586

exit_message:

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

id: 6409227

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_assessments/2026-04-04/1775314155",
        "key": "raw/bdr_assessments/2026-04-04/1775314155/d1b0bd2e-b190-423b-9c1d-7c278a9f53c0.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_bdr_assessments",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 16821859738045498869,
        "service_name": "drive-thru",
        "span_id": 7682372003550510704,
        "trace_id": 4413598924185199174
    }
}

running: False
schema_name_id: 2168
start_time: 2026-04-04 09:50:10
success: True
trace_id: 4413598924185199174

Scan 6408679

duration: 0:00:11.901189

exit_message:

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

id: 6408679

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_assessments/2026-04-03/1775227534",
        "key": "raw/bdr_assessments/2026-04-03/1775227534/1b010587-396a-4b0f-8505-8c784075408b.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_bdr_assessments",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 2206646630308779359,
        "service_name": "drive-thru",
        "span_id": 4386996063494730562,
        "trace_id": 12350025161291670450
    }
}

running: False
schema_name_id: 2168
start_time: 2026-04-03 09:46:35
success: True
trace_id: 12350025161291670450

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:39:35

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_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-stage/raw/bdr_assessments/2026-04-17/1776436719'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_csv.payrixess_bdr_assessments`",
    "repair_table": "MSCK REPAIR TABLE sfdl_stage_csv.payrixess_bdr_assessments"
}

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:15:29",
        "disabled": false,
        "format": "raw",
        "id": 2168,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_stage_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:39:35",
        "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_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-stage/raw/bdr_assessments/2026-04-17/1776436719'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_csv.payrixess_bdr_assessments`",
            "repair_table": "MSCK REPAIR TABLE sfdl_stage_csv.payrixess_bdr_assessments"
        }
    },
    "server": {
        "hostname": "schemamanager-5c55c886bf-h2ts4",
        "name": "schema_manager",
        "process_start": "2025-10-21 13:03:27",
        "sf_env": "stage",
        "version": "2112174301"
    }
}