Schema Info

Schema Name: sfdl_prod_csv.salesforce_netsuite_contract__cs

created: 2023-03-28 12:46:06
disabled: False
format: raw
id: 1529
is_partitioned: False
is_schema_datatyped: True

name:

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

type: csv

Schema Versions: 15

Version 1718101

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_netsuite_contract__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_netsuite_contract__cs`\n(\n `Id`  string , `OwnerId`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Bill_Days_in_Advance__c`  string , `Billing_Day__c`  string , `Cancellation_Date__c`  string , `Customer_Name__c`  string , `Full_Annual_Value__c`  string , `Full_Monthly_Value__c`  string , `Full_NetSuite_Contract_Name__c`  string , `Full_Quarterly_Value__c`  string , `Full_Weekly_Value__c`  string , `Gross_Amount_Billed_to_Date__c`  string , `Last_Billed_Date__c`  string , `NetSuite_ID__c`  string , `NetSuite_Sync_Time__c`  string , `Netsuite_Contract_ID__c`  string , `Next_Bill_Date__c`  string , `OrderId__c`  string , `Payment_Method__c`  string , `Status__c`  string , `Subsidiary__c`  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__cs/2026-04-17/1776427486'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_netsuite_contract__cs"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/netsuite_contract__cs/2026-04-17/1776427486
id: 1718101
processed: 1

raw_data:

{
    "Bill_Days_in_Advance__c": 12,
    "Billing_Day__c": 13,
    "Cancellation_Date__c": 14,
    "ConnectionReceivedId": 10,
    "ConnectionSentId": 11,
    "CreatedById": 6,
    "CreatedDate": 5,
    "CurrencyIsoCode": 4,
    "Customer_Name__c": 15,
    "Full_Annual_Value__c": 16,
    "Full_Monthly_Value__c": 17,
    "Full_NetSuite_Contract_Name__c": 18,
    "Full_Quarterly_Value__c": 19,
    "Full_Weekly_Value__c": 20,
    "Gross_Amount_Billed_to_Date__c": 21,
    "Id": 0,
    "IsDeleted": 2,
    "LastModifiedById": 8,
    "LastModifiedDate": 7,
    "Last_Billed_Date__c": 22,
    "Name": 3,
    "NetSuite_ID__c": 23,
    "NetSuite_Sync_Time__c": 24,
    "Netsuite_Contract_ID__c": 25,
    "Next_Bill_Date__c": 26,
    "OrderId__c": 27,
    "OwnerId": 1,
    "Payment_Method__c": 28,
    "Status__c": 29,
    "Subsidiary__c": 30,
    "SystemModstamp": 9
}

schema_attributes:

{
    "Bill_Days_in_Advance__c": "string",
    "Billing_Day__c": "string",
    "Cancellation_Date__c": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Customer_Name__c": "string",
    "Full_Annual_Value__c": "string",
    "Full_Monthly_Value__c": "string",
    "Full_NetSuite_Contract_Name__c": "string",
    "Full_Quarterly_Value__c": "string",
    "Full_Weekly_Value__c": "string",
    "Gross_Amount_Billed_to_Date__c": "string",
    "Id": "string",
    "IsDeleted": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Last_Billed_Date__c": "string",
    "Name": "string",
    "NetSuite_ID__c": "string",
    "NetSuite_Sync_Time__c": "string",
    "Netsuite_Contract_ID__c": "string",
    "Next_Bill_Date__c": "string",
    "OrderId__c": "string",
    "OwnerId": "string",
    "Payment_Method__c": "string",
    "Status__c": "string",
    "Subsidiary__c": "string",
    "SystemModstamp": "string"
}

schema_name_id: 1529
schema_scan_id: 162173070
updated: 2026-04-17 07:07:05

Version 1716871

created: 2026-04-16 07:07:02

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_netsuite_contract__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_netsuite_contract__cs`\n(\n `Id`  string , `OwnerId`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Bill_Days_in_Advance__c`  string , `Billing_Day__c`  string , `Cancellation_Date__c`  string , `Customer_Name__c`  string , `Full_Annual_Value__c`  string , `Full_Monthly_Value__c`  string , `Full_NetSuite_Contract_Name__c`  string , `Full_Quarterly_Value__c`  string , `Full_Weekly_Value__c`  string , `Gross_Amount_Billed_to_Date__c`  string , `Last_Billed_Date__c`  string , `NetSuite_ID__c`  string , `NetSuite_Sync_Time__c`  string , `Netsuite_Contract_ID__c`  string , `Next_Bill_Date__c`  string , `OrderId__c`  string , `Payment_Method__c`  string , `Status__c`  string , `Subsidiary__c`  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__cs/2026-04-16/1776341117'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_netsuite_contract__cs"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/netsuite_contract__cs/2026-04-16/1776341117
id: 1716871
processed: 1

raw_data:

{
    "Bill_Days_in_Advance__c": 12,
    "Billing_Day__c": 13,
    "Cancellation_Date__c": 14,
    "ConnectionReceivedId": 10,
    "ConnectionSentId": 11,
    "CreatedById": 6,
    "CreatedDate": 5,
    "CurrencyIsoCode": 4,
    "Customer_Name__c": 15,
    "Full_Annual_Value__c": 16,
    "Full_Monthly_Value__c": 17,
    "Full_NetSuite_Contract_Name__c": 18,
    "Full_Quarterly_Value__c": 19,
    "Full_Weekly_Value__c": 20,
    "Gross_Amount_Billed_to_Date__c": 21,
    "Id": 0,
    "IsDeleted": 2,
    "LastModifiedById": 8,
    "LastModifiedDate": 7,
    "Last_Billed_Date__c": 22,
    "Name": 3,
    "NetSuite_ID__c": 23,
    "NetSuite_Sync_Time__c": 24,
    "Netsuite_Contract_ID__c": 25,
    "Next_Bill_Date__c": 26,
    "OrderId__c": 27,
    "OwnerId": 1,
    "Payment_Method__c": 28,
    "Status__c": 29,
    "Subsidiary__c": 30,
    "SystemModstamp": 9
}

schema_attributes:

{
    "Bill_Days_in_Advance__c": "string",
    "Billing_Day__c": "string",
    "Cancellation_Date__c": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Customer_Name__c": "string",
    "Full_Annual_Value__c": "string",
    "Full_Monthly_Value__c": "string",
    "Full_NetSuite_Contract_Name__c": "string",
    "Full_Quarterly_Value__c": "string",
    "Full_Weekly_Value__c": "string",
    "Gross_Amount_Billed_to_Date__c": "string",
    "Id": "string",
    "IsDeleted": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Last_Billed_Date__c": "string",
    "Name": "string",
    "NetSuite_ID__c": "string",
    "NetSuite_Sync_Time__c": "string",
    "Netsuite_Contract_ID__c": "string",
    "Next_Bill_Date__c": "string",
    "OrderId__c": "string",
    "OwnerId": "string",
    "Payment_Method__c": "string",
    "Status__c": "string",
    "Subsidiary__c": "string",
    "SystemModstamp": "string"
}

schema_name_id: 1529
schema_scan_id: 162117355
updated: 2026-04-16 07:07:13

Version 1715683

created: 2026-04-15 07:11:47

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_netsuite_contract__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_netsuite_contract__cs`\n(\n `Id`  string , `OwnerId`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Bill_Days_in_Advance__c`  string , `Billing_Day__c`  string , `Cancellation_Date__c`  string , `Customer_Name__c`  string , `Full_Annual_Value__c`  string , `Full_Monthly_Value__c`  string , `Full_NetSuite_Contract_Name__c`  string , `Full_Quarterly_Value__c`  string , `Full_Weekly_Value__c`  string , `Gross_Amount_Billed_to_Date__c`  string , `Last_Billed_Date__c`  string , `NetSuite_ID__c`  string , `NetSuite_Sync_Time__c`  string , `Netsuite_Contract_ID__c`  string , `Next_Bill_Date__c`  string , `OrderId__c`  string , `Payment_Method__c`  string , `Status__c`  string , `Subsidiary__c`  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__cs/2026-04-15/1776254800'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_netsuite_contract__cs"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/netsuite_contract__cs/2026-04-15/1776254800
id: 1715683
processed: 1

