Schema Info

Schema Name: sfdl_dev_csv.salesforce_pricebook2s
  • created: 2022-10-24 14:52:07
  • disabled: False
  • format: raw
  • id: 2057
  • is_partitioned: False
  • is_schema_datatyped: True
  • name:
    {
        "database": "sfdl_dev_csv",
        "table": "salesforce_pricebook2s"
    }
  • type: csv
Schema Versions: 5
    • created: 2024-06-10 15:32:17
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
          "DROP TABLE IF EXISTS `sfdl_dev_csv.salesforce_pricebook2s`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.salesforce_pricebook2s`\n(\n `Id`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `IsActive`  string , `IsArchived`  string , `Description`  string , `IsStandard`  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/pricebook2s/2024-06-10/1718051338'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_csv.salesforce_pricebook2s"
      ]
    • hive_path: s3://sfdl-csv-salesforce-dev/raw/pricebook2s/2024-06-10/1718051338
    • id: 4706450
    • processed: 1
    • raw_data:
      {
          "CreatedById": 5,
          "CreatedDate": 4,
          "CurrencyIsoCode": 3,
          "Description": 11,
          "Id": 0,
          "IsActive": 9,
          "IsArchived": 10,
          "IsDeleted": 1,
          "IsStandard": 12,
          "LastModifiedById": 7,
          "LastModifiedDate": 6,
          "Name": 2,
          "SystemModstamp": 8
      }
    • schema_attributes:
      {
          "Amount": "string",
          "CloseDate": "string",
          "CreatedById": "string",
          "CreatedDate": "string",
          "CurrencyIsoCode": "string",
          "Description": "string",
          "ExpectedRevenue": "string",
          "ForecastCategory": "string",
          "Id": "string",
          "IsActive": "string",
          "IsArchived": "string",
          "IsDeleted": "string",
          "IsStandard": "string",
          "LastModifiedById": "string",
          "LastModifiedDate": "string",
          "Name": "string",
          "OpportunityId": "string",
          "PrevAmount": "string",
          "PrevCloseDate": "string",
          "Probability": "string",
          "StageName": "string",
          "SystemModstamp": "string"
      }
    • schema_name_id: 2057
    • schema_scan_id: 6510699
    • updated: 2024-06-10 15:32:31
    • created: 2024-01-11 09:14:20
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
          "DROP TABLE IF EXISTS `sfdl_dev_csv.salesforce_pricebook2s`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.salesforce_pricebook2s`\n(\n `Id`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `IsActive`  string , `IsArchived`  string , `Description`  string , `IsStandard`  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/pricebook2s/2024-01-11/1704985763'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_csv.salesforce_pricebook2s"
      ]
    • hive_path: s3://sfdl-csv-salesforce-dev/raw/pricebook2s/2024-01-11/1704985763
    • id: 4700511
    • processed: 1
    • raw_data:
      {
          "CreatedById": 5,
          "CreatedDate": 4,
          "CurrencyIsoCode": 3,
          "Description": 11,
          "Id": 0,
          "IsActive": 9,
          "IsArchived": 10,
          "IsDeleted": 1,
          "IsStandard": 12,
          "LastModifiedById": 7,
          "LastModifiedDate": 6,
          "Name": 2,
          "SystemModstamp": 8
      }
    • schema_attributes:
      {
          "Amount": "string",
          "CloseDate": "string",
          "CreatedById": "string",
          "CreatedDate": "string",
          "CurrencyIsoCode": "string",
          "Description": "string",
          "ExpectedRevenue": "string",
          "ForecastCategory": "string",
          "Id": "string",
          "IsActive": "string",
          "IsArchived": "string",
          "IsDeleted": "string",
          "IsStandard": "string",
          "LastModifiedById": "string",
          "LastModifiedDate": "string",
          "Name": "string",
          "OpportunityId": "string",
          "PrevAmount": "string",
          "PrevCloseDate": "string",
          "Probability": "string",
          "StageName": "string",
          "SystemModstamp": "string"
      }
    • schema_name_id: 2057
    • schema_scan_id: 6402664
    • updated: 2024-01-11 09:14:32
    • created: 2023-08-16 11:12:49
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
          "DROP TABLE IF EXISTS `sfdl_dev_csv.salesforce_pricebook2s`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.salesforce_pricebook2s`\n(\n `Id`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `IsActive`  string , `IsArchived`  string , `Description`  string , `IsStandard`  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/pricebook2s/2023-08-16/1692202293'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_csv.salesforce_pricebook2s"
      ]
    • hive_path: s3://sfdl-csv-salesforce-dev/raw/pricebook2s/2023-08-16/1692202293
    • id: 4697477
    • processed: 1
    • raw_data:
      {
          "CreatedById": 5,
          "CreatedDate": 4,
          "CurrencyIsoCode": 3,
          "Description": 11,
          "Id": 0,
          "IsActive": 9,
          "IsArchived": 10,
          "IsDeleted": 1,
          "IsStandard": 12,
          "LastModifiedById": 7,
          "LastModifiedDate": 6,
          "Name": 2,
          "SystemModstamp": 8
      }
    • schema_attributes:
      {
          "Amount": "string",
          "CloseDate": "string",
          "CreatedById": "string",
          "CreatedDate": "string",
          "CurrencyIsoCode": "string",
          "Description": "string",
          "ExpectedRevenue": "string",
          "ForecastCategory": "string",
          "Id": "string",
          "IsActive": "string",
          "IsArchived": "string",
          "IsDeleted": "string",
          "IsStandard": "string",
          "LastModifiedById": "string",
          "LastModifiedDate": "string",
          "Name": "string",
          "OpportunityId": "string",
          "PrevAmount": "string",
          "PrevCloseDate": "string",
          "Probability": "string",
          "StageName": "string",
          "SystemModstamp": "string"
      }
    • schema_name_id: 2057
    • schema_scan_id: 6251482
    • updated: 2023-08-16 11:13:00
    • created: 2023-08-16 10:31:15
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
          "DROP TABLE IF EXISTS `sfdl_dev_csv.salesforce_pricebook2s`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.salesforce_pricebook2s`\n(\n `Id`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `IsActive`  string , `IsArchived`  string , `Description`  string , `IsStandard`  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/pricebook2s/2023-08-16/1692199563'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_csv.salesforce_pricebook2s"
      ]
    • hive_path: s3://sfdl-csv-salesforce-dev/raw/pricebook2s/2023-08-16/1692199563
    • id: 4697460
    • processed: 1
    • raw_data:
      {
          "CreatedById": 5,
          "CreatedDate": 4,
          "CurrencyIsoCode": 3,
          "Description": 11,
          "Id": 0,
          "IsActive": 9,
          "IsArchived": 10,
          "IsDeleted": 1,
          "IsStandard": 12,
          "LastModifiedById": 7,
          "LastModifiedDate": 6,
          "Name": 2,
          "SystemModstamp": 8
      }
    • schema_attributes:
      {
          "Amount": "string",
          "CloseDate": "string",
          "CreatedById": "string",
          "CreatedDate": "string",
          "CurrencyIsoCode": "string",
          "Description": "string",
          "ExpectedRevenue": "string",
          "ForecastCategory": "string",
          "Id": "string",
          "IsActive": "string",
          "IsArchived": "string",
          "IsDeleted": "string",
          "IsStandard": "string",
          "LastModifiedById": "string",
          "LastModifiedDate": "string",
          "Name": "string",
          "OpportunityId": "string",
          "PrevAmount": "string",
          "PrevCloseDate": "string",
          "Probability": "string",
          "StageName": "string",
          "SystemModstamp": "string"
      }
    • schema_name_id: 2057
    • schema_scan_id: 6251391
    • updated: 2023-08-16 10:31:27
    • created: 2023-08-16 09:29:21
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
          "DROP TABLE IF EXISTS `sfdl_dev_csv.salesforce_pricebook2s`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.salesforce_pricebook2s`\n(\n `Id`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `IsActive`  string , `IsArchived`  string , `Description`  string , `IsStandard`  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/pricebook2s/2023-08-16/1692195976'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_csv.salesforce_pricebook2s"
      ]
    • hive_path: s3://sfdl-csv-salesforce-dev/raw/pricebook2s/2023-08-16/1692195976
    • id: 4697386
    • processed: 1
    • raw_data:
      {
          "CreatedById": 5,
          "CreatedDate": 4,
          "CurrencyIsoCode": 3,
          "Description": 11,
          "Id": 0,
          "IsActive": 9,
          "IsArchived": 10,
          "IsDeleted": 1,
          "IsStandard": 12,
          "LastModifiedById": 7,
          "LastModifiedDate": 6,
          "Name": 2,
          "SystemModstamp": 8
      }
    • schema_attributes:
      {
          "Amount": "string",
          "CloseDate": "string",
          "CreatedById": "string",
          "CreatedDate": "string",
          "CurrencyIsoCode": "string",
          "Description": "string",
          "ExpectedRevenue": "string",
          "ForecastCategory": "string",
          "Id": "string",
          "IsActive": "string",
          "IsArchived": "string",
          "IsDeleted": "string",
          "IsStandard": "string",
          "LastModifiedById": "string",
          "LastModifiedDate": "string",
          "Name": "string",
          "OpportunityId": "string",
          "PrevAmount": "string",
          "PrevCloseDate": "string",
          "Probability": "string",
          "StageName": "string",
          "SystemModstamp": "string"
      }
    • schema_name_id: 2057
    • schema_scan_id: 6251270
    • updated: 2023-08-16 09:29:32
