Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbookquotes_packages
  • created: 2024-10-08 18:23:51
  • disabled: False
  • format: raw
  • id: 2950
  • is_partitioned: False
  • is_schema_datatyped: True
  • name:
    {
        "database": "sfdl_dev_drivethru",
        "table": "newbookdev_newbookquotes_packages"
    }
  • type: drivethrucsv
Schema Versions: 15
    • created: 2024-11-05 23:26:55
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookquotes_packages`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookquotes_packages`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `active`  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-drivethrucsv-drivethru-dev/raw/newbookdev_newbookquotes_packages/2024-11-05/1730866588'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookquotes_packages"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookquotes_packages/2024-11-05/1730866588
    • id: 4749193
    • processed: 1
    • raw_data:
      {
          "active": 4,
          "id": 2,
          "name": 3,
          "newbook_region": 0,
          "tenant": 1
      }
    • schema_attributes:
      {
          "active": "string",
          "id": "string",
          "name": "string",
          "newbook_region": "string",
          "tenant": "string"
      }
    • schema_name_id: 2950
    • schema_scan_id: 6675225
    • updated: 2024-11-05 23:27:06
    • created: 2024-11-05 23:25:05
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookquotes_packages`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookquotes_packages`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `active`  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-drivethrucsv-drivethru-dev/raw/newbookdev_newbookquotes_packages/2024-11-05/1730866530'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookquotes_packages"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookquotes_packages/2024-11-05/1730866530
    • id: 4749167
    • processed: 1
    • raw_data:
      {
          "active": 4,
          "id": 2,
          "name": 3,
          "newbook_region": 0,
          "tenant": 1
      }
    • schema_attributes:
      {
          "active": "string",
          "id": "string",
          "name": "string",
          "newbook_region": "string",
          "tenant": "string"
      }
    • schema_name_id: 2950
    • schema_scan_id: 6675199
    • updated: 2024-11-05 23:25:16
    • created: 2024-11-05 22:43:46
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookquotes_packages`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookquotes_packages`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `active`  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-drivethrucsv-drivethru-dev/raw/newbookdev_newbookquotes_packages/2024-11-05/1730866408'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookquotes_packages"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookquotes_packages/2024-11-05/1730866408
    • id: 4748365
    • processed: 1
    • raw_data:
      {
          "active": 4,
          "id": 2,
          "name": 3,
          "newbook_region": 0,
          "tenant": 1
      }
    • schema_attributes:
      {
          "active": "string",
          "id": "string",
          "name": "string",
          "newbook_region": "string",
          "tenant": "string"
      }
    • schema_name_id: 2950
    • schema_scan_id: 6674398
    • updated: 2024-11-05 22:43:59
    • created: 2024-11-05 04:46:48
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookquotes_packages`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookquotes_packages`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `active`  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-drivethrucsv-drivethru-dev/raw/newbookdev_newbookquotes_packages/2024-11-04/1730785783'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookquotes_packages"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookquotes_packages/2024-11-04/1730785783
    • id: 4747067
    • processed: 1
    • raw_data:
      {
          "active": 4,
          "id": 2,
          "name": 3,
          "newbook_region": 0,
          "tenant": 1
      }
    • schema_attributes:
      {
          "active": "string",
          "id": "string",
          "name": "string",
          "newbook_region": "string",
          "tenant": "string"
      }
    • schema_name_id: 2950
    • schema_scan_id: 6672299
    • updated: 2024-11-05 04:46:59
    • created: 2024-11-05 04:01:29
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookquotes_packages`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookquotes_packages`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `active`  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-drivethrucsv-drivethru-dev/raw/newbookdev_newbookquotes_packages/2024-11-04/1730785159'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookquotes_packages"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookquotes_packages/2024-11-04/1730785159
    • id: 4746401
    • processed: 1
    • raw_data:
      {
          "active": 4,
          "id": 2,
          "name": 3,
          "newbook_region": 0,
          "tenant": 1
      }
    • schema_attributes:
      {
          "active": "string",
          "id": "string",
          "name": "string",
          "newbook_region": "string",
          "tenant": "string"
      }
    • schema_name_id: 2950
    • schema_scan_id: 6671622
    • updated: 2024-11-05 04:01:40
    • created: 2024-11-05 03:33:48
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookquotes_packages`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookquotes_packages`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `active`  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-drivethrucsv-drivethru-dev/raw/newbookdev_newbookquotes_packages/2024-11-04/1730784854'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookquotes_packages"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookquotes_packages/2024-11-04/1730784854
    • id: 4745603
    • processed: 1
    • raw_data:
      {
          "active": 4,
          "id": 2,
          "name": 3,
          "newbook_region": 0,
          "tenant": 1
      }
    • schema_attributes:
      {
          "active": "string",
          "id": "string",
          "name": "string",
          "newbook_region": "string",
          "tenant": "string"
      }
    • schema_name_id: 2950
    • schema_scan_id: 6670820
    • updated: 2024-11-05 03:33:59
    • created: 2024-11-05 03:13:26
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookquotes_packages`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookquotes_packages`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `active`  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-drivethrucsv-drivethru-dev/raw/newbookdev_newbookquotes_packages/2024-11-04/1730784250'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookquotes_packages"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookquotes_packages/2024-11-04/1730784250
    • id: 4744830
    • processed: 1
    • raw_data:
      {
          "active": 4,
          "id": 2,
          "name": 3,
          "newbook_region": 0,
          "tenant": 1
      }
    • schema_attributes:
      {
          "active": "string",
          "id": "string",
          "name": "string",
          "newbook_region": "string",
          "tenant": "string"
      }
    • schema_name_id: 2950
    • schema_scan_id: 6670047
    • updated: 2024-11-05 03:13:39
    • created: 2024-11-05 02:53:54
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookquotes_packages`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookquotes_packages`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `active`  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-drivethrucsv-drivethru-dev/raw/newbookdev_newbookquotes_packages/2024-11-04/1730784088'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookquotes_packages"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookquotes_packages/2024-11-04/1730784088
    • id: 4744097
    • processed: 1
    • raw_data:
      {
          "active": 4,
          "id": 2,
          "name": 3,
          "newbook_region": 0,
          "tenant": 1
      }
    • schema_attributes:
      {
          "active": "string",
          "id": "string",
          "name": "string",
          "newbook_region": "string",
          "tenant": "string"
      }
    • schema_name_id: 2950
    • schema_scan_id: 6669314
    • updated: 2024-11-05 02:54:05
    • created: 2024-11-05 02:21:44
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookquotes_packages`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookquotes_packages`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `active`  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-drivethrucsv-drivethru-dev/raw/newbookdev_newbookquotes_packages/2024-11-04/1730783925'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookquotes_packages"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookquotes_packages/2024-11-04/1730783925
    • id: 4742876
    • processed: 1
    • raw_data:
      {
          "active": 4,
          "id": 2,
          "name": 3,
          "newbook_region": 0,
          "tenant": 1
      }
    • schema_attributes:
      {
          "active": "string",
          "id": "string",
          "name": "string",
          "newbook_region": "string",
          "tenant": "string"
      }
    • schema_name_id: 2950
    • schema_scan_id: 6668093
    • updated: 2024-11-05 02:21:58
    • created: 2024-11-05 02:17:33
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookquotes_packages`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookquotes_packages`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `active`  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-drivethrucsv-drivethru-dev/raw/newbookdev_newbookquotes_packages/2024-11-04/1730783802'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookquotes_packages"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookquotes_packages/2024-11-04/1730783802
    • id: 4742714
    • processed: 1
    • raw_data:
      {
          "active": 4,
          "id": 2,
          "name": 3,
          "newbook_region": 0,
          "tenant": 1
      }
    • schema_attributes:
      {
          "active": "string",
          "id": "string",
          "name": "string",
          "newbook_region": "string",
          "tenant": "string"
      }
    • schema_name_id: 2950
    • schema_scan_id: 6667931
    • updated: 2024-11-05 02:17:46
    • created: 2024-11-05 02:02:15
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookquotes_packages`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookquotes_packages`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `active`  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-drivethrucsv-drivethru-dev/raw/newbookdev_newbookquotes_packages/2024-11-04/1730783691'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookquotes_packages"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookquotes_packages/2024-11-04/1730783691
    • id: 4742144
    • processed: 1
    • raw_data:
      {
          "active": 4,
          "id": 2,
          "name": 3,
          "newbook_region": 0,
          "tenant": 1
      }
    • schema_attributes:
      {
          "active": "string",
          "id": "string",
          "name": "string",
          "newbook_region": "string",
          "tenant": "string"
      }
    • schema_name_id: 2950
    • schema_scan_id: 6667361
    • updated: 2024-11-05 02:02:26
    • created: 2024-11-05 01:39:24
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookquotes_packages`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookquotes_packages`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `active`  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-drivethrucsv-drivethru-dev/raw/newbookdev_newbookquotes_packages/2024-11-04/1730783559'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookquotes_packages"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookquotes_packages/2024-11-04/1730783559
    • id: 4741277
    • processed: 1
    • raw_data:
      {
          "active": 4,
          "id": 2,
          "name": 3,
          "newbook_region": 0,
          "tenant": 1
      }
    • schema_attributes:
      {
          "active": "string",
          "id": "string",
          "name": "string",
          "newbook_region": "string",
          "tenant": "string"
      }
    • schema_name_id: 2950
    • schema_scan_id: 6666494
    • updated: 2024-11-05 01:39:37
    • created: 2024-11-05 01:20:28
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookquotes_packages`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookquotes_packages`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `active`  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-drivethrucsv-drivethru-dev/raw/newbookdev_newbookquotes_packages/2024-11-04/1730783340'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookquotes_packages"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookquotes_packages/2024-11-04/1730783340
    • id: 4740558
    • processed: 1
    • raw_data:
      {
          "active": 4,
          "id": 2,
          "name": 3,
          "newbook_region": 0,
          "tenant": 1
      }
    • schema_attributes:
      {
          "active": "string",
          "id": "string",
          "name": "string",
          "newbook_region": "string",
          "tenant": "string"
      }
    • schema_name_id: 2950
    • schema_scan_id: 6665776
    • updated: 2024-11-05 01:20:39
    • created: 2024-11-05 00:57:43
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookquotes_packages`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookquotes_packages`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `active`  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-drivethrucsv-drivethru-dev/raw/newbookdev_newbookquotes_packages/2024-11-04/1730782939'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookquotes_packages"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookquotes_packages/2024-11-04/1730782939
    • id: 4739705
    • processed: 1
    • raw_data:
      {
          "active": 4,
          "id": 2,
          "name": 3,
          "newbook_region": 0,
          "tenant": 1
      }
    • schema_attributes:
      {
          "active": "string",
          "id": "string",
          "name": "string",
          "newbook_region": "string",
          "tenant": "string"
      }
    • schema_name_id: 2950
    • schema_scan_id: 6664922
    • updated: 2024-11-05 00:57:54
    • created: 2024-11-05 00:32:49
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookquotes_packages`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookquotes_packages`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `active`  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-drivethrucsv-drivethru-dev/raw/newbookdev_newbookquotes_packages/2024-11-04/1730782759'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookquotes_packages"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookquotes_packages/2024-11-04/1730782759
    • id: 4738755
    • processed: 1
    • raw_data:
      {
          "active": 4,
          "id": 2,
          "name": 3,
          "newbook_region": 0,
          "tenant": 1
      }
    • schema_attributes:
      {
          "active": "string",
          "id": "string",
          "name": "string",
          "newbook_region": "string",
          "tenant": "string"
      }
    • schema_name_id: 2950
    • schema_scan_id: 6663968
    • updated: 2024-11-05 00:33:03