raw_data:

{
    "Bill_Days_in_Advance__c": 12,
    "Billing_Day__c": 13,
    "Cancellation_Date__c": 14,
    "ConnectionReceivedId": 10,
    "ConnectionSentId": 11,
    "CreatedById": 6,
    "CreatedDate": 5,
    "CurrencyIsoCode": 4,
    "Customer_Name__c": 15,
    "Full_Annual_Value__c": 16,
    "Full_Monthly_Value__c": 17,
    "Full_NetSuite_Contract_Name__c": 18,
    "Full_Quarterly_Value__c": 19,
    "Full_Weekly_Value__c": 20,
    "Gross_Amount_Billed_to_Date__c": 21,
    "Id": 0,
    "IsDeleted": 2,
    "LastModifiedById": 8,
    "LastModifiedDate": 7,
    "Last_Billed_Date__c": 22,
    "Name": 3,
    "NetSuite_ID__c": 23,
    "NetSuite_Sync_Time__c": 24,
    "Netsuite_Contract_ID__c": 25,
    "Next_Bill_Date__c": 26,
    "OrderId__c": 27,
    "OwnerId": 1,
    "Payment_Method__c": 28,
    "Status__c": 29,
    "Subsidiary__c": 30,
    "SystemModstamp": 9
}

schema_attributes:

{
    "Bill_Days_in_Advance__c": "string",
    "Billing_Day__c": "string",
    "Cancellation_Date__c": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Customer_Name__c": "string",
    "Full_Annual_Value__c": "string",
    "Full_Monthly_Value__c": "string",
    "Full_NetSuite_Contract_Name__c": "string",
    "Full_Quarterly_Value__c": "string",
    "Full_Weekly_Value__c": "string",
    "Gross_Amount_Billed_to_Date__c": "string",
    "Id": "string",
    "IsDeleted": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Last_Billed_Date__c": "string",
    "Name": "string",
    "NetSuite_ID__c": "string",
    "NetSuite_Sync_Time__c": "string",
    "Netsuite_Contract_ID__c": "string",
    "Next_Bill_Date__c": "string",
    "OrderId__c": "string",
    "OwnerId": "string",
    "Payment_Method__c": "string",
    "Status__c": "string",
    "Subsidiary__c": "string",
    "SystemModstamp": "string"
}

schema_name_id: 1529
schema_scan_id: 162061830
updated: 2026-04-15 07:12:01

Version 1714490

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_netsuite_contract__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_netsuite_contract__cs`\n(\n `Id`  string , `OwnerId`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Bill_Days_in_Advance__c`  string , `Billing_Day__c`  string , `Cancellation_Date__c`  string , `Customer_Name__c`  string , `Full_Annual_Value__c`  string , `Full_Monthly_Value__c`  string , `Full_NetSuite_Contract_Name__c`  string , `Full_Quarterly_Value__c`  string , `Full_Weekly_Value__c`  string , `Gross_Amount_Billed_to_Date__c`  string , `Last_Billed_Date__c`  string , `NetSuite_ID__c`  string , `NetSuite_Sync_Time__c`  string , `Netsuite_Contract_ID__c`  string , `Next_Bill_Date__c`  string , `OrderId__c`  string , `Payment_Method__c`  string , `Status__c`  string , `Subsidiary__c`  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__cs/2026-04-14/1776168331'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_netsuite_contract__cs"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/netsuite_contract__cs/2026-04-14/1776168331
id: 1714490
processed: 1

raw_data:

{
    "Bill_Days_in_Advance__c": 12,
    "Billing_Day__c": 13,
    "Cancellation_Date__c": 14,
    "ConnectionReceivedId": 10,
    "ConnectionSentId": 11,
    "CreatedById": 6,
    "CreatedDate": 5,
    "CurrencyIsoCode": 4,
    "Customer_Name__c": 15,
    "Full_Annual_Value__c": 16,
    "Full_Monthly_Value__c": 17,
    "Full_NetSuite_Contract_Name__c": 18,
    "Full_Quarterly_Value__c": 19,
    "Full_Weekly_Value__c": 20,
    "Gross_Amount_Billed_to_Date__c": 21,
    "Id": 0,
    "IsDeleted": 2,
    "LastModifiedById": 8,
    "LastModifiedDate": 7,
    "Last_Billed_Date__c": 22,
    "Name": 3,
    "NetSuite_ID__c": 23,
    "NetSuite_Sync_Time__c": 24,
    "Netsuite_Contract_ID__c": 25,
    "Next_Bill_Date__c": 26,
    "OrderId__c": 27,
    "OwnerId": 1,
    "Payment_Method__c": 28,
    "Status__c": 29,
    "Subsidiary__c": 30,
    "SystemModstamp": 9
}

schema_attributes:

{
    "Bill_Days_in_Advance__c": "string",
    "Billing_Day__c": "string",
    "Cancellation_Date__c": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Customer_Name__c": "string",
    "Full_Annual_Value__c": "string",
    "Full_Monthly_Value__c": "string",
    "Full_NetSuite_Contract_Name__c": "string",
    "Full_Quarterly_Value__c": "string",
    "Full_Weekly_Value__c": "string",
    "Gross_Amount_Billed_to_Date__c": "string",
    "Id": "string",
    "IsDeleted": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Last_Billed_Date__c": "string",
    "Name": "string",
    "NetSuite_ID__c": "string",
    "NetSuite_Sync_Time__c": "string",
    "Netsuite_Contract_ID__c": "string",
    "Next_Bill_Date__c": "string",
    "OrderId__c": "string",
    "OwnerId": "string",
    "Payment_Method__c": "string",
    "Status__c": "string",
    "Subsidiary__c": "string",
    "SystemModstamp": "string"
}

schema_name_id: 1529
schema_scan_id: 162006418
updated: 2026-04-14 07:07:52

Version 1713262

created: 2026-04-13 07:07:45

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_netsuite_contract__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_netsuite_contract__cs`\n(\n `Id`  string , `OwnerId`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Bill_Days_in_Advance__c`  string , `Billing_Day__c`  string , `Cancellation_Date__c`  string , `Customer_Name__c`  string , `Full_Annual_Value__c`  string , `Full_Monthly_Value__c`  string , `Full_NetSuite_Contract_Name__c`  string , `Full_Quarterly_Value__c`  string , `Full_Weekly_Value__c`  string , `Gross_Amount_Billed_to_Date__c`  string , `Last_Billed_Date__c`  string , `NetSuite_ID__c`  string , `NetSuite_Sync_Time__c`  string , `Netsuite_Contract_ID__c`  string , `Next_Bill_Date__c`  string , `OrderId__c`  string , `Payment_Method__c`  string , `Status__c`  string , `Subsidiary__c`  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__cs/2026-04-13/1776081916'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_netsuite_contract__cs"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/netsuite_contract__cs/2026-04-13/1776081916
id: 1713262
processed: 1

raw_data:

{
    "Bill_Days_in_Advance__c": 12,
    "Billing_Day__c": 13,
    "Cancellation_Date__c": 14,
    "ConnectionReceivedId": 10,
    "ConnectionSentId": 11,
    "CreatedById": 6,
    "CreatedDate": 5,
    "CurrencyIsoCode": 4,
    "Customer_Name__c": 15,
    "Full_Annual_Value__c": 16,
    "Full_Monthly_Value__c": 17,
    "Full_NetSuite_Contract_Name__c": 18,
    "Full_Quarterly_Value__c": 19,
    "Full_Weekly_Value__c": 20,
    "Gross_Amount_Billed_to_Date__c": 21,
    "Id": 0,
    "IsDeleted": 2,
    "LastModifiedById": 8,
    "LastModifiedDate": 7,
    "Last_Billed_Date__c": 22,
    "Name": 3,
    "NetSuite_ID__c": 23,
    "NetSuite_Sync_Time__c": 24,
    "Netsuite_Contract_ID__c": 25,
    "Next_Bill_Date__c": 26,
    "OrderId__c": 27,
    "OwnerId": 1,
    "Payment_Method__c": 28,
    "Status__c": 29,
    "Subsidiary__c": 30,
    "SystemModstamp": 9
}

