Schema Info

Schema Name: sfdl_prod_csv.salesforce_netsuite_contract_line__histories

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

name:

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

type: csv

Schema Versions: 15

Version 1718067

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

ddl:

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

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

raw_data:

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

schema_attributes:

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

schema_name_id: 1526
schema_scan_id: 162173034
updated: 2026-04-17 07:05:23

Version 1716883

created: 2026-04-16 07:07:33

ddl:

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

hive_path: s3://sfdl-csv-salesforce-prod/raw/netsuite_contract_line__histories/2026-04-16/1776341126
id: 1716883
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1526
schema_scan_id: 162117370
updated: 2026-04-16 07:07:47

Version 1715651

created: 2026-04-15 07:08:34

ddl:

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

hive_path: s3://sfdl-csv-salesforce-prod/raw/netsuite_contract_line__histories/2026-04-15/1776254770
id: 1715651
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1526
schema_scan_id: 162061790
updated: 2026-04-15 07:08:46

Version 1714489

created: 2026-04-14 07:07:38

ddl:

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

hive_path: s3://sfdl-csv-salesforce-prod/raw/netsuite_contract_line__histories/2026-04-14/1776168320
id: 1714489
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1526
schema_scan_id: 162006415
updated: 2026-04-14 07:07:52

Version 1713237

created: 2026-04-13 07:06:33

ddl:

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

hive_path: s3://sfdl-csv-salesforce-prod/raw/netsuite_contract_line__histories/2026-04-13/1776081911
id: 1713237
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1526
schema_scan_id: 161948316
updated: 2026-04-13 07:06:45

Version 1712085

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

ddl:

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

hive_path: s3://sfdl-csv-salesforce-prod/raw/netsuite_contract_line__histories/2026-04-12/1775995760
id: 1712085
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1526
schema_scan_id: 161899569
updated: 2026-04-12 07:09:57

Version 1710851

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

ddl:

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

hive_path: s3://sfdl-csv-salesforce-prod/raw/netsuite_contract_line__histories/2026-04-11/1775909070
id: 1710851
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1526
schema_scan_id: 161846859
updated: 2026-04-11 07:06:20

Version 1709679

created: 2026-04-10 07:06:37

ddl:

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

hive_path: s3://sfdl-csv-salesforce-prod/raw/netsuite_contract_line__histories/2026-04-10/1775822737
id: 1709679
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1526
schema_scan_id: 161792078
updated: 2026-04-10 07:06:48

Version 1708514

created: 2026-04-09 07:05:53

ddl:

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

hive_path: s3://sfdl-csv-salesforce-prod/raw/netsuite_contract_line__histories/2026-04-09/1775736302
id: 1708514
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1526
schema_scan_id: 161736242
updated: 2026-04-09 07:06:07

Version 1707322

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

ddl:

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

hive_path: s3://sfdl-csv-salesforce-prod/raw/netsuite_contract_line__histories/2026-04-08/1775649876
id: 1707322
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1526
schema_scan_id: 161681376
updated: 2026-04-08 07:06:03

Version 1706127

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

ddl:

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

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

raw_data:

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

schema_attributes:

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

schema_name_id: 1526
schema_scan_id: 161625165
updated: 2026-04-07 07:05:52

Version 1704921

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

ddl:

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

hive_path: s3://sfdl-csv-salesforce-prod/raw/netsuite_contract_line__histories/2026-04-06/1775477098
id: 1704921
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1526
schema_scan_id: 161567330
updated: 2026-04-06 07:09:02

Version 1703687

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

ddl:

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

hive_path: s3://sfdl-csv-salesforce-prod/raw/netsuite_contract_line__histories/2026-04-05/1775390630
id: 1703687
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1526
schema_scan_id: 161519968
updated: 2026-04-05 07:05:16

Version 1702551

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

ddl:

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

hive_path: s3://sfdl-csv-salesforce-prod/raw/netsuite_contract_line__histories/2026-04-04/1775304383
id: 1702551
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1526
schema_scan_id: 161466421
updated: 2026-04-04 07:08:19

Version 1701362

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

ddl:

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

hive_path: s3://sfdl-csv-salesforce-prod/raw/netsuite_contract_line__histories/2026-04-03/1775217862
id: 1701362
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1526
schema_scan_id: 161408571
updated: 2026-04-03 07:06:05

Schema Scans: 15

Last at 2026-04-17 07:05:11

Scan 162173034

duration: 0:00:11.922883

exit_message:

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

id: 162173034

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/netsuite_contract_line__histories/2026-04-17/1776427476",
        "key": "raw/netsuite_contract_line__histories/2026-04-17/1776427476/netsuite_contract_line__histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_netsuite_contract_line__histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 4376670703589067444,
        "service_name": "drive-thru",
        "span_id": 16065667583004204219,
        "trace_id": 2308647944090337721
    }
}

