Schema Info

Schema Name: sfdl_prod_csv.payrix_bdr_assessments

created: 2024-07-10 09:36:16
disabled: False
format: raw
id: 1927
is_partitioned: False
is_schema_datatyped: True

name:

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

type: csv

Schema Versions: 15

Version 1718254

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/bdr_assessments/2026-04-17/1776436378
id: 1718254
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: 1927
schema_scan_id: 162178466
updated: 2026-04-17 09:33:13

Version 1717015

created: 2026-04-16 09:26:57

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/bdr_assessments/2026-04-16/1776349599
id: 1717015
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: 1927
schema_scan_id: 162122647
updated: 2026-04-16 09:27:11

Version 1715884

created: 2026-04-15 11:27:13

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/bdr_assessments/2026-04-15/1776270426
id: 1715884
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: 1927
schema_scan_id: 162072776
updated: 2026-04-15 11:27:24

Version 1714951

created: 2026-04-14 21:11:55

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/bdr_assessments/2026-04-14/1776219105
id: 1714951
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: 1927
schema_scan_id: 162046409
updated: 2026-04-14 21:12:06

Version 1713421

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/bdr_assessments/2026-04-13/1776090894
id: 1713421
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: 1927
schema_scan_id: 161953757
updated: 2026-04-13 09:35:13

Version 1712225

created: 2026-04-12 09:32:38

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/bdr_assessments/2026-04-12/1776004351
id: 1712225
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: 1927
schema_scan_id: 161903510
updated: 2026-04-12 09:32:52

Version 1711018

created: 2026-04-11 09:30:09

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/bdr_assessments/2026-04-11/1775917791
id: 1711018
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: 1927
schema_scan_id: 161852024
updated: 2026-04-11 09:30:21

Version 1709827

created: 2026-04-10 09:26:24

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/bdr_assessments/2026-04-10/1775831179
id: 1709827
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: 1927
schema_scan_id: 161797234
updated: 2026-04-10 09:26:36

Version 1708696

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/bdr_assessments/2026-04-09/1775745492
id: 1708696
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: 1927
schema_scan_id: 161741480
updated: 2026-04-09 09:38:27

Version 1707520

created: 2026-04-08 09:36:25

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/bdr_assessments/2026-04-08/1775658908
id: 1707520
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: 1927
schema_scan_id: 161686340
updated: 2026-04-08 09:36:38

Version 1706308

created: 2026-04-07 09:29:21

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/bdr_assessments/2026-04-07/1775572158
id: 1706308
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: 1927
schema_scan_id: 161630228
updated: 2026-04-07 09:29:32

Version 1705086

created: 2026-04-06 09:30:24

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/bdr_assessments/2026-04-06/1775485820
id: 1705086
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: 1927
schema_scan_id: 161572761
updated: 2026-04-06 09:30:35

Version 1703852

created: 2026-04-05 09:27:58

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/bdr_assessments/2026-04-05/1775399267
id: 1703852
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: 1927
schema_scan_id: 161523748
updated: 2026-04-05 09:28:12

Version 1702740

created: 2026-04-04 09:55:27

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/bdr_assessments/2026-04-04/1775314519
id: 1702740
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: 1927
schema_scan_id: 161472333
updated: 2026-04-04 09:55:38

Version 1701548

created: 2026-04-03 09:58:28

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/bdr_assessments/2026-04-03/1775228210
id: 1701548
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: 1927
schema_scan_id: 161415822
updated: 2026-04-03 09:58:42

Schema Scans: 15

Last at 2026-04-17 09:33:01

Scan 162178466

duration: 0:00:11.845631

exit_message:

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

id: 162178466

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/bdr_assessments/2026-04-17/1776436378",
        "key": "raw/bdr_assessments/2026-04-17/1776436378/cbf748d4-d668-40f8-809a-4e107b7f20f8.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_bdr_assessments",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 14434450093063671784,
        "service_name": "drive-thru",
        "span_id": 14278184850812505887,
        "trace_id": 17211477674090918619
    }
}

running: False
schema_name_id: 1927
start_time: 2026-04-17 09:33:01
success: True
trace_id: 17211477674090918619

Scan 162122647

duration: 0:00:14.282685