schema_attributes:

{
    "Bill_Days_in_Advance__c": "string",
    "Billing_Day__c": "string",
    "Cancellation_Date__c": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Customer_Name__c": "string",
    "Full_Annual_Value__c": "string",
    "Full_Monthly_Value__c": "string",
    "Full_NetSuite_Contract_Name__c": "string",
    "Full_Quarterly_Value__c": "string",
    "Full_Weekly_Value__c": "string",
    "Gross_Amount_Billed_to_Date__c": "string",
    "Id": "string",
    "IsDeleted": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Last_Billed_Date__c": "string",
    "Name": "string",
    "NetSuite_ID__c": "string",
    "NetSuite_Sync_Time__c": "string",
    "Netsuite_Contract_ID__c": "string",
    "Next_Bill_Date__c": "string",
    "OrderId__c": "string",
    "OwnerId": "string",
    "Payment_Method__c": "string",
    "Status__c": "string",
    "Subsidiary__c": "string",
    "SystemModstamp": "string"
}

schema_name_id: 1529
schema_scan_id: 161948349
updated: 2026-04-13 07:07:57

Version 1712045

created: 2026-04-12 07:07:23

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_netsuite_contract__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_netsuite_contract__cs`\n(\n `Id`  string , `OwnerId`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Bill_Days_in_Advance__c`  string , `Billing_Day__c`  string , `Cancellation_Date__c`  string , `Customer_Name__c`  string , `Full_Annual_Value__c`  string , `Full_Monthly_Value__c`  string , `Full_NetSuite_Contract_Name__c`  string , `Full_Quarterly_Value__c`  string , `Full_Weekly_Value__c`  string , `Gross_Amount_Billed_to_Date__c`  string , `Last_Billed_Date__c`  string , `NetSuite_ID__c`  string , `NetSuite_Sync_Time__c`  string , `Netsuite_Contract_ID__c`  string , `Next_Bill_Date__c`  string , `OrderId__c`  string , `Payment_Method__c`  string , `Status__c`  string , `Subsidiary__c`  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__cs/2026-04-12/1775995638'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_netsuite_contract__cs"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/netsuite_contract__cs/2026-04-12/1775995638
id: 1712045
processed: 1

raw_data:

{
    "Bill_Days_in_Advance__c": 12,
    "Billing_Day__c": 13,
    "Cancellation_Date__c": 14,
    "ConnectionReceivedId": 10,
    "ConnectionSentId": 11,
    "CreatedById": 6,
    "CreatedDate": 5,
    "CurrencyIsoCode": 4,
    "Customer_Name__c": 15,
    "Full_Annual_Value__c": 16,
    "Full_Monthly_Value__c": 17,
    "Full_NetSuite_Contract_Name__c": 18,
    "Full_Quarterly_Value__c": 19,
    "Full_Weekly_Value__c": 20,
    "Gross_Amount_Billed_to_Date__c": 21,
    "Id": 0,
    "IsDeleted": 2,
    "LastModifiedById": 8,
    "LastModifiedDate": 7,
    "Last_Billed_Date__c": 22,
    "Name": 3,
    "NetSuite_ID__c": 23,
    "NetSuite_Sync_Time__c": 24,
    "Netsuite_Contract_ID__c": 25,
    "Next_Bill_Date__c": 26,
    "OrderId__c": 27,
    "OwnerId": 1,
    "Payment_Method__c": 28,
    "Status__c": 29,
    "Subsidiary__c": 30,
    "SystemModstamp": 9
}

schema_attributes:

{
    "Bill_Days_in_Advance__c": "string",
    "Billing_Day__c": "string",
    "Cancellation_Date__c": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Customer_Name__c": "string",
    "Full_Annual_Value__c": "string",
    "Full_Monthly_Value__c": "string",
    "Full_NetSuite_Contract_Name__c": "string",
    "Full_Quarterly_Value__c": "string",
    "Full_Weekly_Value__c": "string",
    "Gross_Amount_Billed_to_Date__c": "string",
    "Id": "string",
    "IsDeleted": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Last_Billed_Date__c": "string",
    "Name": "string",
    "NetSuite_ID__c": "string",
    "NetSuite_Sync_Time__c": "string",
    "Netsuite_Contract_ID__c": "string",
    "Next_Bill_Date__c": "string",
    "OrderId__c": "string",
    "OwnerId": "string",
    "Payment_Method__c": "string",
    "Status__c": "string",
    "Subsidiary__c": "string",
    "SystemModstamp": "string"
}

schema_name_id: 1529
schema_scan_id: 161899527
updated: 2026-04-12 07:07:34

Version 1710873

created: 2026-04-11 07:07:47

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_netsuite_contract__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_netsuite_contract__cs`\n(\n `Id`  string , `OwnerId`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Bill_Days_in_Advance__c`  string , `Billing_Day__c`  string , `Cancellation_Date__c`  string , `Customer_Name__c`  string , `Full_Annual_Value__c`  string , `Full_Monthly_Value__c`  string , `Full_NetSuite_Contract_Name__c`  string , `Full_Quarterly_Value__c`  string , `Full_Weekly_Value__c`  string , `Gross_Amount_Billed_to_Date__c`  string , `Last_Billed_Date__c`  string , `NetSuite_ID__c`  string , `NetSuite_Sync_Time__c`  string , `Netsuite_Contract_ID__c`  string , `Next_Bill_Date__c`  string , `OrderId__c`  string , `Payment_Method__c`  string , `Status__c`  string , `Subsidiary__c`  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__cs/2026-04-11/1775909087'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_netsuite_contract__cs"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/netsuite_contract__cs/2026-04-11/1775909087
id: 1710873
processed: 1

raw_data:

{
    "Bill_Days_in_Advance__c": 12,
    "Billing_Day__c": 13,
    "Cancellation_Date__c": 14,
    "ConnectionReceivedId": 10,
    "ConnectionSentId": 11,
    "CreatedById": 6,
    "CreatedDate": 5,
    "CurrencyIsoCode": 4,
    "Customer_Name__c": 15,
    "Full_Annual_Value__c": 16,
    "Full_Monthly_Value__c": 17,
    "Full_NetSuite_Contract_Name__c": 18,
    "Full_Quarterly_Value__c": 19,
    "Full_Weekly_Value__c": 20,
    "Gross_Amount_Billed_to_Date__c": 21,
    "Id": 0,
    "IsDeleted": 2,
    "LastModifiedById": 8,
    "LastModifiedDate": 7,
    "Last_Billed_Date__c": 22,
    "Name": 3,
    "NetSuite_ID__c": 23,
    "NetSuite_Sync_Time__c": 24,
    "Netsuite_Contract_ID__c": 25,
    "Next_Bill_Date__c": 26,
    "OrderId__c": 27,
    "OwnerId": 1,
    "Payment_Method__c": 28,
    "Status__c": 29,
    "Subsidiary__c": 30,
    "SystemModstamp": 9
}

schema_attributes:

{
    "Bill_Days_in_Advance__c": "string",
    "Billing_Day__c": "string",
    "Cancellation_Date__c": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Customer_Name__c": "string",
    "Full_Annual_Value__c": "string",
    "Full_Monthly_Value__c": "string",
    "Full_NetSuite_Contract_Name__c": "string",
    "Full_Quarterly_Value__c": "string",
    "Full_Weekly_Value__c": "string",
    "Gross_Amount_Billed_to_Date__c": "string",
    "Id": "string",
    "IsDeleted": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Last_Billed_Date__c": "string",
    "Name": "string",
    "NetSuite_ID__c": "string",
    "NetSuite_Sync_Time__c": "string",
    "Netsuite_Contract_ID__c": "string",
    "Next_Bill_Date__c": "string",
    "OrderId__c": "string",
    "OwnerId": "string",
    "Payment_Method__c": "string",
    "Status__c": "string",
    "Subsidiary__c": "string",
    "SystemModstamp": "string"
}

