Schema Info

Schema Name: sfdl_prod_csv.salesforce_order_item_histories

created: 2023-03-28 12:45:54
disabled: False
format: raw
id: 1527
is_partitioned: False
is_schema_datatyped: True

name:

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

type: csv

Schema Versions: 15

Version 1718061

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_order_item_histories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_order_item_histories`\n(\n `Id`  string , `IsDeleted`  string , `OrderItemId`  string , `CreatedById`  string , `CreatedDate`  string , `Field`  string , `DataType`  string , `OldValue`  string , `NewValue`  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-salesforce-prod/raw/order_item_histories/2026-04-17/1776427476'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_order_item_histories"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/order_item_histories/2026-04-17/1776427476
id: 1718061
processed: 1

raw_data:

{
    "CreatedById": 3,
    "CreatedDate": 4,
    "DataType": 6,
    "Field": 5,
    "Id": 0,
    "IsDeleted": 1,
    "NewValue": 8,
    "OldValue": 7,
    "OrderItemId": 2
}

schema_attributes:

{
    "CreatedById": "string",
    "CreatedDate": "string",
    "DataType": "string",
    "Field": "string",
    "Id": "string",
    "IsDeleted": "string",
    "NewValue": "string",
    "OldValue": "string",
    "OrderItemId": "string"
}

schema_name_id: 1527
schema_scan_id: 162173026
updated: 2026-04-17 07:05:08

Version 1716855

created: 2026-04-16 07:06:14

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_order_item_histories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_order_item_histories`\n(\n `Id`  string , `IsDeleted`  string , `OrderItemId`  string , `CreatedById`  string , `CreatedDate`  string , `Field`  string , `DataType`  string , `OldValue`  string , `NewValue`  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-salesforce-prod/raw/order_item_histories/2026-04-16/1776341113'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_order_item_histories"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/order_item_histories/2026-04-16/1776341113
id: 1716855
processed: 1

raw_data:

{
    "CreatedById": 3,
    "CreatedDate": 4,
    "DataType": 6,
    "Field": 5,
    "Id": 0,
    "IsDeleted": 1,
    "NewValue": 8,
    "OldValue": 7,
    "OrderItemId": 2
}

schema_attributes:

{
    "CreatedById": "string",
    "CreatedDate": "string",
    "DataType": "string",
    "Field": "string",
    "Id": "string",
    "IsDeleted": "string",
    "NewValue": "string",
    "OldValue": "string",
    "OrderItemId": "string"
}

schema_name_id: 1527
schema_scan_id: 162117328
updated: 2026-04-16 07:06:26

Version 1715673

created: 2026-04-15 07:10:39

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_order_item_histories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_order_item_histories`\n(\n `Id`  string , `IsDeleted`  string , `OrderItemId`  string , `CreatedById`  string , `CreatedDate`  string , `Field`  string , `DataType`  string , `OldValue`  string , `NewValue`  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-salesforce-prod/raw/order_item_histories/2026-04-15/1776254775'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_order_item_histories"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/order_item_histories/2026-04-15/1776254775
id: 1715673
processed: 1

raw_data:

{
    "CreatedById": 3,
    "CreatedDate": 4,
    "DataType": 6,
    "Field": 5,
    "Id": 0,
    "IsDeleted": 1,
    "NewValue": 8,
    "OldValue": 7,
    "OrderItemId": 2
}

schema_attributes:

{
    "CreatedById": "string",
    "CreatedDate": "string",
    "DataType": "string",
    "Field": "string",
    "Id": "string",
    "IsDeleted": "string",
    "NewValue": "string",
    "OldValue": "string",
    "OrderItemId": "string"
}

schema_name_id: 1527
schema_scan_id: 162061816
updated: 2026-04-15 07:10:50

Version 1714469

created: 2026-04-14 07:06:41

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_order_item_histories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_order_item_histories`\n(\n `Id`  string , `IsDeleted`  string , `OrderItemId`  string , `CreatedById`  string , `CreatedDate`  string , `Field`  string , `DataType`  string , `OldValue`  string , `NewValue`  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-salesforce-prod/raw/order_item_histories/2026-04-14/1776168342'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_order_item_histories"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/order_item_histories/2026-04-14/1776168342
id: 1714469
processed: 1

raw_data:

{
    "CreatedById": 3,
    "CreatedDate": 4,
    "DataType": 6,
    "Field": 5,
    "Id": 0,
    "IsDeleted": 1,
    "NewValue": 8,
    "OldValue": 7,
    "OrderItemId": 2
}

schema_attributes:

{
    "CreatedById": "string",
    "CreatedDate": "string",
    "DataType": "string",
    "Field": "string",
    "Id": "string",
    "IsDeleted": "string",
    "NewValue": "string",
    "OldValue": "string",
    "OrderItemId": "string"
}

schema_name_id: 1527
schema_scan_id: 162006386
updated: 2026-04-14 07:06:55

Version 1713260

created: 2026-04-13 07:07:39

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_order_item_histories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_order_item_histories`\n(\n `Id`  string , `IsDeleted`  string , `OrderItemId`  string , `CreatedById`  string , `CreatedDate`  string , `Field`  string , `DataType`  string , `OldValue`  string , `NewValue`  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-salesforce-prod/raw/order_item_histories/2026-04-13/1776081900'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_order_item_histories"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/order_item_histories/2026-04-13/1776081900
id: 1713260
processed: 1

raw_data:

{
    "CreatedById": 3,
    "CreatedDate": 4,
    "DataType": 6,
    "Field": 5,
    "Id": 0,
    "IsDeleted": 1,
    "NewValue": 8,
    "OldValue": 7,
    "OrderItemId": 2
}

schema_attributes:

{
    "CreatedById": "string",
    "CreatedDate": "string",
    "DataType": "string",
    "Field": "string",
    "Id": "string",
    "IsDeleted": "string",
    "NewValue": "string",
    "OldValue": "string",
    "OrderItemId": "string"
}

schema_name_id: 1527
schema_scan_id: 161948345
updated: 2026-04-13 07:07:53

Version 1712084

created: 2026-04-12 07:09:37

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_order_item_histories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_order_item_histories`\n(\n `Id`  string , `IsDeleted`  string , `OrderItemId`  string , `CreatedById`  string , `CreatedDate`  string , `Field`  string , `DataType`  string , `OldValue`  string , `NewValue`  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-salesforce-prod/raw/order_item_histories/2026-04-12/1775995761'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_order_item_histories"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/order_item_histories/2026-04-12/1775995761
id: 1712084
processed: 1

raw_data:

{
    "CreatedById": 3,
    "CreatedDate": 4,
    "DataType": 6,
    "Field": 5,
    "Id": 0,
    "IsDeleted": 1,
    "NewValue": 8,
    "OldValue": 7,
    "OrderItemId": 2
}

schema_attributes:

{
    "CreatedById": "string",
    "CreatedDate": "string",
    "DataType": "string",
    "Field": "string",
    "Id": "string",
    "IsDeleted": "string",
    "NewValue": "string",
    "OldValue": "string",
    "OrderItemId": "string"
}

schema_name_id: 1527
schema_scan_id: 161899568
updated: 2026-04-12 07:09:48

Version 1710865

created: 2026-04-11 07:07:03

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_order_item_histories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_order_item_histories`\n(\n `Id`  string , `IsDeleted`  string , `OrderItemId`  string , `CreatedById`  string , `CreatedDate`  string , `Field`  string , `DataType`  string , `OldValue`  string , `NewValue`  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-salesforce-prod/raw/order_item_histories/2026-04-11/1775909059'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_order_item_histories"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/order_item_histories/2026-04-11/1775909059
id: 1710865
processed: 1

raw_data:

{
    "CreatedById": 3,
    "CreatedDate": 4,
    "DataType": 6,
    "Field": 5,
    "Id": 0,
    "IsDeleted": 1,
    "NewValue": 8,
    "OldValue": 7,
    "OrderItemId": 2
}

schema_attributes:

{
    "CreatedById": "string",
    "CreatedDate": "string",
    "DataType": "string",
    "Field": "string",
    "Id": "string",
    "IsDeleted": "string",
    "NewValue": "string",
    "OldValue": "string",
    "OrderItemId": "string"
}

schema_name_id: 1527
schema_scan_id: 161846875
updated: 2026-04-11 07:07:19

Version 1709658

created: 2026-04-10 07:05:43

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_order_item_histories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_order_item_histories`\n(\n `Id`  string , `IsDeleted`  string , `OrderItemId`  string , `CreatedById`  string , `CreatedDate`  string , `Field`  string , `DataType`  string , `OldValue`  string , `NewValue`  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-salesforce-prod/raw/order_item_histories/2026-04-10/1775822697'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_order_item_histories"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/order_item_histories/2026-04-10/1775822697
id: 1709658
processed: 1

raw_data:

{
    "CreatedById": 3,
    "CreatedDate": 4,
    "DataType": 6,
    "Field": 5,
    "Id": 0,
    "IsDeleted": 1,
    "NewValue": 8,
    "OldValue": 7,
    "OrderItemId": 2
}

schema_attributes:

{
    "CreatedById": "string",
    "CreatedDate": "string",
    "DataType": "string",
    "Field": "string",
    "Id": "string",
    "IsDeleted": "string",
    "NewValue": "string",
    "OldValue": "string",
    "OrderItemId": "string"
}

schema_name_id: 1527
schema_scan_id: 161792055
updated: 2026-04-10 07:05:54

Version 1708494

created: 2026-04-09 07:04:49

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_order_item_histories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_order_item_histories`\n(\n `Id`  string , `IsDeleted`  string , `OrderItemId`  string , `CreatedById`  string , `CreatedDate`  string , `Field`  string , `DataType`  string , `OldValue`  string , `NewValue`  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-salesforce-prod/raw/order_item_histories/2026-04-09/1775736279'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_order_item_histories"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/order_item_histories/2026-04-09/1775736279
id: 1708494
processed: 1

raw_data:

{
    "CreatedById": 3,
    "CreatedDate": 4,
    "DataType": 6,
    "Field": 5,
    "Id": 0,
    "IsDeleted": 1,
    "NewValue": 8,
    "OldValue": 7,
    "OrderItemId": 2
}

schema_attributes:

{
    "CreatedById": "string",
    "CreatedDate": "string",
    "DataType": "string",
    "Field": "string",
    "Id": "string",
    "IsDeleted": "string",
    "NewValue": "string",
    "OldValue": "string",
    "OrderItemId": "string"
}

schema_name_id: 1527
schema_scan_id: 161736204
updated: 2026-04-09 07:05:01

Version 1707308

created: 2026-04-08 07:05:05

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_order_item_histories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_order_item_histories`\n(\n `Id`  string , `IsDeleted`  string , `OrderItemId`  string , `CreatedById`  string , `CreatedDate`  string , `Field`  string , `DataType`  string , `OldValue`  string , `NewValue`  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-salesforce-prod/raw/order_item_histories/2026-04-08/1775649879'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_order_item_histories"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/order_item_histories/2026-04-08/1775649879
id: 1707308
processed: 1

raw_data:

{
    "CreatedById": 3,
    "CreatedDate": 4,
    "DataType": 6,
    "Field": 5,
    "Id": 0,
    "IsDeleted": 1,
    "NewValue": 8,
    "OldValue": 7,
    "OrderItemId": 2
}

schema_attributes:

{
    "CreatedById": "string",
    "CreatedDate": "string",
    "DataType": "string",
    "Field": "string",
    "Id": "string",
    "IsDeleted": "string",
    "NewValue": "string",
    "OldValue": "string",
    "OrderItemId": "string"
}

schema_name_id: 1527
schema_scan_id: 161681361
updated: 2026-04-08 07:05:18

Version 1706115

created: 2026-04-07 07:04:51

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_order_item_histories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_order_item_histories`\n(\n `Id`  string , `IsDeleted`  string , `OrderItemId`  string , `CreatedById`  string , `CreatedDate`  string , `Field`  string , `DataType`  string , `OldValue`  string , `NewValue`  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-salesforce-prod/raw/order_item_histories/2026-04-07/1775563483'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_order_item_histories"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/order_item_histories/2026-04-07/1775563483
id: 1706115
processed: 1

raw_data:

{
    "CreatedById": 3,
    "CreatedDate": 4,
    "DataType": 6,
    "Field": 5,
    "Id": 0,
    "IsDeleted": 1,
    "NewValue": 8,
    "OldValue": 7,
    "OrderItemId": 2
}

schema_attributes:

{
    "CreatedById": "string",
    "CreatedDate": "string",
    "DataType": "string",
    "Field": "string",
    "Id": "string",
    "IsDeleted": "string",
    "NewValue": "string",
    "OldValue": "string",
    "OrderItemId": "string"
}

schema_name_id: 1527
schema_scan_id: 161625149
updated: 2026-04-07 07:05:05

Version 1704908

created: 2026-04-06 07:06:52

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_order_item_histories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_order_item_histories`\n(\n `Id`  string , `IsDeleted`  string , `OrderItemId`  string , `CreatedById`  string , `CreatedDate`  string , `Field`  string , `DataType`  string , `OldValue`  string , `NewValue`  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-salesforce-prod/raw/order_item_histories/2026-04-06/1775477088'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_order_item_histories"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/order_item_histories/2026-04-06/1775477088
id: 1704908
processed: 1

raw_data:

{
    "CreatedById": 3,
    "CreatedDate": 4,
    "DataType": 6,
    "Field": 5,
    "Id": 0,
    "IsDeleted": 1,
    "NewValue": 8,
    "OldValue": 7,
    "OrderItemId": 2
}

schema_attributes:

{
    "CreatedById": "string",
    "CreatedDate": "string",
    "DataType": "string",
    "Field": "string",
    "Id": "string",
    "IsDeleted": "string",
    "NewValue": "string",
    "OldValue": "string",
    "OrderItemId": "string"
}

schema_name_id: 1527
schema_scan_id: 161567317
updated: 2026-04-06 07:07:06

Version 1703673

created: 2026-04-05 07:04:13

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_order_item_histories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_order_item_histories`\n(\n `Id`  string , `IsDeleted`  string , `OrderItemId`  string , `CreatedById`  string , `CreatedDate`  string , `Field`  string , `DataType`  string , `OldValue`  string , `NewValue`  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-salesforce-prod/raw/order_item_histories/2026-04-05/1775390633'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_order_item_histories"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/order_item_histories/2026-04-05/1775390633
id: 1703673
processed: 1

raw_data:

{
    "CreatedById": 3,
    "CreatedDate": 4,
    "DataType": 6,
    "Field": 5,
    "Id": 0,
    "IsDeleted": 1,
    "NewValue": 8,
    "OldValue": 7,
    "OrderItemId": 2
}

schema_attributes:

{
    "CreatedById": "string",
    "CreatedDate": "string",
    "DataType": "string",
    "Field": "string",
    "Id": "string",
    "IsDeleted": "string",
    "NewValue": "string",
    "OldValue": "string",
    "OrderItemId": "string"
}

schema_name_id: 1527
schema_scan_id: 161519952
updated: 2026-04-05 07:04:24

Version 1702562

created: 2026-04-04 07:08:54

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_order_item_histories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_order_item_histories`\n(\n `Id`  string , `IsDeleted`  string , `OrderItemId`  string , `CreatedById`  string , `CreatedDate`  string , `Field`  string , `DataType`  string , `OldValue`  string , `NewValue`  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-salesforce-prod/raw/order_item_histories/2026-04-04/1775304397'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_order_item_histories"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/order_item_histories/2026-04-04/1775304397
id: 1702562
processed: 1

raw_data:

{
    "CreatedById": 3,
    "CreatedDate": 4,
    "DataType": 6,
    "Field": 5,
    "Id": 0,
    "IsDeleted": 1,
    "NewValue": 8,
    "OldValue": 7,
    "OrderItemId": 2
}

schema_attributes:

{
    "CreatedById": "string",
    "CreatedDate": "string",
    "DataType": "string",
    "Field": "string",
    "Id": "string",
    "IsDeleted": "string",
    "NewValue": "string",
    "OldValue": "string",
    "OrderItemId": "string"
}

schema_name_id: 1527
schema_scan_id: 161466433
updated: 2026-04-04 07:09:08

Version 1701383

created: 2026-04-03 07:06:56

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_order_item_histories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_order_item_histories`\n(\n `Id`  string , `IsDeleted`  string , `OrderItemId`  string , `CreatedById`  string , `CreatedDate`  string , `Field`  string , `DataType`  string , `OldValue`  string , `NewValue`  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-salesforce-prod/raw/order_item_histories/2026-04-03/1775217885'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_order_item_histories"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/order_item_histories/2026-04-03/1775217885
id: 1701383
processed: 1

raw_data:

{
    "CreatedById": 3,
    "CreatedDate": 4,
    "DataType": 6,
    "Field": 5,
    "Id": 0,
    "IsDeleted": 1,
    "NewValue": 8,
    "OldValue": 7,
    "OrderItemId": 2
}

schema_attributes:

{
    "CreatedById": "string",
    "CreatedDate": "string",
    "DataType": "string",
    "Field": "string",
    "Id": "string",
    "IsDeleted": "string",
    "NewValue": "string",
    "OldValue": "string",
    "OrderItemId": "string"
}

schema_name_id: 1527
schema_scan_id: 161408608
updated: 2026-04-03 07:07:10

Schema Scans: 15

Last at 2026-04-17 07:04:54

Scan 162173026

duration: 0:00:14.551712

exit_message:

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

id: 162173026

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-salesforce-prod",
        "hive_path": "s3://sfdl-csv-salesforce-prod/raw/order_item_histories/2026-04-17/1776427476",
        "key": "raw/order_item_histories/2026-04-17/1776427476/order_item_histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_order_item_histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 5517332260888471595,
        "service_name": "drive-thru",
        "span_id": 2369525760342471246,
        "trace_id": 16554057531412986228
    }
}

running: False
schema_name_id: 1527
start_time: 2026-04-17 07:04:54
success: True
trace_id: 16554057531412986228

Scan 162117328

duration: 0:00:11.928181

exit_message:

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

id: 162117328

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-salesforce-prod",
        "hive_path": "s3://sfdl-csv-salesforce-prod/raw/order_item_histories/2026-04-16/1776341113",
        "key": "raw/order_item_histories/2026-04-16/1776341113/order_item_histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_order_item_histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 1652968459491936748,
        "service_name": "drive-thru",
        "span_id": 7608793763172993009,
        "trace_id": 4174522283792103423
    }
}

running: False
schema_name_id: 1527
start_time: 2026-04-16 07:06:14
success: True
trace_id: 4174522283792103423

Scan 162061816

duration: 0:00:11.981814

exit_message:

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

id: 162061816

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-salesforce-prod",
        "hive_path": "s3://sfdl-csv-salesforce-prod/raw/order_item_histories/2026-04-15/1776254775",
        "key": "raw/order_item_histories/2026-04-15/1776254775/order_item_histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_order_item_histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 13030253555382642604,
        "service_name": "drive-thru",
        "span_id": 13366294414775053905,
        "trace_id": 16981265033196774143
    }
}

running: False
schema_name_id: 1527
start_time: 2026-04-15 07:10:38
success: True
trace_id: 16981265033196774143

Scan 162006386

duration: 0:00:14.365113

exit_message:

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

id: 162006386

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-salesforce-prod",
        "hive_path": "s3://sfdl-csv-salesforce-prod/raw/order_item_histories/2026-04-14/1776168342",
        "key": "raw/order_item_histories/2026-04-14/1776168342/order_item_histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_order_item_histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 14119658263384186139,
        "service_name": "drive-thru",
        "span_id": 14486730032382884226,
        "trace_id": 6036571963544243656
    }
}

running: False
schema_name_id: 1527
start_time: 2026-04-14 07:06:41
success: True
trace_id: 6036571963544243656

Scan 161948345

duration: 0:00:14.449290

exit_message:

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

id: 161948345

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-salesforce-prod",
        "hive_path": "s3://sfdl-csv-salesforce-prod/raw/order_item_histories/2026-04-13/1776081900",
        "key": "raw/order_item_histories/2026-04-13/1776081900/order_item_histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_order_item_histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 6214781654725552461,
        "service_name": "drive-thru",
        "span_id": 10767810985724446273,
        "trace_id": 12079475048387678960
    }
}

running: False
schema_name_id: 1527
start_time: 2026-04-13 07:07:39
success: True
trace_id: 12079475048387678960

Scan 161899568

duration: 0:00:12.082280

exit_message:

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

id: 161899568

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-salesforce-prod",
        "hive_path": "s3://sfdl-csv-salesforce-prod/raw/order_item_histories/2026-04-12/1775995761",
        "key": "raw/order_item_histories/2026-04-12/1775995761/order_item_histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_order_item_histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 12765509976553725726,
        "service_name": "drive-thru",
        "span_id": 6131696707159714655,
        "trace_id": 3942125958961375302
    }
}

running: False
schema_name_id: 1527
start_time: 2026-04-12 07:09:36
success: True
trace_id: 3942125958961375302

Scan 161846875

duration: 0:00:16.968950

exit_message:

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

id: 161846875

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-salesforce-prod",
        "hive_path": "s3://sfdl-csv-salesforce-prod/raw/order_item_histories/2026-04-11/1775909059",
        "key": "raw/order_item_histories/2026-04-11/1775909059/order_item_histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_order_item_histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 10547887853015800761,
        "service_name": "drive-thru",
        "span_id": 15517330687291028552,
        "trace_id": 11769260386679363582
    }
}

running: False
schema_name_id: 1527
start_time: 2026-04-11 07:07:03
success: True
trace_id: 11769260386679363582

Scan 161792055

duration: 0:00:11.900936

exit_message:

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

id: 161792055

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-salesforce-prod",
        "hive_path": "s3://sfdl-csv-salesforce-prod/raw/order_item_histories/2026-04-10/1775822697",
        "key": "raw/order_item_histories/2026-04-10/1775822697/order_item_histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_order_item_histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 10731922020030690755,
        "service_name": "drive-thru",
        "span_id": 923055966256492032,
        "trace_id": 12513994461160054972
    }
}

running: False
schema_name_id: 1527
start_time: 2026-04-10 07:05:42
success: True
trace_id: 12513994461160054972

Scan 161736204

duration: 0:00:12.066915

exit_message:

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

id: 161736204

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-salesforce-prod",
        "hive_path": "s3://sfdl-csv-salesforce-prod/raw/order_item_histories/2026-04-09/1775736279",
        "key": "raw/order_item_histories/2026-04-09/1775736279/order_item_histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_order_item_histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 1754200847828883325,
        "service_name": "drive-thru",
        "span_id": 2774908715371259316,
        "trace_id": 11299060630938059097
    }
}

running: False
schema_name_id: 1527
start_time: 2026-04-09 07:04:49
success: True
trace_id: 11299060630938059097

Scan 161681361

duration: 0:00:14.455624

exit_message:

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

id: 161681361

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-salesforce-prod",
        "hive_path": "s3://sfdl-csv-salesforce-prod/raw/order_item_histories/2026-04-08/1775649879",
        "key": "raw/order_item_histories/2026-04-08/1775649879/order_item_histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_order_item_histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 17170084098294447369,
        "service_name": "drive-thru",
        "span_id": 1254101338282246617,
        "trace_id": 13517688878168332155
    }
}

running: False
schema_name_id: 1527
start_time: 2026-04-08 07:05:04
success: True
trace_id: 13517688878168332155

Scan 161625149

duration: 0:00:14.531680

exit_message:

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

id: 161625149

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-salesforce-prod",
        "hive_path": "s3://sfdl-csv-salesforce-prod/raw/order_item_histories/2026-04-07/1775563483",
        "key": "raw/order_item_histories/2026-04-07/1775563483/order_item_histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_order_item_histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 6889068697681181077,
        "service_name": "drive-thru",
        "span_id": 13469274638045439535,
        "trace_id": 9243913432108531976
    }
}

running: False
schema_name_id: 1527
start_time: 2026-04-07 07:04:50
success: True
trace_id: 9243913432108531976

Scan 161567317

duration: 0:00:14.581148

exit_message:

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

id: 161567317

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-salesforce-prod",
        "hive_path": "s3://sfdl-csv-salesforce-prod/raw/order_item_histories/2026-04-06/1775477088",
        "key": "raw/order_item_histories/2026-04-06/1775477088/order_item_histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_order_item_histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 5570367081425556163,
        "service_name": "drive-thru",
        "span_id": 6799911908919370043,
        "trace_id": 10254014872328876670
    }
}

running: False
schema_name_id: 1527
start_time: 2026-04-06 07:06:51
success: True
trace_id: 10254014872328876670

Scan 161519952

duration: 0:00:11.749036

exit_message:

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

id: 161519952

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-salesforce-prod",
        "hive_path": "s3://sfdl-csv-salesforce-prod/raw/order_item_histories/2026-04-05/1775390633",
        "key": "raw/order_item_histories/2026-04-05/1775390633/order_item_histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_order_item_histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 4628172133968142013,
        "service_name": "drive-thru",
        "span_id": 4561278865075421198,
        "trace_id": 6265522824335790962
    }
}

running: False
schema_name_id: 1527
start_time: 2026-04-05 07:04:13
success: True
trace_id: 6265522824335790962

Scan 161466433

duration: 0:00:14.257933

exit_message:

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

id: 161466433

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-salesforce-prod",
        "hive_path": "s3://sfdl-csv-salesforce-prod/raw/order_item_histories/2026-04-04/1775304397",
        "key": "raw/order_item_histories/2026-04-04/1775304397/order_item_histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_order_item_histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 5438881395076420781,
        "service_name": "drive-thru",
        "span_id": 13194944328702311621,
        "trace_id": 15700476844266341824
    }
}

running: False
schema_name_id: 1527
start_time: 2026-04-04 07:08:53
success: True
trace_id: 15700476844266341824

Scan 161408608

duration: 0:00:14.414735

exit_message:

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

id: 161408608

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-salesforce-prod",
        "hive_path": "s3://sfdl-csv-salesforce-prod/raw/order_item_histories/2026-04-03/1775217885",
        "key": "raw/order_item_histories/2026-04-03/1775217885/order_item_histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_order_item_histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 5908748972293919466,
        "service_name": "drive-thru",
        "span_id": 3212189336958741537,
        "trace_id": 3999863814148795131
    }
}

running: False
schema_name_id: 1527
start_time: 2026-04-03 07:06:56
success: True
trace_id: 3999863814148795131

Partitions:

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

Schema:

attributes:

{
    "CreatedById": "string",
    "CreatedDate": "string",
    "DataType": "string",
    "Field": "string",
    "Id": "string",
    "IsDeleted": "string",
    "NewValue": "string",
    "OldValue": "string",
    "OrderItemId": "string"
}

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

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_order_item_histories`\n(\n `Id`  string , `IsDeleted`  string , `OrderItemId`  string , `CreatedById`  string , `CreatedDate`  string , `Field`  string , `DataType`  string , `OldValue`  string , `NewValue`  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-salesforce-prod/raw/order_item_histories/2026-04-17/1776427476'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_order_item_histories`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_order_item_histories"
}

Server:

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

Raw:

{
    "name": {
        "created": "2023-03-28 12:45:54",
        "disabled": false,
        "format": "raw",
        "id": 1527,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_csv",
            "table": "salesforce_order_item_histories"
        },
        "type": "csv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "CreatedById": "string",
            "CreatedDate": "string",
            "DataType": "string",
            "Field": "string",
            "Id": "string",
            "IsDeleted": "string",
            "NewValue": "string",
            "OldValue": "string",
            "OrderItemId": "string"
        },
        "created": "2026-04-17 07:04:54",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_order_item_histories`\n(\n `Id`  string , `IsDeleted`  string , `OrderItemId`  string , `CreatedById`  string , `CreatedDate`  string , `Field`  string , `DataType`  string , `OldValue`  string , `NewValue`  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-salesforce-prod/raw/order_item_histories/2026-04-17/1776427476'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_order_item_histories`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_order_item_histories"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}