Schema Info

Schema Name: sfdl_dev_csv.salesforce_case_comments
  • created: 2022-10-24 14:53:57
  • disabled: False
  • format: raw
  • id: 2075
  • is_partitioned: False
  • is_schema_datatyped: True
  • name:
    {
        "database": "sfdl_dev_csv",
        "table": "salesforce_case_comments"
    }
  • type: csv
Schema Versions: 5
    • created: 2024-06-10 15:33:37
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
          "DROP TABLE IF EXISTS `sfdl_dev_csv.salesforce_case_comments`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.salesforce_case_comments`\n(\n `Id`  string , `ParentId`  string , `IsPublished`  string , `CommentBody`  string , `CreatedById`  string , `CreatedDate`  string , `SystemModstamp`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `IsDeleted`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  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/case_comments/2024-06-10/1718051387'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_csv.salesforce_case_comments"
      ]
    • hive_path: s3://sfdl-csv-salesforce-dev/raw/case_comments/2024-06-10/1718051387
    • id: 4706460
    • processed: 1
    • raw_data:
      {
          "CommentBody": 3,
          "ConnectionReceivedId": 10,
          "ConnectionSentId": 11,
          "CreatedById": 4,
          "CreatedDate": 5,
          "Id": 0,
          "IsDeleted": 9,
          "IsPublished": 2,
          "LastModifiedById": 8,
          "LastModifiedDate": 7,
          "ParentId": 1,
          "SystemModstamp": 6
      }
    • schema_attributes:
      {
          "Amount": "string",
          "CloseDate": "string",
          "CommentBody": "string",
          "ConnectionReceivedId": "string",
          "ConnectionSentId": "string",
          "CreatedById": "string",
          "CreatedDate": "string",
          "CurrencyIsoCode": "string",
          "ExpectedRevenue": "string",
          "ForecastCategory": "string",
          "Id": "string",
          "IsDeleted": "string",
          "IsPublished": "string",
          "LastModifiedById": "string",
          "LastModifiedDate": "string",
          "OpportunityId": "string",
          "ParentId": "string",
          "PrevAmount": "string",
          "PrevCloseDate": "string",
          "Probability": "string",
          "StageName": "string",
          "SystemModstamp": "string"
      }
    • schema_name_id: 2075
    • schema_scan_id: 6510715
    • updated: 2024-06-10 15:33:48
    • created: 2024-01-11 09:11:40
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
          "DROP TABLE IF EXISTS `sfdl_dev_csv.salesforce_case_comments`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.salesforce_case_comments`\n(\n `Id`  string , `ParentId`  string , `IsPublished`  string , `CommentBody`  string , `CreatedById`  string , `CreatedDate`  string , `SystemModstamp`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `IsDeleted`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  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/case_comments/2024-01-11/1704985715'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_csv.salesforce_case_comments"
      ]
    • hive_path: s3://sfdl-csv-salesforce-dev/raw/case_comments/2024-01-11/1704985715
    • id: 4700490
    • processed: 1
    • raw_data:
      {
          "CommentBody": 3,
          "ConnectionReceivedId": 10,
          "ConnectionSentId": 11,
          "CreatedById": 4,
          "CreatedDate": 5,
          "Id": 0,
          "IsDeleted": 9,
          "IsPublished": 2,
          "LastModifiedById": 8,
          "LastModifiedDate": 7,
          "ParentId": 1,
          "SystemModstamp": 6
      }
    • schema_attributes:
      {
          "Amount": "string",
          "CloseDate": "string",
          "CommentBody": "string",
          "ConnectionReceivedId": "string",
          "ConnectionSentId": "string",
          "CreatedById": "string",
          "CreatedDate": "string",
          "CurrencyIsoCode": "string",
          "ExpectedRevenue": "string",
          "ForecastCategory": "string",
          "Id": "string",
          "IsDeleted": "string",
          "IsPublished": "string",
          "LastModifiedById": "string",
          "LastModifiedDate": "string",
          "OpportunityId": "string",
          "ParentId": "string",
          "PrevAmount": "string",
          "PrevCloseDate": "string",
          "Probability": "string",
          "StageName": "string",
          "SystemModstamp": "string"
      }
    • schema_name_id: 2075
    • schema_scan_id: 6402633
    • updated: 2024-01-11 09:11:51
    • created: 2023-08-16 11:17:38
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
          "DROP TABLE IF EXISTS `sfdl_dev_csv.salesforce_case_comments`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.salesforce_case_comments`\n(\n `Id`  string , `ParentId`  string , `IsPublished`  string , `CommentBody`  string , `CreatedById`  string , `CreatedDate`  string , `SystemModstamp`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `IsDeleted`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  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/case_comments/2023-08-16/1692202316'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_csv.salesforce_case_comments"
      ]
    • hive_path: s3://sfdl-csv-salesforce-dev/raw/case_comments/2023-08-16/1692202316
    • id: 4697519
    • processed: 1
    • raw_data:
      {
          "CommentBody": 3,
          "ConnectionReceivedId": 10,
          "ConnectionSentId": 11,
          "CreatedById": 4,
          "CreatedDate": 5,
          "Id": 0,
          "IsDeleted": 9,
          "IsPublished": 2,
          "LastModifiedById": 8,
          "LastModifiedDate": 7,
          "ParentId": 1,
          "SystemModstamp": 6
      }
    • schema_attributes:
      {
          "Amount": "string",
          "CloseDate": "string",
          "CommentBody": "string",
          "ConnectionReceivedId": "string",
          "ConnectionSentId": "string",
          "CreatedById": "string",
          "CreatedDate": "string",
          "CurrencyIsoCode": "string",
          "ExpectedRevenue": "string",
          "ForecastCategory": "string",
          "Id": "string",
          "IsDeleted": "string",
          "IsPublished": "string",
          "LastModifiedById": "string",
          "LastModifiedDate": "string",
          "OpportunityId": "string",
          "ParentId": "string",
          "PrevAmount": "string",
          "PrevCloseDate": "string",
          "Probability": "string",
          "StageName": "string",
          "SystemModstamp": "string"
      }
    • schema_name_id: 2075
    • schema_scan_id: 6251526
    • updated: 2023-08-16 11:17:49
    • created: 2023-08-16 10:28:25
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
          "DROP TABLE IF EXISTS `sfdl_dev_csv.salesforce_case_comments`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.salesforce_case_comments`\n(\n `Id`  string , `ParentId`  string , `IsPublished`  string , `CommentBody`  string , `CreatedById`  string , `CreatedDate`  string , `SystemModstamp`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `IsDeleted`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  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/case_comments/2023-08-16/1692199548'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_csv.salesforce_case_comments"
      ]
    • hive_path: s3://sfdl-csv-salesforce-dev/raw/case_comments/2023-08-16/1692199548
    • id: 4697434
    • processed: 1
    • raw_data:
      {
          "CommentBody": 3,
          "ConnectionReceivedId": 10,
          "ConnectionSentId": 11,
          "CreatedById": 4,
          "CreatedDate": 5,
          "Id": 0,
          "IsDeleted": 9,
          "IsPublished": 2,
          "LastModifiedById": 8,
          "LastModifiedDate": 7,
          "ParentId": 1,
          "SystemModstamp": 6
      }
    • schema_attributes:
      {
          "Amount": "string",
          "CloseDate": "string",
          "CommentBody": "string",
          "ConnectionReceivedId": "string",
          "ConnectionSentId": "string",
          "CreatedById": "string",
          "CreatedDate": "string",
          "CurrencyIsoCode": "string",
          "ExpectedRevenue": "string",
          "ForecastCategory": "string",
          "Id": "string",
          "IsDeleted": "string",
          "IsPublished": "string",
          "LastModifiedById": "string",
          "LastModifiedDate": "string",
          "OpportunityId": "string",
          "ParentId": "string",
          "PrevAmount": "string",
          "PrevCloseDate": "string",
          "Probability": "string",
          "StageName": "string",
          "SystemModstamp": "string"
      }
    • schema_name_id: 2075
    • schema_scan_id: 6251361
    • updated: 2023-08-16 10:28:36
    • created: 2023-08-16 09:31:23
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
          "DROP TABLE IF EXISTS `sfdl_dev_csv.salesforce_case_comments`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.salesforce_case_comments`\n(\n `Id`  string , `ParentId`  string , `IsPublished`  string , `CommentBody`  string , `CreatedById`  string , `CreatedDate`  string , `SystemModstamp`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `IsDeleted`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  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/case_comments/2023-08-16/1692195981'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_csv.salesforce_case_comments"
      ]
    • hive_path: s3://sfdl-csv-salesforce-dev/raw/case_comments/2023-08-16/1692195981
    • id: 4697405
    • processed: 1
    • raw_data:
      {
          "CommentBody": 3,
          "ConnectionReceivedId": 10,
          "ConnectionSentId": 11,
          "CreatedById": 4,
          "CreatedDate": 5,
          "Id": 0,
          "IsDeleted": 9,
          "IsPublished": 2,
          "LastModifiedById": 8,
          "LastModifiedDate": 7,
          "ParentId": 1,
          "SystemModstamp": 6
      }
    • schema_attributes:
      {
          "Amount": "string",
          "CloseDate": "string",
          "CommentBody": "string",
          "ConnectionReceivedId": "string",
          "ConnectionSentId": "string",
          "CreatedById": "string",
          "CreatedDate": "string",
          "CurrencyIsoCode": "string",
          "ExpectedRevenue": "string",
          "ForecastCategory": "string",
          "Id": "string",
          "IsDeleted": "string",
          "IsPublished": "string",
          "LastModifiedById": "string",
          "LastModifiedDate": "string",
          "OpportunityId": "string",
          "ParentId": "string",
          "PrevAmount": "string",
          "PrevCloseDate": "string",
          "Probability": "string",
          "StageName": "string",
          "SystemModstamp": "string"
      }
    • schema_name_id: 2075
    • schema_scan_id: 6251291
    • updated: 2023-08-16 09:31:35
