Schema Info
Schema Name: sfdl_stage_csv.salesforce_rate_change__cs
- created: 2022-10-24 15:15:37
- disabled: False
- format: raw
- id: 1448
- is_partitioned: False
- is_schema_datatyped: True
- name:
{ "database": "sfdl_stage_csv", "table": "salesforce_rate_change__cs" } - type: csv
Schema Versions: 3
-
Version 896328
- created: 2026-02-27 09:11:02
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`", "DROP TABLE IF EXISTS `sfdl_stage_csv.salesforce_rate_change__cs`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/rate_change__cs/2026-02-27/1772205019'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_stage_csv.salesforce_rate_change__cs" ] - hive_path: s3://sfdl-csv-salesforce-stage/raw/rate_change__cs/2026-02-27/1772205019
- id: 896328
- 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: 1448
- schema_scan_id: 6391661
- updated: 2026-02-27 09:11:16
-
Version 797928
- created: 2025-01-09 15:17:07
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`", "DROP TABLE IF EXISTS `sfdl_stage_csv.salesforce_rate_change__cs`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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 \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-stage/raw/rate_change__cs/2025-01-09/1736457302'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_stage_csv.salesforce_rate_change__cs" ] - hive_path: s3://sfdl-csv-salesforce-stage/raw/rate_change__cs/2025-01-09/1736457302
- id: 797928
- processed: 1
- raw_data:
{ "Account__c": 12, "Asset_MRR_Updated__c": 20, "Asset__c": 13, "ConnectionReceivedId": 10, "ConnectionSentId": 11, "CreatedById": 5, "CreatedDate": 4, "CurrencyIsoCode": 3, "GenerateBillingCases__c": 19, "Id": 0, "IsDeleted": 1, "LastActivityDate": 9, "LastModifiedById": 7, "LastModifiedDate": 6, "Name": 2, "Negotiatedrate__c": 16, "Number_of_Months__c": 22, "Priorrate__c": 17, "Proposedrate__c": 18, "RatechangeEffectivedate__c": 14, "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", "CloseDate": "string", "ConnectionReceivedId": "string", "ConnectionSentId": "string", "CreatedById": "string", "CreatedDate": "string", "CurrencyIsoCode": "string", "ExpectedRevenue": "string", "ForecastCategory": "string", "GenerateBillingCases__c": "string", "Id": "string", "IsDeleted": "string", "LastActivityDate": "string", "LastModifiedById": "string", "LastModifiedDate": "string", "Name": "string", "Negotiatedrate__c": "string", "Number_of_Months__c": "string", "OpportunityId": "string", "PrevAmount": "string", "PrevCloseDate": "string", "Priorrate__c": "string", "Probability": "string", "Proposedrate__c": "string", "RatechangeEffectivedate__c": "string", "Reschedule_MRR_Update__c": "string", "StageName": "string", "SystemModstamp": "string", "Type__c": "string" } - schema_name_id: 1448
- schema_scan_id: 6197242
- updated: 2025-01-09 15:17:21
-
Version 693435
- created: 2024-05-01 08:54:28
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`", "DROP TABLE IF EXISTS `sfdl_stage_csv.salesforce_rate_change__cs`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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 \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-stage/raw/rate_change__cs/2024-05-01/1714571604'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_stage_csv.salesforce_rate_change__cs" ] - hive_path: s3://sfdl-csv-salesforce-stage/raw/rate_change__cs/2024-05-01/1714571604
- id: 693435
- processed: 1
- raw_data:
{ "Account__c": 12, "Asset_MRR_Updated__c": 20, "Asset__c": 13, "ConnectionReceivedId": 10, "ConnectionSentId": 11, "CreatedById": 5, "CreatedDate": 4, "CurrencyIsoCode": 3, "GenerateBillingCases__c": 19, "Id": 0, "IsDeleted": 1, "LastActivityDate": 9, "LastModifiedById": 7, "LastModifiedDate": 6, "Name": 2, "Negotiatedrate__c": 16, "Number_of_Months__c": 22, "Priorrate__c": 17, "Proposedrate__c": 18, "RatechangeEffectivedate__c": 14, "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", "CloseDate": "string", "ConnectionReceivedId": "string", "ConnectionSentId": "string", "CreatedById": "string", "CreatedDate": "string", "CurrencyIsoCode": "string", "ExpectedRevenue": "string", "ForecastCategory": "string", "GenerateBillingCases__c": "string", "Id": "string", "IsDeleted": "string", "LastActivityDate": "string", "LastModifiedById": "string", "LastModifiedDate": "string", "Name": "string", "Negotiatedrate__c": "string", "Number_of_Months__c": "string", "OpportunityId": "string", "PrevAmount": "string", "PrevCloseDate": "string", "Priorrate__c": "string", "Probability": "string", "Proposedrate__c": "string", "RatechangeEffectivedate__c": "string", "Reschedule_MRR_Update__c": "string", "StageName": "string", "SystemModstamp": "string", "Type__c": "string" } - schema_name_id: 1448
- schema_scan_id: 5671831
- updated: 2024-05-01 08:54:42
Schema Scans: 3
Last at 2026-02-27 09:11:00
-
Scan 6391661
- duration: 0:00:15.632374
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6391661
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-csv-salesforce-stage", "hive_path": "s3://sfdl-csv-salesforce-stage/raw/rate_change__cs/2026-02-27/1772205019", "key": "raw/rate_change__cs/2026-02-27/1772205019/rate_change__cs.csv.gz" }, "schema": { "name": "sfdl_stage_csv.salesforce_rate_change__cs", "type": "csv" }, "trace_context": { "parent_id": 10567490765104485273, "service_name": "drive-thru", "span_id": 12321114919828237099, "trace_id": 9675662463737222703 } } - running: False
- schema_name_id: 1448
- start_time: 2026-02-27 09:11:00
- success: True
- trace_id: 9675662463737222703
-
Scan 6197242
- duration: 0:00:14.757000
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6197242
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-csv-salesforce-stage", "hive_path": "s3://sfdl-csv-salesforce-stage/raw/rate_change__cs/2025-01-09/1736457302", "key": "raw/rate_change__cs/2025-01-09/1736457302/rate_change__cs.csv.gz" }, "schema": { "name": "sfdl_stage_csv.salesforce_rate_change__cs", "type": "csv" }, "trace_context": { "parent_id": 6718543229021376150, "service_name": "drive-thru", "span_id": 4750473137501809889, "trace_id": 9686943763097357209 } } - running: False
- schema_name_id: 1448
- start_time: 2025-01-09 15:17:06
- success: True
- trace_id: 9686943763097357209
-
Scan 5671831
- duration: 0:00:14.740924
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 5671831
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-csv-salesforce-stage", "hive_path": "s3://sfdl-csv-salesforce-stage/raw/rate_change__cs/2024-05-01/1714571604", "key": "raw/rate_change__cs/2024-05-01/1714571604/rate_change__cs.csv.gz" }, "schema": { "name": "sfdl_stage_csv.salesforce_rate_change__cs", "type": "csv" }, "trace_context": { "parent_id": 9638115889593526203, "service_name": "drive-thru", "span_id": 7579016411119863272, "trace_id": 16115395539855463836 } } - running: False
- schema_name_id: 1448
- start_time: 2024-05-01 08:54:27
- success: True
- trace_id: 16115395539855463836
- 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-02-27 09:11:02
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/rate_change__cs/2026-02-27/1772205019'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_csv.salesforce_rate_change__cs`", "repair_table": "MSCK REPAIR TABLE sfdl_stage_csv.salesforce_rate_change__cs" }
- hostname: schemamanager-5c55c886bf-h2ts4
- name: schema_manager
- process_start: 2025-10-21 13:03:27
- sf_env: stage
- version: 2112174301
{
"name": {
"created": "2022-10-24 15:15:37",
"disabled": false,
"format": "raw",
"id": 1448,
"is_partitioned": false,
"is_schema_datatyped": true,
"name": {
"database": "sfdl_stage_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-02-27 09:11:02",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/rate_change__cs/2026-02-27/1772205019'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
"drop_table": "DROP TABLE IF EXISTS `sfdl_stage_csv.salesforce_rate_change__cs`",
"repair_table": "MSCK REPAIR TABLE sfdl_stage_csv.salesforce_rate_change__cs"
}
},
"server": {
"hostname": "schemamanager-5c55c886bf-h2ts4",
"name": "schema_manager",
"process_start": "2025-10-21 13:03:27",
"sf_env": "stage",
"version": "2112174301"
}
}