Schema Info

Schema Name: sfdl_prod_csv.salesforce_order_histories

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

name:

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

type: csv

Schema Versions: 15

Version 1718064

created: 2026-04-17 07:04:59

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_order_histories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_order_histories`\n(\n `Id`  string , `IsDeleted`  string , `OrderId`  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_histories/2026-04-17/1776427480'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_order_histories"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/order_histories/2026-04-17/1776427480
id: 1718064
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1528
schema_scan_id: 162173030
updated: 2026-04-17 07:05:13

Version 1716836

created: 2026-04-16 07:05:16

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_order_histories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_order_histories`\n(\n `Id`  string , `IsDeleted`  string , `OrderId`  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_histories/2026-04-16/1776341084'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_order_histories"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/order_histories/2026-04-16/1776341084
id: 1716836
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1528
schema_scan_id: 162117310
updated: 2026-04-16 07:05:30

Version 1715644

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_order_histories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_order_histories`\n(\n `Id`  string , `IsDeleted`  string , `OrderId`  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_histories/2026-04-15/1776254767'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_order_histories"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/order_histories/2026-04-15/1776254767
id: 1715644
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1528
schema_scan_id: 162061780
updated: 2026-04-15 07:07:53

Version 1714441

created: 2026-04-14 07:05:17

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_order_histories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_order_histories`\n(\n `Id`  string , `IsDeleted`  string , `OrderId`  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_histories/2026-04-14/1776168304'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_order_histories"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/order_histories/2026-04-14/1776168304
id: 1714441
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1528
schema_scan_id: 162006353
updated: 2026-04-14 07:05:30

Version 1713229

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_order_histories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_order_histories`\n(\n `Id`  string , `IsDeleted`  string , `OrderId`  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_histories/2026-04-13/1776081901'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_order_histories"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/order_histories/2026-04-13/1776081901
id: 1713229
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1528
schema_scan_id: 161948305
updated: 2026-04-13 07:06:10

Version 1712035

created: 2026-04-12 07:06:46

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_order_histories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_order_histories`\n(\n `Id`  string , `IsDeleted`  string , `OrderId`  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_histories/2026-04-12/1775995579'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_order_histories"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/order_histories/2026-04-12/1775995579
id: 1712035
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1528
schema_scan_id: 161899515
updated: 2026-04-12 07:06:57

Version 1710859

created: 2026-04-11 07:06:42

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_order_histories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_order_histories`\n(\n `Id`  string , `IsDeleted`  string , `OrderId`  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_histories/2026-04-11/1775909083'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_order_histories"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/order_histories/2026-04-11/1775909083
id: 1710859
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1528
schema_scan_id: 161846867
updated: 2026-04-11 07:06:55

Version 1709657

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_order_histories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_order_histories`\n(\n `Id`  string , `IsDeleted`  string , `OrderId`  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_histories/2026-04-10/1775822699'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_order_histories"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/order_histories/2026-04-10/1775822699
id: 1709657
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1528
schema_scan_id: 161792054
updated: 2026-04-10 07:05:47

Version 1708493

created: 2026-04-09 07:04:40

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_order_histories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_order_histories`\n(\n `Id`  string , `IsDeleted`  string , `OrderId`  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_histories/2026-04-09/1775736271'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_order_histories"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/order_histories/2026-04-09/1775736271
id: 1708493
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1528
schema_scan_id: 161736201
updated: 2026-04-09 07:04:54

Version 1707336

created: 2026-04-08 07:06:29

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_order_histories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_order_histories`\n(\n `Id`  string , `IsDeleted`  string , `OrderId`  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_histories/2026-04-08/1775649905'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_order_histories"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/order_histories/2026-04-08/1775649905
id: 1707336
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1528
schema_scan_id: 161681394
updated: 2026-04-08 07:06:40

Version 1706116

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_order_histories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_order_histories`\n(\n `Id`  string , `IsDeleted`  string , `OrderId`  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_histories/2026-04-07/1775563478'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_order_histories"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/order_histories/2026-04-07/1775563478
id: 1706116
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1528
schema_scan_id: 161625150
updated: 2026-04-07 07:05:16

Version 1704910

created: 2026-04-06 07:07:22

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_order_histories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_order_histories`\n(\n `Id`  string , `IsDeleted`  string , `OrderId`  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_histories/2026-04-06/1775477090'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_order_histories"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/order_histories/2026-04-06/1775477090
id: 1704910
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1528
schema_scan_id: 161567319
updated: 2026-04-06 07:07:33

Version 1703668

created: 2026-04-05 07:03:55

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_order_histories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_order_histories`\n(\n `Id`  string , `IsDeleted`  string , `OrderId`  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_histories/2026-04-05/1775390631'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_order_histories"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/order_histories/2026-04-05/1775390631
id: 1703668
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1528
schema_scan_id: 161519948
updated: 2026-04-05 07:04:09

Version 1702530

created: 2026-04-04 07:06:46

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_order_histories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_order_histories`\n(\n `Id`  string , `IsDeleted`  string , `OrderId`  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_histories/2026-04-04/1775304401'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_order_histories"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/order_histories/2026-04-04/1775304401
id: 1702530
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1528
schema_scan_id: 161466399
updated: 2026-04-04 07:06:59

Version 1701330

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_order_histories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_order_histories`\n(\n `Id`  string , `IsDeleted`  string , `OrderId`  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_histories/2026-04-03/1775217825'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_order_histories"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/order_histories/2026-04-03/1775217825
id: 1701330
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1528
schema_scan_id: 161408528
updated: 2026-04-03 07:04:15

Schema Scans: 15

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

Scan 162173030

duration: 0:00:14.462160

exit_message:

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

id: 162173030

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_histories/2026-04-17/1776427480",
        "key": "raw/order_histories/2026-04-17/1776427480/order_histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_order_histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 8758953938911251605,
        "service_name": "drive-thru",
        "span_id": 4707220486511182435,
        "trace_id": 11079438036466749983
    }
}

running: False
schema_name_id: 1528
start_time: 2026-04-17 07:04:58
success: True
trace_id: 11079438036466749983

Scan 162117310

duration: 0:00:14.450659

exit_message:

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

id: 162117310

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_histories/2026-04-16/1776341084",
        "key": "raw/order_histories/2026-04-16/1776341084/order_histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_order_histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 456403050893593719,
        "service_name": "drive-thru",
        "span_id": 7438791322246632608,
        "trace_id": 66972409523247009
    }
}

running: False
schema_name_id: 1528
start_time: 2026-04-16 07:05:15
success: True
trace_id: 66972409523247009

Scan 162061780

duration: 0:00:14.353482

exit_message:

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

id: 162061780

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_histories/2026-04-15/1776254767",
        "key": "raw/order_histories/2026-04-15/1776254767/order_histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_order_histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 1531684686443870627,
        "service_name": "drive-thru",
        "span_id": 3855079958596315910,
        "trace_id": 10717795532186331609
    }
}

running: False
schema_name_id: 1528
start_time: 2026-04-15 07:07:38
success: True
trace_id: 10717795532186331609

Scan 162006353

duration: 0:00:14.340386

exit_message:

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

id: 162006353

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_histories/2026-04-14/1776168304",
        "key": "raw/order_histories/2026-04-14/1776168304/order_histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_order_histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 16173222757823153125,
        "service_name": "drive-thru",
        "span_id": 4761625691842368433,
        "trace_id": 3414748792270148961
    }
}

running: False
schema_name_id: 1528
start_time: 2026-04-14 07:05:16
success: True
trace_id: 3414748792270148961

Scan 161948305

duration: 0:00:14.369222

exit_message:

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

id: 161948305

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_histories/2026-04-13/1776081901",
        "key": "raw/order_histories/2026-04-13/1776081901/order_histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_order_histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 13026866961412481322,
        "service_name": "drive-thru",
        "span_id": 13818417565460289735,
        "trace_id": 17084846222723818203
    }
}

running: False
schema_name_id: 1528
start_time: 2026-04-13 07:05:56
success: True
trace_id: 17084846222723818203

Scan 161899515

duration: 0:00:11.852348

exit_message:

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

id: 161899515

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_histories/2026-04-12/1775995579",
        "key": "raw/order_histories/2026-04-12/1775995579/order_histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_order_histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 7687857118375747234,
        "service_name": "drive-thru",
        "span_id": 16040639266113560155,
        "trace_id": 1834986128299730576
    }
}

running: False
schema_name_id: 1528
start_time: 2026-04-12 07:06:45
success: True
trace_id: 1834986128299730576

Scan 161846867

duration: 0:00:14.298746

exit_message:

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

id: 161846867

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_histories/2026-04-11/1775909083",
        "key": "raw/order_histories/2026-04-11/1775909083/order_histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_order_histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 3145311372103036377,
        "service_name": "drive-thru",
        "span_id": 2501146422437739588,
        "trace_id": 16655563816573478199
    }
}

running: False
schema_name_id: 1528
start_time: 2026-04-11 07:06:41
success: True
trace_id: 16655563816573478199

Scan 161792054

duration: 0:00:11.912533

exit_message:

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

id: 161792054

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_histories/2026-04-10/1775822699",
        "key": "raw/order_histories/2026-04-10/1775822699/order_histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_order_histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 537360499628497062,
        "service_name": "drive-thru",
        "span_id": 3574699420247078274,
        "trace_id": 4520919737108320329
    }
}

running: False
schema_name_id: 1528
start_time: 2026-04-10 07:05:35
success: True
trace_id: 4520919737108320329

Scan 161736201

duration: 0:00:14.403289

exit_message:

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

id: 161736201

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_histories/2026-04-09/1775736271",
        "key": "raw/order_histories/2026-04-09/1775736271/order_histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_order_histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 14577491802627495843,
        "service_name": "drive-thru",
        "span_id": 11287246856768714868,
        "trace_id": 1785509835303442626
    }
}

running: False
schema_name_id: 1528
start_time: 2026-04-09 07:04:39
success: True
trace_id: 1785509835303442626

Scan 161681394

duration: 0:00:11.949375

exit_message:

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

id: 161681394

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_histories/2026-04-08/1775649905",
        "key": "raw/order_histories/2026-04-08/1775649905/order_histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_order_histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 9443005987691729253,
        "service_name": "drive-thru",
        "span_id": 6713932763759228821,
        "trace_id": 14075737371258735116
    }
}

running: False
schema_name_id: 1528
start_time: 2026-04-08 07:06:28
success: True
trace_id: 14075737371258735116

Scan 161625150

duration: 0:00:11.993312

exit_message:

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

id: 161625150

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_histories/2026-04-07/1775563478",
        "key": "raw/order_histories/2026-04-07/1775563478/order_histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_order_histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 8154322694252326866,
        "service_name": "drive-thru",
        "span_id": 18263858167273548238,
        "trace_id": 4087613885136892191
    }
}

running: False
schema_name_id: 1528
start_time: 2026-04-07 07:05:04
success: True
trace_id: 4087613885136892191

Scan 161567319

duration: 0:00:11.823980

exit_message:

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

id: 161567319

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_histories/2026-04-06/1775477090",
        "key": "raw/order_histories/2026-04-06/1775477090/order_histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_order_histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 15047590378680223439,
        "service_name": "drive-thru",
        "span_id": 17370272001442597170,
        "trace_id": 3394316192040848051
    }
}

running: False
schema_name_id: 1528
start_time: 2026-04-06 07:07:21
success: True
trace_id: 3394316192040848051

Scan 161519948

duration: 0:00:14.305276

exit_message:

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

id: 161519948

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_histories/2026-04-05/1775390631",
        "key": "raw/order_histories/2026-04-05/1775390631/order_histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_order_histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 292927939910301531,
        "service_name": "drive-thru",
        "span_id": 16338256121759796739,
        "trace_id": 2352597715455407429
    }
}

running: False
schema_name_id: 1528
start_time: 2026-04-05 07:03:55
success: True
trace_id: 2352597715455407429

Scan 161466399

duration: 0:00:14.392537

exit_message:

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

id: 161466399

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_histories/2026-04-04/1775304401",
        "key": "raw/order_histories/2026-04-04/1775304401/order_histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_order_histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 17353251100968227133,
        "service_name": "drive-thru",
        "span_id": 2577760370207682921,
        "trace_id": 4205086682753716383
    }
}

running: False
schema_name_id: 1528
start_time: 2026-04-04 07:06:45
success: True
trace_id: 4205086682753716383

Scan 161408528

duration: 0:00:12.099035

exit_message:

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

id: 161408528

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_histories/2026-04-03/1775217825",
        "key": "raw/order_histories/2026-04-03/1775217825/order_histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_order_histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 2042811053895949378,
        "service_name": "drive-thru",
        "span_id": 1886679736538329083,
        "trace_id": 11946443970531979791
    }
}

running: False
schema_name_id: 1528
start_time: 2026-04-03 07:04:03
success: True
trace_id: 11946443970531979791

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",
    "OrderId": "string"
}

created: 2026-04-17 07:04:59

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_histories`\n(\n `Id`  string , `IsDeleted`  string , `OrderId`  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_histories/2026-04-17/1776427480'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_order_histories`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_order_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": 1528,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_csv",
            "table": "salesforce_order_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",
            "OrderId": "string"
        },
        "created": "2026-04-17 07:04:59",
        "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_histories`\n(\n `Id`  string , `IsDeleted`  string , `OrderId`  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_histories/2026-04-17/1776427480'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_order_histories`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_order_histories"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}