Schema Info

Schema Name: sfdl_dev_csv.salesforce_record_types
  • created: 2022-10-24 14:51:20
  • disabled: False
  • format: raw
  • id: 2051
  • is_partitioned: False
  • is_schema_datatyped: True
  • name:
    {
        "database": "sfdl_dev_csv",
        "table": "salesforce_record_types"
    }
  • type: csv
Schema Versions: 5
    • created: 2024-06-10 15:30:24
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
          "DROP TABLE IF EXISTS `sfdl_dev_csv.salesforce_record_types`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.salesforce_record_types`\n(\n `Id`  string , `Name`  string , `DeveloperName`  string , `NamespacePrefix`  string , `Description`  string , `BusinessProcessId`  string , `SobjectType`  string , `IsActive`  string , `CreatedById`  string , `CreatedDate`  string , `LastModifiedById`  string , `LastModifiedDate`  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/record_types/2024-06-10/1718051327'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_csv.salesforce_record_types"
      ]
    • hive_path: s3://sfdl-csv-salesforce-dev/raw/record_types/2024-06-10/1718051327
    • id: 4706436
    • processed: 1
    • raw_data:
      {
          "BusinessProcessId": 5,
          "CreatedById": 8,
          "CreatedDate": 9,
          "Description": 4,
          "DeveloperName": 2,
          "Id": 0,
          "IsActive": 7,
          "LastModifiedById": 10,
          "LastModifiedDate": 11,
          "Name": 1,
          "NamespacePrefix": 3,
          "SobjectType": 6,
          "SystemModstamp": 12
      }
    • schema_attributes:
      {
          "Amount": "string",
          "BusinessProcessId": "string",
          "CloseDate": "string",
          "CreatedById": "string",
          "CreatedDate": "string",
          "CurrencyIsoCode": "string",
          "Description": "string",
          "DeveloperName": "string",
          "ExpectedRevenue": "string",
          "ForecastCategory": "string",
          "Id": "string",
          "IsActive": "string",
          "IsDeleted": "string",
          "LastModifiedById": "string",
          "LastModifiedDate": "string",
          "Name": "string",
          "NamespacePrefix": "string",
          "OpportunityId": "string",
          "PrevAmount": "string",
          "PrevCloseDate": "string",
          "Probability": "string",
          "SobjectType": "string",
          "StageName": "string",
          "SystemModstamp": "string"
      }
    • schema_name_id: 2051
    • schema_scan_id: 6510681
    • updated: 2024-06-10 15:30:35
    • created: 2024-01-11 09:13:22
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
          "DROP TABLE IF EXISTS `sfdl_dev_csv.salesforce_record_types`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.salesforce_record_types`\n(\n `Id`  string , `Name`  string , `DeveloperName`  string , `NamespacePrefix`  string , `Description`  string , `BusinessProcessId`  string , `SobjectType`  string , `IsActive`  string , `CreatedById`  string , `CreatedDate`  string , `LastModifiedById`  string , `LastModifiedDate`  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/record_types/2024-01-11/1704985723'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_csv.salesforce_record_types"
      ]
    • hive_path: s3://sfdl-csv-salesforce-dev/raw/record_types/2024-01-11/1704985723
    • id: 4700503
    • processed: 1
    • raw_data:
      {
          "BusinessProcessId": 5,
          "CreatedById": 8,
          "CreatedDate": 9,
          "Description": 4,
          "DeveloperName": 2,
          "Id": 0,
          "IsActive": 7,
          "LastModifiedById": 10,
          "LastModifiedDate": 11,
          "Name": 1,
          "NamespacePrefix": 3,
          "SobjectType": 6,
          "SystemModstamp": 12
      }
    • schema_attributes:
      {
          "Amount": "string",
          "BusinessProcessId": "string",
          "CloseDate": "string",
          "CreatedById": "string",
          "CreatedDate": "string",
          "CurrencyIsoCode": "string",
          "Description": "string",
          "DeveloperName": "string",
          "ExpectedRevenue": "string",
          "ForecastCategory": "string",
          "Id": "string",
          "IsActive": "string",
          "IsDeleted": "string",
          "LastModifiedById": "string",
          "LastModifiedDate": "string",
          "Name": "string",
          "NamespacePrefix": "string",
          "OpportunityId": "string",
          "PrevAmount": "string",
          "PrevCloseDate": "string",
          "Probability": "string",
          "SobjectType": "string",
          "StageName": "string",
          "SystemModstamp": "string"
      }
    • schema_name_id: 2051
    • schema_scan_id: 6402654
    • updated: 2024-01-11 09:13:33
    • created: 2023-08-16 11:14:27
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
          "DROP TABLE IF EXISTS `sfdl_dev_csv.salesforce_record_types`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.salesforce_record_types`\n(\n `Id`  string , `Name`  string , `DeveloperName`  string , `NamespacePrefix`  string , `Description`  string , `BusinessProcessId`  string , `SobjectType`  string , `IsActive`  string , `CreatedById`  string , `CreatedDate`  string , `LastModifiedById`  string , `LastModifiedDate`  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/record_types/2023-08-16/1692202326'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_csv.salesforce_record_types"
      ]
    • hive_path: s3://sfdl-csv-salesforce-dev/raw/record_types/2023-08-16/1692202326
    • id: 4697492
    • processed: 1
    • raw_data:
      {
          "BusinessProcessId": 5,
          "CreatedById": 8,
          "CreatedDate": 9,
          "Description": 4,
          "DeveloperName": 2,
          "Id": 0,
          "IsActive": 7,
          "LastModifiedById": 10,
          "LastModifiedDate": 11,
          "Name": 1,
          "NamespacePrefix": 3,
          "SobjectType": 6,
          "SystemModstamp": 12
      }
    • schema_attributes:
      {
          "Amount": "string",
          "BusinessProcessId": "string",
          "CloseDate": "string",
          "CreatedById": "string",
          "CreatedDate": "string",
          "CurrencyIsoCode": "string",
          "Description": "string",
          "DeveloperName": "string",
          "ExpectedRevenue": "string",
          "ForecastCategory": "string",
          "Id": "string",
          "IsActive": "string",
          "IsDeleted": "string",
          "LastModifiedById": "string",
          "LastModifiedDate": "string",
          "Name": "string",
          "NamespacePrefix": "string",
          "OpportunityId": "string",
          "PrevAmount": "string",
          "PrevCloseDate": "string",
          "Probability": "string",
          "SobjectType": "string",
          "StageName": "string",
          "SystemModstamp": "string"
      }
    • schema_name_id: 2051
    • schema_scan_id: 6251498
    • updated: 2023-08-16 11:14:38
    • created: 2023-08-16 10:29:31
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
          "DROP TABLE IF EXISTS `sfdl_dev_csv.salesforce_record_types`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.salesforce_record_types`\n(\n `Id`  string , `Name`  string , `DeveloperName`  string , `NamespacePrefix`  string , `Description`  string , `BusinessProcessId`  string , `SobjectType`  string , `IsActive`  string , `CreatedById`  string , `CreatedDate`  string , `LastModifiedById`  string , `LastModifiedDate`  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/record_types/2023-08-16/1692199574'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_csv.salesforce_record_types"
      ]
    • hive_path: s3://sfdl-csv-salesforce-dev/raw/record_types/2023-08-16/1692199574
    • id: 4697444
    • processed: 1
    • raw_data:
      {
          "BusinessProcessId": 5,
          "CreatedById": 8,
          "CreatedDate": 9,
          "Description": 4,
          "DeveloperName": 2,
          "Id": 0,
          "IsActive": 7,
          "LastModifiedById": 10,
          "LastModifiedDate": 11,
          "Name": 1,
          "NamespacePrefix": 3,
          "SobjectType": 6,
          "SystemModstamp": 12
      }
    • schema_attributes:
      {
          "Amount": "string",
          "BusinessProcessId": "string",
          "CloseDate": "string",
          "CreatedById": "string",
          "CreatedDate": "string",
          "CurrencyIsoCode": "string",
          "Description": "string",
          "DeveloperName": "string",
          "ExpectedRevenue": "string",
          "ForecastCategory": "string",
          "Id": "string",
          "IsActive": "string",
          "IsDeleted": "string",
          "LastModifiedById": "string",
          "LastModifiedDate": "string",
          "Name": "string",
          "NamespacePrefix": "string",
          "OpportunityId": "string",
          "PrevAmount": "string",
          "PrevCloseDate": "string",
          "Probability": "string",
          "SobjectType": "string",
          "StageName": "string",
          "SystemModstamp": "string"
      }
    • schema_name_id: 2051
    • schema_scan_id: 6251371
    • updated: 2023-08-16 10:29:42
    • created: 2023-08-16 09:28:57
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
          "DROP TABLE IF EXISTS `sfdl_dev_csv.salesforce_record_types`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.salesforce_record_types`\n(\n `Id`  string , `Name`  string , `DeveloperName`  string , `NamespacePrefix`  string , `Description`  string , `BusinessProcessId`  string , `SobjectType`  string , `IsActive`  string , `CreatedById`  string , `CreatedDate`  string , `LastModifiedById`  string , `LastModifiedDate`  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/record_types/2023-08-16/1692195944'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_csv.salesforce_record_types"
      ]
    • hive_path: s3://sfdl-csv-salesforce-dev/raw/record_types/2023-08-16/1692195944
    • id: 4697382
    • processed: 1
    • raw_data:
      {
          "BusinessProcessId": 5,
          "CreatedById": 8,
          "CreatedDate": 9,
          "Description": 4,
          "DeveloperName": 2,
          "Id": 0,
          "IsActive": 7,
          "LastModifiedById": 10,
          "LastModifiedDate": 11,
          "Name": 1,
          "NamespacePrefix": 3,
          "SobjectType": 6,
          "SystemModstamp": 12
      }
    • schema_attributes:
      {
          "Amount": "string",
          "BusinessProcessId": "string",
          "CloseDate": "string",
          "CreatedById": "string",
          "CreatedDate": "string",
          "CurrencyIsoCode": "string",
          "Description": "string",
          "DeveloperName": "string",
          "ExpectedRevenue": "string",
          "ForecastCategory": "string",
          "Id": "string",
          "IsActive": "string",
          "IsDeleted": "string",
          "LastModifiedById": "string",
          "LastModifiedDate": "string",
          "Name": "string",
          "NamespacePrefix": "string",
          "OpportunityId": "string",
          "PrevAmount": "string",
          "PrevCloseDate": "string",
          "Probability": "string",
          "SobjectType": "string",
          "StageName": "string",
          "SystemModstamp": "string"
      }
    • schema_name_id: 2051
    • schema_scan_id: 6251266
    • updated: 2023-08-16 09:29:08
