Schema Info

Schema Name: sfdl_dev_csv.salesforce_campaign_member_statuses
  • created: 2022-10-24 14:50:32
  • disabled: False
  • format: raw
  • id: 2044
  • is_partitioned: False
  • is_schema_datatyped: True
  • name:
    {
        "database": "sfdl_dev_csv",
        "table": "salesforce_campaign_member_statuses"
    }
  • type: csv
Schema Versions: 5
    • created: 2024-06-10 15:36:04
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
          "DROP TABLE IF EXISTS `sfdl_dev_csv.salesforce_campaign_member_statuses`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.salesforce_campaign_member_statuses`\n(\n `Id`  string , `IsDeleted`  string , `CampaignId`  string , `Label`  string , `SortOrder`  string , `IsDefault`  string , `HasResponded`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  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/campaign_member_statuses/2024-06-10/1718051393'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_csv.salesforce_campaign_member_statuses"
      ]
    • hive_path: s3://sfdl-csv-salesforce-dev/raw/campaign_member_statuses/2024-06-10/1718051393
    • id: 4706476
    • processed: 1
    • raw_data:
      {
          "CampaignId": 2,
          "CreatedById": 8,
          "CreatedDate": 7,
          "HasResponded": 6,
          "Id": 0,
          "IsDefault": 5,
          "IsDeleted": 1,
          "Label": 3,
          "LastModifiedById": 10,
          "LastModifiedDate": 9,
          "SortOrder": 4,
          "SystemModstamp": 11
      }
    • schema_attributes:
      {
          "Amount": "string",
          "CampaignId": "string",
          "CloseDate": "string",
          "CreatedById": "string",
          "CreatedDate": "string",
          "CurrencyIsoCode": "string",
          "ExpectedRevenue": "string",
          "ForecastCategory": "string",
          "HasResponded": "string",
          "Id": "string",
          "IsDefault": "string",
          "IsDeleted": "string",
          "Label": "string",
          "LastModifiedById": "string",
          "LastModifiedDate": "string",
          "OpportunityId": "string",
          "PrevAmount": "string",
          "PrevCloseDate": "string",
          "Probability": "string",
          "SortOrder": "string",
          "StageName": "string",
          "SystemModstamp": "string"
      }
    • schema_name_id: 2044
    • schema_scan_id: 6510753
    • updated: 2024-06-10 15:36:15
    • created: 2024-01-11 09:11:28
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
          "DROP TABLE IF EXISTS `sfdl_dev_csv.salesforce_campaign_member_statuses`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.salesforce_campaign_member_statuses`\n(\n `Id`  string , `IsDeleted`  string , `CampaignId`  string , `Label`  string , `SortOrder`  string , `IsDefault`  string , `HasResponded`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  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/campaign_member_statuses/2024-01-11/1704985711'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_csv.salesforce_campaign_member_statuses"
      ]
    • hive_path: s3://sfdl-csv-salesforce-dev/raw/campaign_member_statuses/2024-01-11/1704985711
    • id: 4700489
    • processed: 1
    • raw_data:
      {
          "CampaignId": 2,
          "CreatedById": 8,
          "CreatedDate": 7,
          "HasResponded": 6,
          "Id": 0,
          "IsDefault": 5,
          "IsDeleted": 1,
          "Label": 3,
          "LastModifiedById": 10,
          "LastModifiedDate": 9,
          "SortOrder": 4,
          "SystemModstamp": 11
      }
    • schema_attributes:
      {
          "Amount": "string",
          "CampaignId": "string",
          "CloseDate": "string",
          "CreatedById": "string",
          "CreatedDate": "string",
          "CurrencyIsoCode": "string",
          "ExpectedRevenue": "string",
          "ForecastCategory": "string",
          "HasResponded": "string",
          "Id": "string",
          "IsDefault": "string",
          "IsDeleted": "string",
          "Label": "string",
          "LastModifiedById": "string",
          "LastModifiedDate": "string",
          "OpportunityId": "string",
          "PrevAmount": "string",
          "PrevCloseDate": "string",
          "Probability": "string",
          "SortOrder": "string",
          "StageName": "string",
          "SystemModstamp": "string"
      }
    • schema_name_id: 2044
    • schema_scan_id: 6402632
    • updated: 2024-01-11 09:11:42
    • created: 2023-08-16 11:11:34
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
          "DROP TABLE IF EXISTS `sfdl_dev_csv.salesforce_campaign_member_statuses`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.salesforce_campaign_member_statuses`\n(\n `Id`  string , `IsDeleted`  string , `CampaignId`  string , `Label`  string , `SortOrder`  string , `IsDefault`  string , `HasResponded`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  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/campaign_member_statuses/2023-08-16/1692202263'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_csv.salesforce_campaign_member_statuses"
      ]
    • hive_path: s3://sfdl-csv-salesforce-dev/raw/campaign_member_statuses/2023-08-16/1692202263
    • id: 4697468
    • processed: 1
    • raw_data:
      {
          "CampaignId": 2,
          "CreatedById": 8,
          "CreatedDate": 7,
          "HasResponded": 6,
          "Id": 0,
          "IsDefault": 5,
          "IsDeleted": 1,
          "Label": 3,
          "LastModifiedById": 10,
          "LastModifiedDate": 9,
          "SortOrder": 4,
          "SystemModstamp": 11
      }
    • schema_attributes:
      {
          "Amount": "string",
          "CampaignId": "string",
          "CloseDate": "string",
          "CreatedById": "string",
          "CreatedDate": "string",
          "CurrencyIsoCode": "string",
          "ExpectedRevenue": "string",
          "ForecastCategory": "string",
          "HasResponded": "string",
          "Id": "string",
          "IsDefault": "string",
          "IsDeleted": "string",
          "Label": "string",
          "LastModifiedById": "string",
          "LastModifiedDate": "string",
          "OpportunityId": "string",
          "PrevAmount": "string",
          "PrevCloseDate": "string",
          "Probability": "string",
          "SortOrder": "string",
          "StageName": "string",
          "SystemModstamp": "string"
      }
    • schema_name_id: 2044
    • schema_scan_id: 6251473
    • updated: 2023-08-16 11:11:46
    • created: 2023-08-16 10:29:46
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
          "DROP TABLE IF EXISTS `sfdl_dev_csv.salesforce_campaign_member_statuses`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.salesforce_campaign_member_statuses`\n(\n `Id`  string , `IsDeleted`  string , `CampaignId`  string , `Label`  string , `SortOrder`  string , `IsDefault`  string , `HasResponded`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  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/campaign_member_statuses/2023-08-16/1692199533'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_csv.salesforce_campaign_member_statuses"
      ]
    • hive_path: s3://sfdl-csv-salesforce-dev/raw/campaign_member_statuses/2023-08-16/1692199533
    • id: 4697447
    • processed: 1
    • raw_data:
      {
          "CampaignId": 2,
          "CreatedById": 8,
          "CreatedDate": 7,
          "HasResponded": 6,
          "Id": 0,
          "IsDefault": 5,
          "IsDeleted": 1,
          "Label": 3,
          "LastModifiedById": 10,
          "LastModifiedDate": 9,
          "SortOrder": 4,
          "SystemModstamp": 11
      }
    • schema_attributes:
      {
          "Amount": "string",
          "CampaignId": "string",
          "CloseDate": "string",
          "CreatedById": "string",
          "CreatedDate": "string",
          "CurrencyIsoCode": "string",
          "ExpectedRevenue": "string",
          "ForecastCategory": "string",
          "HasResponded": "string",
          "Id": "string",
          "IsDefault": "string",
          "IsDeleted": "string",
          "Label": "string",
          "LastModifiedById": "string",
          "LastModifiedDate": "string",
          "OpportunityId": "string",
          "PrevAmount": "string",
          "PrevCloseDate": "string",
          "Probability": "string",
          "SortOrder": "string",
          "StageName": "string",
          "SystemModstamp": "string"
      }
    • schema_name_id: 2044
    • schema_scan_id: 6251374
    • updated: 2023-08-16 10:29:57
    • created: 2023-08-16 09:27:32
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
          "DROP TABLE IF EXISTS `sfdl_dev_csv.salesforce_campaign_member_statuses`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.salesforce_campaign_member_statuses`\n(\n `Id`  string , `IsDeleted`  string , `CampaignId`  string , `Label`  string , `SortOrder`  string , `IsDefault`  string , `HasResponded`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  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/campaign_member_statuses/2023-08-16/1692195928'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_csv.salesforce_campaign_member_statuses"
      ]
    • hive_path: s3://sfdl-csv-salesforce-dev/raw/campaign_member_statuses/2023-08-16/1692195928
    • id: 4697370
    • processed: 1
    • raw_data:
      {
          "CampaignId": 2,
          "CreatedById": 8,
          "CreatedDate": 7,
          "HasResponded": 6,
          "Id": 0,
          "IsDefault": 5,
          "IsDeleted": 1,
          "Label": 3,
          "LastModifiedById": 10,
          "LastModifiedDate": 9,
          "SortOrder": 4,
          "SystemModstamp": 11
      }
    • schema_attributes:
      {
          "Amount": "string",
          "CampaignId": "string",
          "CloseDate": "string",
          "CreatedById": "string",
          "CreatedDate": "string",
          "CurrencyIsoCode": "string",
          "ExpectedRevenue": "string",
          "ForecastCategory": "string",
          "HasResponded": "string",
          "Id": "string",
          "IsDefault": "string",
          "IsDeleted": "string",
          "Label": "string",
          "LastModifiedById": "string",
          "LastModifiedDate": "string",
          "OpportunityId": "string",
          "PrevAmount": "string",
          "PrevCloseDate": "string",
          "Probability": "string",
          "SortOrder": "string",
          "StageName": "string",
          "SystemModstamp": "string"
      }
    • schema_name_id: 2044
    • schema_scan_id: 6251254
    • updated: 2023-08-16 09:27:43