running: False
schema_name_id: 1526
start_time: 2026-04-17 07:05:11
success: True
trace_id: 2308647944090337721

Scan 162117370

duration: 0:00:14.364957

exit_message:

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

id: 162117370

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/netsuite_contract_line__histories/2026-04-16/1776341126",
        "key": "raw/netsuite_contract_line__histories/2026-04-16/1776341126/netsuite_contract_line__histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_netsuite_contract_line__histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 6083017898407593214,
        "service_name": "drive-thru",
        "span_id": 2963980389143427538,
        "trace_id": 2428942433720726587
    }
}

running: False
schema_name_id: 1526
start_time: 2026-04-16 07:07:33
success: True
trace_id: 2428942433720726587

Scan 162061790

duration: 0:00:11.815274

exit_message:

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

id: 162061790

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/netsuite_contract_line__histories/2026-04-15/1776254770",
        "key": "raw/netsuite_contract_line__histories/2026-04-15/1776254770/netsuite_contract_line__histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_netsuite_contract_line__histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 942248719354693312,
        "service_name": "drive-thru",
        "span_id": 10614860389407372338,
        "trace_id": 9393247417869590521
    }
}

running: False
schema_name_id: 1526
start_time: 2026-04-15 07:08:34
success: True
trace_id: 9393247417869590521

Scan 162006415

duration: 0:00:14.426449

exit_message:

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

id: 162006415

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/netsuite_contract_line__histories/2026-04-14/1776168320",
        "key": "raw/netsuite_contract_line__histories/2026-04-14/1776168320/netsuite_contract_line__histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_netsuite_contract_line__histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 173513086473030552,
        "service_name": "drive-thru",
        "span_id": 1482009563642356212,
        "trace_id": 12368612408090406451
    }
}

running: False
schema_name_id: 1526
start_time: 2026-04-14 07:07:38
success: True
trace_id: 12368612408090406451

Scan 161948316

duration: 0:00:11.883692

exit_message:

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

id: 161948316

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/netsuite_contract_line__histories/2026-04-13/1776081911",
        "key": "raw/netsuite_contract_line__histories/2026-04-13/1776081911/netsuite_contract_line__histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_netsuite_contract_line__histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 4196539926830076605,
        "service_name": "drive-thru",
        "span_id": 8898086464351113845,
        "trace_id": 5580360858748936222
    }
}

running: False
schema_name_id: 1526
start_time: 2026-04-13 07:06:33
success: True
trace_id: 5580360858748936222

Scan 161899569

duration: 0:00:14.422643

exit_message:

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

id: 161899569

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/netsuite_contract_line__histories/2026-04-12/1775995760",
        "key": "raw/netsuite_contract_line__histories/2026-04-12/1775995760/netsuite_contract_line__histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_netsuite_contract_line__histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 4554737054774218010,
        "service_name": "drive-thru",
        "span_id": 8461316783343041765,
        "trace_id": 9847559783900287684
    }
}

running: False
schema_name_id: 1526
start_time: 2026-04-12 07:09:42
success: True
trace_id: 9847559783900287684

Scan 161846859

duration: 0:00:14.367547

exit_message:

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

id: 161846859

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/netsuite_contract_line__histories/2026-04-11/1775909070",
        "key": "raw/netsuite_contract_line__histories/2026-04-11/1775909070/netsuite_contract_line__histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_netsuite_contract_line__histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 16795999367156595893,
        "service_name": "drive-thru",
        "span_id": 18096612419940823182,
        "trace_id": 2586638750779968250
    }
}

running: False
schema_name_id: 1526
start_time: 2026-04-11 07:06:06
success: True
trace_id: 2586638750779968250

Scan 161792078

duration: 0:00:11.891629

exit_message:

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

id: 161792078

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/netsuite_contract_line__histories/2026-04-10/1775822737",
        "key": "raw/netsuite_contract_line__histories/2026-04-10/1775822737/netsuite_contract_line__histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_netsuite_contract_line__histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 11111218705366345629,
        "service_name": "drive-thru",
        "span_id": 7315472451607681619,
        "trace_id": 13056902183347165345
    }
}

running: False
schema_name_id: 1526
start_time: 2026-04-10 07:06:36
success: True
trace_id: 13056902183347165345

Scan 161736242

duration: 0:00:14.344925

exit_message:

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