Schema Scans: 5
Last at 2024-06-10 15:33:36
    • duration: 0:00:12.136260
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6510715
    • 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/case_comments/2024-06-10/1718051387",
              "key": "raw/case_comments/2024-06-10/1718051387/case_comments.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_csv.salesforce_case_comments",
              "type": "csv"
          },
          "trace_context": {
              "parent_id": 13914259264747120951,
              "service_name": "drive-thru",
              "span_id": 9270378242176882566,
              "trace_id": 13877094775211453774
          }
      }
    • running: False
    • schema_name_id: 2075
    • start_time: 2024-06-10 15:33:36
    • success: True
    • trace_id: 13877094775211453774
    • duration: 0:00:12.144863
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6402633
    • 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/case_comments/2024-01-11/1704985715",
              "key": "raw/case_comments/2024-01-11/1704985715/case_comments.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_csv.salesforce_case_comments",
              "type": "csv"
          },
          "trace_context": {
              "parent_id": 4078121917401203599,
              "service_name": "drive-thru",
              "span_id": 9295808366520328582,
              "trace_id": 11514582219471082659
          }
      }
    • running: False
    • schema_name_id: 2075
    • start_time: 2024-01-11 09:11:39
    • success: True
    • trace_id: 11514582219471082659
    • duration: 0:00:11.953355
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6251526
    • 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/case_comments/2023-08-16/1692202316",
              "key": "raw/case_comments/2023-08-16/1692202316/case_comments.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_csv.salesforce_case_comments",
              "type": "csv"
          },
          "trace_context": {
              "parent_id": 18267376030779704078,
              "service_name": "drive-thru",
              "span_id": 5832071055906736957,
              "trace_id": 9487876072263458796
          }
      }
    • running: False
    • schema_name_id: 2075
    • start_time: 2023-08-16 11:17:37
    • success: True
    • trace_id: 9487876072263458796
    • duration: 0:00:12.016422
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6251361
    • 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/case_comments/2023-08-16/1692199548",
              "key": "raw/case_comments/2023-08-16/1692199548/case_comments.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_csv.salesforce_case_comments",
              "type": "csv"
          },
          "trace_context": {
              "parent_id": 4314134634383618947,
              "service_name": "drive-thru",
              "span_id": 2381592736915753524,
              "trace_id": 10544794218991188068
          }
      }
    • running: False
    • schema_name_id: 2075
    • start_time: 2023-08-16 10:28:24
    • success: True
    • trace_id: 10544794218991188068
    • duration: 0:00:12.025944
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6251291
    • 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/case_comments/2023-08-16/1692195981",
              "key": "raw/case_comments/2023-08-16/1692195981/case_comments.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_csv.salesforce_case_comments",
              "type": "csv"
          },
          "trace_context": {
              "parent_id": 14157818551073470981,
              "service_name": "drive-thru",
              "span_id": 1145234009491322537,
              "trace_id": 5311748959443346713
          }
      }
    • running: False
    • schema_name_id: 2075
    • start_time: 2023-08-16 09:31:23
    • success: True
    • trace_id: 5311748959443346713