Schema Scans: 5
Last at 2024-06-10 15:36:03
    • duration: 0:00:12.062742
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6510753
    • 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/campaign_member_statuses/2024-06-10/1718051393",
              "key": "raw/campaign_member_statuses/2024-06-10/1718051393/campaign_member_statuses.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_csv.salesforce_campaign_member_statuses",
              "type": "csv"
          },
          "trace_context": {
              "parent_id": 396973882437874001,
              "service_name": "drive-thru",
              "span_id": 129244015646559201,
              "trace_id": 2911454109013525917
          }
      }
    • running: False
    • schema_name_id: 2044
    • start_time: 2024-06-10 15:36:03
    • success: True
    • trace_id: 2911454109013525917
    • duration: 0:00:14.507048
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6402632
    • 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/campaign_member_statuses/2024-01-11/1704985711",
              "key": "raw/campaign_member_statuses/2024-01-11/1704985711/campaign_member_statuses.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_csv.salesforce_campaign_member_statuses",
              "type": "csv"
          },
          "trace_context": {
              "parent_id": 5800998719137631342,
              "service_name": "drive-thru",
              "span_id": 5687443189280688610,
              "trace_id": 12845144036371481294
          }
      }
    • running: False
    • schema_name_id: 2044
    • start_time: 2024-01-11 09:11:28
    • success: True
    • trace_id: 12845144036371481294
    • duration: 0:00:12.191863
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6251473
    • 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/campaign_member_statuses/2023-08-16/1692202263",
              "key": "raw/campaign_member_statuses/2023-08-16/1692202263/campaign_member_statuses.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_csv.salesforce_campaign_member_statuses",
              "type": "csv"
          },
          "trace_context": {
              "parent_id": 8579003469744837455,
              "service_name": "drive-thru",
              "span_id": 4818003842958092440,
              "trace_id": 2691808516005487149
          }
      }
    • running: False
    • schema_name_id: 2044
    • start_time: 2023-08-16 11:11:34
    • success: True
    • trace_id: 2691808516005487149
    • duration: 0:00:11.829316
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6251374
    • 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/campaign_member_statuses/2023-08-16/1692199533",
              "key": "raw/campaign_member_statuses/2023-08-16/1692199533/campaign_member_statuses.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_csv.salesforce_campaign_member_statuses",
              "type": "csv"
          },
          "trace_context": {
              "parent_id": 14366409808536500555,
              "service_name": "drive-thru",
              "span_id": 3552754540507372227,
              "trace_id": 7922219773868993275
          }
      }
    • running: False
    • schema_name_id: 2044
    • start_time: 2023-08-16 10:29:45
    • success: True
    • trace_id: 7922219773868993275
    • duration: 0:00:12.009932
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6251254
    • 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/campaign_member_statuses/2023-08-16/1692195928",
              "key": "raw/campaign_member_statuses/2023-08-16/1692195928/campaign_member_statuses.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_csv.salesforce_campaign_member_statuses",
              "type": "csv"
          },
          "trace_context": {
              "parent_id": 7397766672654280982,
              "service_name": "drive-thru",
              "span_id": 2989372051408989514,
              "trace_id": 10353701985529666200
          }
      }
    • running: False
    • schema_name_id: 2044
    • start_time: 2023-08-16 09:27:31
    • success: True
    • trace_id: 10353701985529666200