Schema Scans: 5
Last at 2024-06-10 15:30:23
    • duration: 0:00:11.922013
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6510681
    • 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/record_types/2024-06-10/1718051327",
              "key": "raw/record_types/2024-06-10/1718051327/record_types.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_csv.salesforce_record_types",
              "type": "csv"
          },
          "trace_context": {
              "parent_id": 9538635651710279006,
              "service_name": "drive-thru",
              "span_id": 17007402251992243702,
              "trace_id": 8892601988866246798
          }
      }
    • running: False
    • schema_name_id: 2051
    • start_time: 2024-06-10 15:30:23
    • success: True
    • trace_id: 8892601988866246798
    • duration: 0:00:11.916467
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6402654
    • 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/record_types/2024-01-11/1704985723",
              "key": "raw/record_types/2024-01-11/1704985723/record_types.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_csv.salesforce_record_types",
              "type": "csv"
          },
          "trace_context": {
              "parent_id": 1589449358027315618,
              "service_name": "drive-thru",
              "span_id": 11096547269681834155,
              "trace_id": 17297145539196692230
          }
      }
    • running: False
    • schema_name_id: 2051
    • start_time: 2024-01-11 09:13:21
    • success: True
    • trace_id: 17297145539196692230
    • duration: 0:00:11.951802
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6251498
    • 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/record_types/2023-08-16/1692202326",
              "key": "raw/record_types/2023-08-16/1692202326/record_types.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_csv.salesforce_record_types",
              "type": "csv"
          },
          "trace_context": {
              "parent_id": 16150440599919382574,
              "service_name": "drive-thru",
              "span_id": 10364680420932632543,
              "trace_id": 528777172968971681
          }
      }
    • running: False
    • schema_name_id: 2051
    • start_time: 2023-08-16 11:14:26
    • success: True
    • trace_id: 528777172968971681
    • duration: 0:00:12.002178
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6251371
    • 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/record_types/2023-08-16/1692199574",
              "key": "raw/record_types/2023-08-16/1692199574/record_types.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_csv.salesforce_record_types",
              "type": "csv"
          },
          "trace_context": {
              "parent_id": 15393525879203619005,
              "service_name": "drive-thru",
              "span_id": 5810627229752487401,
              "trace_id": 12910682592030326940
          }
      }
    • running: False
    • schema_name_id: 2051
    • start_time: 2023-08-16 10:29:30
    • success: True
    • trace_id: 12910682592030326940
    • duration: 0:00:12.108141
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6251266
    • 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/record_types/2023-08-16/1692195944",
              "key": "raw/record_types/2023-08-16/1692195944/record_types.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_csv.salesforce_record_types",
              "type": "csv"
          },
          "trace_context": {
              "parent_id": 4883146036083306769,
              "service_name": "drive-thru",
              "span_id": 8500826860247777522,
              "trace_id": 11349341376199139107
          }
      }
    • running: False
    • schema_name_id: 2051
    • start_time: 2023-08-16 09:28:56
    • success: True
    • trace_id: 11349341376199139107
