Schema Info

Schema Name: sfdl_prod_csv.salesforce_rate_change__cs

created: 2022-10-10 16:22:43
disabled: False
format: raw
id: 1183
is_partitioned: False
is_schema_datatyped: True

name:

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

type: csv

Schema Versions: 15

Version 1718078

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_rate_change__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_rate_change__cs`\n(\n `Id`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `LastActivityDate`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Account__c`  string , `Asset__c`  string , `RatechangeEffectivedate__c`  string , `Type__c`  string , `Negotiatedrate__c`  string , `Priorrate__c`  string , `Proposedrate__c`  string , `GenerateBillingCases__c`  string , `Asset_MRR_Updated__c`  string , `Reschedule_MRR_Update__c`  string , `Number_of_Months__c`  string , `Custom_Contract__c`  string , `Negotiated_Rate_Adjustment__c`  string , `Product_Name__c`  string , `Proposed_Rate_Adjustment__c`  string , `Related_Rate_Increase__c`  string , `Contract_Product_Category__c`  string , `Billing_Cases_Created__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/rate_change__cs/2026-04-17/1776427498'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_rate_change__cs"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/rate_change__cs/2026-04-17/1776427498
id: 1718078
processed: 1

raw_data:

{
    "Account__c": 12,
    "Asset_MRR_Updated__c": 20,
    "Asset__c": 13,
    "Billing_Cases_Created__c": 29,
    "ConnectionReceivedId": 10,
    "ConnectionSentId": 11,
    "Contract_Product_Category__c": 28,
    "CreatedById": 5,
    "CreatedDate": 4,
    "CurrencyIsoCode": 3,
    "Custom_Contract__c": 23,
    "GenerateBillingCases__c": 19,
    "Id": 0,
    "IsDeleted": 1,
    "LastActivityDate": 9,
    "LastModifiedById": 7,
    "LastModifiedDate": 6,
    "Name": 2,
    "Negotiated_Rate_Adjustment__c": 24,
    "Negotiatedrate__c": 16,
    "Number_of_Months__c": 22,
    "Priorrate__c": 17,
    "Product_Name__c": 25,
    "Proposed_Rate_Adjustment__c": 26,
    "Proposedrate__c": 18,
    "RatechangeEffectivedate__c": 14,
    "Related_Rate_Increase__c": 27,
    "Reschedule_MRR_Update__c": 21,
    "SystemModstamp": 8,
    "Type__c": 15
}

schema_attributes:

{
    "Account__c": "string",
    "Amount": "string",
    "Asset_MRR_Updated__c": "string",
    "Asset__c": "string",
    "Billing_Cases_Created__c": "string",
    "CloseDate": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "Contract_Product_Category__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Custom_Contract__c": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "GenerateBillingCases__c": "string",
    "Id": "string",
    "IsDeleted": "string",
    "LastActivityDate": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Name": "string",
    "Negotiated_Rate_Adjustment__c": "string",
    "Negotiatedrate__c": "string",
    "Number_of_Months__c": "string",
    "OpportunityId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Priorrate__c": "string",
    "Probability": "string",
    "Product_Name__c": "string",
    "Proposed_Rate_Adjustment__c": "string",
    "Proposedrate__c": "string",
    "RatechangeEffectivedate__c": "string",
    "Related_Rate_Increase__c": "string",
    "Reschedule_MRR_Update__c": "string",
    "StageName": "string",
    "SystemModstamp": "string",
    "Type__c": "string"
}

schema_name_id: 1183
schema_scan_id: 162173044
updated: 2026-04-17 07:05:57

Version 1716852

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_rate_change__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_rate_change__cs`\n(\n `Id`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `LastActivityDate`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Account__c`  string , `Asset__c`  string , `RatechangeEffectivedate__c`  string , `Type__c`  string , `Negotiatedrate__c`  string , `Priorrate__c`  string , `Proposedrate__c`  string , `GenerateBillingCases__c`  string , `Asset_MRR_Updated__c`  string , `Reschedule_MRR_Update__c`  string , `Number_of_Months__c`  string , `Custom_Contract__c`  string , `Negotiated_Rate_Adjustment__c`  string , `Product_Name__c`  string , `Proposed_Rate_Adjustment__c`  string , `Related_Rate_Increase__c`  string , `Contract_Product_Category__c`  string , `Billing_Cases_Created__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/rate_change__cs/2026-04-16/1776341092'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_rate_change__cs"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/rate_change__cs/2026-04-16/1776341092
id: 1716852
processed: 1

raw_data:

{
    "Account__c": 12,
    "Asset_MRR_Updated__c": 20,
    "Asset__c": 13,
    "Billing_Cases_Created__c": 29,
    "ConnectionReceivedId": 10,
    "ConnectionSentId": 11,
    "Contract_Product_Category__c": 28,
    "CreatedById": 5,
    "CreatedDate": 4,
    "CurrencyIsoCode": 3,
    "Custom_Contract__c": 23,
    "GenerateBillingCases__c": 19,
    "Id": 0,
    "IsDeleted": 1,
    "LastActivityDate": 9,
    "LastModifiedById": 7,
    "LastModifiedDate": 6,
    "Name": 2,
    "Negotiated_Rate_Adjustment__c": 24,
    "Negotiatedrate__c": 16,
    "Number_of_Months__c": 22,
    "Priorrate__c": 17,
    "Product_Name__c": 25,
    "Proposed_Rate_Adjustment__c": 26,
    "Proposedrate__c": 18,
    "RatechangeEffectivedate__c": 14,
    "Related_Rate_Increase__c": 27,
    "Reschedule_MRR_Update__c": 21,
    "SystemModstamp": 8,
    "Type__c": 15
}

schema_attributes:

{
    "Account__c": "string",
    "Amount": "string",
    "Asset_MRR_Updated__c": "string",
    "Asset__c": "string",
    "Billing_Cases_Created__c": "string",
    "CloseDate": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "Contract_Product_Category__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Custom_Contract__c": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "GenerateBillingCases__c": "string",
    "Id": "string",
    "IsDeleted": "string",
    "LastActivityDate": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Name": "string",
    "Negotiated_Rate_Adjustment__c": "string",
    "Negotiatedrate__c": "string",
    "Number_of_Months__c": "string",
    "OpportunityId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Priorrate__c": "string",
    "Probability": "string",
    "Product_Name__c": "string",
    "Proposed_Rate_Adjustment__c": "string",
    "Proposedrate__c": "string",
    "RatechangeEffectivedate__c": "string",
    "Related_Rate_Increase__c": "string",
    "Reschedule_MRR_Update__c": "string",
    "StageName": "string",
    "SystemModstamp": "string",
    "Type__c": "string"
}

schema_name_id: 1183
schema_scan_id: 162117326
updated: 2026-04-16 07:06:18

Version 1715653

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_rate_change__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_rate_change__cs`\n(\n `Id`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `LastActivityDate`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Account__c`  string , `Asset__c`  string , `RatechangeEffectivedate__c`  string , `Type__c`  string , `Negotiatedrate__c`  string , `Priorrate__c`  string , `Proposedrate__c`  string , `GenerateBillingCases__c`  string , `Asset_MRR_Updated__c`  string , `Reschedule_MRR_Update__c`  string , `Number_of_Months__c`  string , `Custom_Contract__c`  string , `Negotiated_Rate_Adjustment__c`  string , `Product_Name__c`  string , `Proposed_Rate_Adjustment__c`  string , `Related_Rate_Increase__c`  string , `Contract_Product_Category__c`  string , `Billing_Cases_Created__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/rate_change__cs/2026-04-15/1776254793'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_rate_change__cs"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/rate_change__cs/2026-04-15/1776254793
id: 1715653
processed: 1

raw_data:

{
    "Account__c": 12,
    "Asset_MRR_Updated__c": 20,
    "Asset__c": 13,
    "Billing_Cases_Created__c": 29,
    "ConnectionReceivedId": 10,
    "ConnectionSentId": 11,
    "Contract_Product_Category__c": 28,
    "CreatedById": 5,
    "CreatedDate": 4,
    "CurrencyIsoCode": 3,
    "Custom_Contract__c": 23,
    "GenerateBillingCases__c": 19,
    "Id": 0,
    "IsDeleted": 1,
    "LastActivityDate": 9,
    "LastModifiedById": 7,
    "LastModifiedDate": 6,
    "Name": 2,
    "Negotiated_Rate_Adjustment__c": 24,
    "Negotiatedrate__c": 16,
    "Number_of_Months__c": 22,
    "Priorrate__c": 17,
    "Product_Name__c": 25,
    "Proposed_Rate_Adjustment__c": 26,
    "Proposedrate__c": 18,
    "RatechangeEffectivedate__c": 14,
    "Related_Rate_Increase__c": 27,
    "Reschedule_MRR_Update__c": 21,
    "SystemModstamp": 8,
    "Type__c": 15
}

schema_attributes:

{
    "Account__c": "string",
    "Amount": "string",
    "Asset_MRR_Updated__c": "string",
    "Asset__c": "string",
    "Billing_Cases_Created__c": "string",
    "CloseDate": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "Contract_Product_Category__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Custom_Contract__c": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "GenerateBillingCases__c": "string",
    "Id": "string",
    "IsDeleted": "string",
    "LastActivityDate": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Name": "string",
    "Negotiated_Rate_Adjustment__c": "string",
    "Negotiatedrate__c": "string",
    "Number_of_Months__c": "string",
    "OpportunityId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Priorrate__c": "string",
    "Probability": "string",
    "Product_Name__c": "string",
    "Proposed_Rate_Adjustment__c": "string",
    "Proposedrate__c": "string",
    "RatechangeEffectivedate__c": "string",
    "Related_Rate_Increase__c": "string",
    "Reschedule_MRR_Update__c": "string",
    "StageName": "string",
    "SystemModstamp": "string",
    "Type__c": "string"
}

schema_name_id: 1183
schema_scan_id: 162061792
updated: 2026-04-15 07:08:58

Version 1714451

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_rate_change__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_rate_change__cs`\n(\n `Id`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `LastActivityDate`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Account__c`  string , `Asset__c`  string , `RatechangeEffectivedate__c`  string , `Type__c`  string , `Negotiatedrate__c`  string , `Priorrate__c`  string , `Proposedrate__c`  string , `GenerateBillingCases__c`  string , `Asset_MRR_Updated__c`  string , `Reschedule_MRR_Update__c`  string , `Number_of_Months__c`  string , `Custom_Contract__c`  string , `Negotiated_Rate_Adjustment__c`  string , `Product_Name__c`  string , `Proposed_Rate_Adjustment__c`  string , `Related_Rate_Increase__c`  string , `Contract_Product_Category__c`  string , `Billing_Cases_Created__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/rate_change__cs/2026-04-14/1776168308'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_rate_change__cs"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/rate_change__cs/2026-04-14/1776168308
id: 1714451
processed: 1

raw_data:

{
    "Account__c": 12,
    "Asset_MRR_Updated__c": 20,
    "Asset__c": 13,
    "Billing_Cases_Created__c": 29,
    "ConnectionReceivedId": 10,
    "ConnectionSentId": 11,
    "Contract_Product_Category__c": 28,
    "CreatedById": 5,
    "CreatedDate": 4,
    "CurrencyIsoCode": 3,
    "Custom_Contract__c": 23,
    "GenerateBillingCases__c": 19,
    "Id": 0,
    "IsDeleted": 1,
    "LastActivityDate": 9,
    "LastModifiedById": 7,
    "LastModifiedDate": 6,
    "Name": 2,
    "Negotiated_Rate_Adjustment__c": 24,
    "Negotiatedrate__c": 16,
    "Number_of_Months__c": 22,
    "Priorrate__c": 17,
    "Product_Name__c": 25,
    "Proposed_Rate_Adjustment__c": 26,
    "Proposedrate__c": 18,
    "RatechangeEffectivedate__c": 14,
    "Related_Rate_Increase__c": 27,
    "Reschedule_MRR_Update__c": 21,
    "SystemModstamp": 8,
    "Type__c": 15
}

schema_attributes:

{
    "Account__c": "string",
    "Amount": "string",
    "Asset_MRR_Updated__c": "string",
    "Asset__c": "string",
    "Billing_Cases_Created__c": "string",
    "CloseDate": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "Contract_Product_Category__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Custom_Contract__c": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "GenerateBillingCases__c": "string",
    "Id": "string",
    "IsDeleted": "string",
    "LastActivityDate": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Name": "string",
    "Negotiated_Rate_Adjustment__c": "string",
    "Negotiatedrate__c": "string",
    "Number_of_Months__c": "string",
    "OpportunityId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Priorrate__c": "string",
    "Probability": "string",
    "Product_Name__c": "string",
    "Proposed_Rate_Adjustment__c": "string",
    "Proposedrate__c": "string",
    "RatechangeEffectivedate__c": "string",
    "Related_Rate_Increase__c": "string",
    "Reschedule_MRR_Update__c": "string",
    "StageName": "string",
    "SystemModstamp": "string",
    "Type__c": "string"
}

schema_name_id: 1183
schema_scan_id: 162006366
updated: 2026-04-14 07:06:09

Version 1713239

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_rate_change__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_rate_change__cs`\n(\n `Id`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `LastActivityDate`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Account__c`  string , `Asset__c`  string , `RatechangeEffectivedate__c`  string , `Type__c`  string , `Negotiatedrate__c`  string , `Priorrate__c`  string , `Proposedrate__c`  string , `GenerateBillingCases__c`  string , `Asset_MRR_Updated__c`  string , `Reschedule_MRR_Update__c`  string , `Number_of_Months__c`  string , `Custom_Contract__c`  string , `Negotiated_Rate_Adjustment__c`  string , `Product_Name__c`  string , `Proposed_Rate_Adjustment__c`  string , `Related_Rate_Increase__c`  string , `Contract_Product_Category__c`  string , `Billing_Cases_Created__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/rate_change__cs/2026-04-13/1776081934'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_rate_change__cs"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/rate_change__cs/2026-04-13/1776081934
id: 1713239
processed: 1

raw_data:

{
    "Account__c": 12,
    "Asset_MRR_Updated__c": 20,
    "Asset__c": 13,
    "Billing_Cases_Created__c": 29,
    "ConnectionReceivedId": 10,
    "ConnectionSentId": 11,
    "Contract_Product_Category__c": 28,
    "CreatedById": 5,
    "CreatedDate": 4,
    "CurrencyIsoCode": 3,
    "Custom_Contract__c": 23,
    "GenerateBillingCases__c": 19,
    "Id": 0,
    "IsDeleted": 1,
    "LastActivityDate": 9,
    "LastModifiedById": 7,
    "LastModifiedDate": 6,
    "Name": 2,
    "Negotiated_Rate_Adjustment__c": 24,
    "Negotiatedrate__c": 16,
    "Number_of_Months__c": 22,
    "Priorrate__c": 17,
    "Product_Name__c": 25,
    "Proposed_Rate_Adjustment__c": 26,
    "Proposedrate__c": 18,
    "RatechangeEffectivedate__c": 14,
    "Related_Rate_Increase__c": 27,
    "Reschedule_MRR_Update__c": 21,
    "SystemModstamp": 8,
    "Type__c": 15
}

schema_attributes:

{
    "Account__c": "string",
    "Amount": "string",
    "Asset_MRR_Updated__c": "string",
    "Asset__c": "string",
    "Billing_Cases_Created__c": "string",
    "CloseDate": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "Contract_Product_Category__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Custom_Contract__c": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "GenerateBillingCases__c": "string",
    "Id": "string",
    "IsDeleted": "string",
    "LastActivityDate": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Name": "string",
    "Negotiated_Rate_Adjustment__c": "string",
    "Negotiatedrate__c": "string",
    "Number_of_Months__c": "string",
    "OpportunityId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Priorrate__c": "string",
    "Probability": "string",
    "Product_Name__c": "string",
    "Proposed_Rate_Adjustment__c": "string",
    "Proposedrate__c": "string",
    "RatechangeEffectivedate__c": "string",
    "Related_Rate_Increase__c": "string",
    "Reschedule_MRR_Update__c": "string",
    "StageName": "string",
    "SystemModstamp": "string",
    "Type__c": "string"
}

schema_name_id: 1183
schema_scan_id: 161948318
updated: 2026-04-13 07:06:50

Version 1712038

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_rate_change__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_rate_change__cs`\n(\n `Id`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `LastActivityDate`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Account__c`  string , `Asset__c`  string , `RatechangeEffectivedate__c`  string , `Type__c`  string , `Negotiatedrate__c`  string , `Priorrate__c`  string , `Proposedrate__c`  string , `GenerateBillingCases__c`  string , `Asset_MRR_Updated__c`  string , `Reschedule_MRR_Update__c`  string , `Number_of_Months__c`  string , `Custom_Contract__c`  string , `Negotiated_Rate_Adjustment__c`  string , `Product_Name__c`  string , `Proposed_Rate_Adjustment__c`  string , `Related_Rate_Increase__c`  string , `Contract_Product_Category__c`  string , `Billing_Cases_Created__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/rate_change__cs/2026-04-12/1775995608'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_rate_change__cs"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/rate_change__cs/2026-04-12/1775995608
id: 1712038
processed: 1

raw_data:

{
    "Account__c": 12,
    "Asset_MRR_Updated__c": 20,
    "Asset__c": 13,
    "Billing_Cases_Created__c": 29,
    "ConnectionReceivedId": 10,
    "ConnectionSentId": 11,
    "Contract_Product_Category__c": 28,
    "CreatedById": 5,
    "CreatedDate": 4,
    "CurrencyIsoCode": 3,
    "Custom_Contract__c": 23,
    "GenerateBillingCases__c": 19,
    "Id": 0,
    "IsDeleted": 1,
    "LastActivityDate": 9,
    "LastModifiedById": 7,
    "LastModifiedDate": 6,
    "Name": 2,
    "Negotiated_Rate_Adjustment__c": 24,
    "Negotiatedrate__c": 16,
    "Number_of_Months__c": 22,
    "Priorrate__c": 17,
    "Product_Name__c": 25,
    "Proposed_Rate_Adjustment__c": 26,
    "Proposedrate__c": 18,
    "RatechangeEffectivedate__c": 14,
    "Related_Rate_Increase__c": 27,
    "Reschedule_MRR_Update__c": 21,
    "SystemModstamp": 8,
    "Type__c": 15
}

schema_attributes:

{
    "Account__c": "string",
    "Amount": "string",
    "Asset_MRR_Updated__c": "string",
    "Asset__c": "string",
    "Billing_Cases_Created__c": "string",
    "CloseDate": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "Contract_Product_Category__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Custom_Contract__c": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "GenerateBillingCases__c": "string",
    "Id": "string",
    "IsDeleted": "string",
    "LastActivityDate": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Name": "string",
    "Negotiated_Rate_Adjustment__c": "string",
    "Negotiatedrate__c": "string",
    "Number_of_Months__c": "string",
    "OpportunityId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Priorrate__c": "string",
    "Probability": "string",
    "Product_Name__c": "string",
    "Proposed_Rate_Adjustment__c": "string",
    "Proposedrate__c": "string",
    "RatechangeEffectivedate__c": "string",
    "Related_Rate_Increase__c": "string",
    "Reschedule_MRR_Update__c": "string",
    "StageName": "string",
    "SystemModstamp": "string",
    "Type__c": "string"
}

schema_name_id: 1183
schema_scan_id: 161899518
updated: 2026-04-12 07:07:12

Version 1710837

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_rate_change__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_rate_change__cs`\n(\n `Id`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `LastActivityDate`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Account__c`  string , `Asset__c`  string , `RatechangeEffectivedate__c`  string , `Type__c`  string , `Negotiatedrate__c`  string , `Priorrate__c`  string , `Proposedrate__c`  string , `GenerateBillingCases__c`  string , `Asset_MRR_Updated__c`  string , `Reschedule_MRR_Update__c`  string , `Number_of_Months__c`  string , `Custom_Contract__c`  string , `Negotiated_Rate_Adjustment__c`  string , `Product_Name__c`  string , `Proposed_Rate_Adjustment__c`  string , `Related_Rate_Increase__c`  string , `Contract_Product_Category__c`  string , `Billing_Cases_Created__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/rate_change__cs/2026-04-11/1775909052'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_rate_change__cs"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/rate_change__cs/2026-04-11/1775909052
id: 1710837
processed: 1

raw_data:

{
    "Account__c": 12,
    "Asset_MRR_Updated__c": 20,
    "Asset__c": 13,
    "Billing_Cases_Created__c": 29,
    "ConnectionReceivedId": 10,
    "ConnectionSentId": 11,
    "Contract_Product_Category__c": 28,
    "CreatedById": 5,
    "CreatedDate": 4,
    "CurrencyIsoCode": 3,
    "Custom_Contract__c": 23,
    "GenerateBillingCases__c": 19,
    "Id": 0,
    "IsDeleted": 1,
    "LastActivityDate": 9,
    "LastModifiedById": 7,
    "LastModifiedDate": 6,
    "Name": 2,
    "Negotiated_Rate_Adjustment__c": 24,
    "Negotiatedrate__c": 16,
    "Number_of_Months__c": 22,
    "Priorrate__c": 17,
    "Product_Name__c": 25,
    "Proposed_Rate_Adjustment__c": 26,
    "Proposedrate__c": 18,
    "RatechangeEffectivedate__c": 14,
    "Related_Rate_Increase__c": 27,
    "Reschedule_MRR_Update__c": 21,
    "SystemModstamp": 8,
    "Type__c": 15
}

schema_attributes:

{
    "Account__c": "string",
    "Amount": "string",
    "Asset_MRR_Updated__c": "string",
    "Asset__c": "string",
    "Billing_Cases_Created__c": "string",
    "CloseDate": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "Contract_Product_Category__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Custom_Contract__c": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "GenerateBillingCases__c": "string",
    "Id": "string",
    "IsDeleted": "string",
    "LastActivityDate": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Name": "string",
    "Negotiated_Rate_Adjustment__c": "string",
    "Negotiatedrate__c": "string",
    "Number_of_Months__c": "string",
    "OpportunityId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Priorrate__c": "string",
    "Probability": "string",
    "Product_Name__c": "string",
    "Proposed_Rate_Adjustment__c": "string",
    "Proposedrate__c": "string",
    "RatechangeEffectivedate__c": "string",
    "Related_Rate_Increase__c": "string",
    "Reschedule_MRR_Update__c": "string",
    "StageName": "string",
    "SystemModstamp": "string",
    "Type__c": "string"
}

schema_name_id: 1183
schema_scan_id: 161846845
updated: 2026-04-11 07:05:24

Version 1709671

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_rate_change__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_rate_change__cs`\n(\n `Id`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `LastActivityDate`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Account__c`  string , `Asset__c`  string , `RatechangeEffectivedate__c`  string , `Type__c`  string , `Negotiatedrate__c`  string , `Priorrate__c`  string , `Proposedrate__c`  string , `GenerateBillingCases__c`  string , `Asset_MRR_Updated__c`  string , `Reschedule_MRR_Update__c`  string , `Number_of_Months__c`  string , `Custom_Contract__c`  string , `Negotiated_Rate_Adjustment__c`  string , `Product_Name__c`  string , `Proposed_Rate_Adjustment__c`  string , `Related_Rate_Increase__c`  string , `Contract_Product_Category__c`  string , `Billing_Cases_Created__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/rate_change__cs/2026-04-10/1775822733'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_rate_change__cs"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/rate_change__cs/2026-04-10/1775822733
id: 1709671
processed: 1

raw_data:

{
    "Account__c": 12,
    "Asset_MRR_Updated__c": 20,
    "Asset__c": 13,
    "Billing_Cases_Created__c": 29,
    "ConnectionReceivedId": 10,
    "ConnectionSentId": 11,
    "Contract_Product_Category__c": 28,
    "CreatedById": 5,
    "CreatedDate": 4,
    "CurrencyIsoCode": 3,
    "Custom_Contract__c": 23,
    "GenerateBillingCases__c": 19,
    "Id": 0,
    "IsDeleted": 1,
    "LastActivityDate": 9,
    "LastModifiedById": 7,
    "LastModifiedDate": 6,
    "Name": 2,
    "Negotiated_Rate_Adjustment__c": 24,
    "Negotiatedrate__c": 16,
    "Number_of_Months__c": 22,
    "Priorrate__c": 17,
    "Product_Name__c": 25,
    "Proposed_Rate_Adjustment__c": 26,
    "Proposedrate__c": 18,
    "RatechangeEffectivedate__c": 14,
    "Related_Rate_Increase__c": 27,
    "Reschedule_MRR_Update__c": 21,
    "SystemModstamp": 8,
    "Type__c": 15
}

schema_attributes:

{
    "Account__c": "string",
    "Amount": "string",
    "Asset_MRR_Updated__c": "string",
    "Asset__c": "string",
    "Billing_Cases_Created__c": "string",
    "CloseDate": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "Contract_Product_Category__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Custom_Contract__c": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "GenerateBillingCases__c": "string",
    "Id": "string",
    "IsDeleted": "string",
    "LastActivityDate": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Name": "string",
    "Negotiated_Rate_Adjustment__c": "string",
    "Negotiatedrate__c": "string",
    "Number_of_Months__c": "string",
    "OpportunityId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Priorrate__c": "string",
    "Probability": "string",
    "Product_Name__c": "string",
    "Proposed_Rate_Adjustment__c": "string",
    "Proposedrate__c": "string",
    "RatechangeEffectivedate__c": "string",
    "Related_Rate_Increase__c": "string",
    "Reschedule_MRR_Update__c": "string",
    "StageName": "string",
    "SystemModstamp": "string",
    "Type__c": "string"
}

schema_name_id: 1183
schema_scan_id: 161792070
updated: 2026-04-10 07:06:33

Version 1708516

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_rate_change__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_rate_change__cs`\n(\n `Id`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `LastActivityDate`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Account__c`  string , `Asset__c`  string , `RatechangeEffectivedate__c`  string , `Type__c`  string , `Negotiatedrate__c`  string , `Priorrate__c`  string , `Proposedrate__c`  string , `GenerateBillingCases__c`  string , `Asset_MRR_Updated__c`  string , `Reschedule_MRR_Update__c`  string , `Number_of_Months__c`  string , `Custom_Contract__c`  string , `Negotiated_Rate_Adjustment__c`  string , `Product_Name__c`  string , `Proposed_Rate_Adjustment__c`  string , `Related_Rate_Increase__c`  string , `Contract_Product_Category__c`  string , `Billing_Cases_Created__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/rate_change__cs/2026-04-09/1775736311'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_rate_change__cs"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/rate_change__cs/2026-04-09/1775736311
id: 1708516
processed: 1

raw_data:

{
    "Account__c": 12,
    "Asset_MRR_Updated__c": 20,
    "Asset__c": 13,
    "Billing_Cases_Created__c": 29,
    "ConnectionReceivedId": 10,
    "ConnectionSentId": 11,
    "Contract_Product_Category__c": 28,
    "CreatedById": 5,
    "CreatedDate": 4,
    "CurrencyIsoCode": 3,
    "Custom_Contract__c": 23,
    "GenerateBillingCases__c": 19,
    "Id": 0,
    "IsDeleted": 1,
    "LastActivityDate": 9,
    "LastModifiedById": 7,
    "LastModifiedDate": 6,
    "Name": 2,
    "Negotiated_Rate_Adjustment__c": 24,
    "Negotiatedrate__c": 16,
    "Number_of_Months__c": 22,
    "Priorrate__c": 17,
    "Product_Name__c": 25,
    "Proposed_Rate_Adjustment__c": 26,
    "Proposedrate__c": 18,
    "RatechangeEffectivedate__c": 14,
    "Related_Rate_Increase__c": 27,
    "Reschedule_MRR_Update__c": 21,
    "SystemModstamp": 8,
    "Type__c": 15
}

schema_attributes:

{
    "Account__c": "string",
    "Amount": "string",
    "Asset_MRR_Updated__c": "string",
    "Asset__c": "string",
    "Billing_Cases_Created__c": "string",
    "CloseDate": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "Contract_Product_Category__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Custom_Contract__c": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "GenerateBillingCases__c": "string",
    "Id": "string",
    "IsDeleted": "string",
    "LastActivityDate": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Name": "string",
    "Negotiated_Rate_Adjustment__c": "string",
    "Negotiatedrate__c": "string",
    "Number_of_Months__c": "string",
    "OpportunityId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Priorrate__c": "string",
    "Probability": "string",
    "Product_Name__c": "string",
    "Proposed_Rate_Adjustment__c": "string",
    "Proposedrate__c": "string",
    "RatechangeEffectivedate__c": "string",
    "Related_Rate_Increase__c": "string",
    "Reschedule_MRR_Update__c": "string",
    "StageName": "string",
    "SystemModstamp": "string",
    "Type__c": "string"
}

schema_name_id: 1183
schema_scan_id: 161736247
updated: 2026-04-09 07:06:19

Version 1707316

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_rate_change__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_rate_change__cs`\n(\n `Id`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `LastActivityDate`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Account__c`  string , `Asset__c`  string , `RatechangeEffectivedate__c`  string , `Type__c`  string , `Negotiatedrate__c`  string , `Priorrate__c`  string , `Proposedrate__c`  string , `GenerateBillingCases__c`  string , `Asset_MRR_Updated__c`  string , `Reschedule_MRR_Update__c`  string , `Number_of_Months__c`  string , `Custom_Contract__c`  string , `Negotiated_Rate_Adjustment__c`  string , `Product_Name__c`  string , `Proposed_Rate_Adjustment__c`  string , `Related_Rate_Increase__c`  string , `Contract_Product_Category__c`  string , `Billing_Cases_Created__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/rate_change__cs/2026-04-08/1775649894'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_rate_change__cs"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/rate_change__cs/2026-04-08/1775649894
id: 1707316
processed: 1

raw_data:

{
    "Account__c": 12,
    "Asset_MRR_Updated__c": 20,
    "Asset__c": 13,
    "Billing_Cases_Created__c": 29,
    "ConnectionReceivedId": 10,
    "ConnectionSentId": 11,
    "Contract_Product_Category__c": 28,
    "CreatedById": 5,
    "CreatedDate": 4,
    "CurrencyIsoCode": 3,
    "Custom_Contract__c": 23,
    "GenerateBillingCases__c": 19,
    "Id": 0,
    "IsDeleted": 1,
    "LastActivityDate": 9,
    "LastModifiedById": 7,
    "LastModifiedDate": 6,
    "Name": 2,
    "Negotiated_Rate_Adjustment__c": 24,
    "Negotiatedrate__c": 16,
    "Number_of_Months__c": 22,
    "Priorrate__c": 17,
    "Product_Name__c": 25,
    "Proposed_Rate_Adjustment__c": 26,
    "Proposedrate__c": 18,
    "RatechangeEffectivedate__c": 14,
    "Related_Rate_Increase__c": 27,
    "Reschedule_MRR_Update__c": 21,
    "SystemModstamp": 8,
    "Type__c": 15
}

schema_attributes:

{
    "Account__c": "string",
    "Amount": "string",
    "Asset_MRR_Updated__c": "string",
    "Asset__c": "string",
    "Billing_Cases_Created__c": "string",
    "CloseDate": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "Contract_Product_Category__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Custom_Contract__c": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "GenerateBillingCases__c": "string",
    "Id": "string",
    "IsDeleted": "string",
    "LastActivityDate": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Name": "string",
    "Negotiated_Rate_Adjustment__c": "string",
    "Negotiatedrate__c": "string",
    "Number_of_Months__c": "string",
    "OpportunityId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Priorrate__c": "string",
    "Probability": "string",
    "Product_Name__c": "string",
    "Proposed_Rate_Adjustment__c": "string",
    "Proposedrate__c": "string",
    "RatechangeEffectivedate__c": "string",
    "Related_Rate_Increase__c": "string",
    "Reschedule_MRR_Update__c": "string",
    "StageName": "string",
    "SystemModstamp": "string",
    "Type__c": "string"
}

schema_name_id: 1183
schema_scan_id: 161681369
updated: 2026-04-08 07:05:46

Version 1706124

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_rate_change__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_rate_change__cs`\n(\n `Id`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `LastActivityDate`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Account__c`  string , `Asset__c`  string , `RatechangeEffectivedate__c`  string , `Type__c`  string , `Negotiatedrate__c`  string , `Priorrate__c`  string , `Proposedrate__c`  string , `GenerateBillingCases__c`  string , `Asset_MRR_Updated__c`  string , `Reschedule_MRR_Update__c`  string , `Number_of_Months__c`  string , `Custom_Contract__c`  string , `Negotiated_Rate_Adjustment__c`  string , `Product_Name__c`  string , `Proposed_Rate_Adjustment__c`  string , `Related_Rate_Increase__c`  string , `Contract_Product_Category__c`  string , `Billing_Cases_Created__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/rate_change__cs/2026-04-07/1775563497'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_rate_change__cs"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/rate_change__cs/2026-04-07/1775563497
id: 1706124
processed: 1

raw_data:

{
    "Account__c": 12,
    "Asset_MRR_Updated__c": 20,
    "Asset__c": 13,
    "Billing_Cases_Created__c": 29,
    "ConnectionReceivedId": 10,
    "ConnectionSentId": 11,
    "Contract_Product_Category__c": 28,
    "CreatedById": 5,
    "CreatedDate": 4,
    "CurrencyIsoCode": 3,
    "Custom_Contract__c": 23,
    "GenerateBillingCases__c": 19,
    "Id": 0,
    "IsDeleted": 1,
    "LastActivityDate": 9,
    "LastModifiedById": 7,
    "LastModifiedDate": 6,
    "Name": 2,
    "Negotiated_Rate_Adjustment__c": 24,
    "Negotiatedrate__c": 16,
    "Number_of_Months__c": 22,
    "Priorrate__c": 17,
    "Product_Name__c": 25,
    "Proposed_Rate_Adjustment__c": 26,
    "Proposedrate__c": 18,
    "RatechangeEffectivedate__c": 14,
    "Related_Rate_Increase__c": 27,
    "Reschedule_MRR_Update__c": 21,
    "SystemModstamp": 8,
    "Type__c": 15
}

schema_attributes:

{
    "Account__c": "string",
    "Amount": "string",
    "Asset_MRR_Updated__c": "string",
    "Asset__c": "string",
    "Billing_Cases_Created__c": "string",
    "CloseDate": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "Contract_Product_Category__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Custom_Contract__c": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "GenerateBillingCases__c": "string",
    "Id": "string",
    "IsDeleted": "string",
    "LastActivityDate": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Name": "string",
    "Negotiated_Rate_Adjustment__c": "string",
    "Negotiatedrate__c": "string",
    "Number_of_Months__c": "string",
    "OpportunityId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Priorrate__c": "string",
    "Probability": "string",
    "Product_Name__c": "string",
    "Proposed_Rate_Adjustment__c": "string",
    "Proposedrate__c": "string",
    "RatechangeEffectivedate__c": "string",
    "Related_Rate_Increase__c": "string",
    "Reschedule_MRR_Update__c": "string",
    "StageName": "string",
    "SystemModstamp": "string",
    "Type__c": "string"
}

schema_name_id: 1183
schema_scan_id: 161625161
updated: 2026-04-07 07:05:37

Version 1704952

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_rate_change__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_rate_change__cs`\n(\n `Id`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `LastActivityDate`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Account__c`  string , `Asset__c`  string , `RatechangeEffectivedate__c`  string , `Type__c`  string , `Negotiatedrate__c`  string , `Priorrate__c`  string , `Proposedrate__c`  string , `GenerateBillingCases__c`  string , `Asset_MRR_Updated__c`  string , `Reschedule_MRR_Update__c`  string , `Number_of_Months__c`  string , `Custom_Contract__c`  string , `Negotiated_Rate_Adjustment__c`  string , `Product_Name__c`  string , `Proposed_Rate_Adjustment__c`  string , `Related_Rate_Increase__c`  string , `Contract_Product_Category__c`  string , `Billing_Cases_Created__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/rate_change__cs/2026-04-06/1775477103'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_rate_change__cs"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/rate_change__cs/2026-04-06/1775477103
id: 1704952
processed: 1

raw_data:

{
    "Account__c": 12,
    "Asset_MRR_Updated__c": 20,
    "Asset__c": 13,
    "Billing_Cases_Created__c": 29,
    "ConnectionReceivedId": 10,
    "ConnectionSentId": 11,
    "Contract_Product_Category__c": 28,
    "CreatedById": 5,
    "CreatedDate": 4,
    "CurrencyIsoCode": 3,
    "Custom_Contract__c": 23,
    "GenerateBillingCases__c": 19,
    "Id": 0,
    "IsDeleted": 1,
    "LastActivityDate": 9,
    "LastModifiedById": 7,
    "LastModifiedDate": 6,
    "Name": 2,
    "Negotiated_Rate_Adjustment__c": 24,
    "Negotiatedrate__c": 16,
    "Number_of_Months__c": 22,
    "Priorrate__c": 17,
    "Product_Name__c": 25,
    "Proposed_Rate_Adjustment__c": 26,
    "Proposedrate__c": 18,
    "RatechangeEffectivedate__c": 14,
    "Related_Rate_Increase__c": 27,
    "Reschedule_MRR_Update__c": 21,
    "SystemModstamp": 8,
    "Type__c": 15
}

schema_attributes:

{
    "Account__c": "string",
    "Amount": "string",
    "Asset_MRR_Updated__c": "string",
    "Asset__c": "string",
    "Billing_Cases_Created__c": "string",
    "CloseDate": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "Contract_Product_Category__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Custom_Contract__c": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "GenerateBillingCases__c": "string",
    "Id": "string",
    "IsDeleted": "string",
    "LastActivityDate": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Name": "string",
    "Negotiated_Rate_Adjustment__c": "string",
    "Negotiatedrate__c": "string",
    "Number_of_Months__c": "string",
    "OpportunityId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Priorrate__c": "string",
    "Probability": "string",
    "Product_Name__c": "string",
    "Proposed_Rate_Adjustment__c": "string",
    "Proposedrate__c": "string",
    "RatechangeEffectivedate__c": "string",
    "Related_Rate_Increase__c": "string",
    "Reschedule_MRR_Update__c": "string",
    "StageName": "string",
    "SystemModstamp": "string",
    "Type__c": "string"
}

schema_name_id: 1183
schema_scan_id: 161567367
updated: 2026-04-06 07:11:34

Version 1703674

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_rate_change__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_rate_change__cs`\n(\n `Id`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `LastActivityDate`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Account__c`  string , `Asset__c`  string , `RatechangeEffectivedate__c`  string , `Type__c`  string , `Negotiatedrate__c`  string , `Priorrate__c`  string , `Proposedrate__c`  string , `GenerateBillingCases__c`  string , `Asset_MRR_Updated__c`  string , `Reschedule_MRR_Update__c`  string , `Number_of_Months__c`  string , `Custom_Contract__c`  string , `Negotiated_Rate_Adjustment__c`  string , `Product_Name__c`  string , `Proposed_Rate_Adjustment__c`  string , `Related_Rate_Increase__c`  string , `Contract_Product_Category__c`  string , `Billing_Cases_Created__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/rate_change__cs/2026-04-05/1775390648'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_rate_change__cs"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/rate_change__cs/2026-04-05/1775390648
id: 1703674
processed: 1

raw_data:

{
    "Account__c": 12,
    "Asset_MRR_Updated__c": 20,
    "Asset__c": 13,
    "Billing_Cases_Created__c": 29,
    "ConnectionReceivedId": 10,
    "ConnectionSentId": 11,
    "Contract_Product_Category__c": 28,
    "CreatedById": 5,
    "CreatedDate": 4,
    "CurrencyIsoCode": 3,
    "Custom_Contract__c": 23,
    "GenerateBillingCases__c": 19,
    "Id": 0,
    "IsDeleted": 1,
    "LastActivityDate": 9,
    "LastModifiedById": 7,
    "LastModifiedDate": 6,
    "Name": 2,
    "Negotiated_Rate_Adjustment__c": 24,
    "Negotiatedrate__c": 16,
    "Number_of_Months__c": 22,
    "Priorrate__c": 17,
    "Product_Name__c": 25,
    "Proposed_Rate_Adjustment__c": 26,
    "Proposedrate__c": 18,
    "RatechangeEffectivedate__c": 14,
    "Related_Rate_Increase__c": 27,
    "Reschedule_MRR_Update__c": 21,
    "SystemModstamp": 8,
    "Type__c": 15
}

schema_attributes:

{
    "Account__c": "string",
    "Amount": "string",
    "Asset_MRR_Updated__c": "string",
    "Asset__c": "string",
    "Billing_Cases_Created__c": "string",
    "CloseDate": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "Contract_Product_Category__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Custom_Contract__c": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "GenerateBillingCases__c": "string",
    "Id": "string",
    "IsDeleted": "string",
    "LastActivityDate": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Name": "string",
    "Negotiated_Rate_Adjustment__c": "string",
    "Negotiatedrate__c": "string",
    "Number_of_Months__c": "string",
    "OpportunityId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Priorrate__c": "string",
    "Probability": "string",
    "Product_Name__c": "string",
    "Proposed_Rate_Adjustment__c": "string",
    "Proposedrate__c": "string",
    "RatechangeEffectivedate__c": "string",
    "Related_Rate_Increase__c": "string",
    "Reschedule_MRR_Update__c": "string",
    "StageName": "string",
    "SystemModstamp": "string",
    "Type__c": "string"
}

schema_name_id: 1183
schema_scan_id: 161519953
updated: 2026-04-05 07:04:29

Version 1702544

created: 2026-04-04 07:07:44

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_rate_change__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_rate_change__cs`\n(\n `Id`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `LastActivityDate`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Account__c`  string , `Asset__c`  string , `RatechangeEffectivedate__c`  string , `Type__c`  string , `Negotiatedrate__c`  string , `Priorrate__c`  string , `Proposedrate__c`  string , `GenerateBillingCases__c`  string , `Asset_MRR_Updated__c`  string , `Reschedule_MRR_Update__c`  string , `Number_of_Months__c`  string , `Custom_Contract__c`  string , `Negotiated_Rate_Adjustment__c`  string , `Product_Name__c`  string , `Proposed_Rate_Adjustment__c`  string , `Related_Rate_Increase__c`  string , `Contract_Product_Category__c`  string , `Billing_Cases_Created__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/rate_change__cs/2026-04-04/1775304406'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_rate_change__cs"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/rate_change__cs/2026-04-04/1775304406
id: 1702544
processed: 1

raw_data:

{
    "Account__c": 12,
    "Asset_MRR_Updated__c": 20,
    "Asset__c": 13,
    "Billing_Cases_Created__c": 29,
    "ConnectionReceivedId": 10,
    "ConnectionSentId": 11,
    "Contract_Product_Category__c": 28,
    "CreatedById": 5,
    "CreatedDate": 4,
    "CurrencyIsoCode": 3,
    "Custom_Contract__c": 23,
    "GenerateBillingCases__c": 19,
    "Id": 0,
    "IsDeleted": 1,
    "LastActivityDate": 9,
    "LastModifiedById": 7,
    "LastModifiedDate": 6,
    "Name": 2,
    "Negotiated_Rate_Adjustment__c": 24,
    "Negotiatedrate__c": 16,
    "Number_of_Months__c": 22,
    "Priorrate__c": 17,
    "Product_Name__c": 25,
    "Proposed_Rate_Adjustment__c": 26,
    "Proposedrate__c": 18,
    "RatechangeEffectivedate__c": 14,
    "Related_Rate_Increase__c": 27,
    "Reschedule_MRR_Update__c": 21,
    "SystemModstamp": 8,
    "Type__c": 15
}

schema_attributes:

{
    "Account__c": "string",
    "Amount": "string",
    "Asset_MRR_Updated__c": "string",
    "Asset__c": "string",
    "Billing_Cases_Created__c": "string",
    "CloseDate": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "Contract_Product_Category__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Custom_Contract__c": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "GenerateBillingCases__c": "string",
    "Id": "string",
    "IsDeleted": "string",
    "LastActivityDate": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Name": "string",
    "Negotiated_Rate_Adjustment__c": "string",
    "Negotiatedrate__c": "string",
    "Number_of_Months__c": "string",
    "OpportunityId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Priorrate__c": "string",
    "Probability": "string",
    "Product_Name__c": "string",
    "Proposed_Rate_Adjustment__c": "string",
    "Proposedrate__c": "string",
    "RatechangeEffectivedate__c": "string",
    "Related_Rate_Increase__c": "string",
    "Reschedule_MRR_Update__c": "string",
    "StageName": "string",
    "SystemModstamp": "string",
    "Type__c": "string"
}

schema_name_id: 1183
schema_scan_id: 161466414
updated: 2026-04-04 07:07:58

Version 1701356

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_rate_change__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_rate_change__cs`\n(\n `Id`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `LastActivityDate`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Account__c`  string , `Asset__c`  string , `RatechangeEffectivedate__c`  string , `Type__c`  string , `Negotiatedrate__c`  string , `Priorrate__c`  string , `Proposedrate__c`  string , `GenerateBillingCases__c`  string , `Asset_MRR_Updated__c`  string , `Reschedule_MRR_Update__c`  string , `Number_of_Months__c`  string , `Custom_Contract__c`  string , `Negotiated_Rate_Adjustment__c`  string , `Product_Name__c`  string , `Proposed_Rate_Adjustment__c`  string , `Related_Rate_Increase__c`  string , `Contract_Product_Category__c`  string , `Billing_Cases_Created__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/rate_change__cs/2026-04-03/1775217851'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_rate_change__cs"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/rate_change__cs/2026-04-03/1775217851
id: 1701356
processed: 1

raw_data:

{
    "Account__c": 12,
    "Asset_MRR_Updated__c": 20,
    "Asset__c": 13,
    "Billing_Cases_Created__c": 29,
    "ConnectionReceivedId": 10,
    "ConnectionSentId": 11,
    "Contract_Product_Category__c": 28,
    "CreatedById": 5,
    "CreatedDate": 4,
    "CurrencyIsoCode": 3,
    "Custom_Contract__c": 23,
    "GenerateBillingCases__c": 19,
    "Id": 0,
    "IsDeleted": 1,
    "LastActivityDate": 9,
    "LastModifiedById": 7,
    "LastModifiedDate": 6,
    "Name": 2,
    "Negotiated_Rate_Adjustment__c": 24,
    "Negotiatedrate__c": 16,
    "Number_of_Months__c": 22,
    "Priorrate__c": 17,
    "Product_Name__c": 25,
    "Proposed_Rate_Adjustment__c": 26,
    "Proposedrate__c": 18,
    "RatechangeEffectivedate__c": 14,
    "Related_Rate_Increase__c": 27,
    "Reschedule_MRR_Update__c": 21,
    "SystemModstamp": 8,
    "Type__c": 15
}

schema_attributes:

{
    "Account__c": "string",
    "Amount": "string",
    "Asset_MRR_Updated__c": "string",
    "Asset__c": "string",
    "Billing_Cases_Created__c": "string",
    "CloseDate": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "Contract_Product_Category__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Custom_Contract__c": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "GenerateBillingCases__c": "string",
    "Id": "string",
    "IsDeleted": "string",
    "LastActivityDate": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Name": "string",
    "Negotiated_Rate_Adjustment__c": "string",
    "Negotiatedrate__c": "string",
    "Number_of_Months__c": "string",
    "OpportunityId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Priorrate__c": "string",
    "Probability": "string",
    "Product_Name__c": "string",
    "Proposed_Rate_Adjustment__c": "string",
    "Proposedrate__c": "string",
    "RatechangeEffectivedate__c": "string",
    "Related_Rate_Increase__c": "string",
    "Reschedule_MRR_Update__c": "string",
    "StageName": "string",
    "SystemModstamp": "string",
    "Type__c": "string"
}

schema_name_id: 1183
schema_scan_id: 161408562
updated: 2026-04-03 07:05:45

Schema Scans: 15

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

Scan 162173044

duration: 0:00:12.537743

exit_message:

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

id: 162173044

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/rate_change__cs/2026-04-17/1776427498",
        "key": "raw/rate_change__cs/2026-04-17/1776427498/rate_change__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_rate_change__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 8842335041789475097,
        "service_name": "drive-thru",
        "span_id": 7961699339256335264,
        "trace_id": 6091516654789716407
    }
}

running: False
schema_name_id: 1183
start_time: 2026-04-17 07:05:44
success: True
trace_id: 6091516654789716407

Scan 162117326

duration: 0:00:15.204145

exit_message:

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

id: 162117326

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/rate_change__cs/2026-04-16/1776341092",
        "key": "raw/rate_change__cs/2026-04-16/1776341092/rate_change__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_rate_change__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 4219939807047035352,
        "service_name": "drive-thru",
        "span_id": 13493250876867437229,
        "trace_id": 10245290200867218818
    }
}

running: False
schema_name_id: 1183
start_time: 2026-04-16 07:06:03
success: True
trace_id: 10245290200867218818

Scan 162061792

duration: 0:00:12.612530

exit_message:

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

id: 162061792

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/rate_change__cs/2026-04-15/1776254793",
        "key": "raw/rate_change__cs/2026-04-15/1776254793/rate_change__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_rate_change__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 796637774647927693,
        "service_name": "drive-thru",
        "span_id": 16627368712409429827,
        "trace_id": 14073096981886089163
    }
}

running: False
schema_name_id: 1183
start_time: 2026-04-15 07:08:46
success: True
trace_id: 14073096981886089163

Scan 162006366

duration: 0:00:15.242987

exit_message:

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

id: 162006366

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/rate_change__cs/2026-04-14/1776168308",
        "key": "raw/rate_change__cs/2026-04-14/1776168308/rate_change__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_rate_change__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 16269240788094417683,
        "service_name": "drive-thru",
        "span_id": 14770215202756488665,
        "trace_id": 15189123752255504509
    }
}

running: False
schema_name_id: 1183
start_time: 2026-04-14 07:05:54
success: True
trace_id: 15189123752255504509

Scan 161948318

duration: 0:00:15.065878

exit_message:

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

id: 161948318

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/rate_change__cs/2026-04-13/1776081934",
        "key": "raw/rate_change__cs/2026-04-13/1776081934/rate_change__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_rate_change__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 3684664574088707029,
        "service_name": "drive-thru",
        "span_id": 3853065038315203956,
        "trace_id": 12690418442954228405
    }
}

running: False
schema_name_id: 1183
start_time: 2026-04-13 07:06:35
success: True
trace_id: 12690418442954228405

Scan 161899518

duration: 0:00:15.068202

exit_message:

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

id: 161899518

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/rate_change__cs/2026-04-12/1775995608",
        "key": "raw/rate_change__cs/2026-04-12/1775995608/rate_change__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_rate_change__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 17555958463715291937,
        "service_name": "drive-thru",
        "span_id": 11735080389861586291,
        "trace_id": 18008640477750392991
    }
}

running: False
schema_name_id: 1183
start_time: 2026-04-12 07:06:57
success: True
trace_id: 18008640477750392991

Scan 161846845

duration: 0:00:15.019090

exit_message:

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

id: 161846845

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/rate_change__cs/2026-04-11/1775909052",
        "key": "raw/rate_change__cs/2026-04-11/1775909052/rate_change__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_rate_change__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 17867669818470932258,
        "service_name": "drive-thru",
        "span_id": 14107724143857719254,
        "trace_id": 15716487669397911230
    }
}

running: False
schema_name_id: 1183
start_time: 2026-04-11 07:05:09
success: True
trace_id: 15716487669397911230

Scan 161792070

duration: 0:00:15.288378

exit_message:

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

id: 161792070

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/rate_change__cs/2026-04-10/1775822733",
        "key": "raw/rate_change__cs/2026-04-10/1775822733/rate_change__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_rate_change__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 14835093099079659050,
        "service_name": "drive-thru",
        "span_id": 14644009644680941992,
        "trace_id": 14264095144203943596
    }
}

running: False
schema_name_id: 1183
start_time: 2026-04-10 07:06:18
success: True
trace_id: 14264095144203943596

Scan 161736247

duration: 0:00:14.969378

exit_message:

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

id: 161736247

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/rate_change__cs/2026-04-09/1775736311",
        "key": "raw/rate_change__cs/2026-04-09/1775736311/rate_change__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_rate_change__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 8382037665815546564,
        "service_name": "drive-thru",
        "span_id": 11255878964523338339,
        "trace_id": 18086268237706104461
    }
}

running: False
schema_name_id: 1183
start_time: 2026-04-09 07:06:04
success: True
trace_id: 18086268237706104461

Scan 161681369

duration: 0:00:15.162216

exit_message:

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

id: 161681369

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/rate_change__cs/2026-04-08/1775649894",
        "key": "raw/rate_change__cs/2026-04-08/1775649894/rate_change__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_rate_change__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 11424486152202539155,
        "service_name": "drive-thru",
        "span_id": 3602176070618695898,
        "trace_id": 3292595903970638616
    }
}

running: False
schema_name_id: 1183
start_time: 2026-04-08 07:05:31
success: True
trace_id: 3292595903970638616

Scan 161625161

duration: 0:00:15.072040

exit_message:

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

id: 161625161

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/rate_change__cs/2026-04-07/1775563497",
        "key": "raw/rate_change__cs/2026-04-07/1775563497/rate_change__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_rate_change__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 15120496277401322787,
        "service_name": "drive-thru",
        "span_id": 18133776381276567656,
        "trace_id": 16415529456076517025
    }
}

running: False
schema_name_id: 1183
start_time: 2026-04-07 07:05:22
success: True
trace_id: 16415529456076517025

Scan 161567367

duration: 0:00:12.545825

exit_message:

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

id: 161567367

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/rate_change__cs/2026-04-06/1775477103",
        "key": "raw/rate_change__cs/2026-04-06/1775477103/rate_change__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_rate_change__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 1210903597107720078,
        "service_name": "drive-thru",
        "span_id": 2368952001330075586,
        "trace_id": 17355787849534362649
    }
}

running: False
schema_name_id: 1183
start_time: 2026-04-06 07:11:21
success: True
trace_id: 17355787849534362649

Scan 161519953

duration: 0:00:15.107776

exit_message:

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

id: 161519953

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/rate_change__cs/2026-04-05/1775390648",
        "key": "raw/rate_change__cs/2026-04-05/1775390648/rate_change__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_rate_change__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 7069838169204058350,
        "service_name": "drive-thru",
        "span_id": 4382053430208298419,
        "trace_id": 8559522090259956026
    }
}

running: False
schema_name_id: 1183
start_time: 2026-04-05 07:04:14
success: True
trace_id: 8559522090259956026

Scan 161466414

duration: 0:00:15.059004

exit_message:

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

id: 161466414

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/rate_change__cs/2026-04-04/1775304406",
        "key": "raw/rate_change__cs/2026-04-04/1775304406/rate_change__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_rate_change__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 8117284790762938179,
        "service_name": "drive-thru",
        "span_id": 3913437309991655045,
        "trace_id": 1512104744385919407
    }
}

running: False
schema_name_id: 1183
start_time: 2026-04-04 07:07:43
success: True
trace_id: 1512104744385919407

Scan 161408562

duration: 0:00:15.115935

exit_message:

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

id: 161408562

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/rate_change__cs/2026-04-03/1775217851",
        "key": "raw/rate_change__cs/2026-04-03/1775217851/rate_change__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_rate_change__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 6110545802810006495,
        "service_name": "drive-thru",
        "span_id": 16745368141055160382,
        "trace_id": 469468971386419065
    }
}

running: False
schema_name_id: 1183
start_time: 2026-04-03 07:05:29
success: True
trace_id: 469468971386419065

Partitions:

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

Schema:

attributes:

{
    "Account__c": "string",
    "Amount": "string",
    "Asset_MRR_Updated__c": "string",
    "Asset__c": "string",
    "Billing_Cases_Created__c": "string",
    "CloseDate": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "Contract_Product_Category__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Custom_Contract__c": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "GenerateBillingCases__c": "string",
    "Id": "string",
    "IsDeleted": "string",
    "LastActivityDate": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Name": "string",
    "Negotiated_Rate_Adjustment__c": "string",
    "Negotiatedrate__c": "string",
    "Number_of_Months__c": "string",
    "OpportunityId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Priorrate__c": "string",
    "Probability": "string",
    "Product_Name__c": "string",
    "Proposed_Rate_Adjustment__c": "string",
    "Proposedrate__c": "string",
    "RatechangeEffectivedate__c": "string",
    "Related_Rate_Increase__c": "string",
    "Reschedule_MRR_Update__c": "string",
    "StageName": "string",
    "SystemModstamp": "string",
    "Type__c": "string"
}

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

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_rate_change__cs`\n(\n `Id`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `LastActivityDate`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Account__c`  string , `Asset__c`  string , `RatechangeEffectivedate__c`  string , `Type__c`  string , `Negotiatedrate__c`  string , `Priorrate__c`  string , `Proposedrate__c`  string , `GenerateBillingCases__c`  string , `Asset_MRR_Updated__c`  string , `Reschedule_MRR_Update__c`  string , `Number_of_Months__c`  string , `Custom_Contract__c`  string , `Negotiated_Rate_Adjustment__c`  string , `Product_Name__c`  string , `Proposed_Rate_Adjustment__c`  string , `Related_Rate_Increase__c`  string , `Contract_Product_Category__c`  string , `Billing_Cases_Created__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/rate_change__cs/2026-04-17/1776427498'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_rate_change__cs`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_rate_change__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": "2022-10-10 16:22:43",
        "disabled": false,
        "format": "raw",
        "id": 1183,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_csv",
            "table": "salesforce_rate_change__cs"
        },
        "type": "csv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "Account__c": "string",
            "Amount": "string",
            "Asset_MRR_Updated__c": "string",
            "Asset__c": "string",
            "Billing_Cases_Created__c": "string",
            "CloseDate": "string",
            "ConnectionReceivedId": "string",
            "ConnectionSentId": "string",
            "Contract_Product_Category__c": "string",
            "CreatedById": "string",
            "CreatedDate": "string",
            "CurrencyIsoCode": "string",
            "Custom_Contract__c": "string",
            "ExpectedRevenue": "string",
            "ForecastCategory": "string",
            "GenerateBillingCases__c": "string",
            "Id": "string",
            "IsDeleted": "string",
            "LastActivityDate": "string",
            "LastModifiedById": "string",
            "LastModifiedDate": "string",
            "Name": "string",
            "Negotiated_Rate_Adjustment__c": "string",
            "Negotiatedrate__c": "string",
            "Number_of_Months__c": "string",
            "OpportunityId": "string",
            "PrevAmount": "string",
            "PrevCloseDate": "string",
            "Priorrate__c": "string",
            "Probability": "string",
            "Product_Name__c": "string",
            "Proposed_Rate_Adjustment__c": "string",
            "Proposedrate__c": "string",
            "RatechangeEffectivedate__c": "string",
            "Related_Rate_Increase__c": "string",
            "Reschedule_MRR_Update__c": "string",
            "StageName": "string",
            "SystemModstamp": "string",
            "Type__c": "string"
        },
        "created": "2026-04-17 07:05:46",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_rate_change__cs`\n(\n `Id`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `LastActivityDate`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Account__c`  string , `Asset__c`  string , `RatechangeEffectivedate__c`  string , `Type__c`  string , `Negotiatedrate__c`  string , `Priorrate__c`  string , `Proposedrate__c`  string , `GenerateBillingCases__c`  string , `Asset_MRR_Updated__c`  string , `Reschedule_MRR_Update__c`  string , `Number_of_Months__c`  string , `Custom_Contract__c`  string , `Negotiated_Rate_Adjustment__c`  string , `Product_Name__c`  string , `Proposed_Rate_Adjustment__c`  string , `Related_Rate_Increase__c`  string , `Contract_Product_Category__c`  string , `Billing_Cases_Created__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/rate_change__cs/2026-04-17/1776427498'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_rate_change__cs`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_rate_change__cs"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}