Schema Scans: 15
Last at 2024-11-05 23:26:55
    • duration: 0:00:11.586985
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6675225
    • payload:
      {
          "datatype_dict": null,
          "file_format": "csv",
          "file_properties": {
              "data_has_header_row": true
          },
          "is_schema_datatyped": true,
          "s3": {
              "bucket": "sfdl-drivethrucsv-drivethru-dev",
              "hive_path": "s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookquotes_packages/2024-11-05/1730866588",
              "key": "raw/newbookdev_newbookquotes_packages/2024-11-05/1730866588/quotes_packages.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_drivethru.newbookdev_newbookquotes_packages",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 8507851357973221881,
              "service_name": "drive-thru",
              "span_id": 4536609228681138105,
              "trace_id": 3982931988190795355
          }
      }
    • running: False
    • schema_name_id: 2950
    • start_time: 2024-11-05 23:26:55
    • success: True
    • trace_id: 3982931988190795355
    • duration: 0:00:11.493925
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6675199
    • payload:
      {
          "datatype_dict": null,
          "file_format": "csv",
          "file_properties": {
              "data_has_header_row": true
          },
          "is_schema_datatyped": true,
          "s3": {
              "bucket": "sfdl-drivethrucsv-drivethru-dev",
              "hive_path": "s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookquotes_packages/2024-11-05/1730866530",
              "key": "raw/newbookdev_newbookquotes_packages/2024-11-05/1730866530/quotes_packages.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_drivethru.newbookdev_newbookquotes_packages",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 17642351787782331503,
              "service_name": "drive-thru",
              "span_id": 16072116185774699035,
              "trace_id": 15293296964826195781
          }
      }
    • running: False
    • schema_name_id: 2950
    • start_time: 2024-11-05 23:25:04
    • success: True
    • trace_id: 15293296964826195781
    • duration: 0:00:13.968582
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6674398
    • payload:
      {
          "datatype_dict": null,
          "file_format": "csv",
          "file_properties": {
              "data_has_header_row": true
          },
          "is_schema_datatyped": true,
          "s3": {
              "bucket": "sfdl-drivethrucsv-drivethru-dev",
              "hive_path": "s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookquotes_packages/2024-11-05/1730866408",
              "key": "raw/newbookdev_newbookquotes_packages/2024-11-05/1730866408/quotes_packages.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_drivethru.newbookdev_newbookquotes_packages",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 15122910732430887275,
              "service_name": "drive-thru",
              "span_id": 8199989532705653814,
              "trace_id": 18089493501052803571
          }
      }
    • running: False
    • schema_name_id: 2950
    • start_time: 2024-11-05 22:43:46
    • success: True
    • trace_id: 18089493501052803571
    • duration: 0:00:11.442055
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6672299
    • payload:
      {
          "datatype_dict": null,
          "file_format": "csv",
          "file_properties": {
              "data_has_header_row": true
          },
          "is_schema_datatyped": true,
          "s3": {
              "bucket": "sfdl-drivethrucsv-drivethru-dev",
              "hive_path": "s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookquotes_packages/2024-11-04/1730785783",
              "key": "raw/newbookdev_newbookquotes_packages/2024-11-04/1730785783/quotes_packages.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_drivethru.newbookdev_newbookquotes_packages",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 15505710183354547960,
              "service_name": "drive-thru",
              "span_id": 5621350435170425845,
              "trace_id": 14697142920409590716
          }
      }
    • running: False
    • schema_name_id: 2950
    • start_time: 2024-11-05 04:46:48
    • success: True
    • trace_id: 14697142920409590716
    • duration: 0:00:11.421251
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6671622
    • payload:
      {
          "datatype_dict": null,
          "file_format": "csv",
          "file_properties": {
              "data_has_header_row": true
          },
          "is_schema_datatyped": true,
          "s3": {
              "bucket": "sfdl-drivethrucsv-drivethru-dev",
              "hive_path": "s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookquotes_packages/2024-11-04/1730785159",
              "key": "raw/newbookdev_newbookquotes_packages/2024-11-04/1730785159/quotes_packages.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_drivethru.newbookdev_newbookquotes_packages",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 14023538040468708219,
              "service_name": "drive-thru",
              "span_id": 15705334119986096830,
              "trace_id": 15758236794801576211
          }
      }
    • running: False
    • schema_name_id: 2950
    • start_time: 2024-11-05 04:01:29
    • success: True
    • trace_id: 15758236794801576211
    • duration: 0:00:11.433054
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6670820
    • payload:
      {
          "datatype_dict": null,
          "file_format": "csv",
          "file_properties": {
              "data_has_header_row": true
          },
          "is_schema_datatyped": true,
          "s3": {
              "bucket": "sfdl-drivethrucsv-drivethru-dev",
              "hive_path": "s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookquotes_packages/2024-11-04/1730784854",
              "key": "raw/newbookdev_newbookquotes_packages/2024-11-04/1730784854/quotes_packages.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_drivethru.newbookdev_newbookquotes_packages",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 13046590013063349783,
              "service_name": "drive-thru",
              "span_id": 719686739159128975,
              "trace_id": 483376029824777942
          }
      }
    • running: False
    • schema_name_id: 2950
    • start_time: 2024-11-05 03:33:47
    • success: True
    • trace_id: 483376029824777942
    • duration: 0:00:13.850518
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6670047
    • payload:
      {
          "datatype_dict": null,
          "file_format": "csv",
          "file_properties": {
              "data_has_header_row": true
          },
          "is_schema_datatyped": true,
          "s3": {
              "bucket": "sfdl-drivethrucsv-drivethru-dev",
              "hive_path": "s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookquotes_packages/2024-11-04/1730784250",
              "key": "raw/newbookdev_newbookquotes_packages/2024-11-04/1730784250/quotes_packages.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_drivethru.newbookdev_newbookquotes_packages",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 7378386793801562848,
              "service_name": "drive-thru",
              "span_id": 1636522456859031912,
              "trace_id": 9635782382809231097
          }
      }
    • running: False
    • schema_name_id: 2950
    • start_time: 2024-11-05 03:13:25
    • success: True
    • trace_id: 9635782382809231097
    • duration: 0:00:11.308165
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6669314
    • payload:
      {
          "datatype_dict": null,
          "file_format": "csv",
          "file_properties": {
              "data_has_header_row": true
          },
          "is_schema_datatyped": true,
          "s3": {
              "bucket": "sfdl-drivethrucsv-drivethru-dev",
              "hive_path": "s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookquotes_packages/2024-11-04/1730784088",
              "key": "raw/newbookdev_newbookquotes_packages/2024-11-04/1730784088/quotes_packages.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_drivethru.newbookdev_newbookquotes_packages",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 12721886624383373797,
              "service_name": "drive-thru",
              "span_id": 10390040039081485041,
              "trace_id": 4842586341328388924
          }
      }
    • running: False
    • schema_name_id: 2950
    • start_time: 2024-11-05 02:53:54
    • success: True
    • trace_id: 4842586341328388924
    • duration: 0:00:13.850701
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6668093
    • payload:
      {
          "datatype_dict": null,
          "file_format": "csv",
          "file_properties": {
              "data_has_header_row": true
          },
          "is_schema_datatyped": true,
          "s3": {
              "bucket": "sfdl-drivethrucsv-drivethru-dev",
              "hive_path": "s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookquotes_packages/2024-11-04/1730783925",
              "key": "raw/newbookdev_newbookquotes_packages/2024-11-04/1730783925/quotes_packages.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_drivethru.newbookdev_newbookquotes_packages",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 928618225782057883,
              "service_name": "drive-thru",
              "span_id": 3387832516476416543,
              "trace_id": 338420804686770689
          }
      }
    • running: False
    • schema_name_id: 2950
    • start_time: 2024-11-05 02:21:44
    • success: True
    • trace_id: 338420804686770689
    • duration: 0:00:13.911450
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6667931
    • payload:
      {
          "datatype_dict": null,
          "file_format": "csv",
          "file_properties": {
              "data_has_header_row": true
          },
          "is_schema_datatyped": true,
          "s3": {
              "bucket": "sfdl-drivethrucsv-drivethru-dev",
              "hive_path": "s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookquotes_packages/2024-11-04/1730783802",
              "key": "raw/newbookdev_newbookquotes_packages/2024-11-04/1730783802/quotes_packages.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_drivethru.newbookdev_newbookquotes_packages",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 8312124966552102614,
              "service_name": "drive-thru",
              "span_id": 14360255237317494510,
              "trace_id": 14310674479911546455
          }
      }
    • running: False
    • schema_name_id: 2950
    • start_time: 2024-11-05 02:17:32
    • success: True
    • trace_id: 14310674479911546455
    • duration: 0:00:11.382054
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6667361
    • payload:
      {
          "datatype_dict": null,
          "file_format": "csv",
          "file_properties": {
              "data_has_header_row": true
          },
          "is_schema_datatyped": true,
          "s3": {
              "bucket": "sfdl-drivethrucsv-drivethru-dev",
              "hive_path": "s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookquotes_packages/2024-11-04/1730783691",
              "key": "raw/newbookdev_newbookquotes_packages/2024-11-04/1730783691/quotes_packages.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_drivethru.newbookdev_newbookquotes_packages",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 12062356242810368260,
              "service_name": "drive-thru",
              "span_id": 13220794365785673938,
              "trace_id": 17650202138800760799
          }
      }
    • running: False
    • schema_name_id: 2950
    • start_time: 2024-11-05 02:02:14
    • success: True
    • trace_id: 17650202138800760799
    • duration: 0:00:13.829052
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6666494
    • payload:
      {
          "datatype_dict": null,
          "file_format": "csv",
          "file_properties": {
              "data_has_header_row": true
          },
          "is_schema_datatyped": true,
          "s3": {
              "bucket": "sfdl-drivethrucsv-drivethru-dev",
              "hive_path": "s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookquotes_packages/2024-11-04/1730783559",
              "key": "raw/newbookdev_newbookquotes_packages/2024-11-04/1730783559/quotes_packages.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_drivethru.newbookdev_newbookquotes_packages",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 14295493447039461855,
              "service_name": "drive-thru",
              "span_id": 5868322387838330249,
              "trace_id": 6809815603643544733
          }
      }
    • running: False
    • schema_name_id: 2950
    • start_time: 2024-11-05 01:39:24
    • success: True
    • trace_id: 6809815603643544733
    • duration: 0:00:11.338317
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6665776
    • payload:
      {
          "datatype_dict": null,
          "file_format": "csv",
          "file_properties": {
              "data_has_header_row": true
          },
          "is_schema_datatyped": true,
          "s3": {
              "bucket": "sfdl-drivethrucsv-drivethru-dev",
              "hive_path": "s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookquotes_packages/2024-11-04/1730783340",
              "key": "raw/newbookdev_newbookquotes_packages/2024-11-04/1730783340/quotes_packages.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_drivethru.newbookdev_newbookquotes_packages",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 13298473264729833137,
              "service_name": "drive-thru",
              "span_id": 11312530166734830093,
              "trace_id": 382203736835780735
          }
      }
    • running: False
    • schema_name_id: 2950
    • start_time: 2024-11-05 01:20:27
    • success: True
    • trace_id: 382203736835780735
    • duration: 0:00:11.335366
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6664922
    • payload:
      {
          "datatype_dict": null,
          "file_format": "csv",
          "file_properties": {
              "data_has_header_row": true
          },
          "is_schema_datatyped": true,
          "s3": {
              "bucket": "sfdl-drivethrucsv-drivethru-dev",
              "hive_path": "s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookquotes_packages/2024-11-04/1730782939",
              "key": "raw/newbookdev_newbookquotes_packages/2024-11-04/1730782939/quotes_packages.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_drivethru.newbookdev_newbookquotes_packages",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 6747131268630163917,
              "service_name": "drive-thru",
              "span_id": 4396908818366226394,
              "trace_id": 532066434500025130
          }
      }
    • running: False
    • schema_name_id: 2950
    • start_time: 2024-11-05 00:57:42
    • success: True
    • trace_id: 532066434500025130
    • duration: 0:00:13.948012
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6663968
    • payload:
      {
          "datatype_dict": null,
          "file_format": "csv",
          "file_properties": {
              "data_has_header_row": true
          },
          "is_schema_datatyped": true,
          "s3": {
              "bucket": "sfdl-drivethrucsv-drivethru-dev",
              "hive_path": "s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookquotes_packages/2024-11-04/1730782759",
              "key": "raw/newbookdev_newbookquotes_packages/2024-11-04/1730782759/quotes_packages.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_drivethru.newbookdev_newbookquotes_packages",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 17557378892340802484,
              "service_name": "drive-thru",
              "span_id": 7169731147492951014,
              "trace_id": 14253766606841499026
          }
      }
    • running: False
    • schema_name_id: 2950
    • start_time: 2024-11-05 00:32:49
    • success: True
    • trace_id: 14253766606841499026