schema_name_id: 1529
schema_scan_id: 161846886
updated: 2026-04-11 07:08:01

Version 1709665

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_netsuite_contract__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_netsuite_contract__cs`\n(\n `Id`  string , `OwnerId`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Bill_Days_in_Advance__c`  string , `Billing_Day__c`  string , `Cancellation_Date__c`  string , `Customer_Name__c`  string , `Full_Annual_Value__c`  string , `Full_Monthly_Value__c`  string , `Full_NetSuite_Contract_Name__c`  string , `Full_Quarterly_Value__c`  string , `Full_Weekly_Value__c`  string , `Gross_Amount_Billed_to_Date__c`  string , `Last_Billed_Date__c`  string , `NetSuite_ID__c`  string , `NetSuite_Sync_Time__c`  string , `Netsuite_Contract_ID__c`  string , `Next_Bill_Date__c`  string , `OrderId__c`  string , `Payment_Method__c`  string , `Status__c`  string , `Subsidiary__c`  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__cs/2026-04-10/1775822708'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_netsuite_contract__cs"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/netsuite_contract__cs/2026-04-10/1775822708
id: 1709665
processed: 1

raw_data:

{
    "Bill_Days_in_Advance__c": 12,
    "Billing_Day__c": 13,
    "Cancellation_Date__c": 14,
    "ConnectionReceivedId": 10,
    "ConnectionSentId": 11,
    "CreatedById": 6,
    "CreatedDate": 5,
    "CurrencyIsoCode": 4,
    "Customer_Name__c": 15,
    "Full_Annual_Value__c": 16,
    "Full_Monthly_Value__c": 17,
    "Full_NetSuite_Contract_Name__c": 18,
    "Full_Quarterly_Value__c": 19,
    "Full_Weekly_Value__c": 20,
    "Gross_Amount_Billed_to_Date__c": 21,
    "Id": 0,
    "IsDeleted": 2,
    "LastModifiedById": 8,
    "LastModifiedDate": 7,
    "Last_Billed_Date__c": 22,
    "Name": 3,
    "NetSuite_ID__c": 23,
    "NetSuite_Sync_Time__c": 24,
    "Netsuite_Contract_ID__c": 25,
    "Next_Bill_Date__c": 26,
    "OrderId__c": 27,
    "OwnerId": 1,
    "Payment_Method__c": 28,
    "Status__c": 29,
    "Subsidiary__c": 30,
    "SystemModstamp": 9
}

schema_attributes:

{
    "Bill_Days_in_Advance__c": "string",
    "Billing_Day__c": "string",
    "Cancellation_Date__c": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Customer_Name__c": "string",
    "Full_Annual_Value__c": "string",
    "Full_Monthly_Value__c": "string",
    "Full_NetSuite_Contract_Name__c": "string",
    "Full_Quarterly_Value__c": "string",
    "Full_Weekly_Value__c": "string",
    "Gross_Amount_Billed_to_Date__c": "string",
    "Id": "string",
    "IsDeleted": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Last_Billed_Date__c": "string",
    "Name": "string",
    "NetSuite_ID__c": "string",
    "NetSuite_Sync_Time__c": "string",
    "Netsuite_Contract_ID__c": "string",
    "Next_Bill_Date__c": "string",
    "OrderId__c": "string",
    "OwnerId": "string",
    "Payment_Method__c": "string",
    "Status__c": "string",
    "Subsidiary__c": "string",
    "SystemModstamp": "string"
}

schema_name_id: 1529
schema_scan_id: 161792064
updated: 2026-04-10 07:06:12

Version 1708506

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_netsuite_contract__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_netsuite_contract__cs`\n(\n `Id`  string , `OwnerId`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Bill_Days_in_Advance__c`  string , `Billing_Day__c`  string , `Cancellation_Date__c`  string , `Customer_Name__c`  string , `Full_Annual_Value__c`  string , `Full_Monthly_Value__c`  string , `Full_NetSuite_Contract_Name__c`  string , `Full_Quarterly_Value__c`  string , `Full_Weekly_Value__c`  string , `Gross_Amount_Billed_to_Date__c`  string , `Last_Billed_Date__c`  string , `NetSuite_ID__c`  string , `NetSuite_Sync_Time__c`  string , `Netsuite_Contract_ID__c`  string , `Next_Bill_Date__c`  string , `OrderId__c`  string , `Payment_Method__c`  string , `Status__c`  string , `Subsidiary__c`  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__cs/2026-04-09/1775736304'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_netsuite_contract__cs"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/netsuite_contract__cs/2026-04-09/1775736304
id: 1708506
processed: 1

raw_data:

{
    "Bill_Days_in_Advance__c": 12,
    "Billing_Day__c": 13,
    "Cancellation_Date__c": 14,
    "ConnectionReceivedId": 10,
    "ConnectionSentId": 11,
    "CreatedById": 6,
    "CreatedDate": 5,
    "CurrencyIsoCode": 4,
    "Customer_Name__c": 15,
    "Full_Annual_Value__c": 16,
    "Full_Monthly_Value__c": 17,
    "Full_NetSuite_Contract_Name__c": 18,
    "Full_Quarterly_Value__c": 19,
    "Full_Weekly_Value__c": 20,
    "Gross_Amount_Billed_to_Date__c": 21,
    "Id": 0,
    "IsDeleted": 2,
    "LastModifiedById": 8,
    "LastModifiedDate": 7,
    "Last_Billed_Date__c": 22,
    "Name": 3,
    "NetSuite_ID__c": 23,
    "NetSuite_Sync_Time__c": 24,
    "Netsuite_Contract_ID__c": 25,
    "Next_Bill_Date__c": 26,
    "OrderId__c": 27,
    "OwnerId": 1,
    "Payment_Method__c": 28,
    "Status__c": 29,
    "Subsidiary__c": 30,
    "SystemModstamp": 9
}

schema_attributes:

{
    "Bill_Days_in_Advance__c": "string",
    "Billing_Day__c": "string",
    "Cancellation_Date__c": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Customer_Name__c": "string",
    "Full_Annual_Value__c": "string",
    "Full_Monthly_Value__c": "string",
    "Full_NetSuite_Contract_Name__c": "string",
    "Full_Quarterly_Value__c": "string",
    "Full_Weekly_Value__c": "string",
    "Gross_Amount_Billed_to_Date__c": "string",
    "Id": "string",
    "IsDeleted": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Last_Billed_Date__c": "string",
    "Name": "string",
    "NetSuite_ID__c": "string",
    "NetSuite_Sync_Time__c": "string",
    "Netsuite_Contract_ID__c": "string",
    "Next_Bill_Date__c": "string",
    "OrderId__c": "string",
    "OwnerId": "string",
    "Payment_Method__c": "string",
    "Status__c": "string",
    "Subsidiary__c": "string",
    "SystemModstamp": "string"
}

schema_name_id: 1529
schema_scan_id: 161736232
updated: 2026-04-09 07:05:47

Version 1707347

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_netsuite_contract__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_netsuite_contract__cs`\n(\n `Id`  string , `OwnerId`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Bill_Days_in_Advance__c`  string , `Billing_Day__c`  string , `Cancellation_Date__c`  string , `Customer_Name__c`  string , `Full_Annual_Value__c`  string , `Full_Monthly_Value__c`  string , `Full_NetSuite_Contract_Name__c`  string , `Full_Quarterly_Value__c`  string , `Full_Weekly_Value__c`  string , `Gross_Amount_Billed_to_Date__c`  string , `Last_Billed_Date__c`  string , `NetSuite_ID__c`  string , `NetSuite_Sync_Time__c`  string , `Netsuite_Contract_ID__c`  string , `Next_Bill_Date__c`  string , `OrderId__c`  string , `Payment_Method__c`  string , `Status__c`  string , `Subsidiary__c`  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__cs/2026-04-08/1775649919'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_netsuite_contract__cs"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/netsuite_contract__cs/2026-04-08/1775649919
id: 1707347
processed: 1