Partitions:
  • count: 0
  • ddl: None
  • name: None
  • state:
    []
  • type: None
Schema:
  • attributes:
    {
        "Amount": "string",
        "CampaignId": "string",
        "CloseDate": "string",
        "CreatedById": "string",
        "CreatedDate": "string",
        "CurrencyIsoCode": "string",
        "ExpectedRevenue": "string",
        "ForecastCategory": "string",
        "HasResponded": "string",
        "Id": "string",
        "IsDefault": "string",
        "IsDeleted": "string",
        "Label": "string",
        "LastModifiedById": "string",
        "LastModifiedDate": "string",
        "OpportunityId": "string",
        "PrevAmount": "string",
        "PrevCloseDate": "string",
        "Probability": "string",
        "SortOrder": "string",
        "StageName": "string",
        "SystemModstamp": "string"
    }
  • created: 2024-06-10 15:36:04
  • ddl:
    {
        "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
        "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.salesforce_campaign_member_statuses`\n(\n `Id`  string , `IsDeleted`  string , `CampaignId`  string , `Label`  string , `SortOrder`  string , `IsDefault`  string , `HasResponded`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  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/campaign_member_statuses/2024-06-10/1718051393'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
        "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_csv.salesforce_campaign_member_statuses`",
        "repair_table": "MSCK REPAIR TABLE sfdl_dev_csv.salesforce_campaign_member_statuses"
    }
