Schema Info
Schema Name: sfdl_dev_csv.salesforce_dsfs__docu_sign_status__cs
- created: 2022-10-24 14:52:19
- disabled: False
- format: raw
- id: 2059
- is_partitioned: False
- is_schema_datatyped: True
- name:
{ "database": "sfdl_dev_csv", "table": "salesforce_dsfs__docu_sign_status__cs" } - type: csv
Schema Versions: 5
-
Version 4706459
- created: 2024-06-10 15:33:28
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`", "DROP TABLE IF EXISTS `sfdl_dev_csv.salesforce_dsfs__docu_sign_status__cs`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.salesforce_dsfs__docu_sign_status__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 , `dsfs__Case__c` string , `dsfs__Company__c` string , `dsfs__Completed_Date_Time__c` string , `dsfs__Contact__c` string , `dsfs__Contract__c` string , `dsfs__Declined_Date_Time__c` string , `dsfs__Declined_Reason__c` string , `dsfs__DocuSign_Envelope_ID__c` string , `dsfs__Envelope_Link__c` string , `dsfs__Envelope_Status__c` string , `dsfs__Lead__c` string , `dsfs__Opportunity__c` string , `dsfs__Sender_Email__c` string , `dsfs__Sender__c` string , `dsfs__Sent_Date_Time__c` string , `dsfs__Subject__c` string , `dsfs__Viewed_Date_Time__c` string , `dsfs__Voided_Date_Time__c` string , `dsfs__Voided_Reason__c` string , `NewMerchantProfile__c` string , `dsfs__Declined_Reason_Extended__c` string , `dsfs__Voided_Reason_Extended__c` string , `dsfs__EnvelopeConfiguration__c` string , `CongaTemplateID__c` string , `FormResponseId__c` string , `AttachmentCount__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-dev/raw/dsfs__docu_sign_status__cs/2024-06-10/1718051362'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_csv.salesforce_dsfs__docu_sign_status__cs" ] - hive_path: s3://sfdl-csv-salesforce-dev/raw/dsfs__docu_sign_status__cs/2024-06-10/1718051362
- id: 4706459
- processed: 1
- raw_data:
{ "AttachmentCount__c": 38, "CongaTemplateID__c": 36, "ConnectionReceivedId": 11, "ConnectionSentId": 12, "CreatedById": 6, "CreatedDate": 5, "CurrencyIsoCode": 4, "FormResponseId__c": 37, "Id": 0, "IsDeleted": 2, "LastActivityDate": 10, "LastModifiedById": 8, "LastModifiedDate": 7, "Name": 3, "NewMerchantProfile__c": 32, "OwnerId": 1, "SystemModstamp": 9, "dsfs__Case__c": 13, "dsfs__Company__c": 14, "dsfs__Completed_Date_Time__c": 15, "dsfs__Contact__c": 16, "dsfs__Contract__c": 17, "dsfs__Declined_Date_Time__c": 18, "dsfs__Declined_Reason_Extended__c": 33, "dsfs__Declined_Reason__c": 19, "dsfs__DocuSign_Envelope_ID__c": 20, "dsfs__EnvelopeConfiguration__c": 35, "dsfs__Envelope_Link__c": 21, "dsfs__Envelope_Status__c": 22, "dsfs__Lead__c": 23, "dsfs__Opportunity__c": 24, "dsfs__Sender_Email__c": 25, "dsfs__Sender__c": 26, "dsfs__Sent_Date_Time__c": 27, "dsfs__Subject__c": 28, "dsfs__Viewed_Date_Time__c": 29, "dsfs__Voided_Date_Time__c": 30, "dsfs__Voided_Reason_Extended__c": 34, "dsfs__Voided_Reason__c": 31 } - schema_attributes:
{ "Amount": "string", "AttachmentCount__c": "string", "CloseDate": "string", "CongaTemplateID__c": "string", "ConnectionReceivedId": "string", "ConnectionSentId": "string", "CreatedById": "string", "CreatedDate": "string", "CurrencyIsoCode": "string", "ExpectedRevenue": "string", "ForecastCategory": "string", "FormResponseId__c": "string", "Id": "string", "IsDeleted": "string", "LastActivityDate": "string", "LastModifiedById": "string", "LastModifiedDate": "string", "Name": "string", "NewMerchantProfile__c": "string", "OpportunityId": "string", "OwnerId": "string", "PrevAmount": "string", "PrevCloseDate": "string", "Probability": "string", "StageName": "string", "SystemModstamp": "string", "dsfs__Case__c": "string", "dsfs__Company__c": "string", "dsfs__Completed_Date_Time__c": "string", "dsfs__Contact__c": "string", "dsfs__Contract__c": "string", "dsfs__Declined_Date_Time__c": "string", "dsfs__Declined_Reason_Extended__c": "string", "dsfs__Declined_Reason__c": "string", "dsfs__DocuSign_Envelope_ID__c": "string", "dsfs__EnvelopeConfiguration__c": "string", "dsfs__Envelope_Link__c": "string", "dsfs__Envelope_Status__c": "string", "dsfs__Lead__c": "string", "dsfs__Opportunity__c": "string", "dsfs__Sender_Email__c": "string", "dsfs__Sender__c": "string", "dsfs__Sent_Date_Time__c": "string", "dsfs__Subject__c": "string", "dsfs__Viewed_Date_Time__c": "string", "dsfs__Voided_Date_Time__c": "string", "dsfs__Voided_Reason_Extended__c": "string", "dsfs__Voided_Reason__c": "string" } - schema_name_id: 2059
- schema_scan_id: 6510714
- updated: 2024-06-10 15:33:42
-
Version 4700482
- created: 2024-01-11 09:10:28
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`", "DROP TABLE IF EXISTS `sfdl_dev_csv.salesforce_dsfs__docu_sign_status__cs`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.salesforce_dsfs__docu_sign_status__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 , `dsfs__Case__c` string , `dsfs__Company__c` string , `dsfs__Completed_Date_Time__c` string , `dsfs__Contact__c` string , `dsfs__Contract__c` string , `dsfs__Declined_Date_Time__c` string , `dsfs__Declined_Reason__c` string , `dsfs__DocuSign_Envelope_ID__c` string , `dsfs__Envelope_Link__c` string , `dsfs__Envelope_Status__c` string , `dsfs__Lead__c` string , `dsfs__Opportunity__c` string , `dsfs__Sender_Email__c` string , `dsfs__Sender__c` string , `dsfs__Sent_Date_Time__c` string , `dsfs__Subject__c` string , `dsfs__Viewed_Date_Time__c` string , `dsfs__Voided_Date_Time__c` string , `dsfs__Voided_Reason__c` string , `NewMerchantProfile__c` string , `dsfs__Declined_Reason_Extended__c` string , `dsfs__Voided_Reason_Extended__c` string , `dsfs__EnvelopeConfiguration__c` string , `CongaTemplateID__c` string , `FormResponseId__c` string , `AttachmentCount__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-dev/raw/dsfs__docu_sign_status__cs/2024-01-11/1704985700'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_csv.salesforce_dsfs__docu_sign_status__cs" ] - hive_path: s3://sfdl-csv-salesforce-dev/raw/dsfs__docu_sign_status__cs/2024-01-11/1704985700
- id: 4700482
- processed: 1
- raw_data:
{ "AttachmentCount__c": 38, "CongaTemplateID__c": 36, "ConnectionReceivedId": 11, "ConnectionSentId": 12, "CreatedById": 6, "CreatedDate": 5, "CurrencyIsoCode": 4, "FormResponseId__c": 37, "Id": 0, "IsDeleted": 2, "LastActivityDate": 10, "LastModifiedById": 8, "LastModifiedDate": 7, "Name": 3, "NewMerchantProfile__c": 32, "OwnerId": 1, "SystemModstamp": 9, "dsfs__Case__c": 13, "dsfs__Company__c": 14, "dsfs__Completed_Date_Time__c": 15, "dsfs__Contact__c": 16, "dsfs__Contract__c": 17, "dsfs__Declined_Date_Time__c": 18, "dsfs__Declined_Reason_Extended__c": 33, "dsfs__Declined_Reason__c": 19, "dsfs__DocuSign_Envelope_ID__c": 20, "dsfs__EnvelopeConfiguration__c": 35, "dsfs__Envelope_Link__c": 21, "dsfs__Envelope_Status__c": 22, "dsfs__Lead__c": 23, "dsfs__Opportunity__c": 24, "dsfs__Sender_Email__c": 25, "dsfs__Sender__c": 26, "dsfs__Sent_Date_Time__c": 27, "dsfs__Subject__c": 28, "dsfs__Viewed_Date_Time__c": 29, "dsfs__Voided_Date_Time__c": 30, "dsfs__Voided_Reason_Extended__c": 34, "dsfs__Voided_Reason__c": 31 } - schema_attributes:
{ "Amount": "string", "AttachmentCount__c": "string", "CloseDate": "string", "CongaTemplateID__c": "string", "ConnectionReceivedId": "string", "ConnectionSentId": "string", "CreatedById": "string", "CreatedDate": "string", "CurrencyIsoCode": "string", "ExpectedRevenue": "string", "ForecastCategory": "string", "FormResponseId__c": "string", "Id": "string", "IsDeleted": "string", "LastActivityDate": "string", "LastModifiedById": "string", "LastModifiedDate": "string", "Name": "string", "NewMerchantProfile__c": "string", "OpportunityId": "string", "OwnerId": "string", "PrevAmount": "string", "PrevCloseDate": "string", "Probability": "string", "StageName": "string", "SystemModstamp": "string", "dsfs__Case__c": "string", "dsfs__Company__c": "string", "dsfs__Completed_Date_Time__c": "string", "dsfs__Contact__c": "string", "dsfs__Contract__c": "string", "dsfs__Declined_Date_Time__c": "string", "dsfs__Declined_Reason_Extended__c": "string", "dsfs__Declined_Reason__c": "string", "dsfs__DocuSign_Envelope_ID__c": "string", "dsfs__EnvelopeConfiguration__c": "string", "dsfs__Envelope_Link__c": "string", "dsfs__Envelope_Status__c": "string", "dsfs__Lead__c": "string", "dsfs__Opportunity__c": "string", "dsfs__Sender_Email__c": "string", "dsfs__Sender__c": "string", "dsfs__Sent_Date_Time__c": "string", "dsfs__Subject__c": "string", "dsfs__Viewed_Date_Time__c": "string", "dsfs__Voided_Date_Time__c": "string", "dsfs__Voided_Reason_Extended__c": "string", "dsfs__Voided_Reason__c": "string" } - schema_name_id: 2059
- schema_scan_id: 6402620
- updated: 2024-01-11 09:10:42
-
Version 4697506
- created: 2023-08-16 11:16:04
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`", "DROP TABLE IF EXISTS `sfdl_dev_csv.salesforce_dsfs__docu_sign_status__cs`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.salesforce_dsfs__docu_sign_status__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 , `dsfs__Case__c` string , `dsfs__Company__c` string , `dsfs__Completed_Date_Time__c` string , `dsfs__Contact__c` string , `dsfs__Contract__c` string , `dsfs__Declined_Date_Time__c` string , `dsfs__Declined_Reason__c` string , `dsfs__DocuSign_Envelope_ID__c` string , `dsfs__Envelope_Link__c` string , `dsfs__Envelope_Status__c` string , `dsfs__Lead__c` string , `dsfs__Opportunity__c` string , `dsfs__Sender_Email__c` string , `dsfs__Sender__c` string , `dsfs__Sent_Date_Time__c` string , `dsfs__Subject__c` string , `dsfs__Viewed_Date_Time__c` string , `dsfs__Voided_Date_Time__c` string , `dsfs__Voided_Reason__c` string , `NewMerchantProfile__c` string , `dsfs__Declined_Reason_Extended__c` string , `dsfs__Voided_Reason_Extended__c` string , `dsfs__EnvelopeConfiguration__c` string , `CongaTemplateID__c` string , `FormResponseId__c` string , `AttachmentCount__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-dev/raw/dsfs__docu_sign_status__cs/2023-08-16/1692202316'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_csv.salesforce_dsfs__docu_sign_status__cs" ] - hive_path: s3://sfdl-csv-salesforce-dev/raw/dsfs__docu_sign_status__cs/2023-08-16/1692202316
- id: 4697506
- processed: 1
- raw_data:
{ "AttachmentCount__c": 38, "CongaTemplateID__c": 36, "ConnectionReceivedId": 11, "ConnectionSentId": 12, "CreatedById": 6, "CreatedDate": 5, "CurrencyIsoCode": 4, "FormResponseId__c": 37, "Id": 0, "IsDeleted": 2, "LastActivityDate": 10, "LastModifiedById": 8, "LastModifiedDate": 7, "Name": 3, "NewMerchantProfile__c": 32, "OwnerId": 1, "SystemModstamp": 9, "dsfs__Case__c": 13, "dsfs__Company__c": 14, "dsfs__Completed_Date_Time__c": 15, "dsfs__Contact__c": 16, "dsfs__Contract__c": 17, "dsfs__Declined_Date_Time__c": 18, "dsfs__Declined_Reason_Extended__c": 33, "dsfs__Declined_Reason__c": 19, "dsfs__DocuSign_Envelope_ID__c": 20, "dsfs__EnvelopeConfiguration__c": 35, "dsfs__Envelope_Link__c": 21, "dsfs__Envelope_Status__c": 22, "dsfs__Lead__c": 23, "dsfs__Opportunity__c": 24, "dsfs__Sender_Email__c": 25, "dsfs__Sender__c": 26, "dsfs__Sent_Date_Time__c": 27, "dsfs__Subject__c": 28, "dsfs__Viewed_Date_Time__c": 29, "dsfs__Voided_Date_Time__c": 30, "dsfs__Voided_Reason_Extended__c": 34, "dsfs__Voided_Reason__c": 31 } - schema_attributes:
{ "Amount": "string", "AttachmentCount__c": "string", "CloseDate": "string", "CongaTemplateID__c": "string", "ConnectionReceivedId": "string", "ConnectionSentId": "string", "CreatedById": "string", "CreatedDate": "string", "CurrencyIsoCode": "string", "ExpectedRevenue": "string", "ForecastCategory": "string", "FormResponseId__c": "string", "Id": "string", "IsDeleted": "string", "LastActivityDate": "string", "LastModifiedById": "string", "LastModifiedDate": "string", "Name": "string", "NewMerchantProfile__c": "string", "OpportunityId": "string", "OwnerId": "string", "PrevAmount": "string", "PrevCloseDate": "string", "Probability": "string", "StageName": "string", "SystemModstamp": "string", "dsfs__Case__c": "string", "dsfs__Company__c": "string", "dsfs__Completed_Date_Time__c": "string", "dsfs__Contact__c": "string", "dsfs__Contract__c": "string", "dsfs__Declined_Date_Time__c": "string", "dsfs__Declined_Reason_Extended__c": "string", "dsfs__Declined_Reason__c": "string", "dsfs__DocuSign_Envelope_ID__c": "string", "dsfs__EnvelopeConfiguration__c": "string", "dsfs__Envelope_Link__c": "string", "dsfs__Envelope_Status__c": "string", "dsfs__Lead__c": "string", "dsfs__Opportunity__c": "string", "dsfs__Sender_Email__c": "string", "dsfs__Sender__c": "string", "dsfs__Sent_Date_Time__c": "string", "dsfs__Subject__c": "string", "dsfs__Viewed_Date_Time__c": "string", "dsfs__Voided_Date_Time__c": "string", "dsfs__Voided_Reason_Extended__c": "string", "dsfs__Voided_Reason__c": "string" } - schema_name_id: 2059
- schema_scan_id: 6251512
- updated: 2023-08-16 11:16:15
-
Version 4697443
- created: 2023-08-16 10:29:21
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`", "DROP TABLE IF EXISTS `sfdl_dev_csv.salesforce_dsfs__docu_sign_status__cs`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.salesforce_dsfs__docu_sign_status__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 , `dsfs__Case__c` string , `dsfs__Company__c` string , `dsfs__Completed_Date_Time__c` string , `dsfs__Contact__c` string , `dsfs__Contract__c` string , `dsfs__Declined_Date_Time__c` string , `dsfs__Declined_Reason__c` string , `dsfs__DocuSign_Envelope_ID__c` string , `dsfs__Envelope_Link__c` string , `dsfs__Envelope_Status__c` string , `dsfs__Lead__c` string , `dsfs__Opportunity__c` string , `dsfs__Sender_Email__c` string , `dsfs__Sender__c` string , `dsfs__Sent_Date_Time__c` string , `dsfs__Subject__c` string , `dsfs__Viewed_Date_Time__c` string , `dsfs__Voided_Date_Time__c` string , `dsfs__Voided_Reason__c` string , `NewMerchantProfile__c` string , `dsfs__Declined_Reason_Extended__c` string , `dsfs__Voided_Reason_Extended__c` string , `dsfs__EnvelopeConfiguration__c` string , `CongaTemplateID__c` string , `FormResponseId__c` string , `AttachmentCount__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-dev/raw/dsfs__docu_sign_status__cs/2023-08-16/1692199569'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_csv.salesforce_dsfs__docu_sign_status__cs" ] - hive_path: s3://sfdl-csv-salesforce-dev/raw/dsfs__docu_sign_status__cs/2023-08-16/1692199569
- id: 4697443
- processed: 1
- raw_data:
{ "AttachmentCount__c": 38, "CongaTemplateID__c": 36, "ConnectionReceivedId": 11, "ConnectionSentId": 12, "CreatedById": 6, "CreatedDate": 5, "CurrencyIsoCode": 4, "FormResponseId__c": 37, "Id": 0, "IsDeleted": 2, "LastActivityDate": 10, "LastModifiedById": 8, "LastModifiedDate": 7, "Name": 3, "NewMerchantProfile__c": 32, "OwnerId": 1, "SystemModstamp": 9, "dsfs__Case__c": 13, "dsfs__Company__c": 14, "dsfs__Completed_Date_Time__c": 15, "dsfs__Contact__c": 16, "dsfs__Contract__c": 17, "dsfs__Declined_Date_Time__c": 18, "dsfs__Declined_Reason_Extended__c": 33, "dsfs__Declined_Reason__c": 19, "dsfs__DocuSign_Envelope_ID__c": 20, "dsfs__EnvelopeConfiguration__c": 35, "dsfs__Envelope_Link__c": 21, "dsfs__Envelope_Status__c": 22, "dsfs__Lead__c": 23, "dsfs__Opportunity__c": 24, "dsfs__Sender_Email__c": 25, "dsfs__Sender__c": 26, "dsfs__Sent_Date_Time__c": 27, "dsfs__Subject__c": 28, "dsfs__Viewed_Date_Time__c": 29, "dsfs__Voided_Date_Time__c": 30, "dsfs__Voided_Reason_Extended__c": 34, "dsfs__Voided_Reason__c": 31 } - schema_attributes:
{ "Amount": "string", "AttachmentCount__c": "string", "CloseDate": "string", "CongaTemplateID__c": "string", "ConnectionReceivedId": "string", "ConnectionSentId": "string", "CreatedById": "string", "CreatedDate": "string", "CurrencyIsoCode": "string", "ExpectedRevenue": "string", "ForecastCategory": "string", "FormResponseId__c": "string", "Id": "string", "IsDeleted": "string", "LastActivityDate": "string", "LastModifiedById": "string", "LastModifiedDate": "string", "Name": "string", "NewMerchantProfile__c": "string", "OpportunityId": "string", "OwnerId": "string", "PrevAmount": "string", "PrevCloseDate": "string", "Probability": "string", "StageName": "string", "SystemModstamp": "string", "dsfs__Case__c": "string", "dsfs__Company__c": "string", "dsfs__Completed_Date_Time__c": "string", "dsfs__Contact__c": "string", "dsfs__Contract__c": "string", "dsfs__Declined_Date_Time__c": "string", "dsfs__Declined_Reason_Extended__c": "string", "dsfs__Declined_Reason__c": "string", "dsfs__DocuSign_Envelope_ID__c": "string", "dsfs__EnvelopeConfiguration__c": "string", "dsfs__Envelope_Link__c": "string", "dsfs__Envelope_Status__c": "string", "dsfs__Lead__c": "string", "dsfs__Opportunity__c": "string", "dsfs__Sender_Email__c": "string", "dsfs__Sender__c": "string", "dsfs__Sent_Date_Time__c": "string", "dsfs__Subject__c": "string", "dsfs__Viewed_Date_Time__c": "string", "dsfs__Voided_Date_Time__c": "string", "dsfs__Voided_Reason_Extended__c": "string", "dsfs__Voided_Reason__c": "string" } - schema_name_id: 2059
- schema_scan_id: 6251370
- updated: 2023-08-16 10:29:33
-
Version 4697380
- created: 2023-08-16 09:28:44
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`", "DROP TABLE IF EXISTS `sfdl_dev_csv.salesforce_dsfs__docu_sign_status__cs`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.salesforce_dsfs__docu_sign_status__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 , `dsfs__Case__c` string , `dsfs__Company__c` string , `dsfs__Completed_Date_Time__c` string , `dsfs__Contact__c` string , `dsfs__Contract__c` string , `dsfs__Declined_Date_Time__c` string , `dsfs__Declined_Reason__c` string , `dsfs__DocuSign_Envelope_ID__c` string , `dsfs__Envelope_Link__c` string , `dsfs__Envelope_Status__c` string , `dsfs__Lead__c` string , `dsfs__Opportunity__c` string , `dsfs__Sender_Email__c` string , `dsfs__Sender__c` string , `dsfs__Sent_Date_Time__c` string , `dsfs__Subject__c` string , `dsfs__Viewed_Date_Time__c` string , `dsfs__Voided_Date_Time__c` string , `dsfs__Voided_Reason__c` string , `NewMerchantProfile__c` string , `dsfs__Declined_Reason_Extended__c` string , `dsfs__Voided_Reason_Extended__c` string , `dsfs__EnvelopeConfiguration__c` string , `CongaTemplateID__c` string , `FormResponseId__c` string , `AttachmentCount__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-dev/raw/dsfs__docu_sign_status__cs/2023-08-16/1692195969'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_csv.salesforce_dsfs__docu_sign_status__cs" ] - hive_path: s3://sfdl-csv-salesforce-dev/raw/dsfs__docu_sign_status__cs/2023-08-16/1692195969
- id: 4697380
- processed: 1
- raw_data:
{ "AttachmentCount__c": 38, "CongaTemplateID__c": 36, "ConnectionReceivedId": 11, "ConnectionSentId": 12, "CreatedById": 6, "CreatedDate": 5, "CurrencyIsoCode": 4, "FormResponseId__c": 37, "Id": 0, "IsDeleted": 2, "LastActivityDate": 10, "LastModifiedById": 8, "LastModifiedDate": 7, "Name": 3, "NewMerchantProfile__c": 32, "OwnerId": 1, "SystemModstamp": 9, "dsfs__Case__c": 13, "dsfs__Company__c": 14, "dsfs__Completed_Date_Time__c": 15, "dsfs__Contact__c": 16, "dsfs__Contract__c": 17, "dsfs__Declined_Date_Time__c": 18, "dsfs__Declined_Reason_Extended__c": 33, "dsfs__Declined_Reason__c": 19, "dsfs__DocuSign_Envelope_ID__c": 20, "dsfs__EnvelopeConfiguration__c": 35, "dsfs__Envelope_Link__c": 21, "dsfs__Envelope_Status__c": 22, "dsfs__Lead__c": 23, "dsfs__Opportunity__c": 24, "dsfs__Sender_Email__c": 25, "dsfs__Sender__c": 26, "dsfs__Sent_Date_Time__c": 27, "dsfs__Subject__c": 28, "dsfs__Viewed_Date_Time__c": 29, "dsfs__Voided_Date_Time__c": 30, "dsfs__Voided_Reason_Extended__c": 34, "dsfs__Voided_Reason__c": 31 } - schema_attributes:
{ "Amount": "string", "AttachmentCount__c": "string", "CloseDate": "string", "CongaTemplateID__c": "string", "ConnectionReceivedId": "string", "ConnectionSentId": "string", "CreatedById": "string", "CreatedDate": "string", "CurrencyIsoCode": "string", "ExpectedRevenue": "string", "ForecastCategory": "string", "FormResponseId__c": "string", "Id": "string", "IsDeleted": "string", "LastActivityDate": "string", "LastModifiedById": "string", "LastModifiedDate": "string", "Name": "string", "NewMerchantProfile__c": "string", "OpportunityId": "string", "OwnerId": "string", "PrevAmount": "string", "PrevCloseDate": "string", "Probability": "string", "StageName": "string", "SystemModstamp": "string", "dsfs__Case__c": "string", "dsfs__Company__c": "string", "dsfs__Completed_Date_Time__c": "string", "dsfs__Contact__c": "string", "dsfs__Contract__c": "string", "dsfs__Declined_Date_Time__c": "string", "dsfs__Declined_Reason_Extended__c": "string", "dsfs__Declined_Reason__c": "string", "dsfs__DocuSign_Envelope_ID__c": "string", "dsfs__EnvelopeConfiguration__c": "string", "dsfs__Envelope_Link__c": "string", "dsfs__Envelope_Status__c": "string", "dsfs__Lead__c": "string", "dsfs__Opportunity__c": "string", "dsfs__Sender_Email__c": "string", "dsfs__Sender__c": "string", "dsfs__Sent_Date_Time__c": "string", "dsfs__Subject__c": "string", "dsfs__Viewed_Date_Time__c": "string", "dsfs__Voided_Date_Time__c": "string", "dsfs__Voided_Reason_Extended__c": "string", "dsfs__Voided_Reason__c": "string" } - schema_name_id: 2059
- schema_scan_id: 6251264
- updated: 2023-08-16 09:28:56
Schema Scans: 5
Last at 2024-06-10 15:33:27
-
Scan 6510714
- duration: 0:00:15.359487
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6510714
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-csv-salesforce-dev", "hive_path": "s3://sfdl-csv-salesforce-dev/raw/dsfs__docu_sign_status__cs/2024-06-10/1718051362", "key": "raw/dsfs__docu_sign_status__cs/2024-06-10/1718051362/dsfs__docu_sign_status__cs.csv.gz" }, "schema": { "name": "sfdl_dev_csv.salesforce_dsfs__docu_sign_status__cs", "type": "csv" }, "trace_context": { "parent_id": 16385387801005615664, "service_name": "drive-thru", "span_id": 9849807916873207435, "trace_id": 13663704221587147827 } } - running: False
- schema_name_id: 2059
- start_time: 2024-06-10 15:33:27
- success: True
- trace_id: 13663704221587147827
-
Scan 6402620
- duration: 0:00:15.264310
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6402620
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-csv-salesforce-dev", "hive_path": "s3://sfdl-csv-salesforce-dev/raw/dsfs__docu_sign_status__cs/2024-01-11/1704985700", "key": "raw/dsfs__docu_sign_status__cs/2024-01-11/1704985700/dsfs__docu_sign_status__cs.csv.gz" }, "schema": { "name": "sfdl_dev_csv.salesforce_dsfs__docu_sign_status__cs", "type": "csv" }, "trace_context": { "parent_id": 17081864950129259102, "service_name": "drive-thru", "span_id": 11833144189929100467, "trace_id": 14488567320841428879 } } - running: False
- schema_name_id: 2059
- start_time: 2024-01-11 09:10:27
- success: True
- trace_id: 14488567320841428879
-
Scan 6251512
- duration: 0:00:12.795831
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6251512
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-csv-salesforce-dev", "hive_path": "s3://sfdl-csv-salesforce-dev/raw/dsfs__docu_sign_status__cs/2023-08-16/1692202316", "key": "raw/dsfs__docu_sign_status__cs/2023-08-16/1692202316/dsfs__docu_sign_status__cs.csv.gz" }, "schema": { "name": "sfdl_dev_csv.salesforce_dsfs__docu_sign_status__cs", "type": "csv" }, "trace_context": { "parent_id": 7618224439194854857, "service_name": "drive-thru", "span_id": 17605696120981983397, "trace_id": 5687131581229844237 } } - running: False
- schema_name_id: 2059
- start_time: 2023-08-16 11:16:03
- success: True
- trace_id: 5687131581229844237
-
Scan 6251370
- duration: 0:00:12.749061
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6251370
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-csv-salesforce-dev", "hive_path": "s3://sfdl-csv-salesforce-dev/raw/dsfs__docu_sign_status__cs/2023-08-16/1692199569", "key": "raw/dsfs__docu_sign_status__cs/2023-08-16/1692199569/dsfs__docu_sign_status__cs.csv.gz" }, "schema": { "name": "sfdl_dev_csv.salesforce_dsfs__docu_sign_status__cs", "type": "csv" }, "trace_context": { "parent_id": 11817505799700794310, "service_name": "drive-thru", "span_id": 13724372566936434906, "trace_id": 14637011551811027863 } } - running: False
- schema_name_id: 2059
- start_time: 2023-08-16 10:29:20
- success: True
- trace_id: 14637011551811027863
-
Scan 6251264
- duration: 0:00:12.864516
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6251264
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-csv-salesforce-dev", "hive_path": "s3://sfdl-csv-salesforce-dev/raw/dsfs__docu_sign_status__cs/2023-08-16/1692195969", "key": "raw/dsfs__docu_sign_status__cs/2023-08-16/1692195969/dsfs__docu_sign_status__cs.csv.gz" }, "schema": { "name": "sfdl_dev_csv.salesforce_dsfs__docu_sign_status__cs", "type": "csv" }, "trace_context": { "parent_id": 16001503585608667214, "service_name": "drive-thru", "span_id": 15986830740076659703, "trace_id": 3235899009120195670 } } - running: False
- schema_name_id: 2059
- start_time: 2023-08-16 09:28:43
- success: True
- trace_id: 3235899009120195670
- attributes:
{ "Amount": "string", "AttachmentCount__c": "string", "CloseDate": "string", "CongaTemplateID__c": "string", "ConnectionReceivedId": "string", "ConnectionSentId": "string", "CreatedById": "string", "CreatedDate": "string", "CurrencyIsoCode": "string", "ExpectedRevenue": "string", "ForecastCategory": "string", "FormResponseId__c": "string", "Id": "string", "IsDeleted": "string", "LastActivityDate": "string", "LastModifiedById": "string", "LastModifiedDate": "string", "Name": "string", "NewMerchantProfile__c": "string", "OpportunityId": "string", "OwnerId": "string", "PrevAmount": "string", "PrevCloseDate": "string", "Probability": "string", "StageName": "string", "SystemModstamp": "string", "dsfs__Case__c": "string", "dsfs__Company__c": "string", "dsfs__Completed_Date_Time__c": "string", "dsfs__Contact__c": "string", "dsfs__Contract__c": "string", "dsfs__Declined_Date_Time__c": "string", "dsfs__Declined_Reason_Extended__c": "string", "dsfs__Declined_Reason__c": "string", "dsfs__DocuSign_Envelope_ID__c": "string", "dsfs__EnvelopeConfiguration__c": "string", "dsfs__Envelope_Link__c": "string", "dsfs__Envelope_Status__c": "string", "dsfs__Lead__c": "string", "dsfs__Opportunity__c": "string", "dsfs__Sender_Email__c": "string", "dsfs__Sender__c": "string", "dsfs__Sent_Date_Time__c": "string", "dsfs__Subject__c": "string", "dsfs__Viewed_Date_Time__c": "string", "dsfs__Voided_Date_Time__c": "string", "dsfs__Voided_Reason_Extended__c": "string", "dsfs__Voided_Reason__c": "string" } - created: 2024-06-10 15:33:28
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.salesforce_dsfs__docu_sign_status__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 , `dsfs__Case__c` string , `dsfs__Company__c` string , `dsfs__Completed_Date_Time__c` string , `dsfs__Contact__c` string , `dsfs__Contract__c` string , `dsfs__Declined_Date_Time__c` string , `dsfs__Declined_Reason__c` string , `dsfs__DocuSign_Envelope_ID__c` string , `dsfs__Envelope_Link__c` string , `dsfs__Envelope_Status__c` string , `dsfs__Lead__c` string , `dsfs__Opportunity__c` string , `dsfs__Sender_Email__c` string , `dsfs__Sender__c` string , `dsfs__Sent_Date_Time__c` string , `dsfs__Subject__c` string , `dsfs__Viewed_Date_Time__c` string , `dsfs__Voided_Date_Time__c` string , `dsfs__Voided_Reason__c` string , `NewMerchantProfile__c` string , `dsfs__Declined_Reason_Extended__c` string , `dsfs__Voided_Reason_Extended__c` string , `dsfs__EnvelopeConfiguration__c` string , `CongaTemplateID__c` string , `FormResponseId__c` string , `AttachmentCount__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-dev/raw/dsfs__docu_sign_status__cs/2024-06-10/1718051362'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_csv.salesforce_dsfs__docu_sign_status__cs`", "repair_table": "MSCK REPAIR TABLE sfdl_dev_csv.salesforce_dsfs__docu_sign_status__cs" }
- hostname: schemamanager-5447774fc6-4w58v
- name: schema_manager
- process_start: 2026-04-02 21:43:44
- sf_env: dev
- version: 2427328685
{
"name": {
"created": "2022-10-24 14:52:19",
"disabled": false,
"format": "raw",
"id": 2059,
"is_partitioned": false,
"is_schema_datatyped": true,
"name": {
"database": "sfdl_dev_csv",
"table": "salesforce_dsfs__docu_sign_status__cs"
},
"type": "csv"
},
"partition": {
"count": 0,
"ddl": null,
"name": null,
"state": [],
"type": null
},
"schema": {
"attributes": {
"Amount": "string",
"AttachmentCount__c": "string",
"CloseDate": "string",
"CongaTemplateID__c": "string",
"ConnectionReceivedId": "string",
"ConnectionSentId": "string",
"CreatedById": "string",
"CreatedDate": "string",
"CurrencyIsoCode": "string",
"ExpectedRevenue": "string",
"ForecastCategory": "string",
"FormResponseId__c": "string",
"Id": "string",
"IsDeleted": "string",
"LastActivityDate": "string",
"LastModifiedById": "string",
"LastModifiedDate": "string",
"Name": "string",
"NewMerchantProfile__c": "string",
"OpportunityId": "string",
"OwnerId": "string",
"PrevAmount": "string",
"PrevCloseDate": "string",
"Probability": "string",
"StageName": "string",
"SystemModstamp": "string",
"dsfs__Case__c": "string",
"dsfs__Company__c": "string",
"dsfs__Completed_Date_Time__c": "string",
"dsfs__Contact__c": "string",
"dsfs__Contract__c": "string",
"dsfs__Declined_Date_Time__c": "string",
"dsfs__Declined_Reason_Extended__c": "string",
"dsfs__Declined_Reason__c": "string",
"dsfs__DocuSign_Envelope_ID__c": "string",
"dsfs__EnvelopeConfiguration__c": "string",
"dsfs__Envelope_Link__c": "string",
"dsfs__Envelope_Status__c": "string",
"dsfs__Lead__c": "string",
"dsfs__Opportunity__c": "string",
"dsfs__Sender_Email__c": "string",
"dsfs__Sender__c": "string",
"dsfs__Sent_Date_Time__c": "string",
"dsfs__Subject__c": "string",
"dsfs__Viewed_Date_Time__c": "string",
"dsfs__Voided_Date_Time__c": "string",
"dsfs__Voided_Reason_Extended__c": "string",
"dsfs__Voided_Reason__c": "string"
},
"created": "2024-06-10 15:33:28",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.salesforce_dsfs__docu_sign_status__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 , `dsfs__Case__c` string , `dsfs__Company__c` string , `dsfs__Completed_Date_Time__c` string , `dsfs__Contact__c` string , `dsfs__Contract__c` string , `dsfs__Declined_Date_Time__c` string , `dsfs__Declined_Reason__c` string , `dsfs__DocuSign_Envelope_ID__c` string , `dsfs__Envelope_Link__c` string , `dsfs__Envelope_Status__c` string , `dsfs__Lead__c` string , `dsfs__Opportunity__c` string , `dsfs__Sender_Email__c` string , `dsfs__Sender__c` string , `dsfs__Sent_Date_Time__c` string , `dsfs__Subject__c` string , `dsfs__Viewed_Date_Time__c` string , `dsfs__Voided_Date_Time__c` string , `dsfs__Voided_Reason__c` string , `NewMerchantProfile__c` string , `dsfs__Declined_Reason_Extended__c` string , `dsfs__Voided_Reason_Extended__c` string , `dsfs__EnvelopeConfiguration__c` string , `CongaTemplateID__c` string , `FormResponseId__c` string , `AttachmentCount__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-dev/raw/dsfs__docu_sign_status__cs/2024-06-10/1718051362'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
"drop_table": "DROP TABLE IF EXISTS `sfdl_dev_csv.salesforce_dsfs__docu_sign_status__cs`",
"repair_table": "MSCK REPAIR TABLE sfdl_dev_csv.salesforce_dsfs__docu_sign_status__cs"
}
},
"server": {
"hostname": "schemamanager-5447774fc6-4w58v",
"name": "schema_manager",
"process_start": "2026-04-02 21:43:44",
"sf_env": "dev",
"version": "2427328685"
}
}