raw_data:

{
    "Bill_Days_in_Advance__c": 12,
    "Billing_Day__c": 13,
    "Cancellation_Date__c": 14,
    "ConnectionReceivedId": 10,
    "ConnectionSentId": 11,
    "CreatedById": 6,
    "CreatedDate": 5,
    "CurrencyIsoCode": 4,
    "Customer_Name__c": 15,
    "Full_Annual_Value__c": 16,
    "Full_Monthly_Value__c": 17,
    "Full_NetSuite_Contract_Name__c": 18,
    "Full_Quarterly_Value__c": 19,
    "Full_Weekly_Value__c": 20,
    "Gross_Amount_Billed_to_Date__c": 21,
    "Id": 0,
    "IsDeleted": 2,
    "LastModifiedById": 8,
    "LastModifiedDate": 7,
    "Last_Billed_Date__c": 22,
    "Name": 3,
    "NetSuite_ID__c": 23,
    "NetSuite_Sync_Time__c": 24,
    "Netsuite_Contract_ID__c": 25,
    "Next_Bill_Date__c": 26,
    "OrderId__c": 27,
    "OwnerId": 1,
    "Payment_Method__c": 28,
    "Status__c": 29,
    "Subsidiary__c": 30,
    "SystemModstamp": 9
}

schema_attributes:

{
    "Bill_Days_in_Advance__c": "string",
    "Billing_Day__c": "string",
    "Cancellation_Date__c": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Customer_Name__c": "string",
    "Full_Annual_Value__c": "string",
    "Full_Monthly_Value__c": "string",
    "Full_NetSuite_Contract_Name__c": "string",
    "Full_Quarterly_Value__c": "string",
    "Full_Weekly_Value__c": "string",
    "Gross_Amount_Billed_to_Date__c": "string",
    "Id": "string",
    "IsDeleted": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Last_Billed_Date__c": "string",
    "Name": "string",
    "NetSuite_ID__c": "string",
    "NetSuite_Sync_Time__c": "string",
    "Netsuite_Contract_ID__c": "string",
    "Next_Bill_Date__c": "string",
    "OrderId__c": "string",
    "OwnerId": "string",
    "Payment_Method__c": "string",
    "Status__c": "string",
    "Subsidiary__c": "string",
    "SystemModstamp": "string"
}

schema_name_id: 1529
schema_scan_id: 161681408
updated: 2026-04-08 07:07:12

Version 1706139

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_netsuite_contract__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_netsuite_contract__cs`\n(\n `Id`  string , `OwnerId`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Bill_Days_in_Advance__c`  string , `Billing_Day__c`  string , `Cancellation_Date__c`  string , `Customer_Name__c`  string , `Full_Annual_Value__c`  string , `Full_Monthly_Value__c`  string , `Full_NetSuite_Contract_Name__c`  string , `Full_Quarterly_Value__c`  string , `Full_Weekly_Value__c`  string , `Gross_Amount_Billed_to_Date__c`  string , `Last_Billed_Date__c`  string , `NetSuite_ID__c`  string , `NetSuite_Sync_Time__c`  string , `Netsuite_Contract_ID__c`  string , `Next_Bill_Date__c`  string , `OrderId__c`  string , `Payment_Method__c`  string , `Status__c`  string , `Subsidiary__c`  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__cs/2026-04-07/1775563508'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_netsuite_contract__cs"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/netsuite_contract__cs/2026-04-07/1775563508
id: 1706139
processed: 1

raw_data:

{
    "Bill_Days_in_Advance__c": 12,
    "Billing_Day__c": 13,
    "Cancellation_Date__c": 14,
    "ConnectionReceivedId": 10,
    "ConnectionSentId": 11,
    "CreatedById": 6,
    "CreatedDate": 5,
    "CurrencyIsoCode": 4,
    "Customer_Name__c": 15,
    "Full_Annual_Value__c": 16,
    "Full_Monthly_Value__c": 17,
    "Full_NetSuite_Contract_Name__c": 18,
    "Full_Quarterly_Value__c": 19,
    "Full_Weekly_Value__c": 20,
    "Gross_Amount_Billed_to_Date__c": 21,
    "Id": 0,
    "IsDeleted": 2,
    "LastModifiedById": 8,
    "LastModifiedDate": 7,
    "Last_Billed_Date__c": 22,
    "Name": 3,
    "NetSuite_ID__c": 23,
    "NetSuite_Sync_Time__c": 24,
    "Netsuite_Contract_ID__c": 25,
    "Next_Bill_Date__c": 26,
    "OrderId__c": 27,
    "OwnerId": 1,
    "Payment_Method__c": 28,
    "Status__c": 29,
    "Subsidiary__c": 30,
    "SystemModstamp": 9
}

schema_attributes:

{
    "Bill_Days_in_Advance__c": "string",
    "Billing_Day__c": "string",
    "Cancellation_Date__c": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Customer_Name__c": "string",
    "Full_Annual_Value__c": "string",
    "Full_Monthly_Value__c": "string",
    "Full_NetSuite_Contract_Name__c": "string",
    "Full_Quarterly_Value__c": "string",
    "Full_Weekly_Value__c": "string",
    "Gross_Amount_Billed_to_Date__c": "string",
    "Id": "string",
    "IsDeleted": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Last_Billed_Date__c": "string",
    "Name": "string",
    "NetSuite_ID__c": "string",
    "NetSuite_Sync_Time__c": "string",
    "Netsuite_Contract_ID__c": "string",
    "Next_Bill_Date__c": "string",
    "OrderId__c": "string",
    "OwnerId": "string",
    "Payment_Method__c": "string",
    "Status__c": "string",
    "Subsidiary__c": "string",
    "SystemModstamp": "string"
}

schema_name_id: 1529
schema_scan_id: 161625175
updated: 2026-04-07 07:06:18

Version 1704950

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_netsuite_contract__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_netsuite_contract__cs`\n(\n `Id`  string , `OwnerId`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Bill_Days_in_Advance__c`  string , `Billing_Day__c`  string , `Cancellation_Date__c`  string , `Customer_Name__c`  string , `Full_Annual_Value__c`  string , `Full_Monthly_Value__c`  string , `Full_NetSuite_Contract_Name__c`  string , `Full_Quarterly_Value__c`  string , `Full_Weekly_Value__c`  string , `Gross_Amount_Billed_to_Date__c`  string , `Last_Billed_Date__c`  string , `NetSuite_ID__c`  string , `NetSuite_Sync_Time__c`  string , `Netsuite_Contract_ID__c`  string , `Next_Bill_Date__c`  string , `OrderId__c`  string , `Payment_Method__c`  string , `Status__c`  string , `Subsidiary__c`  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__cs/2026-04-06/1775477098'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_netsuite_contract__cs"
]

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

raw_data:

{
    "Bill_Days_in_Advance__c": 12,
    "Billing_Day__c": 13,
    "Cancellation_Date__c": 14,
    "ConnectionReceivedId": 10,
    "ConnectionSentId": 11,
    "CreatedById": 6,
    "CreatedDate": 5,
    "CurrencyIsoCode": 4,
    "Customer_Name__c": 15,
    "Full_Annual_Value__c": 16,
    "Full_Monthly_Value__c": 17,
    "Full_NetSuite_Contract_Name__c": 18,
    "Full_Quarterly_Value__c": 19,
    "Full_Weekly_Value__c": 20,
    "Gross_Amount_Billed_to_Date__c": 21,
    "Id": 0,
    "IsDeleted": 2,
    "LastModifiedById": 8,
    "LastModifiedDate": 7,
    "Last_Billed_Date__c": 22,
    "Name": 3,
    "NetSuite_ID__c": 23,
    "NetSuite_Sync_Time__c": 24,
    "Netsuite_Contract_ID__c": 25,
    "Next_Bill_Date__c": 26,
    "OrderId__c": 27,
    "OwnerId": 1,
    "Payment_Method__c": 28,
    "Status__c": 29,
    "Subsidiary__c": 30,
    "SystemModstamp": 9
}

