Schema Info
Schema Name: sfdl_stage_csv.salesforce_dsfs__docu_sign_status__cs
- created: 2022-10-24 15:13:33
- disabled: False
- format: raw
- id: 1429
- is_partitioned: False
- is_schema_datatyped: True
- name:
{ "database": "sfdl_stage_csv", "table": "salesforce_dsfs__docu_sign_status__cs" } - type: csv
Schema Versions: 3
-
Version 896343
- created: 2026-02-27 09:12:00
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`", "DROP TABLE IF EXISTS `sfdl_stage_csv.salesforce_dsfs__docu_sign_status__cs`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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 , `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-stage/raw/dsfs__docu_sign_status__cs/2026-02-27/1772205030'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_stage_csv.salesforce_dsfs__docu_sign_status__cs" ] - hive_path: s3://sfdl-csv-salesforce-stage/raw/dsfs__docu_sign_status__cs/2026-02-27/1772205030
- id: 896343
- processed: 1
- raw_data:
{ "AttachmentCount__c": 37, "ConnectionReceivedId": 11, "ConnectionSentId": 12, "CreatedById": 6, "CreatedDate": 5, "CurrencyIsoCode": 4, "FormResponseId__c": 36, "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: 1429
- schema_scan_id: 6391676
- updated: 2026-02-27 09:12:12
-
Version 797905
- created: 2025-01-09 15:15:44
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`", "DROP TABLE IF EXISTS `sfdl_stage_csv.salesforce_dsfs__docu_sign_status__cs`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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 , `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-stage/raw/dsfs__docu_sign_status__cs/2025-01-09/1736457255'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_stage_csv.salesforce_dsfs__docu_sign_status__cs" ] - hive_path: s3://sfdl-csv-salesforce-stage/raw/dsfs__docu_sign_status__cs/2025-01-09/1736457255
- id: 797905
- processed: 1
- raw_data:
{ "AttachmentCount__c": 37, "ConnectionReceivedId": 11, "ConnectionSentId": 12, "CreatedById": 6, "CreatedDate": 5, "CurrencyIsoCode": 4, "FormResponseId__c": 36, "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: 1429
- schema_scan_id: 6197221
- updated: 2025-01-09 15:15:55
-
Version 693447
- created: 2024-05-01 08:55:13
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`", "DROP TABLE IF EXISTS `sfdl_stage_csv.salesforce_dsfs__docu_sign_status__cs`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/dsfs__docu_sign_status__cs/2024-05-01/1714571553'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_stage_csv.salesforce_dsfs__docu_sign_status__cs" ] - hive_path: s3://sfdl-csv-salesforce-stage/raw/dsfs__docu_sign_status__cs/2024-05-01/1714571553
- id: 693447
- 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: 1429
- schema_scan_id: 5671844
- updated: 2024-05-01 08:55:24
Schema Scans: 3
Last at 2026-02-27 09:11:59
-
Scan 6391676
- duration: 0:00:13.049878
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6391676
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-csv-salesforce-stage", "hive_path": "s3://sfdl-csv-salesforce-stage/raw/dsfs__docu_sign_status__cs/2026-02-27/1772205030", "key": "raw/dsfs__docu_sign_status__cs/2026-02-27/1772205030/dsfs__docu_sign_status__cs.csv.gz" }, "schema": { "name": "sfdl_stage_csv.salesforce_dsfs__docu_sign_status__cs", "type": "csv" }, "trace_context": { "parent_id": 9669994270984230498, "service_name": "drive-thru", "span_id": 13796085282920571137, "trace_id": 460391671937193854 } } - running: False
- schema_name_id: 1429
- start_time: 2026-02-27 09:11:59
- success: True
- trace_id: 460391671937193854
-
Scan 6197221
- duration: 0:00:12.781860
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6197221
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-csv-salesforce-stage", "hive_path": "s3://sfdl-csv-salesforce-stage/raw/dsfs__docu_sign_status__cs/2025-01-09/1736457255", "key": "raw/dsfs__docu_sign_status__cs/2025-01-09/1736457255/dsfs__docu_sign_status__cs.csv.gz" }, "schema": { "name": "sfdl_stage_csv.salesforce_dsfs__docu_sign_status__cs", "type": "csv" }, "trace_context": { "parent_id": 15683659786536552776, "service_name": "drive-thru", "span_id": 9122668261399153781, "trace_id": 13163634655318504528 } } - running: False
- schema_name_id: 1429
- start_time: 2025-01-09 15:15:42
- success: True
- trace_id: 13163634655318504528
-
Scan 5671844
- duration: 0:00:12.573067
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 5671844
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-csv-salesforce-stage", "hive_path": "s3://sfdl-csv-salesforce-stage/raw/dsfs__docu_sign_status__cs/2024-05-01/1714571553", "key": "raw/dsfs__docu_sign_status__cs/2024-05-01/1714571553/dsfs__docu_sign_status__cs.csv.gz" }, "schema": { "name": "sfdl_stage_csv.salesforce_dsfs__docu_sign_status__cs", "type": "csv" }, "trace_context": { "parent_id": 11031533792796599366, "service_name": "drive-thru", "span_id": 555058003942841224, "trace_id": 6374576709925562508 } } - running: False
- schema_name_id: 1429
- start_time: 2024-05-01 08:55:11
- success: True
- trace_id: 6374576709925562508
- 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: 2026-02-27 09:12:00
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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 , `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-stage/raw/dsfs__docu_sign_status__cs/2026-02-27/1772205030'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_csv.salesforce_dsfs__docu_sign_status__cs`", "repair_table": "MSCK REPAIR TABLE sfdl_stage_csv.salesforce_dsfs__docu_sign_status__cs" }
- hostname: schemamanager-5c55c886bf-h2ts4
- name: schema_manager
- process_start: 2025-10-21 13:03:27
- sf_env: stage
- version: 2112174301
{
"name": {
"created": "2022-10-24 15:13:33",
"disabled": false,
"format": "raw",
"id": 1429,
"is_partitioned": false,
"is_schema_datatyped": true,
"name": {
"database": "sfdl_stage_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": "2026-02-27 09:12:00",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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 , `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-stage/raw/dsfs__docu_sign_status__cs/2026-02-27/1772205030'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
"drop_table": "DROP TABLE IF EXISTS `sfdl_stage_csv.salesforce_dsfs__docu_sign_status__cs`",
"repair_table": "MSCK REPAIR TABLE sfdl_stage_csv.salesforce_dsfs__docu_sign_status__cs"
}
},
"server": {
"hostname": "schemamanager-5c55c886bf-h2ts4",
"name": "schema_manager",
"process_start": "2025-10-21 13:03:27",
"sf_env": "stage",
"version": "2112174301"
}
}