Server:
  • hostname: schemamanager-5447774fc6-4w58v
  • name: schema_manager
  • process_start: 2026-04-02 21:43:44
  • sf_env: dev
  • version: 2427328685
Raw:
{
    "name": {
        "created": "2022-10-24 14:50:32",
        "disabled": false,
        "format": "raw",
        "id": 2044,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_csv",
            "table": "salesforce_campaign_member_statuses"
        },
        "type": "csv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "Amount": "string",
            "CampaignId": "string",
            "CloseDate": "string",
            "CreatedById": "string",
            "CreatedDate": "string",
            "CurrencyIsoCode": "string",
            "ExpectedRevenue": "string",
            "ForecastCategory": "string",
            "HasResponded": "string",
            "Id": "string",
            "IsDefault": "string",
            "IsDeleted": "string",
            "Label": "string",
            "LastModifiedById": "string",
            "LastModifiedDate": "string",
            "OpportunityId": "string",
            "PrevAmount": "string",
            "PrevCloseDate": "string",
            "Probability": "string",
            "SortOrder": "string",
            "StageName": "string",
            "SystemModstamp": "string"
        },
        "created": "2024-06-10 15:36:04",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.salesforce_campaign_member_statuses`\n(\n `Id`  string , `IsDeleted`  string , `CampaignId`  string , `Label`  string , `SortOrder`  string , `IsDefault`  string , `HasResponded`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  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/campaign_member_statuses/2024-06-10/1718051393'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_csv.salesforce_campaign_member_statuses`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_csv.salesforce_campaign_member_statuses"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}