exit_message:

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

id: 162122647

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/bdr_assessments/2026-04-16/1776349599",
        "key": "raw/bdr_assessments/2026-04-16/1776349599/7a9106b4-84bf-44ab-ad6f-5f6372bbf1cb.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_bdr_assessments",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 16640913744103161259,
        "service_name": "drive-thru",
        "span_id": 280552177698925257,
        "trace_id": 4430653567863930067
    }
}

running: False
schema_name_id: 1927
start_time: 2026-04-16 09:26:56
success: True
trace_id: 4430653567863930067

Scan 162072776

duration: 0:00:11.696766

exit_message:

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

id: 162072776

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/bdr_assessments/2026-04-15/1776270426",
        "key": "raw/bdr_assessments/2026-04-15/1776270426/cea13df4-8429-4cd6-b85d-d95498d80936.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_bdr_assessments",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 9188893108800484085,
        "service_name": "drive-thru",
        "span_id": 4524811497993117013,
        "trace_id": 9519301110208556923
    }
}

running: False
schema_name_id: 1927
start_time: 2026-04-15 11:27:13
success: True
trace_id: 9519301110208556923

Scan 162046409

duration: 0:00:11.736234

exit_message:

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

id: 162046409

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/bdr_assessments/2026-04-14/1776219105",
        "key": "raw/bdr_assessments/2026-04-14/1776219105/6eb3ca0d-2f8e-4ad5-85dc-ff4a89eb464b.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_bdr_assessments",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 3707340294021624036,
        "service_name": "drive-thru",
        "span_id": 17498087435770086625,
        "trace_id": 17912647926784833312
    }
}

running: False
schema_name_id: 1927
start_time: 2026-04-14 21:11:55
success: True
trace_id: 17912647926784833312

Scan 161953757

duration: 0:00:12.058124

exit_message:

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

id: 161953757

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/bdr_assessments/2026-04-13/1776090894",
        "key": "raw/bdr_assessments/2026-04-13/1776090894/d6367047-27bf-4eb9-b969-49d693dc11dc.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_bdr_assessments",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 12244562185553424803,
        "service_name": "drive-thru",
        "span_id": 1930018466097880460,
        "trace_id": 2388669124447569843
    }
}

running: False
schema_name_id: 1927
start_time: 2026-04-13 09:35:01
success: True
trace_id: 2388669124447569843

Scan 161903510

duration: 0:00:14.209296

exit_message:

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

id: 161903510

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/bdr_assessments/2026-04-12/1776004351",
        "key": "raw/bdr_assessments/2026-04-12/1776004351/f21ffbab-eeb5-46e0-8f01-82310c1fb6c2.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_bdr_assessments",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 10848775826911673302,
        "service_name": "drive-thru",
        "span_id": 4567024362870058080,
        "trace_id": 14740985831404938101
    }
}

running: False
schema_name_id: 1927
start_time: 2026-04-12 09:32:38
success: True
trace_id: 14740985831404938101

Scan 161852024

duration: 0:00:11.833711

exit_message:

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

id: 161852024

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/bdr_assessments/2026-04-11/1775917791",
        "key": "raw/bdr_assessments/2026-04-11/1775917791/29a91859-296d-4db7-9689-3bd7f45322fd.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_bdr_assessments",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 3718829453533706891,
        "service_name": "drive-thru",
        "span_id": 7602992233976741034,
        "trace_id": 2986032917537287942
    }
}

running: False
schema_name_id: 1927
start_time: 2026-04-11 09:30:09
success: True
trace_id: 2986032917537287942

Scan 161797234

duration: 0:00:11.624637

exit_message:

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

id: 161797234

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/bdr_assessments/2026-04-10/1775831179",
        "key": "raw/bdr_assessments/2026-04-10/1775831179/dcf03e4e-896f-4c1e-b710-754f53792fa3.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_bdr_assessments",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 12282012582810548406,
        "service_name": "drive-thru",
        "span_id": 2050096885627591454,
        "trace_id": 18415941402194755978
    }
}

running: False
schema_name_id: 1927
start_time: 2026-04-10 09:26:24
success: True
trace_id: 18415941402194755978

Scan 161741480