schema_attributes:

{
    "Bill_Days_in_Advance__c": "string",
    "Billing_Day__c": "string",
    "Cancellation_Date__c": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Customer_Name__c": "string",
    "Full_Annual_Value__c": "string",
    "Full_Monthly_Value__c": "string",
    "Full_NetSuite_Contract_Name__c": "string",
    "Full_Quarterly_Value__c": "string",
    "Full_Weekly_Value__c": "string",
    "Gross_Amount_Billed_to_Date__c": "string",
    "Id": "string",
    "IsDeleted": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Last_Billed_Date__c": "string",
    "Name": "string",
    "NetSuite_ID__c": "string",
    "NetSuite_Sync_Time__c": "string",
    "Netsuite_Contract_ID__c": "string",
    "Next_Bill_Date__c": "string",
    "OrderId__c": "string",
    "OwnerId": "string",
    "Payment_Method__c": "string",
    "Status__c": "string",
    "Subsidiary__c": "string",
    "SystemModstamp": "string"
}

schema_name_id: 1529
schema_scan_id: 161567366
updated: 2026-04-06 07:11:32

Version 1703686

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_netsuite_contract__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_netsuite_contract__cs`\n(\n `Id`  string , `OwnerId`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Bill_Days_in_Advance__c`  string , `Billing_Day__c`  string , `Cancellation_Date__c`  string , `Customer_Name__c`  string , `Full_Annual_Value__c`  string , `Full_Monthly_Value__c`  string , `Full_NetSuite_Contract_Name__c`  string , `Full_Quarterly_Value__c`  string , `Full_Weekly_Value__c`  string , `Gross_Amount_Billed_to_Date__c`  string , `Last_Billed_Date__c`  string , `NetSuite_ID__c`  string , `NetSuite_Sync_Time__c`  string , `Netsuite_Contract_ID__c`  string , `Next_Bill_Date__c`  string , `OrderId__c`  string , `Payment_Method__c`  string , `Status__c`  string , `Subsidiary__c`  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__cs/2026-04-05/1775390656'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_netsuite_contract__cs"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/netsuite_contract__cs/2026-04-05/1775390656
id: 1703686
processed: 1

raw_data:

{
    "Bill_Days_in_Advance__c": 12,
    "Billing_Day__c": 13,
    "Cancellation_Date__c": 14,
    "ConnectionReceivedId": 10,
    "ConnectionSentId": 11,
    "CreatedById": 6,
    "CreatedDate": 5,
    "CurrencyIsoCode": 4,
    "Customer_Name__c": 15,
    "Full_Annual_Value__c": 16,
    "Full_Monthly_Value__c": 17,
    "Full_NetSuite_Contract_Name__c": 18,
    "Full_Quarterly_Value__c": 19,
    "Full_Weekly_Value__c": 20,
    "Gross_Amount_Billed_to_Date__c": 21,
    "Id": 0,
    "IsDeleted": 2,
    "LastModifiedById": 8,
    "LastModifiedDate": 7,
    "Last_Billed_Date__c": 22,
    "Name": 3,
    "NetSuite_ID__c": 23,
    "NetSuite_Sync_Time__c": 24,
    "Netsuite_Contract_ID__c": 25,
    "Next_Bill_Date__c": 26,
    "OrderId__c": 27,
    "OwnerId": 1,
    "Payment_Method__c": 28,
    "Status__c": 29,
    "Subsidiary__c": 30,
    "SystemModstamp": 9
}

schema_attributes:

{
    "Bill_Days_in_Advance__c": "string",
    "Billing_Day__c": "string",
    "Cancellation_Date__c": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Customer_Name__c": "string",
    "Full_Annual_Value__c": "string",
    "Full_Monthly_Value__c": "string",
    "Full_NetSuite_Contract_Name__c": "string",
    "Full_Quarterly_Value__c": "string",
    "Full_Weekly_Value__c": "string",
    "Gross_Amount_Billed_to_Date__c": "string",
    "Id": "string",
    "IsDeleted": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Last_Billed_Date__c": "string",
    "Name": "string",
    "NetSuite_ID__c": "string",
    "NetSuite_Sync_Time__c": "string",
    "Netsuite_Contract_ID__c": "string",
    "Next_Bill_Date__c": "string",
    "OrderId__c": "string",
    "OwnerId": "string",
    "Payment_Method__c": "string",
    "Status__c": "string",
    "Subsidiary__c": "string",
    "SystemModstamp": "string"
}

schema_name_id: 1529
schema_scan_id: 161519967
updated: 2026-04-05 07:05:14

Version 1702540

created: 2026-04-04 07:07:32

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_netsuite_contract__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_netsuite_contract__cs`\n(\n `Id`  string , `OwnerId`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Bill_Days_in_Advance__c`  string , `Billing_Day__c`  string , `Cancellation_Date__c`  string , `Customer_Name__c`  string , `Full_Annual_Value__c`  string , `Full_Monthly_Value__c`  string , `Full_NetSuite_Contract_Name__c`  string , `Full_Quarterly_Value__c`  string , `Full_Weekly_Value__c`  string , `Gross_Amount_Billed_to_Date__c`  string , `Last_Billed_Date__c`  string , `NetSuite_ID__c`  string , `NetSuite_Sync_Time__c`  string , `Netsuite_Contract_ID__c`  string , `Next_Bill_Date__c`  string , `OrderId__c`  string , `Payment_Method__c`  string , `Status__c`  string , `Subsidiary__c`  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__cs/2026-04-04/1775304393'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_netsuite_contract__cs"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/netsuite_contract__cs/2026-04-04/1775304393
id: 1702540
processed: 1

raw_data:

{
    "Bill_Days_in_Advance__c": 12,
    "Billing_Day__c": 13,
    "Cancellation_Date__c": 14,
    "ConnectionReceivedId": 10,
    "ConnectionSentId": 11,
    "CreatedById": 6,
    "CreatedDate": 5,
    "CurrencyIsoCode": 4,
    "Customer_Name__c": 15,
    "Full_Annual_Value__c": 16,
    "Full_Monthly_Value__c": 17,
    "Full_NetSuite_Contract_Name__c": 18,
    "Full_Quarterly_Value__c": 19,
    "Full_Weekly_Value__c": 20,
    "Gross_Amount_Billed_to_Date__c": 21,
    "Id": 0,
    "IsDeleted": 2,
    "LastModifiedById": 8,
    "LastModifiedDate": 7,
    "Last_Billed_Date__c": 22,
    "Name": 3,
    "NetSuite_ID__c": 23,
    "NetSuite_Sync_Time__c": 24,
    "Netsuite_Contract_ID__c": 25,
    "Next_Bill_Date__c": 26,
    "OrderId__c": 27,
    "OwnerId": 1,
    "Payment_Method__c": 28,
    "Status__c": 29,
    "Subsidiary__c": 30,
    "SystemModstamp": 9
}

schema_attributes:

{
    "Bill_Days_in_Advance__c": "string",
    "Billing_Day__c": "string",
    "Cancellation_Date__c": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Customer_Name__c": "string",
    "Full_Annual_Value__c": "string",
    "Full_Monthly_Value__c": "string",
    "Full_NetSuite_Contract_Name__c": "string",
    "Full_Quarterly_Value__c": "string",
    "Full_Weekly_Value__c": "string",
    "Gross_Amount_Billed_to_Date__c": "string",
    "Id": "string",
    "IsDeleted": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Last_Billed_Date__c": "string",
    "Name": "string",
    "NetSuite_ID__c": "string",
    "NetSuite_Sync_Time__c": "string",
    "Netsuite_Contract_ID__c": "string",
    "Next_Bill_Date__c": "string",
    "OrderId__c": "string",
    "OwnerId": "string",
    "Payment_Method__c": "string",
    "Status__c": "string",
    "Subsidiary__c": "string",
    "SystemModstamp": "string"
}