Partitions:
  • count: 0
  • ddl: None
  • name: None
  • state:
    []
  • type: None
Schema:
  • attributes:
    {
        "Amount": "string",
        "BusinessProcessId": "string",
        "CloseDate": "string",
        "CreatedById": "string",
        "CreatedDate": "string",
        "CurrencyIsoCode": "string",
        "Description": "string",
        "DeveloperName": "string",
        "ExpectedRevenue": "string",
        "ForecastCategory": "string",
        "Id": "string",
        "IsActive": "string",
        "IsDeleted": "string",
        "LastModifiedById": "string",
        "LastModifiedDate": "string",
        "Name": "string",
        "NamespacePrefix": "string",
        "OpportunityId": "string",
        "PrevAmount": "string",
        "PrevCloseDate": "string",
        "Probability": "string",
        "SobjectType": "string",
        "StageName": "string",
        "SystemModstamp": "string"
    }
  • created: 2024-06-10 15:30:24
  • ddl:
    {
        "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
        "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.salesforce_record_types`\n(\n `Id`  string , `Name`  string , `DeveloperName`  string , `NamespacePrefix`  string , `Description`  string , `BusinessProcessId`  string , `SobjectType`  string , `IsActive`  string , `CreatedById`  string , `CreatedDate`  string , `LastModifiedById`  string , `LastModifiedDate`  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/record_types/2024-06-10/1718051327'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
        "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_csv.salesforce_record_types`",
        "repair_table": "MSCK REPAIR TABLE sfdl_dev_csv.salesforce_record_types"
    }
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:51:20",
        "disabled": false,
        "format": "raw",
        "id": 2051,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_csv",
            "table": "salesforce_record_types"
        },
        "type": "csv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "Amount": "string",
            "BusinessProcessId": "string",
            "CloseDate": "string",
            "CreatedById": "string",
            "CreatedDate": "string",
            "CurrencyIsoCode": "string",
            "Description": "string",
            "DeveloperName": "string",
            "ExpectedRevenue": "string",
            "ForecastCategory": "string",
            "Id": "string",
            "IsActive": "string",
            "IsDeleted": "string",
            "LastModifiedById": "string",
            "LastModifiedDate": "string",
            "Name": "string",
            "NamespacePrefix": "string",
            "OpportunityId": "string",
            "PrevAmount": "string",
            "PrevCloseDate": "string",
            "Probability": "string",
            "SobjectType": "string",
            "StageName": "string",
            "SystemModstamp": "string"
        },
        "created": "2024-06-10 15:30:24",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.salesforce_record_types`\n(\n `Id`  string , `Name`  string , `DeveloperName`  string , `NamespacePrefix`  string , `Description`  string , `BusinessProcessId`  string , `SobjectType`  string , `IsActive`  string , `CreatedById`  string , `CreatedDate`  string , `LastModifiedById`  string , `LastModifiedDate`  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/record_types/2024-06-10/1718051327'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_csv.salesforce_record_types`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_csv.salesforce_record_types"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}