Schema Scans: 5
Last at 2024-06-10 15:32:17
    • duration: 0:00:14.425221
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6510699
    • 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/pricebook2s/2024-06-10/1718051338",
              "key": "raw/pricebook2s/2024-06-10/1718051338/pricebook2s.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_csv.salesforce_pricebook2s",
              "type": "csv"
          },
          "trace_context": {
              "parent_id": 8644522213047504680,
              "service_name": "drive-thru",
              "span_id": 17619095806723613780,
              "trace_id": 17710544401129142856
          }
      }
    • running: False
    • schema_name_id: 2057
    • start_time: 2024-06-10 15:32:17
    • success: True
    • trace_id: 17710544401129142856
    • duration: 0:00:12.095407
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6402664
    • 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/pricebook2s/2024-01-11/1704985763",
              "key": "raw/pricebook2s/2024-01-11/1704985763/pricebook2s.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_csv.salesforce_pricebook2s",
              "type": "csv"
          },
          "trace_context": {
              "parent_id": 490600569897677904,
              "service_name": "drive-thru",
              "span_id": 5315760648209508876,
              "trace_id": 5185416265169080228
          }
      }
    • running: False
    • schema_name_id: 2057
    • start_time: 2024-01-11 09:14:20
    • success: True
    • trace_id: 5185416265169080228
    • duration: 0:00:12.215262
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6251482
    • 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/pricebook2s/2023-08-16/1692202293",
              "key": "raw/pricebook2s/2023-08-16/1692202293/pricebook2s.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_csv.salesforce_pricebook2s",
              "type": "csv"
          },
          "trace_context": {
              "parent_id": 10271592519390031281,
              "service_name": "drive-thru",
              "span_id": 14994677548845065627,
              "trace_id": 3904108995620756944
          }
      }
    • running: False
    • schema_name_id: 2057
    • start_time: 2023-08-16 11:12:48
    • success: True
    • trace_id: 3904108995620756944
    • duration: 0:00:11.960681
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6251391
    • 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/pricebook2s/2023-08-16/1692199563",
              "key": "raw/pricebook2s/2023-08-16/1692199563/pricebook2s.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_csv.salesforce_pricebook2s",
              "type": "csv"
          },
          "trace_context": {
              "parent_id": 669777887017118201,
              "service_name": "drive-thru",
              "span_id": 11861261360952670166,
              "trace_id": 17499162161944166339
          }
      }
    • running: False
    • schema_name_id: 2057
    • start_time: 2023-08-16 10:31:15
    • success: True
    • trace_id: 17499162161944166339
    • duration: 0:00:11.993941
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6251270
    • 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/pricebook2s/2023-08-16/1692195976",
              "key": "raw/pricebook2s/2023-08-16/1692195976/pricebook2s.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_csv.salesforce_pricebook2s",
              "type": "csv"
          },
          "trace_context": {
              "parent_id": 8828475963628560228,
              "service_name": "drive-thru",
              "span_id": 5605390938071758994,
              "trace_id": 1233966471971048858
          }
      }
    • running: False
    • schema_name_id: 2057
    • start_time: 2023-08-16 09:29:20
    • success: True
    • trace_id: 1233966471971048858
