Schema Info

Schema Name: sfdl_prod_csv.salesforce_property__cs

created: 2022-10-10 16:21:50
disabled: False
format: raw
id: 1170
is_partitioned: False
is_schema_datatyped: True

name:

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

type: csv

Schema Versions: 15

Version 1718060

created: 2026-04-17 07:04:47

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_property__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_property__cs`\n(\n `Id`  string , `OwnerId`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `LastActivityDate`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Accounts_Connected__c`  string , `City__c`  string , `Country__c`  string , `PostalCode__c`  string , `Region__c`  string , `Street__c`  string , `Type__c`  string , `Uplid_ID__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/property__cs/2026-04-17/1776427470'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_property__cs"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/property__cs/2026-04-17/1776427470
id: 1718060
processed: 1

raw_data:

{
    "Accounts_Connected__c": 13,
    "City__c": 14,
    "ConnectionReceivedId": 11,
    "ConnectionSentId": 12,
    "Country__c": 15,
    "CreatedById": 6,
    "CreatedDate": 5,
    "CurrencyIsoCode": 4,
    "Id": 0,
    "IsDeleted": 2,
    "LastActivityDate": 10,
    "LastModifiedById": 8,
    "LastModifiedDate": 7,
    "Name": 3,
    "OwnerId": 1,
    "PostalCode__c": 16,
    "Region__c": 17,
    "Street__c": 18,
    "SystemModstamp": 9,
    "Type__c": 19,
    "Uplid_ID__c": 20
}

schema_attributes:

{
    "Accounts_Connected__c": "string",
    "Amount": "string",
    "City__c": "string",
    "CloseDate": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "Country__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "Id": "string",
    "IsDeleted": "string",
    "LastActivityDate": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Name": "string",
    "OpportunityId": "string",
    "OwnerId": "string",
    "PostalCode__c": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "Region__c": "string",
    "StageName": "string",
    "Street__c": "string",
    "SystemModstamp": "string",
    "Type__c": "string",
    "Uplid_ID__c": "string"
}

schema_name_id: 1170
schema_scan_id: 162173023
updated: 2026-04-17 07:05:01

Version 1716835

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_property__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_property__cs`\n(\n `Id`  string , `OwnerId`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `LastActivityDate`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Accounts_Connected__c`  string , `City__c`  string , `Country__c`  string , `PostalCode__c`  string , `Region__c`  string , `Street__c`  string , `Type__c`  string , `Uplid_ID__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/property__cs/2026-04-16/1776341083'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_property__cs"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/property__cs/2026-04-16/1776341083
id: 1716835
processed: 1

raw_data:

{
    "Accounts_Connected__c": 13,
    "City__c": 14,
    "ConnectionReceivedId": 11,
    "ConnectionSentId": 12,
    "Country__c": 15,
    "CreatedById": 6,
    "CreatedDate": 5,
    "CurrencyIsoCode": 4,
    "Id": 0,
    "IsDeleted": 2,
    "LastActivityDate": 10,
    "LastModifiedById": 8,
    "LastModifiedDate": 7,
    "Name": 3,
    "OwnerId": 1,
    "PostalCode__c": 16,
    "Region__c": 17,
    "Street__c": 18,
    "SystemModstamp": 9,
    "Type__c": 19,
    "Uplid_ID__c": 20
}

schema_attributes:

{
    "Accounts_Connected__c": "string",
    "Amount": "string",
    "City__c": "string",
    "CloseDate": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "Country__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "Id": "string",
    "IsDeleted": "string",
    "LastActivityDate": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Name": "string",
    "OpportunityId": "string",
    "OwnerId": "string",
    "PostalCode__c": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "Region__c": "string",
    "StageName": "string",
    "Street__c": "string",
    "SystemModstamp": "string",
    "Type__c": "string",
    "Uplid_ID__c": "string"
}

schema_name_id: 1170
schema_scan_id: 162117307
updated: 2026-04-16 07:05:25

Version 1715640

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_property__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_property__cs`\n(\n `Id`  string , `OwnerId`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `LastActivityDate`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Accounts_Connected__c`  string , `City__c`  string , `Country__c`  string , `PostalCode__c`  string , `Region__c`  string , `Street__c`  string , `Type__c`  string , `Uplid_ID__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/property__cs/2026-04-15/1776254745'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_property__cs"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/property__cs/2026-04-15/1776254745
id: 1715640
processed: 1

raw_data:

{
    "Accounts_Connected__c": 13,
    "City__c": 14,
    "ConnectionReceivedId": 11,
    "ConnectionSentId": 12,
    "Country__c": 15,
    "CreatedById": 6,
    "CreatedDate": 5,
    "CurrencyIsoCode": 4,
    "Id": 0,
    "IsDeleted": 2,
    "LastActivityDate": 10,
    "LastModifiedById": 8,
    "LastModifiedDate": 7,
    "Name": 3,
    "OwnerId": 1,
    "PostalCode__c": 16,
    "Region__c": 17,
    "Street__c": 18,
    "SystemModstamp": 9,
    "Type__c": 19,
    "Uplid_ID__c": 20
}

schema_attributes:

{
    "Accounts_Connected__c": "string",
    "Amount": "string",
    "City__c": "string",
    "CloseDate": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "Country__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "Id": "string",
    "IsDeleted": "string",
    "LastActivityDate": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Name": "string",
    "OpportunityId": "string",
    "OwnerId": "string",
    "PostalCode__c": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "Region__c": "string",
    "StageName": "string",
    "Street__c": "string",
    "SystemModstamp": "string",
    "Type__c": "string",
    "Uplid_ID__c": "string"
}

schema_name_id: 1170
schema_scan_id: 162061774
updated: 2026-04-15 07:07:19

Version 1714447

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_property__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_property__cs`\n(\n `Id`  string , `OwnerId`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `LastActivityDate`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Accounts_Connected__c`  string , `City__c`  string , `Country__c`  string , `PostalCode__c`  string , `Region__c`  string , `Street__c`  string , `Type__c`  string , `Uplid_ID__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/property__cs/2026-04-14/1776168299'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_property__cs"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/property__cs/2026-04-14/1776168299
id: 1714447
processed: 1

raw_data:

{
    "Accounts_Connected__c": 13,
    "City__c": 14,
    "ConnectionReceivedId": 11,
    "ConnectionSentId": 12,
    "Country__c": 15,
    "CreatedById": 6,
    "CreatedDate": 5,
    "CurrencyIsoCode": 4,
    "Id": 0,
    "IsDeleted": 2,
    "LastActivityDate": 10,
    "LastModifiedById": 8,
    "LastModifiedDate": 7,
    "Name": 3,
    "OwnerId": 1,
    "PostalCode__c": 16,
    "Region__c": 17,
    "Street__c": 18,
    "SystemModstamp": 9,
    "Type__c": 19,
    "Uplid_ID__c": 20
}

schema_attributes:

{
    "Accounts_Connected__c": "string",
    "Amount": "string",
    "City__c": "string",
    "CloseDate": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "Country__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "Id": "string",
    "IsDeleted": "string",
    "LastActivityDate": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Name": "string",
    "OpportunityId": "string",
    "OwnerId": "string",
    "PostalCode__c": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "Region__c": "string",
    "StageName": "string",
    "Street__c": "string",
    "SystemModstamp": "string",
    "Type__c": "string",
    "Uplid_ID__c": "string"
}

schema_name_id: 1170
schema_scan_id: 162006361
updated: 2026-04-14 07:05:54

Version 1713256

created: 2026-04-13 07:07:30

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_property__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_property__cs`\n(\n `Id`  string , `OwnerId`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `LastActivityDate`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Accounts_Connected__c`  string , `City__c`  string , `Country__c`  string , `PostalCode__c`  string , `Region__c`  string , `Street__c`  string , `Type__c`  string , `Uplid_ID__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/property__cs/2026-04-13/1776081931'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_property__cs"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/property__cs/2026-04-13/1776081931
id: 1713256
processed: 1

raw_data:

{
    "Accounts_Connected__c": 13,
    "City__c": 14,
    "ConnectionReceivedId": 11,
    "ConnectionSentId": 12,
    "Country__c": 15,
    "CreatedById": 6,
    "CreatedDate": 5,
    "CurrencyIsoCode": 4,
    "Id": 0,
    "IsDeleted": 2,
    "LastActivityDate": 10,
    "LastModifiedById": 8,
    "LastModifiedDate": 7,
    "Name": 3,
    "OwnerId": 1,
    "PostalCode__c": 16,
    "Region__c": 17,
    "Street__c": 18,
    "SystemModstamp": 9,
    "Type__c": 19,
    "Uplid_ID__c": 20
}

schema_attributes:

{
    "Accounts_Connected__c": "string",
    "Amount": "string",
    "City__c": "string",
    "CloseDate": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "Country__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "Id": "string",
    "IsDeleted": "string",
    "LastActivityDate": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Name": "string",
    "OpportunityId": "string",
    "OwnerId": "string",
    "PostalCode__c": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "Region__c": "string",
    "StageName": "string",
    "Street__c": "string",
    "SystemModstamp": "string",
    "Type__c": "string",
    "Uplid_ID__c": "string"
}

schema_name_id: 1170
schema_scan_id: 161948338
updated: 2026-04-13 07:07:41

Version 1712068

created: 2026-04-12 07:08:53

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_property__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_property__cs`\n(\n `Id`  string , `OwnerId`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `LastActivityDate`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Accounts_Connected__c`  string , `City__c`  string , `Country__c`  string , `PostalCode__c`  string , `Region__c`  string , `Street__c`  string , `Type__c`  string , `Uplid_ID__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/property__cs/2026-04-12/1775995717'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_property__cs"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/property__cs/2026-04-12/1775995717
id: 1712068
processed: 1

raw_data:

{
    "Accounts_Connected__c": 13,
    "City__c": 14,
    "ConnectionReceivedId": 11,
    "ConnectionSentId": 12,
    "Country__c": 15,
    "CreatedById": 6,
    "CreatedDate": 5,
    "CurrencyIsoCode": 4,
    "Id": 0,
    "IsDeleted": 2,
    "LastActivityDate": 10,
    "LastModifiedById": 8,
    "LastModifiedDate": 7,
    "Name": 3,
    "OwnerId": 1,
    "PostalCode__c": 16,
    "Region__c": 17,
    "Street__c": 18,
    "SystemModstamp": 9,
    "Type__c": 19,
    "Uplid_ID__c": 20
}

schema_attributes:

{
    "Accounts_Connected__c": "string",
    "Amount": "string",
    "City__c": "string",
    "CloseDate": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "Country__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "Id": "string",
    "IsDeleted": "string",
    "LastActivityDate": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Name": "string",
    "OpportunityId": "string",
    "OwnerId": "string",
    "PostalCode__c": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "Region__c": "string",
    "StageName": "string",
    "Street__c": "string",
    "SystemModstamp": "string",
    "Type__c": "string",
    "Uplid_ID__c": "string"
}

schema_name_id: 1170
schema_scan_id: 161899554
updated: 2026-04-12 07:09:04

Version 1710852

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_property__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_property__cs`\n(\n `Id`  string , `OwnerId`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `LastActivityDate`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Accounts_Connected__c`  string , `City__c`  string , `Country__c`  string , `PostalCode__c`  string , `Region__c`  string , `Street__c`  string , `Type__c`  string , `Uplid_ID__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/property__cs/2026-04-11/1775909080'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_property__cs"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/property__cs/2026-04-11/1775909080
id: 1710852
processed: 1

raw_data:

{
    "Accounts_Connected__c": 13,
    "City__c": 14,
    "ConnectionReceivedId": 11,
    "ConnectionSentId": 12,
    "Country__c": 15,
    "CreatedById": 6,
    "CreatedDate": 5,
    "CurrencyIsoCode": 4,
    "Id": 0,
    "IsDeleted": 2,
    "LastActivityDate": 10,
    "LastModifiedById": 8,
    "LastModifiedDate": 7,
    "Name": 3,
    "OwnerId": 1,
    "PostalCode__c": 16,
    "Region__c": 17,
    "Street__c": 18,
    "SystemModstamp": 9,
    "Type__c": 19,
    "Uplid_ID__c": 20
}

schema_attributes:

{
    "Accounts_Connected__c": "string",
    "Amount": "string",
    "City__c": "string",
    "CloseDate": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "Country__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "Id": "string",
    "IsDeleted": "string",
    "LastActivityDate": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Name": "string",
    "OpportunityId": "string",
    "OwnerId": "string",
    "PostalCode__c": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "Region__c": "string",
    "StageName": "string",
    "Street__c": "string",
    "SystemModstamp": "string",
    "Type__c": "string",
    "Uplid_ID__c": "string"
}

schema_name_id: 1170
schema_scan_id: 161846861
updated: 2026-04-11 07:06:25

Version 1709650

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_property__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_property__cs`\n(\n `Id`  string , `OwnerId`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `LastActivityDate`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Accounts_Connected__c`  string , `City__c`  string , `Country__c`  string , `PostalCode__c`  string , `Region__c`  string , `Street__c`  string , `Type__c`  string , `Uplid_ID__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/property__cs/2026-04-10/1775822687'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_property__cs"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/property__cs/2026-04-10/1775822687
id: 1709650
processed: 1

raw_data:

{
    "Accounts_Connected__c": 13,
    "City__c": 14,
    "ConnectionReceivedId": 11,
    "ConnectionSentId": 12,
    "Country__c": 15,
    "CreatedById": 6,
    "CreatedDate": 5,
    "CurrencyIsoCode": 4,
    "Id": 0,
    "IsDeleted": 2,
    "LastActivityDate": 10,
    "LastModifiedById": 8,
    "LastModifiedDate": 7,
    "Name": 3,
    "OwnerId": 1,
    "PostalCode__c": 16,
    "Region__c": 17,
    "Street__c": 18,
    "SystemModstamp": 9,
    "Type__c": 19,
    "Uplid_ID__c": 20
}

schema_attributes:

{
    "Accounts_Connected__c": "string",
    "Amount": "string",
    "City__c": "string",
    "CloseDate": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "Country__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "Id": "string",
    "IsDeleted": "string",
    "LastActivityDate": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Name": "string",
    "OpportunityId": "string",
    "OwnerId": "string",
    "PostalCode__c": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "Region__c": "string",
    "StageName": "string",
    "Street__c": "string",
    "SystemModstamp": "string",
    "Type__c": "string",
    "Uplid_ID__c": "string"
}

schema_name_id: 1170
schema_scan_id: 161792045
updated: 2026-04-10 07:05:27

Version 1708501

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_property__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_property__cs`\n(\n `Id`  string , `OwnerId`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `LastActivityDate`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Accounts_Connected__c`  string , `City__c`  string , `Country__c`  string , `PostalCode__c`  string , `Region__c`  string , `Street__c`  string , `Type__c`  string , `Uplid_ID__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/property__cs/2026-04-09/1775736295'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_property__cs"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/property__cs/2026-04-09/1775736295
id: 1708501
processed: 1

raw_data:

{
    "Accounts_Connected__c": 13,
    "City__c": 14,
    "ConnectionReceivedId": 11,
    "ConnectionSentId": 12,
    "Country__c": 15,
    "CreatedById": 6,
    "CreatedDate": 5,
    "CurrencyIsoCode": 4,
    "Id": 0,
    "IsDeleted": 2,
    "LastActivityDate": 10,
    "LastModifiedById": 8,
    "LastModifiedDate": 7,
    "Name": 3,
    "OwnerId": 1,
    "PostalCode__c": 16,
    "Region__c": 17,
    "Street__c": 18,
    "SystemModstamp": 9,
    "Type__c": 19,
    "Uplid_ID__c": 20
}

schema_attributes:

{
    "Accounts_Connected__c": "string",
    "Amount": "string",
    "City__c": "string",
    "CloseDate": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "Country__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "Id": "string",
    "IsDeleted": "string",
    "LastActivityDate": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Name": "string",
    "OpportunityId": "string",
    "OwnerId": "string",
    "PostalCode__c": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "Region__c": "string",
    "StageName": "string",
    "Street__c": "string",
    "SystemModstamp": "string",
    "Type__c": "string",
    "Uplid_ID__c": "string"
}

schema_name_id: 1170
schema_scan_id: 161736227
updated: 2026-04-09 07:05:32

Version 1707320

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_property__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_property__cs`\n(\n `Id`  string , `OwnerId`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `LastActivityDate`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Accounts_Connected__c`  string , `City__c`  string , `Country__c`  string , `PostalCode__c`  string , `Region__c`  string , `Street__c`  string , `Type__c`  string , `Uplid_ID__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/property__cs/2026-04-08/1775649897'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_property__cs"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/property__cs/2026-04-08/1775649897
id: 1707320
processed: 1

raw_data:

{
    "Accounts_Connected__c": 13,
    "City__c": 14,
    "ConnectionReceivedId": 11,
    "ConnectionSentId": 12,
    "Country__c": 15,
    "CreatedById": 6,
    "CreatedDate": 5,
    "CurrencyIsoCode": 4,
    "Id": 0,
    "IsDeleted": 2,
    "LastActivityDate": 10,
    "LastModifiedById": 8,
    "LastModifiedDate": 7,
    "Name": 3,
    "OwnerId": 1,
    "PostalCode__c": 16,
    "Region__c": 17,
    "Street__c": 18,
    "SystemModstamp": 9,
    "Type__c": 19,
    "Uplid_ID__c": 20
}

schema_attributes:

{
    "Accounts_Connected__c": "string",
    "Amount": "string",
    "City__c": "string",
    "CloseDate": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "Country__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "Id": "string",
    "IsDeleted": "string",
    "LastActivityDate": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Name": "string",
    "OpportunityId": "string",
    "OwnerId": "string",
    "PostalCode__c": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "Region__c": "string",
    "StageName": "string",
    "Street__c": "string",
    "SystemModstamp": "string",
    "Type__c": "string",
    "Uplid_ID__c": "string"
}

schema_name_id: 1170
schema_scan_id: 161681375
updated: 2026-04-08 07:05:59

Version 1706131

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_property__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_property__cs`\n(\n `Id`  string , `OwnerId`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `LastActivityDate`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Accounts_Connected__c`  string , `City__c`  string , `Country__c`  string , `PostalCode__c`  string , `Region__c`  string , `Street__c`  string , `Type__c`  string , `Uplid_ID__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/property__cs/2026-04-07/1775563505'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_property__cs"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/property__cs/2026-04-07/1775563505
id: 1706131
processed: 1

raw_data:

{
    "Accounts_Connected__c": 13,
    "City__c": 14,
    "ConnectionReceivedId": 11,
    "ConnectionSentId": 12,
    "Country__c": 15,
    "CreatedById": 6,
    "CreatedDate": 5,
    "CurrencyIsoCode": 4,
    "Id": 0,
    "IsDeleted": 2,
    "LastActivityDate": 10,
    "LastModifiedById": 8,
    "LastModifiedDate": 7,
    "Name": 3,
    "OwnerId": 1,
    "PostalCode__c": 16,
    "Region__c": 17,
    "Street__c": 18,
    "SystemModstamp": 9,
    "Type__c": 19,
    "Uplid_ID__c": 20
}

schema_attributes:

{
    "Accounts_Connected__c": "string",
    "Amount": "string",
    "City__c": "string",
    "CloseDate": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "Country__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "Id": "string",
    "IsDeleted": "string",
    "LastActivityDate": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Name": "string",
    "OpportunityId": "string",
    "OwnerId": "string",
    "PostalCode__c": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "Region__c": "string",
    "StageName": "string",
    "Street__c": "string",
    "SystemModstamp": "string",
    "Type__c": "string",
    "Uplid_ID__c": "string"
}

schema_name_id: 1170
schema_scan_id: 161625168
updated: 2026-04-07 07:06:04

Version 1704935

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_property__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_property__cs`\n(\n `Id`  string , `OwnerId`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `LastActivityDate`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Accounts_Connected__c`  string , `City__c`  string , `Country__c`  string , `PostalCode__c`  string , `Region__c`  string , `Street__c`  string , `Type__c`  string , `Uplid_ID__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/property__cs/2026-04-06/1775477122'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_property__cs"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/property__cs/2026-04-06/1775477122
id: 1704935
processed: 1

raw_data:

{
    "Accounts_Connected__c": 13,
    "City__c": 14,
    "ConnectionReceivedId": 11,
    "ConnectionSentId": 12,
    "Country__c": 15,
    "CreatedById": 6,
    "CreatedDate": 5,
    "CurrencyIsoCode": 4,
    "Id": 0,
    "IsDeleted": 2,
    "LastActivityDate": 10,
    "LastModifiedById": 8,
    "LastModifiedDate": 7,
    "Name": 3,
    "OwnerId": 1,
    "PostalCode__c": 16,
    "Region__c": 17,
    "Street__c": 18,
    "SystemModstamp": 9,
    "Type__c": 19,
    "Uplid_ID__c": 20
}

schema_attributes:

{
    "Accounts_Connected__c": "string",
    "Amount": "string",
    "City__c": "string",
    "CloseDate": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "Country__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "Id": "string",
    "IsDeleted": "string",
    "LastActivityDate": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Name": "string",
    "OpportunityId": "string",
    "OwnerId": "string",
    "PostalCode__c": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "Region__c": "string",
    "StageName": "string",
    "Street__c": "string",
    "SystemModstamp": "string",
    "Type__c": "string",
    "Uplid_ID__c": "string"
}

schema_name_id: 1170
schema_scan_id: 161567344
updated: 2026-04-06 07:10:19

Version 1703684

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_property__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_property__cs`\n(\n `Id`  string , `OwnerId`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `LastActivityDate`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Accounts_Connected__c`  string , `City__c`  string , `Country__c`  string , `PostalCode__c`  string , `Region__c`  string , `Street__c`  string , `Type__c`  string , `Uplid_ID__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/property__cs/2026-04-05/1775390664'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_property__cs"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/property__cs/2026-04-05/1775390664
id: 1703684
processed: 1

raw_data:

{
    "Accounts_Connected__c": 13,
    "City__c": 14,
    "ConnectionReceivedId": 11,
    "ConnectionSentId": 12,
    "Country__c": 15,
    "CreatedById": 6,
    "CreatedDate": 5,
    "CurrencyIsoCode": 4,
    "Id": 0,
    "IsDeleted": 2,
    "LastActivityDate": 10,
    "LastModifiedById": 8,
    "LastModifiedDate": 7,
    "Name": 3,
    "OwnerId": 1,
    "PostalCode__c": 16,
    "Region__c": 17,
    "Street__c": 18,
    "SystemModstamp": 9,
    "Type__c": 19,
    "Uplid_ID__c": 20
}

schema_attributes:

{
    "Accounts_Connected__c": "string",
    "Amount": "string",
    "City__c": "string",
    "CloseDate": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "Country__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "Id": "string",
    "IsDeleted": "string",
    "LastActivityDate": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Name": "string",
    "OpportunityId": "string",
    "OwnerId": "string",
    "PostalCode__c": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "Region__c": "string",
    "StageName": "string",
    "Street__c": "string",
    "SystemModstamp": "string",
    "Type__c": "string",
    "Uplid_ID__c": "string"
}

schema_name_id: 1170
schema_scan_id: 161519964
updated: 2026-04-05 07:05:09

Version 1702528

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_property__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_property__cs`\n(\n `Id`  string , `OwnerId`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `LastActivityDate`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Accounts_Connected__c`  string , `City__c`  string , `Country__c`  string , `PostalCode__c`  string , `Region__c`  string , `Street__c`  string , `Type__c`  string , `Uplid_ID__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/property__cs/2026-04-04/1775304368'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_property__cs"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/property__cs/2026-04-04/1775304368
id: 1702528
processed: 1

raw_data:

{
    "Accounts_Connected__c": 13,
    "City__c": 14,
    "ConnectionReceivedId": 11,
    "ConnectionSentId": 12,
    "Country__c": 15,
    "CreatedById": 6,
    "CreatedDate": 5,
    "CurrencyIsoCode": 4,
    "Id": 0,
    "IsDeleted": 2,
    "LastActivityDate": 10,
    "LastModifiedById": 8,
    "LastModifiedDate": 7,
    "Name": 3,
    "OwnerId": 1,
    "PostalCode__c": 16,
    "Region__c": 17,
    "Street__c": 18,
    "SystemModstamp": 9,
    "Type__c": 19,
    "Uplid_ID__c": 20
}

schema_attributes:

{
    "Accounts_Connected__c": "string",
    "Amount": "string",
    "City__c": "string",
    "CloseDate": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "Country__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "Id": "string",
    "IsDeleted": "string",
    "LastActivityDate": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Name": "string",
    "OpportunityId": "string",
    "OwnerId": "string",
    "PostalCode__c": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "Region__c": "string",
    "StageName": "string",
    "Street__c": "string",
    "SystemModstamp": "string",
    "Type__c": "string",
    "Uplid_ID__c": "string"
}

schema_name_id: 1170
schema_scan_id: 161466398
updated: 2026-04-04 07:06:49

Version 1701344

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_property__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_property__cs`\n(\n `Id`  string , `OwnerId`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `LastActivityDate`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Accounts_Connected__c`  string , `City__c`  string , `Country__c`  string , `PostalCode__c`  string , `Region__c`  string , `Street__c`  string , `Type__c`  string , `Uplid_ID__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/property__cs/2026-04-03/1775217852'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_property__cs"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/property__cs/2026-04-03/1775217852
id: 1701344
processed: 1

raw_data:

{
    "Accounts_Connected__c": 13,
    "City__c": 14,
    "ConnectionReceivedId": 11,
    "ConnectionSentId": 12,
    "Country__c": 15,
    "CreatedById": 6,
    "CreatedDate": 5,
    "CurrencyIsoCode": 4,
    "Id": 0,
    "IsDeleted": 2,
    "LastActivityDate": 10,
    "LastModifiedById": 8,
    "LastModifiedDate": 7,
    "Name": 3,
    "OwnerId": 1,
    "PostalCode__c": 16,
    "Region__c": 17,
    "Street__c": 18,
    "SystemModstamp": 9,
    "Type__c": 19,
    "Uplid_ID__c": 20
}

schema_attributes:

{
    "Accounts_Connected__c": "string",
    "Amount": "string",
    "City__c": "string",
    "CloseDate": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "Country__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "Id": "string",
    "IsDeleted": "string",
    "LastActivityDate": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Name": "string",
    "OpportunityId": "string",
    "OwnerId": "string",
    "PostalCode__c": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "Region__c": "string",
    "StageName": "string",
    "Street__c": "string",
    "SystemModstamp": "string",
    "Type__c": "string",
    "Uplid_ID__c": "string"
}

schema_name_id: 1170
schema_scan_id: 161408545
updated: 2026-04-03 07:05:00

Schema Scans: 15

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

Scan 162173023

duration: 0:00:14.892499

exit_message:

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

id: 162173023

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/property__cs/2026-04-17/1776427470",
        "key": "raw/property__cs/2026-04-17/1776427470/property__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_property__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 11371202305625768675,
        "service_name": "drive-thru",
        "span_id": 10949006419836968755,
        "trace_id": 6592743818676528133
    }
}

running: False
schema_name_id: 1170
start_time: 2026-04-17 07:04:46
success: True
trace_id: 6592743818676528133

Scan 162117307

duration: 0:00:14.916797

exit_message:

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

id: 162117307

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/property__cs/2026-04-16/1776341083",
        "key": "raw/property__cs/2026-04-16/1776341083/property__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_property__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 12064227018818902264,
        "service_name": "drive-thru",
        "span_id": 734149107615870603,
        "trace_id": 13762564009002567460
    }
}

running: False
schema_name_id: 1170
start_time: 2026-04-16 07:05:10
success: True
trace_id: 13762564009002567460

Scan 162061774

duration: 0:00:14.801213

exit_message:

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

id: 162061774

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/property__cs/2026-04-15/1776254745",
        "key": "raw/property__cs/2026-04-15/1776254745/property__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_property__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 1128959866560091885,
        "service_name": "drive-thru",
        "span_id": 15023932393264064764,
        "trace_id": 18090397479142453439
    }
}

running: False
schema_name_id: 1170
start_time: 2026-04-15 07:07:04
success: True
trace_id: 18090397479142453439

Scan 162006361

duration: 0:00:14.833133

exit_message:

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

id: 162006361

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/property__cs/2026-04-14/1776168299",
        "key": "raw/property__cs/2026-04-14/1776168299/property__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_property__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 9960498999694705486,
        "service_name": "drive-thru",
        "span_id": 18385880405210792105,
        "trace_id": 7829655630003835750
    }
}

running: False
schema_name_id: 1170
start_time: 2026-04-14 07:05:39
success: True
trace_id: 7829655630003835750

Scan 161948338

duration: 0:00:12.286928

exit_message:

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

id: 161948338

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/property__cs/2026-04-13/1776081931",
        "key": "raw/property__cs/2026-04-13/1776081931/property__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_property__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 4109491793019631752,
        "service_name": "drive-thru",
        "span_id": 11465202590429585131,
        "trace_id": 16627793959652666156
    }
}

running: False
schema_name_id: 1170
start_time: 2026-04-13 07:07:29
success: True
trace_id: 16627793959652666156

Scan 161899554

duration: 0:00:12.096126

exit_message:

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

id: 161899554

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/property__cs/2026-04-12/1775995717",
        "key": "raw/property__cs/2026-04-12/1775995717/property__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_property__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 9775731166055345036,
        "service_name": "drive-thru",
        "span_id": 16712002155962813364,
        "trace_id": 16638324542917421023
    }
}

running: False
schema_name_id: 1170
start_time: 2026-04-12 07:08:52
success: True
trace_id: 16638324542917421023

Scan 161846861

duration: 0:00:14.734607

exit_message:

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

id: 161846861

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/property__cs/2026-04-11/1775909080",
        "key": "raw/property__cs/2026-04-11/1775909080/property__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_property__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 3856944985246892161,
        "service_name": "drive-thru",
        "span_id": 2322896108301957727,
        "trace_id": 18231631196652588037
    }
}

running: False
schema_name_id: 1170
start_time: 2026-04-11 07:06:10
success: True
trace_id: 18231631196652588037

Scan 161792045

duration: 0:00:12.242689

exit_message:

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

id: 161792045

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/property__cs/2026-04-10/1775822687",
        "key": "raw/property__cs/2026-04-10/1775822687/property__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_property__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 7767739713909391453,
        "service_name": "drive-thru",
        "span_id": 10259331386057989527,
        "trace_id": 7273355439982209622
    }
}

running: False
schema_name_id: 1170
start_time: 2026-04-10 07:05:15
success: True
trace_id: 7273355439982209622

Scan 161736227

duration: 0:00:14.743991

exit_message:

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

id: 161736227

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/property__cs/2026-04-09/1775736295",
        "key": "raw/property__cs/2026-04-09/1775736295/property__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_property__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 2668422767953134056,
        "service_name": "drive-thru",
        "span_id": 4897662833453489687,
        "trace_id": 5315217660094243238
    }
}

running: False
schema_name_id: 1170
start_time: 2026-04-09 07:05:17
success: True
trace_id: 5315217660094243238

Scan 161681375

duration: 0:00:12.339499

exit_message:

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

id: 161681375

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/property__cs/2026-04-08/1775649897",
        "key": "raw/property__cs/2026-04-08/1775649897/property__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_property__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 11012120162135231603,
        "service_name": "drive-thru",
        "span_id": 2401939588566203343,
        "trace_id": 3533834817503392719
    }
}

running: False
schema_name_id: 1170
start_time: 2026-04-08 07:05:46
success: True
trace_id: 3533834817503392719

Scan 161625168

duration: 0:00:14.763374

exit_message:

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

id: 161625168

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/property__cs/2026-04-07/1775563505",
        "key": "raw/property__cs/2026-04-07/1775563505/property__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_property__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 2536306172430999213,
        "service_name": "drive-thru",
        "span_id": 7348909339029621072,
        "trace_id": 12511175173472597131
    }
}

running: False
schema_name_id: 1170
start_time: 2026-04-07 07:05:49
success: True
trace_id: 12511175173472597131

Scan 161567344

duration: 0:00:14.922545

exit_message:

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

id: 161567344

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/property__cs/2026-04-06/1775477122",
        "key": "raw/property__cs/2026-04-06/1775477122/property__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_property__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 9460749192447962511,
        "service_name": "drive-thru",
        "span_id": 11465033732497435850,
        "trace_id": 6450281330523062432
    }
}

running: False
schema_name_id: 1170
start_time: 2026-04-06 07:10:04
success: True
trace_id: 6450281330523062432

Scan 161519964

duration: 0:00:14.765549

exit_message:

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

id: 161519964

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/property__cs/2026-04-05/1775390664",
        "key": "raw/property__cs/2026-04-05/1775390664/property__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_property__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 8050161527353468312,
        "service_name": "drive-thru",
        "span_id": 2276719794955190006,
        "trace_id": 715039017479863673
    }
}

running: False
schema_name_id: 1170
start_time: 2026-04-05 07:04:54
success: True
trace_id: 715039017479863673

Scan 161466398

duration: 0:00:14.756883

exit_message:

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

id: 161466398

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/property__cs/2026-04-04/1775304368",
        "key": "raw/property__cs/2026-04-04/1775304368/property__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_property__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 3859513633605365026,
        "service_name": "drive-thru",
        "span_id": 11488845149079522033,
        "trace_id": 18357281864778192593
    }
}

running: False
schema_name_id: 1170
start_time: 2026-04-04 07:06:34
success: True
trace_id: 18357281864778192593

Scan 161408545

duration: 0:00:12.319550

exit_message:

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

id: 161408545

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/property__cs/2026-04-03/1775217852",
        "key": "raw/property__cs/2026-04-03/1775217852/property__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_property__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 5144990554011101338,
        "service_name": "drive-thru",
        "span_id": 15407957008445734535,
        "trace_id": 5208140535226698095
    }
}

running: False
schema_name_id: 1170
start_time: 2026-04-03 07:04:48
success: True
trace_id: 5208140535226698095

Partitions:

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

Schema:

attributes:

{
    "Accounts_Connected__c": "string",
    "Amount": "string",
    "City__c": "string",
    "CloseDate": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "Country__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "Id": "string",
    "IsDeleted": "string",
    "LastActivityDate": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Name": "string",
    "OpportunityId": "string",
    "OwnerId": "string",
    "PostalCode__c": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "Region__c": "string",
    "StageName": "string",
    "Street__c": "string",
    "SystemModstamp": "string",
    "Type__c": "string",
    "Uplid_ID__c": "string"
}

created: 2026-04-17 07:04:47

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_property__cs`\n(\n `Id`  string , `OwnerId`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `LastActivityDate`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Accounts_Connected__c`  string , `City__c`  string , `Country__c`  string , `PostalCode__c`  string , `Region__c`  string , `Street__c`  string , `Type__c`  string , `Uplid_ID__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/property__cs/2026-04-17/1776427470'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_property__cs`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_property__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:21:50",
        "disabled": false,
        "format": "raw",
        "id": 1170,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_csv",
            "table": "salesforce_property__cs"
        },
        "type": "csv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "Accounts_Connected__c": "string",
            "Amount": "string",
            "City__c": "string",
            "CloseDate": "string",
            "ConnectionReceivedId": "string",
            "ConnectionSentId": "string",
            "Country__c": "string",
            "CreatedById": "string",
            "CreatedDate": "string",
            "CurrencyIsoCode": "string",
            "ExpectedRevenue": "string",
            "ForecastCategory": "string",
            "Id": "string",
            "IsDeleted": "string",
            "LastActivityDate": "string",
            "LastModifiedById": "string",
            "LastModifiedDate": "string",
            "Name": "string",
            "OpportunityId": "string",
            "OwnerId": "string",
            "PostalCode__c": "string",
            "PrevAmount": "string",
            "PrevCloseDate": "string",
            "Probability": "string",
            "Region__c": "string",
            "StageName": "string",
            "Street__c": "string",
            "SystemModstamp": "string",
            "Type__c": "string",
            "Uplid_ID__c": "string"
        },
        "created": "2026-04-17 07:04:47",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_property__cs`\n(\n `Id`  string , `OwnerId`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `LastActivityDate`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Accounts_Connected__c`  string , `City__c`  string , `Country__c`  string , `PostalCode__c`  string , `Region__c`  string , `Street__c`  string , `Type__c`  string , `Uplid_ID__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/property__cs/2026-04-17/1776427470'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_property__cs`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_property__cs"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}