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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
Partitions:
  • count: 0
  • ddl: None
  • name: None
  • state:
    []
  • type: None
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
Raw:
{
    "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"
    }
}