Partitions:
  • count: 0
  • ddl: None
  • name: None
  • state:
    []
  • type: None
Schema:
  • attributes:
    {
        "Amount": "string",
        "CloseDate": "string",
        "CreatedById": "string",
        "CreatedDate": "string",
        "CurrencyIsoCode": "string",
        "Description": "string",
        "ExpectedRevenue": "string",
        "ForecastCategory": "string",
        "Id": "string",
        "IsActive": "string",
        "IsArchived": "string",
        "IsDeleted": "string",
        "IsStandard": "string",
        "LastModifiedById": "string",
        "LastModifiedDate": "string",
        "Name": "string",
        "OpportunityId": "string",
        "PrevAmount": "string",
        "PrevCloseDate": "string",
        "Probability": "string",
        "StageName": "string",
        "SystemModstamp": "string"
    }
  • created: 2024-06-10 15:32:17
  • ddl:
    {
        "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
        "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.salesforce_pricebook2s`\n(\n `Id`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `IsActive`  string , `IsArchived`  string , `Description`  string , `IsStandard`  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/pricebook2s/2024-06-10/1718051338'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
        "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_csv.salesforce_pricebook2s`",
        "repair_table": "MSCK REPAIR TABLE sfdl_dev_csv.salesforce_pricebook2s"
    }
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:52:07",
        "disabled": false,
        "format": "raw",
        "id": 2057,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_csv",
            "table": "salesforce_pricebook2s"
        },
        "type": "csv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "Amount": "string",
            "CloseDate": "string",
            "CreatedById": "string",
            "CreatedDate": "string",
            "CurrencyIsoCode": "string",
            "Description": "string",
            "ExpectedRevenue": "string",
            "ForecastCategory": "string",
            "Id": "string",
            "IsActive": "string",
            "IsArchived": "string",
            "IsDeleted": "string",
            "IsStandard": "string",
            "LastModifiedById": "string",
            "LastModifiedDate": "string",
            "Name": "string",
            "OpportunityId": "string",
            "PrevAmount": "string",
            "PrevCloseDate": "string",
            "Probability": "string",
            "StageName": "string",
            "SystemModstamp": "string"
        },
        "created": "2024-06-10 15:32:17",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.salesforce_pricebook2s`\n(\n `Id`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `IsActive`  string , `IsArchived`  string , `Description`  string , `IsStandard`  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/pricebook2s/2024-06-10/1718051338'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_csv.salesforce_pricebook2s`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_csv.salesforce_pricebook2s"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}