Partitions:
  • count: 0
  • ddl: None
  • name: None
  • state:
    []
  • type: None
Schema:
  • attributes:
    {
        "Amount": "string",
        "CloseDate": "string",
        "CommentBody": "string",
        "ConnectionReceivedId": "string",
        "ConnectionSentId": "string",
        "CreatedById": "string",
        "CreatedDate": "string",
        "CurrencyIsoCode": "string",
        "ExpectedRevenue": "string",
        "ForecastCategory": "string",
        "Id": "string",
        "IsDeleted": "string",
        "IsPublished": "string",
        "LastModifiedById": "string",
        "LastModifiedDate": "string",
        "OpportunityId": "string",
        "ParentId": "string",
        "PrevAmount": "string",
        "PrevCloseDate": "string",
        "Probability": "string",
        "StageName": "string",
        "SystemModstamp": "string"
    }
  • created: 2024-06-10 15:33:37
  • ddl:
    {
        "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
        "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.salesforce_case_comments`\n(\n `Id`  string , `ParentId`  string , `IsPublished`  string , `CommentBody`  string , `CreatedById`  string , `CreatedDate`  string , `SystemModstamp`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `IsDeleted`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  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/case_comments/2024-06-10/1718051387'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
        "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_csv.salesforce_case_comments`",
        "repair_table": "MSCK REPAIR TABLE sfdl_dev_csv.salesforce_case_comments"
    }
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:53:57",
        "disabled": false,
        "format": "raw",
        "id": 2075,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_csv",
            "table": "salesforce_case_comments"
        },
        "type": "csv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "Amount": "string",
            "CloseDate": "string",
            "CommentBody": "string",
            "ConnectionReceivedId": "string",
            "ConnectionSentId": "string",
            "CreatedById": "string",
            "CreatedDate": "string",
            "CurrencyIsoCode": "string",
            "ExpectedRevenue": "string",
            "ForecastCategory": "string",
            "Id": "string",
            "IsDeleted": "string",
            "IsPublished": "string",
            "LastModifiedById": "string",
            "LastModifiedDate": "string",
            "OpportunityId": "string",
            "ParentId": "string",
            "PrevAmount": "string",
            "PrevCloseDate": "string",
            "Probability": "string",
            "StageName": "string",
            "SystemModstamp": "string"
        },
        "created": "2024-06-10 15:33:37",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.salesforce_case_comments`\n(\n `Id`  string , `ParentId`  string , `IsPublished`  string , `CommentBody`  string , `CreatedById`  string , `CreatedDate`  string , `SystemModstamp`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `IsDeleted`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  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/case_comments/2024-06-10/1718051387'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_csv.salesforce_case_comments`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_csv.salesforce_case_comments"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}