Partitions:
  • count: 0
  • ddl: None
  • name: None
  • state:
    []
  • type: None
Schema:
  • attributes:
    {
        "active": "string",
        "id": "string",
        "name": "string",
        "newbook_region": "string",
        "tenant": "string"
    }
  • created: 2024-11-05 23:26:55
  • ddl:
    {
        "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
        "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookquotes_packages`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `active`  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-drivethrucsv-drivethru-dev/raw/newbookdev_newbookquotes_packages/2024-11-05/1730866588'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
        "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookquotes_packages`",
        "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookquotes_packages"
    }
Server:
  • hostname: schemamanager-5447774fc6-4w58v
  • name: schema_manager
  • process_start: 2026-04-02 21:43:44
  • sf_env: dev
  • version: 2427328685
Raw:
{
    "name": {
        "created": "2024-10-08 18:23:51",
        "disabled": false,
        "format": "raw",
        "id": 2950,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_drivethru",
            "table": "newbookdev_newbookquotes_packages"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "active": "string",
            "id": "string",
            "name": "string",
            "newbook_region": "string",
            "tenant": "string"
        },
        "created": "2024-11-05 23:26:55",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookquotes_packages`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `active`  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-drivethrucsv-drivethru-dev/raw/newbookdev_newbookquotes_packages/2024-11-05/1730866588'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookquotes_packages`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookquotes_packages"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}