duration: 0:00:11.688697

exit_message:

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

id: 161741480

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/bdr_assessments/2026-04-09/1775745492",
        "key": "raw/bdr_assessments/2026-04-09/1775745492/c5114b7d-24dc-47f8-aa16-9c221a6b0809.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_bdr_assessments",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 10252629811779107583,
        "service_name": "drive-thru",
        "span_id": 4273096679943587637,
        "trace_id": 12822546116654367134
    }
}

running: False
schema_name_id: 1927
start_time: 2026-04-09 09:38:15
success: True
trace_id: 12822546116654367134

Scan 161686340

duration: 0:00:14.222987

exit_message:

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

id: 161686340

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/bdr_assessments/2026-04-08/1775658908",
        "key": "raw/bdr_assessments/2026-04-08/1775658908/28c23ccf-7e3c-4ca5-bd44-030c2c35bf42.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_bdr_assessments",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 1354377300360322851,
        "service_name": "drive-thru",
        "span_id": 6025290686836929033,
        "trace_id": 5098339563615820042
    }
}

running: False
schema_name_id: 1927
start_time: 2026-04-08 09:36:24
success: True
trace_id: 5098339563615820042

Scan 161630228

duration: 0:00:11.724753

exit_message:

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

id: 161630228

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/bdr_assessments/2026-04-07/1775572158",
        "key": "raw/bdr_assessments/2026-04-07/1775572158/e43d7f42-0489-4981-9a78-db9d683e4e7b.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_bdr_assessments",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 9134635686678064915,
        "service_name": "drive-thru",
        "span_id": 17553871048837331959,
        "trace_id": 12686442722925572835
    }
}

running: False
schema_name_id: 1927
start_time: 2026-04-07 09:29:20
success: True
trace_id: 12686442722925572835

Scan 161572761

duration: 0:00:11.702037

exit_message:

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

id: 161572761

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/bdr_assessments/2026-04-06/1775485820",
        "key": "raw/bdr_assessments/2026-04-06/1775485820/34c4fe80-8fc5-4a0e-8dd9-10adc9ea73f0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_bdr_assessments",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 12507029904108848680,
        "service_name": "drive-thru",
        "span_id": 13038824179157214842,
        "trace_id": 10230852741796013006
    }
}

running: False
schema_name_id: 1927
start_time: 2026-04-06 09:30:23
success: True
trace_id: 10230852741796013006

Scan 161523748

duration: 0:00:14.275776

exit_message:

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

id: 161523748

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/bdr_assessments/2026-04-05/1775399267",
        "key": "raw/bdr_assessments/2026-04-05/1775399267/79219da5-54f5-410b-936a-58389b72cd82.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_bdr_assessments",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 4345340792320366048,
        "service_name": "drive-thru",
        "span_id": 7215012570441059590,
        "trace_id": 5236620123607322919
    }
}

running: False
schema_name_id: 1927
start_time: 2026-04-05 09:27:58
success: True
trace_id: 5236620123607322919

Scan 161472333

duration: 0:00:11.741939

exit_message:

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

id: 161472333

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/bdr_assessments/2026-04-04/1775314519",
        "key": "raw/bdr_assessments/2026-04-04/1775314519/5d8f4031-f6cc-40f7-9cba-6162c64b3e09.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_bdr_assessments",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 2563737447570515386,
        "service_name": "drive-thru",
        "span_id": 6368693137568391208,
        "trace_id": 11535535201257919154
    }
}

running: False
schema_name_id: 1927
start_time: 2026-04-04 09:55:26
success: True
trace_id: 11535535201257919154

Scan 161415822

duration: 0:00:14.275637

exit_message:

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

id: 161415822

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/bdr_assessments/2026-04-03/1775228210",
        "key": "raw/bdr_assessments/2026-04-03/1775228210/9b57db70-764b-4e16-95f2-f23db3accf1e.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_bdr_assessments",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 3934186859618328642,
        "service_name": "drive-thru",
        "span_id": 9965902320976255644,
        "trace_id": 12790707173527341844
    }
}

running: False
schema_name_id: 1927
start_time: 2026-04-03 09:58:28
success: True
trace_id: 12790707173527341844

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

ddl:

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