schema_name_id: 1529
schema_scan_id: 161466411
updated: 2026-04-04 07:07:43

Version 1701369

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_netsuite_contract__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_netsuite_contract__cs`\n(\n `Id`  string , `OwnerId`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Bill_Days_in_Advance__c`  string , `Billing_Day__c`  string , `Cancellation_Date__c`  string , `Customer_Name__c`  string , `Full_Annual_Value__c`  string , `Full_Monthly_Value__c`  string , `Full_NetSuite_Contract_Name__c`  string , `Full_Quarterly_Value__c`  string , `Full_Weekly_Value__c`  string , `Gross_Amount_Billed_to_Date__c`  string , `Last_Billed_Date__c`  string , `NetSuite_ID__c`  string , `NetSuite_Sync_Time__c`  string , `Netsuite_Contract_ID__c`  string , `Next_Bill_Date__c`  string , `OrderId__c`  string , `Payment_Method__c`  string , `Status__c`  string , `Subsidiary__c`  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__cs/2026-04-03/1775217863'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_netsuite_contract__cs"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/netsuite_contract__cs/2026-04-03/1775217863
id: 1701369
processed: 1

raw_data:

{
    "Bill_Days_in_Advance__c": 12,
    "Billing_Day__c": 13,
    "Cancellation_Date__c": 14,
    "ConnectionReceivedId": 10,
    "ConnectionSentId": 11,
    "CreatedById": 6,
    "CreatedDate": 5,
    "CurrencyIsoCode": 4,
    "Customer_Name__c": 15,
    "Full_Annual_Value__c": 16,
    "Full_Monthly_Value__c": 17,
    "Full_NetSuite_Contract_Name__c": 18,
    "Full_Quarterly_Value__c": 19,
    "Full_Weekly_Value__c": 20,
    "Gross_Amount_Billed_to_Date__c": 21,
    "Id": 0,
    "IsDeleted": 2,
    "LastModifiedById": 8,
    "LastModifiedDate": 7,
    "Last_Billed_Date__c": 22,
    "Name": 3,
    "NetSuite_ID__c": 23,
    "NetSuite_Sync_Time__c": 24,
    "Netsuite_Contract_ID__c": 25,
    "Next_Bill_Date__c": 26,
    "OrderId__c": 27,
    "OwnerId": 1,
    "Payment_Method__c": 28,
    "Status__c": 29,
    "Subsidiary__c": 30,
    "SystemModstamp": 9
}

schema_attributes:

{
    "Bill_Days_in_Advance__c": "string",
    "Billing_Day__c": "string",
    "Cancellation_Date__c": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Customer_Name__c": "string",
    "Full_Annual_Value__c": "string",
    "Full_Monthly_Value__c": "string",
    "Full_NetSuite_Contract_Name__c": "string",
    "Full_Quarterly_Value__c": "string",
    "Full_Weekly_Value__c": "string",
    "Gross_Amount_Billed_to_Date__c": "string",
    "Id": "string",
    "IsDeleted": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Last_Billed_Date__c": "string",
    "Name": "string",
    "NetSuite_ID__c": "string",
    "NetSuite_Sync_Time__c": "string",
    "Netsuite_Contract_ID__c": "string",
    "Next_Bill_Date__c": "string",
    "OrderId__c": "string",
    "OwnerId": "string",
    "Payment_Method__c": "string",
    "Status__c": "string",
    "Subsidiary__c": "string",
    "SystemModstamp": "string"
}

schema_name_id: 1529
schema_scan_id: 161408577
updated: 2026-04-03 07:06:25

Schema Scans: 15

Last at 2026-04-17 07:06:50

Scan 162173070

duration: 0:00:14.944638

exit_message:

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

id: 162173070

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__cs/2026-04-17/1776427486",
        "key": "raw/netsuite_contract__cs/2026-04-17/1776427486/netsuite_contract__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_netsuite_contract__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 5812954672749425715,
        "service_name": "drive-thru",
        "span_id": 2772097488713656278,
        "trace_id": 5312723015222370024
    }
}

running: False
schema_name_id: 1529
start_time: 2026-04-17 07:06:50
success: True
trace_id: 5312723015222370024

Scan 162117355

duration: 0:00:12.631838

exit_message:

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

id: 162117355

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__cs/2026-04-16/1776341117",
        "key": "raw/netsuite_contract__cs/2026-04-16/1776341117/netsuite_contract__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_netsuite_contract__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 16058302716265881266,
        "service_name": "drive-thru",
        "span_id": 14838735502552188437,
        "trace_id": 16039067391262585540
    }
}

running: False
schema_name_id: 1529
start_time: 2026-04-16 07:07:01
success: True
trace_id: 16039067391262585540

Scan 162061830

duration: 0:00:15.006115

exit_message:

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

id: 162061830

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__cs/2026-04-15/1776254800",
        "key": "raw/netsuite_contract__cs/2026-04-15/1776254800/netsuite_contract__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_netsuite_contract__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 3662198168521181098,
        "service_name": "drive-thru",
        "span_id": 5027669171111322428,
        "trace_id": 9934218714367283368
    }
}

running: False
schema_name_id: 1529
start_time: 2026-04-15 07:11:46
success: True
trace_id: 9934218714367283368

Scan 162006418

duration: 0:00:12.376037

exit_message:

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

id: 162006418

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__cs/2026-04-14/1776168331",
        "key": "raw/netsuite_contract__cs/2026-04-14/1776168331/netsuite_contract__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_netsuite_contract__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 1483459151825370558,
        "service_name": "drive-thru",
        "span_id": 15886352166562861018,
        "trace_id": 1139356159078829524
    }
}

running: False
schema_name_id: 1529
start_time: 2026-04-14 07:07:40
success: True
trace_id: 1139356159078829524

Scan 161948349

duration: 0:00:12.372238

exit_message:

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

id: 161948349

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__cs/2026-04-13/1776081916",
        "key": "raw/netsuite_contract__cs/2026-04-13/1776081916/netsuite_contract__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_netsuite_contract__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 1203419029558450941,
        "service_name": "drive-thru",
        "span_id": 7015564268678642669,
        "trace_id": 7233423342884309501
    }
}

running: False
schema_name_id: 1529
start_time: 2026-04-13 07:07:44
success: True
trace_id: 7233423342884309501

Scan 161899527

duration: 0:00:12.389402

exit_message:

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

id: 161899527

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__cs/2026-04-12/1775995638",
        "key": "raw/netsuite_contract__cs/2026-04-12/1775995638/netsuite_contract__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_netsuite_contract__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 5264029252086690237,
        "service_name": "drive-thru",
        "span_id": 7072049053307435123,
        "trace_id": 11082571634612988805
    }
}

running: False
schema_name_id: 1529
start_time: 2026-04-12 07:07:22
success: True
trace_id: 11082571634612988805

Scan 161846886

duration: 0:00:15.072752

exit_message:

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

id: 161846886

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__cs/2026-04-11/1775909087",
        "key": "raw/netsuite_contract__cs/2026-04-11/1775909087/netsuite_contract__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_netsuite_contract__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 8787788104357157901,
        "service_name": "drive-thru",
        "span_id": 1181079425816809303,
        "trace_id": 7249569195617037881
    }
}

running: False
schema_name_id: 1529
start_time: 2026-04-11 07:07:45
success: True
trace_id: 7249569195617037881

Scan 161792064

duration: 0:00:12.448557

exit_message:

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

id: 161792064

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__cs/2026-04-10/1775822708",
        "key": "raw/netsuite_contract__cs/2026-04-10/1775822708/netsuite_contract__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_netsuite_contract__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 15338880384305141414,
        "service_name": "drive-thru",
        "span_id": 8696977933653128961,
        "trace_id": 15316607717037281581
    }
}

running: False
schema_name_id: 1529
start_time: 2026-04-10 07:05:59
success: True
trace_id: 15316607717037281581

Scan 161736232

duration: 0:00:15.054128

exit_message:

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

