Schema Info

Schema Name: sfdl_prod_csv.salesforce_jira_comment__cs

created: 2022-10-10 16:22:03
disabled: False
format: raw
id: 1174
is_partitioned: False
is_schema_datatyped: True

name:

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

type: csv

Schema Versions: 15

Version 1718105

created: 2026-04-17 07:07:00

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_jira_comment__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_jira_comment__cs`\n(\n `Id`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Jira_Issue__c`  string , `Author__c`  string , `Body__c`  string , `Jira_Comment_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/jira_comment__cs/2026-04-17/1776427517'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_jira_comment__cs"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/jira_comment__cs/2026-04-17/1776427517
id: 1718105
processed: 1

raw_data:

{
    "Author__c": 12,
    "Body__c": 13,
    "ConnectionReceivedId": 9,
    "ConnectionSentId": 10,
    "CreatedById": 5,
    "CreatedDate": 4,
    "CurrencyIsoCode": 3,
    "Id": 0,
    "IsDeleted": 1,
    "Jira_Comment_ID__c": 14,
    "Jira_Issue__c": 11,
    "LastModifiedById": 7,
    "LastModifiedDate": 6,
    "Name": 2,
    "SystemModstamp": 8
}

schema_attributes:

{
    "Amount": "string",
    "Author__c": "string",
    "Body__c": "string",
    "CloseDate": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "Id": "string",
    "IsDeleted": "string",
    "Jira_Comment_ID__c": "string",
    "Jira_Issue__c": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Name": "string",
    "OpportunityId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "StageName": "string",
    "SystemModstamp": "string"
}

schema_name_id: 1174
schema_scan_id: 162173076
updated: 2026-04-17 07:07:14

Version 1716874

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_jira_comment__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_jira_comment__cs`\n(\n `Id`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Jira_Issue__c`  string , `Author__c`  string , `Body__c`  string , `Jira_Comment_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/jira_comment__cs/2026-04-16/1776341126'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_jira_comment__cs"
]

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

raw_data:

{
    "Author__c": 12,
    "Body__c": 13,
    "ConnectionReceivedId": 9,
    "ConnectionSentId": 10,
    "CreatedById": 5,
    "CreatedDate": 4,
    "CurrencyIsoCode": 3,
    "Id": 0,
    "IsDeleted": 1,
    "Jira_Comment_ID__c": 14,
    "Jira_Issue__c": 11,
    "LastModifiedById": 7,
    "LastModifiedDate": 6,
    "Name": 2,
    "SystemModstamp": 8
}

schema_attributes:

{
    "Amount": "string",
    "Author__c": "string",
    "Body__c": "string",
    "CloseDate": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "Id": "string",
    "IsDeleted": "string",
    "Jira_Comment_ID__c": "string",
    "Jira_Issue__c": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Name": "string",
    "OpportunityId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "StageName": "string",
    "SystemModstamp": "string"
}

schema_name_id: 1174
schema_scan_id: 162117358
updated: 2026-04-16 07:07:18