id: 161736242

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/netsuite_contract_line__histories/2026-04-09/1775736302",
        "key": "raw/netsuite_contract_line__histories/2026-04-09/1775736302/netsuite_contract_line__histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_netsuite_contract_line__histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 16537407135498190790,
        "service_name": "drive-thru",
        "span_id": 6612799698393277809,
        "trace_id": 2036296875629118911
    }
}

running: False
schema_name_id: 1526
start_time: 2026-04-09 07:05:53
success: True
trace_id: 2036296875629118911

Scan 161681376

duration: 0:00:11.856508

exit_message:

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

id: 161681376

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/netsuite_contract_line__histories/2026-04-08/1775649876",
        "key": "raw/netsuite_contract_line__histories/2026-04-08/1775649876/netsuite_contract_line__histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_netsuite_contract_line__histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 8683161833603120773,
        "service_name": "drive-thru",
        "span_id": 16291194472742484498,
        "trace_id": 9584428949945814233
    }
}

running: False
schema_name_id: 1526
start_time: 2026-04-08 07:05:51
success: True
trace_id: 9584428949945814233

Scan 161625165

duration: 0:00:14.252619

exit_message:

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

id: 161625165

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/netsuite_contract_line__histories/2026-04-07/1775563483",
        "key": "raw/netsuite_contract_line__histories/2026-04-07/1775563483/netsuite_contract_line__histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_netsuite_contract_line__histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 8398061703072032397,
        "service_name": "drive-thru",
        "span_id": 8394831765452343670,
        "trace_id": 3005842762997820503
    }
}

running: False
schema_name_id: 1526
start_time: 2026-04-07 07:05:37
success: True
trace_id: 3005842762997820503

Scan 161567330

duration: 0:00:14.327174

exit_message:

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

id: 161567330

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/netsuite_contract_line__histories/2026-04-06/1775477098",
        "key": "raw/netsuite_contract_line__histories/2026-04-06/1775477098/netsuite_contract_line__histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_netsuite_contract_line__histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 17399317595407326030,
        "service_name": "drive-thru",
        "span_id": 14543449376141865662,
        "trace_id": 3361568128938544642
    }
}

running: False
schema_name_id: 1526
start_time: 2026-04-06 07:08:48
success: True
trace_id: 3361568128938544642

Scan 161519968

duration: 0:00:14.438630

exit_message:

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

id: 161519968

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/netsuite_contract_line__histories/2026-04-05/1775390630",
        "key": "raw/netsuite_contract_line__histories/2026-04-05/1775390630/netsuite_contract_line__histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_netsuite_contract_line__histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 12290585461812912549,
        "service_name": "drive-thru",
        "span_id": 7268556527801803386,
        "trace_id": 13532447437285490351
    }
}

running: False
schema_name_id: 1526
start_time: 2026-04-05 07:05:02
success: True
trace_id: 13532447437285490351

Scan 161466421

duration: 0:00:11.784188

exit_message:

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

id: 161466421

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/netsuite_contract_line__histories/2026-04-04/1775304383",
        "key": "raw/netsuite_contract_line__histories/2026-04-04/1775304383/netsuite_contract_line__histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_netsuite_contract_line__histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 13971017747262253888,
        "service_name": "drive-thru",
        "span_id": 2226652918705260540,
        "trace_id": 7021466288168392291
    }
}

running: False
schema_name_id: 1526
start_time: 2026-04-04 07:08:08
success: True
trace_id: 7021466288168392291

Scan 161408571

duration: 0:00:14.236323

exit_message:

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

id: 161408571

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/netsuite_contract_line__histories/2026-04-03/1775217862",
        "key": "raw/netsuite_contract_line__histories/2026-04-03/1775217862/netsuite_contract_line__histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_netsuite_contract_line__histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 1480477882937137801,
        "service_name": "drive-thru",
        "span_id": 2252071061374939064,
        "trace_id": 7781412535253706237
    }
}

running: False
schema_name_id: 1526
start_time: 2026-04-03 07:05:51
success: True
trace_id: 7781412535253706237

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

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

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_netsuite_contract_line__histories`\n(\n `Id`  string , `IsDeleted`  string , `ParentId`  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/netsuite_contract_line__histories/2026-04-17/1776427476'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_netsuite_contract_line__histories`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_netsuite_contract_line__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:44",
        "disabled": false,
        "format": "raw",
        "id": 1526,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_csv",
            "table": "salesforce_netsuite_contract_line__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",
            "ParentId": "string"
        },
        "created": "2026-04-17 07:05:12",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_netsuite_contract_line__histories`\n(\n `Id`  string , `IsDeleted`  string , `ParentId`  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/netsuite_contract_line__histories/2026-04-17/1776427476'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_netsuite_contract_line__histories`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_netsuite_contract_line__histories"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}