id: 161736232

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__cs/2026-04-09/1775736304",
        "key": "raw/netsuite_contract__cs/2026-04-09/1775736304/netsuite_contract__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_netsuite_contract__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 7655723447463563672,
        "service_name": "drive-thru",
        "span_id": 13781612922785392589,
        "trace_id": 16709118379751262964
    }
}

running: False
schema_name_id: 1529
start_time: 2026-04-09 07:05:32
success: True
trace_id: 16709118379751262964

Scan 161681408

duration: 0:00:12.798063

exit_message:

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

id: 161681408

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__cs/2026-04-08/1775649919",
        "key": "raw/netsuite_contract__cs/2026-04-08/1775649919/netsuite_contract__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_netsuite_contract__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 7492203330116677733,
        "service_name": "drive-thru",
        "span_id": 8337392168559477650,
        "trace_id": 8704983936502320807
    }
}

running: False
schema_name_id: 1529
start_time: 2026-04-08 07:06:59
success: True
trace_id: 8704983936502320807

Scan 161625175

duration: 0:00:12.480309

exit_message:

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

id: 161625175

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__cs/2026-04-07/1775563508",
        "key": "raw/netsuite_contract__cs/2026-04-07/1775563508/netsuite_contract__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_netsuite_contract__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 1803295600582773710,
        "service_name": "drive-thru",
        "span_id": 16848055390438711814,
        "trace_id": 14621493573035398068
    }
}

running: False
schema_name_id: 1529
start_time: 2026-04-07 07:06:06
success: True
trace_id: 14621493573035398068

Scan 161567366

duration: 0:00:12.417979

exit_message:

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

id: 161567366

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__cs/2026-04-06/1775477098",
        "key": "raw/netsuite_contract__cs/2026-04-06/1775477098/netsuite_contract__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_netsuite_contract__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 9118820389416676129,
        "service_name": "drive-thru",
        "span_id": 8189617126556721992,
        "trace_id": 12831557362608230100
    }
}

running: False
schema_name_id: 1529
start_time: 2026-04-06 07:11:20
success: True
trace_id: 12831557362608230100

Scan 161519967

duration: 0:00:14.976073

exit_message:

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

id: 161519967

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__cs/2026-04-05/1775390656",
        "key": "raw/netsuite_contract__cs/2026-04-05/1775390656/netsuite_contract__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_netsuite_contract__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 3941465502714608739,
        "service_name": "drive-thru",
        "span_id": 10915297940060130923,
        "trace_id": 18120634553998923257
    }
}

running: False
schema_name_id: 1529
start_time: 2026-04-05 07:04:59
success: True
trace_id: 18120634553998923257

Scan 161466411

duration: 0:00:12.501929

exit_message:

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

id: 161466411

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__cs/2026-04-04/1775304393",
        "key": "raw/netsuite_contract__cs/2026-04-04/1775304393/netsuite_contract__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_netsuite_contract__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 3011146571885663463,
        "service_name": "drive-thru",
        "span_id": 14726903772950649104,
        "trace_id": 9201554801507792713
    }
}

running: False
schema_name_id: 1529
start_time: 2026-04-04 07:07:30
success: True
trace_id: 9201554801507792713

Scan 161408577

duration: 0:00:14.971913

exit_message:

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

id: 161408577

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__cs/2026-04-03/1775217863",
        "key": "raw/netsuite_contract__cs/2026-04-03/1775217863/netsuite_contract__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_netsuite_contract__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 8177527570348352397,
        "service_name": "drive-thru",
        "span_id": 9243111915956515866,
        "trace_id": 7607682986762856544
    }
}

running: False
schema_name_id: 1529
start_time: 2026-04-03 07:06:10
success: True
trace_id: 7607682986762856544

Partitions:

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

Schema:

attributes:

{
    "Bill_Days_in_Advance__c": "string",
    "Billing_Day__c": "string",
    "Cancellation_Date__c": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Customer_Name__c": "string",
    "Full_Annual_Value__c": "string",
    "Full_Monthly_Value__c": "string",
    "Full_NetSuite_Contract_Name__c": "string",
    "Full_Quarterly_Value__c": "string",
    "Full_Weekly_Value__c": "string",
    "Gross_Amount_Billed_to_Date__c": "string",
    "Id": "string",
    "IsDeleted": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Last_Billed_Date__c": "string",
    "Name": "string",
    "NetSuite_ID__c": "string",
    "NetSuite_Sync_Time__c": "string",
    "Netsuite_Contract_ID__c": "string",
    "Next_Bill_Date__c": "string",
    "OrderId__c": "string",
    "OwnerId": "string",
    "Payment_Method__c": "string",
    "Status__c": "string",
    "Subsidiary__c": "string",
    "SystemModstamp": "string"
}

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

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__cs`\n(\n `Id`  string , `OwnerId`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Bill_Days_in_Advance__c`  string , `Billing_Day__c`  string , `Cancellation_Date__c`  string , `Customer_Name__c`  string , `Full_Annual_Value__c`  string , `Full_Monthly_Value__c`  string , `Full_NetSuite_Contract_Name__c`  string , `Full_Quarterly_Value__c`  string , `Full_Weekly_Value__c`  string , `Gross_Amount_Billed_to_Date__c`  string , `Last_Billed_Date__c`  string , `NetSuite_ID__c`  string , `NetSuite_Sync_Time__c`  string , `Netsuite_Contract_ID__c`  string , `Next_Bill_Date__c`  string , `OrderId__c`  string , `Payment_Method__c`  string , `Status__c`  string , `Subsidiary__c`  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__cs/2026-04-17/1776427486'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_netsuite_contract__cs`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_netsuite_contract__cs"
}

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:46:06",
        "disabled": false,
        "format": "raw",
        "id": 1529,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_csv",
            "table": "salesforce_netsuite_contract__cs"
        },
        "type": "csv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "Bill_Days_in_Advance__c": "string",
            "Billing_Day__c": "string",
            "Cancellation_Date__c": "string",
            "ConnectionReceivedId": "string",
            "ConnectionSentId": "string",
            "CreatedById": "string",
            "CreatedDate": "string",
            "CurrencyIsoCode": "string",
            "Customer_Name__c": "string",
            "Full_Annual_Value__c": "string",
            "Full_Monthly_Value__c": "string",
            "Full_NetSuite_Contract_Name__c": "string",
            "Full_Quarterly_Value__c": "string",
            "Full_Weekly_Value__c": "string",
            "Gross_Amount_Billed_to_Date__c": "string",
            "Id": "string",
            "IsDeleted": "string",
            "LastModifiedById": "string",
            "LastModifiedDate": "string",
            "Last_Billed_Date__c": "string",
            "Name": "string",
            "NetSuite_ID__c": "string",
            "NetSuite_Sync_Time__c": "string",
            "Netsuite_Contract_ID__c": "string",
            "Next_Bill_Date__c": "string",
            "OrderId__c": "string",
            "OwnerId": "string",
            "Payment_Method__c": "string",
            "Status__c": "string",
            "Subsidiary__c": "string",
            "SystemModstamp": "string"
        },
        "created": "2026-04-17 07:06:52",
        "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__cs`\n(\n `Id`  string , `OwnerId`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Bill_Days_in_Advance__c`  string , `Billing_Day__c`  string , `Cancellation_Date__c`  string , `Customer_Name__c`  string , `Full_Annual_Value__c`  string , `Full_Monthly_Value__c`  string , `Full_NetSuite_Contract_Name__c`  string , `Full_Quarterly_Value__c`  string , `Full_Weekly_Value__c`  string , `Gross_Amount_Billed_to_Date__c`  string , `Last_Billed_Date__c`  string , `NetSuite_ID__c`  string , `NetSuite_Sync_Time__c`  string , `Netsuite_Contract_ID__c`  string , `Next_Bill_Date__c`  string , `OrderId__c`  string , `Payment_Method__c`  string , `Status__c`  string , `Subsidiary__c`  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__cs/2026-04-17/1776427486'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_netsuite_contract__cs`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_netsuite_contract__cs"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}