Version 1715676

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_jira_comment__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_jira_comment__cs`\n(\n `Id`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Jira_Issue__c`  string , `Author__c`  string , `Body__c`  string , `Jira_Comment_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/jira_comment__cs/2026-04-15/1776254774'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_jira_comment__cs"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/jira_comment__cs/2026-04-15/1776254774
id: 1715676
processed: 1

raw_data:

{
    "Author__c": 12,
    "Body__c": 13,
    "ConnectionReceivedId": 9,
    "ConnectionSentId": 10,
    "CreatedById": 5,
    "CreatedDate": 4,
    "CurrencyIsoCode": 3,
    "Id": 0,
    "IsDeleted": 1,
    "Jira_Comment_ID__c": 14,
    "Jira_Issue__c": 11,
    "LastModifiedById": 7,
    "LastModifiedDate": 6,
    "Name": 2,
    "SystemModstamp": 8
}

schema_attributes:

{
    "Amount": "string",
    "Author__c": "string",
    "Body__c": "string",
    "CloseDate": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "Id": "string",
    "IsDeleted": "string",
    "Jira_Comment_ID__c": "string",
    "Jira_Issue__c": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Name": "string",
    "OpportunityId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "StageName": "string",
    "SystemModstamp": "string"
}

schema_name_id: 1174
schema_scan_id: 162061820
updated: 2026-04-15 07:11:12

Version 1714473

created: 2026-04-14 07:06:56

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_jira_comment__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_jira_comment__cs`\n(\n `Id`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Jira_Issue__c`  string , `Author__c`  string , `Body__c`  string , `Jira_Comment_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/jira_comment__cs/2026-04-14/1776168347'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_jira_comment__cs"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/jira_comment__cs/2026-04-14/1776168347
id: 1714473
processed: 1

raw_data:

{
    "Author__c": 12,
    "Body__c": 13,
    "ConnectionReceivedId": 9,
    "ConnectionSentId": 10,
    "CreatedById": 5,
    "CreatedDate": 4,
    "CurrencyIsoCode": 3,
    "Id": 0,
    "IsDeleted": 1,
    "Jira_Comment_ID__c": 14,
    "Jira_Issue__c": 11,
    "LastModifiedById": 7,
    "LastModifiedDate": 6,
    "Name": 2,
    "SystemModstamp": 8
}

schema_attributes:

{
    "Amount": "string",
    "Author__c": "string",
    "Body__c": "string",
    "CloseDate": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "Id": "string",
    "IsDeleted": "string",
    "Jira_Comment_ID__c": "string",
    "Jira_Issue__c": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Name": "string",
    "OpportunityId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "StageName": "string",
    "SystemModstamp": "string"
}

schema_name_id: 1174
schema_scan_id: 162006391
updated: 2026-04-14 07:07:08

Version 1713221

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_jira_comment__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_jira_comment__cs`\n(\n `Id`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Jira_Issue__c`  string , `Author__c`  string , `Body__c`  string , `Jira_Comment_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/jira_comment__cs/2026-04-13/1776081911'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_jira_comment__cs"
]

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

raw_data:

{
    "Author__c": 12,
    "Body__c": 13,
    "ConnectionReceivedId": 9,
    "ConnectionSentId": 10,
    "CreatedById": 5,
    "CreatedDate": 4,
    "CurrencyIsoCode": 3,
    "Id": 0,
    "IsDeleted": 1,
    "Jira_Comment_ID__c": 14,
    "Jira_Issue__c": 11,
    "LastModifiedById": 7,
    "LastModifiedDate": 6,
    "Name": 2,
    "SystemModstamp": 8
}

schema_attributes:

{
    "Amount": "string",
    "Author__c": "string",
    "Body__c": "string",
    "CloseDate": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "Id": "string",
    "IsDeleted": "string",
    "Jira_Comment_ID__c": "string",
    "Jira_Issue__c": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Name": "string",
    "OpportunityId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "StageName": "string",
    "SystemModstamp": "string"
}

schema_name_id: 1174
schema_scan_id: 161948297
updated: 2026-04-13 07:05:36

Version 1712040

created: 2026-04-12 07:07:03

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_jira_comment__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_jira_comment__cs`\n(\n `Id`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Jira_Issue__c`  string , `Author__c`  string , `Body__c`  string , `Jira_Comment_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/jira_comment__cs/2026-04-12/1775995619'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_jira_comment__cs"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/jira_comment__cs/2026-04-12/1775995619
id: 1712040
processed: 1

raw_data:

{
    "Author__c": 12,
    "Body__c": 13,
    "ConnectionReceivedId": 9,
    "ConnectionSentId": 10,
    "CreatedById": 5,
    "CreatedDate": 4,
    "CurrencyIsoCode": 3,
    "Id": 0,
    "IsDeleted": 1,
    "Jira_Comment_ID__c": 14,
    "Jira_Issue__c": 11,
    "LastModifiedById": 7,
    "LastModifiedDate": 6,
    "Name": 2,
    "SystemModstamp": 8
}

schema_attributes:

{
    "Amount": "string",
    "Author__c": "string",
    "Body__c": "string",
    "CloseDate": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "Id": "string",
    "IsDeleted": "string",
    "Jira_Comment_ID__c": "string",
    "Jira_Issue__c": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Name": "string",
    "OpportunityId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "StageName": "string",
    "SystemModstamp": "string"
}

schema_name_id: 1174
schema_scan_id: 161899520
updated: 2026-04-12 07:07:17

Version 1710846

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_jira_comment__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_jira_comment__cs`\n(\n `Id`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Jira_Issue__c`  string , `Author__c`  string , `Body__c`  string , `Jira_Comment_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/jira_comment__cs/2026-04-11/1775909031'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_jira_comment__cs"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/jira_comment__cs/2026-04-11/1775909031
id: 1710846
processed: 1

raw_data:

{
    "Author__c": 12,
    "Body__c": 13,
    "ConnectionReceivedId": 9,
    "ConnectionSentId": 10,
    "CreatedById": 5,
    "CreatedDate": 4,
    "CurrencyIsoCode": 3,
    "Id": 0,
    "IsDeleted": 1,
    "Jira_Comment_ID__c": 14,
    "Jira_Issue__c": 11,
    "LastModifiedById": 7,
    "LastModifiedDate": 6,
    "Name": 2,
    "SystemModstamp": 8
}

schema_attributes:

{
    "Amount": "string",
    "Author__c": "string",
    "Body__c": "string",
    "CloseDate": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "Id": "string",
    "IsDeleted": "string",
    "Jira_Comment_ID__c": "string",
    "Jira_Issue__c": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Name": "string",
    "OpportunityId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "StageName": "string",
    "SystemModstamp": "string"
}

schema_name_id: 1174
schema_scan_id: 161846854
updated: 2026-04-11 07:06:06

Version 1709669

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_jira_comment__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_jira_comment__cs`\n(\n `Id`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Jira_Issue__c`  string , `Author__c`  string , `Body__c`  string , `Jira_Comment_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/jira_comment__cs/2026-04-10/1775822724'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_jira_comment__cs"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/jira_comment__cs/2026-04-10/1775822724
id: 1709669
processed: 1

raw_data:

{
    "Author__c": 12,
    "Body__c": 13,
    "ConnectionReceivedId": 9,
    "ConnectionSentId": 10,
    "CreatedById": 5,
    "CreatedDate": 4,
    "CurrencyIsoCode": 3,
    "Id": 0,
    "IsDeleted": 1,
    "Jira_Comment_ID__c": 14,
    "Jira_Issue__c": 11,
    "LastModifiedById": 7,
    "LastModifiedDate": 6,
    "Name": 2,
    "SystemModstamp": 8
}

schema_attributes:

{
    "Amount": "string",
    "Author__c": "string",
    "Body__c": "string",
    "CloseDate": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "Id": "string",
    "IsDeleted": "string",
    "Jira_Comment_ID__c": "string",
    "Jira_Issue__c": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Name": "string",
    "OpportunityId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "StageName": "string",
    "SystemModstamp": "string"
}

schema_name_id: 1174
schema_scan_id: 161792069
updated: 2026-04-10 07:06:24

Version 1708540

created: 2026-04-09 07:07:30

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_jira_comment__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_jira_comment__cs`\n(\n `Id`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Jira_Issue__c`  string , `Author__c`  string , `Body__c`  string , `Jira_Comment_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/jira_comment__cs/2026-04-09/1775736311'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_jira_comment__cs"
]

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

raw_data:

{
    "Author__c": 12,
    "Body__c": 13,
    "ConnectionReceivedId": 9,
    "ConnectionSentId": 10,
    "CreatedById": 5,
    "CreatedDate": 4,
    "CurrencyIsoCode": 3,
    "Id": 0,
    "IsDeleted": 1,
    "Jira_Comment_ID__c": 14,
    "Jira_Issue__c": 11,
    "LastModifiedById": 7,
    "LastModifiedDate": 6,
    "Name": 2,
    "SystemModstamp": 8
}

schema_attributes:

{
    "Amount": "string",
    "Author__c": "string",
    "Body__c": "string",
    "CloseDate": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "Id": "string",
    "IsDeleted": "string",
    "Jira_Comment_ID__c": "string",
    "Jira_Issue__c": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Name": "string",
    "OpportunityId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "StageName": "string",
    "SystemModstamp": "string"
}

schema_name_id: 1174
schema_scan_id: 161736276
updated: 2026-04-09 07:07:41

Version 1707317

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_jira_comment__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_jira_comment__cs`\n(\n `Id`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Jira_Issue__c`  string , `Author__c`  string , `Body__c`  string , `Jira_Comment_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/jira_comment__cs/2026-04-08/1775649900'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_jira_comment__cs"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/jira_comment__cs/2026-04-08/1775649900
id: 1707317
processed: 1

raw_data:

{
    "Author__c": 12,
    "Body__c": 13,
    "ConnectionReceivedId": 9,
    "ConnectionSentId": 10,
    "CreatedById": 5,
    "CreatedDate": 4,
    "CurrencyIsoCode": 3,
    "Id": 0,
    "IsDeleted": 1,
    "Jira_Comment_ID__c": 14,
    "Jira_Issue__c": 11,
    "LastModifiedById": 7,
    "LastModifiedDate": 6,
    "Name": 2,
    "SystemModstamp": 8
}

schema_attributes:

{
    "Amount": "string",
    "Author__c": "string",
    "Body__c": "string",
    "CloseDate": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "Id": "string",
    "IsDeleted": "string",
    "Jira_Comment_ID__c": "string",
    "Jira_Issue__c": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Name": "string",
    "OpportunityId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "StageName": "string",
    "SystemModstamp": "string"
}

schema_name_id: 1174
schema_scan_id: 161681372
updated: 2026-04-08 07:05:51

Version 1706157

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_jira_comment__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_jira_comment__cs`\n(\n `Id`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Jira_Issue__c`  string , `Author__c`  string , `Body__c`  string , `Jira_Comment_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/jira_comment__cs/2026-04-07/1775563512'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_jira_comment__cs"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/jira_comment__cs/2026-04-07/1775563512
id: 1706157
processed: 1

raw_data:

{
    "Author__c": 12,
    "Body__c": 13,
    "ConnectionReceivedId": 9,
    "ConnectionSentId": 10,
    "CreatedById": 5,
    "CreatedDate": 4,
    "CurrencyIsoCode": 3,
    "Id": 0,
    "IsDeleted": 1,
    "Jira_Comment_ID__c": 14,
    "Jira_Issue__c": 11,
    "LastModifiedById": 7,
    "LastModifiedDate": 6,
    "Name": 2,
    "SystemModstamp": 8
}

schema_attributes:

{
    "Amount": "string",
    "Author__c": "string",
    "Body__c": "string",
    "CloseDate": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "Id": "string",
    "IsDeleted": "string",
    "Jira_Comment_ID__c": "string",
    "Jira_Issue__c": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Name": "string",
    "OpportunityId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "StageName": "string",
    "SystemModstamp": "string"
}

schema_name_id: 1174
schema_scan_id: 161625199
updated: 2026-04-07 07:07:07

Version 1704925

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_jira_comment__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_jira_comment__cs`\n(\n `Id`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Jira_Issue__c`  string , `Author__c`  string , `Body__c`  string , `Jira_Comment_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/jira_comment__cs/2026-04-06/1775477100'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_jira_comment__cs"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/jira_comment__cs/2026-04-06/1775477100
id: 1704925
processed: 1

raw_data:

{
    "Author__c": 12,
    "Body__c": 13,
    "ConnectionReceivedId": 9,
    "ConnectionSentId": 10,
    "CreatedById": 5,
    "CreatedDate": 4,
    "CurrencyIsoCode": 3,
    "Id": 0,
    "IsDeleted": 1,
    "Jira_Comment_ID__c": 14,
    "Jira_Issue__c": 11,
    "LastModifiedById": 7,
    "LastModifiedDate": 6,
    "Name": 2,
    "SystemModstamp": 8
}

schema_attributes:

{
    "Amount": "string",
    "Author__c": "string",
    "Body__c": "string",
    "CloseDate": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "Id": "string",
    "IsDeleted": "string",
    "Jira_Comment_ID__c": "string",
    "Jira_Issue__c": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Name": "string",
    "OpportunityId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "StageName": "string",
    "SystemModstamp": "string"
}

schema_name_id: 1174
schema_scan_id: 161567333
updated: 2026-04-06 07:09:19

Version 1703694

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_jira_comment__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_jira_comment__cs`\n(\n `Id`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Jira_Issue__c`  string , `Author__c`  string , `Body__c`  string , `Jira_Comment_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/jira_comment__cs/2026-04-05/1775390672'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_jira_comment__cs"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/jira_comment__cs/2026-04-05/1775390672
id: 1703694
processed: 1

raw_data:

{
    "Author__c": 12,
    "Body__c": 13,
    "ConnectionReceivedId": 9,
    "ConnectionSentId": 10,
    "CreatedById": 5,
    "CreatedDate": 4,
    "CurrencyIsoCode": 3,
    "Id": 0,
    "IsDeleted": 1,
    "Jira_Comment_ID__c": 14,
    "Jira_Issue__c": 11,
    "LastModifiedById": 7,
    "LastModifiedDate": 6,
    "Name": 2,
    "SystemModstamp": 8
}

schema_attributes:

{
    "Amount": "string",
    "Author__c": "string",
    "Body__c": "string",
    "CloseDate": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "Id": "string",
    "IsDeleted": "string",
    "Jira_Comment_ID__c": "string",
    "Jira_Issue__c": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Name": "string",
    "OpportunityId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "StageName": "string",
    "SystemModstamp": "string"
}

schema_name_id: 1174
schema_scan_id: 161519975
updated: 2026-04-05 07:05:38

Version 1702567

created: 2026-04-04 07:09:14

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_jira_comment__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_jira_comment__cs`\n(\n `Id`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Jira_Issue__c`  string , `Author__c`  string , `Body__c`  string , `Jira_Comment_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/jira_comment__cs/2026-04-04/1775304414'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_jira_comment__cs"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/jira_comment__cs/2026-04-04/1775304414
id: 1702567
processed: 1

raw_data:

{
    "Author__c": 12,
    "Body__c": 13,
    "ConnectionReceivedId": 9,
    "ConnectionSentId": 10,
    "CreatedById": 5,
    "CreatedDate": 4,
    "CurrencyIsoCode": 3,
    "Id": 0,
    "IsDeleted": 1,
    "Jira_Comment_ID__c": 14,
    "Jira_Issue__c": 11,
    "LastModifiedById": 7,
    "LastModifiedDate": 6,
    "Name": 2,
    "SystemModstamp": 8
}

schema_attributes:

{
    "Amount": "string",
    "Author__c": "string",
    "Body__c": "string",
    "CloseDate": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "Id": "string",
    "IsDeleted": "string",
    "Jira_Comment_ID__c": "string",
    "Jira_Issue__c": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Name": "string",
    "OpportunityId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "StageName": "string",
    "SystemModstamp": "string"
}

schema_name_id: 1174
schema_scan_id: 161466438
updated: 2026-04-04 07:09:25

Version 1701335

created: 2026-04-03 07:04:22

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_jira_comment__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_jira_comment__cs`\n(\n `Id`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Jira_Issue__c`  string , `Author__c`  string , `Body__c`  string , `Jira_Comment_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/jira_comment__cs/2026-04-03/1775217848'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_jira_comment__cs"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/jira_comment__cs/2026-04-03/1775217848
id: 1701335
processed: 1

raw_data:

{
    "Author__c": 12,
    "Body__c": 13,
    "ConnectionReceivedId": 9,
    "ConnectionSentId": 10,
    "CreatedById": 5,
    "CreatedDate": 4,
    "CurrencyIsoCode": 3,
    "Id": 0,
    "IsDeleted": 1,
    "Jira_Comment_ID__c": 14,
    "Jira_Issue__c": 11,
    "LastModifiedById": 7,
    "LastModifiedDate": 6,
    "Name": 2,
    "SystemModstamp": 8
}

schema_attributes:

{
    "Amount": "string",
    "Author__c": "string",
    "Body__c": "string",
    "CloseDate": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "Id": "string",
    "IsDeleted": "string",
    "Jira_Comment_ID__c": "string",
    "Jira_Issue__c": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Name": "string",
    "OpportunityId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "StageName": "string",
    "SystemModstamp": "string"
}

schema_name_id: 1174
schema_scan_id: 161408537
updated: 2026-04-03 07:04:33

Schema Scans: 15

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

Scan 162173076

duration: 0:00:14.796772

exit_message:

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

id: 162173076

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/jira_comment__cs/2026-04-17/1776427517",
        "key": "raw/jira_comment__cs/2026-04-17/1776427517/jira_comment__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_jira_comment__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 12267972017910802371,
        "service_name": "drive-thru",
        "span_id": 9401303022505367814,
        "trace_id": 9954808682320562338
    }
}

running: False
schema_name_id: 1174
start_time: 2026-04-17 07:06:59
success: True
trace_id: 9954808682320562338

Scan 162117358

duration: 0:00:14.916904

exit_message:

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

id: 162117358

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/jira_comment__cs/2026-04-16/1776341126",
        "key": "raw/jira_comment__cs/2026-04-16/1776341126/jira_comment__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_jira_comment__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 10720725348555248193,
        "service_name": "drive-thru",
        "span_id": 14026416891038079189,
        "trace_id": 2160062640590191691
    }
}

running: False
schema_name_id: 1174
start_time: 2026-04-16 07:07:03
success: True
trace_id: 2160062640590191691

Scan 162061820

duration: 0:00:12.286659

exit_message:

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

id: 162061820

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/jira_comment__cs/2026-04-15/1776254774",
        "key": "raw/jira_comment__cs/2026-04-15/1776254774/jira_comment__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_jira_comment__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 15722833774204373687,
        "service_name": "drive-thru",
        "span_id": 9358070179298496860,
        "trace_id": 4276710741777789005
    }
}

running: False
schema_name_id: 1174
start_time: 2026-04-15 07:11:00
success: True
trace_id: 4276710741777789005

Scan 162006391

duration: 0:00:12.280256

exit_message:

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

id: 162006391

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/jira_comment__cs/2026-04-14/1776168347",
        "key": "raw/jira_comment__cs/2026-04-14/1776168347/jira_comment__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_jira_comment__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 13958647411308836019,
        "service_name": "drive-thru",
        "span_id": 3707359841668744822,
        "trace_id": 283868539919287264
    }
}

running: False
schema_name_id: 1174
start_time: 2026-04-14 07:06:55
success: True
trace_id: 283868539919287264

Scan 161948297

duration: 0:00:12.172411

exit_message:

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

id: 161948297

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/jira_comment__cs/2026-04-13/1776081911",
        "key": "raw/jira_comment__cs/2026-04-13/1776081911/jira_comment__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_jira_comment__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 6925331089119549525,
        "service_name": "drive-thru",
        "span_id": 2068071958678995899,
        "trace_id": 10741643863021774391
    }
}

running: False
schema_name_id: 1174
start_time: 2026-04-13 07:05:24
success: True
trace_id: 10741643863021774391

Scan 161899520

duration: 0:00:14.704165

exit_message:

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

id: 161899520

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/jira_comment__cs/2026-04-12/1775995619",
        "key": "raw/jira_comment__cs/2026-04-12/1775995619/jira_comment__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_jira_comment__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 17360841644659739689,
        "service_name": "drive-thru",
        "span_id": 17593932838391696858,
        "trace_id": 6181825131634403562
    }
}

running: False
schema_name_id: 1174
start_time: 2026-04-12 07:07:02
success: True
trace_id: 6181825131634403562

Scan 161846854

duration: 0:00:14.623973

exit_message:

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

id: 161846854

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/jira_comment__cs/2026-04-11/1775909031",
        "key": "raw/jira_comment__cs/2026-04-11/1775909031/jira_comment__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_jira_comment__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 5147840042608426075,
        "service_name": "drive-thru",
        "span_id": 15036737779628799181,
        "trace_id": 13344657274163456925
    }
}

running: False
schema_name_id: 1174
start_time: 2026-04-11 07:05:51
success: True
trace_id: 13344657274163456925

Scan 161792069

duration: 0:00:12.155379

exit_message:

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

id: 161792069

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/jira_comment__cs/2026-04-10/1775822724",
        "key": "raw/jira_comment__cs/2026-04-10/1775822724/jira_comment__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_jira_comment__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 12451756352509770797,
        "service_name": "drive-thru",
        "span_id": 1500546816128813196,
        "trace_id": 1964808757789299292
    }
}

running: False
schema_name_id: 1174
start_time: 2026-04-10 07:06:12
success: True
trace_id: 1964808757789299292

Scan 161736276

duration: 0:00:12.204435

exit_message:

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

id: 161736276

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/jira_comment__cs/2026-04-09/1775736311",
        "key": "raw/jira_comment__cs/2026-04-09/1775736311/jira_comment__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_jira_comment__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 11884463567389410870,
        "service_name": "drive-thru",
        "span_id": 7165512441243512721,
        "trace_id": 1036290631307763665
    }
}

running: False
schema_name_id: 1174
start_time: 2026-04-09 07:07:29
success: True
trace_id: 1036290631307763665

Scan 161681372

duration: 0:00:12.330647

exit_message:

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

id: 161681372

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/jira_comment__cs/2026-04-08/1775649900",
        "key": "raw/jira_comment__cs/2026-04-08/1775649900/jira_comment__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_jira_comment__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 2391219756825840049,
        "service_name": "drive-thru",
        "span_id": 12047975816690088054,
        "trace_id": 8977011853451786545
    }
}

running: False
schema_name_id: 1174
start_time: 2026-04-08 07:05:39
success: True
trace_id: 8977011853451786545

Scan 161625199

duration: 0:00:12.154017

exit_message:

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

id: 161625199

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/jira_comment__cs/2026-04-07/1775563512",
        "key": "raw/jira_comment__cs/2026-04-07/1775563512/jira_comment__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_jira_comment__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 17021565366282834319,
        "service_name": "drive-thru",
        "span_id": 5759340142893004557,
        "trace_id": 9245780670556009047
    }
}

running: False
schema_name_id: 1174
start_time: 2026-04-07 07:06:55
success: True
trace_id: 9245780670556009047

Scan 161567333

duration: 0:00:14.758103

exit_message:

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

id: 161567333

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/jira_comment__cs/2026-04-06/1775477100",
        "key": "raw/jira_comment__cs/2026-04-06/1775477100/jira_comment__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_jira_comment__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 14968570505370510364,
        "service_name": "drive-thru",
        "span_id": 7456659634319497575,
        "trace_id": 7574397882027696634
    }
}

running: False
schema_name_id: 1174
start_time: 2026-04-06 07:09:05
success: True
trace_id: 7574397882027696634

Scan 161519975

duration: 0:00:14.553733

exit_message:

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

id: 161519975

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/jira_comment__cs/2026-04-05/1775390672",
        "key": "raw/jira_comment__cs/2026-04-05/1775390672/jira_comment__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_jira_comment__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 13628852015585366941,
        "service_name": "drive-thru",
        "span_id": 16380330293302777696,
        "trace_id": 2443175176729819088
    }
}

running: False
schema_name_id: 1174
start_time: 2026-04-05 07:05:24
success: True
trace_id: 2443175176729819088

Scan 161466438

duration: 0:00:12.063858

exit_message:

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

id: 161466438

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/jira_comment__cs/2026-04-04/1775304414",
        "key": "raw/jira_comment__cs/2026-04-04/1775304414/jira_comment__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_jira_comment__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 1067291462936571495,
        "service_name": "drive-thru",
        "span_id": 7981522673603865193,
        "trace_id": 11930633501518965329
    }
}

running: False
schema_name_id: 1174
start_time: 2026-04-04 07:09:13
success: True
trace_id: 11930633501518965329

Scan 161408537

duration: 0:00:12.268884

exit_message:

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

id: 161408537

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/jira_comment__cs/2026-04-03/1775217848",
        "key": "raw/jira_comment__cs/2026-04-03/1775217848/jira_comment__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_jira_comment__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 7001814408215733742,
        "service_name": "drive-thru",
        "span_id": 8601826026584056008,
        "trace_id": 15247733260336979626
    }
}

running: False
schema_name_id: 1174
start_time: 2026-04-03 07:04:21
success: True
trace_id: 15247733260336979626

Partitions:

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

Schema:

attributes:

{
    "Amount": "string",
    "Author__c": "string",
    "Body__c": "string",
    "CloseDate": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "Id": "string",
    "IsDeleted": "string",
    "Jira_Comment_ID__c": "string",
    "Jira_Issue__c": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Name": "string",
    "OpportunityId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "StageName": "string",
    "SystemModstamp": "string"
}

created: 2026-04-17 07:07:00

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_jira_comment__cs`\n(\n `Id`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Jira_Issue__c`  string , `Author__c`  string , `Body__c`  string , `Jira_Comment_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/jira_comment__cs/2026-04-17/1776427517'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_jira_comment__cs`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_jira_comment__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:03",
        "disabled": false,
        "format": "raw",
        "id": 1174,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_csv",
            "table": "salesforce_jira_comment__cs"
        },
        "type": "csv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "Amount": "string",
            "Author__c": "string",
            "Body__c": "string",
            "CloseDate": "string",
            "ConnectionReceivedId": "string",
            "ConnectionSentId": "string",
            "CreatedById": "string",
            "CreatedDate": "string",
            "CurrencyIsoCode": "string",
            "ExpectedRevenue": "string",
            "ForecastCategory": "string",
            "Id": "string",
            "IsDeleted": "string",
            "Jira_Comment_ID__c": "string",
            "Jira_Issue__c": "string",
            "LastModifiedById": "string",
            "LastModifiedDate": "string",
            "Name": "string",
            "OpportunityId": "string",
            "PrevAmount": "string",
            "PrevCloseDate": "string",
            "Probability": "string",
            "StageName": "string",
            "SystemModstamp": "string"
        },
        "created": "2026-04-17 07:07:00",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_jira_comment__cs`\n(\n `Id`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Jira_Issue__c`  string , `Author__c`  string , `Body__c`  string , `Jira_Comment_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/jira_comment__cs/2026-04-17/1776427517'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_jira_comment__cs`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_jira_comment__cs"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}