Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbookcron_groups
  • created: 2024-10-08 17:55:15
  • disabled: False
  • format: raw
  • id: 2662
  • is_partitioned: False
  • is_schema_datatyped: True
  • name:
    {
        "database": "sfdl_dev_drivethru",
        "table": "newbookdev_newbookcron_groups"
    }
  • type: drivethrucsv
Schema Versions: 15
    • created: 2024-11-05 22:45:38
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcron_groups`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcron_groups`\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_newbookcron_groups/2024-11-05/1730866443'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcron_groups"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcron_groups/2024-11-05/1730866443
    • id: 4748420
    • 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: 2662
    • schema_scan_id: 6674452
    • updated: 2024-11-05 22:45:49
    • created: 2024-11-05 22:36:14
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcron_groups`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcron_groups`\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_newbookcron_groups/2024-11-05/1730866359'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcron_groups"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcron_groups/2024-11-05/1730866359
    • id: 4748145
    • 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: 2662
    • schema_scan_id: 6674177
    • updated: 2024-11-05 22:36:28
    • created: 2024-11-05 22:19:12
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcron_groups`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcron_groups`\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_newbookcron_groups/2024-11-05/1730866265'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcron_groups"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcron_groups/2024-11-05/1730866265
    • id: 4747526
    • 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: 2662
    • schema_scan_id: 6673559
    • updated: 2024-11-05 22:19:25
    • created: 2024-11-05 04:36:04
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcron_groups`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcron_groups`\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_newbookcron_groups/2024-11-04/1730785685'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcron_groups"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcron_groups/2024-11-04/1730785685
    • id: 4746966
    • 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: 2662
    • schema_scan_id: 6672197
    • updated: 2024-11-05 04:36:15
    • created: 2024-11-05 03:31:55
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcron_groups`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcron_groups`\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_newbookcron_groups/2024-11-04/1730784799'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcron_groups"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcron_groups/2024-11-04/1730784799
    • id: 4745532
    • 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: 2662
    • schema_scan_id: 6670749
    • updated: 2024-11-05 03:32:06
    • created: 2024-11-05 03:27:05
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcron_groups`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcron_groups`\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_newbookcron_groups/2024-11-04/1730785104'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcron_groups"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcron_groups/2024-11-04/1730785104
    • id: 4745348
    • 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: 2662
    • schema_scan_id: 6670565
    • updated: 2024-11-05 03:27:16
    • created: 2024-11-05 03:08:00
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcron_groups`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcron_groups`\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_newbookcron_groups/2024-11-04/1730784195'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcron_groups"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcron_groups/2024-11-04/1730784195
    • id: 4744622
    • 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: 2662
    • schema_scan_id: 6669838
    • updated: 2024-11-05 03:08:11
    • created: 2024-11-05 02:48:34
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcron_groups`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcron_groups`\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_newbookcron_groups/2024-11-04/1730784033'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcron_groups"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcron_groups/2024-11-04/1730784033
    • id: 4743889
    • 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: 2662
    • schema_scan_id: 6669106
    • updated: 2024-11-05 02:48:44
    • created: 2024-11-05 02:22:15
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcron_groups`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcron_groups`\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_newbookcron_groups/2024-11-04/1730783838'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcron_groups"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcron_groups/2024-11-04/1730783838
    • id: 4742895
    • 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: 2662
    • schema_scan_id: 6668112
    • updated: 2024-11-05 02:22:26
    • created: 2024-11-05 02:10:42
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcron_groups`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcron_groups`\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_newbookcron_groups/2024-11-04/1730783746'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcron_groups"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcron_groups/2024-11-04/1730783746
    • id: 4742456
    • 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: 2662
    • schema_scan_id: 6667673
    • updated: 2024-11-05 02:10:56
    • created: 2024-11-05 01:56:00
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcron_groups`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcron_groups`\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_newbookcron_groups/2024-11-04/1730783648'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcron_groups"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcron_groups/2024-11-04/1730783648
    • id: 4741910
    • 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: 2662
    • schema_scan_id: 6667127
    • updated: 2024-11-05 01:56:13
    • created: 2024-11-05 01:28:15
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcron_groups`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcron_groups`\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_newbookcron_groups/2024-11-04/1730783501'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcron_groups"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcron_groups/2024-11-04/1730783501
    • id: 4740854
    • 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: 2662
    • schema_scan_id: 6666071
    • updated: 2024-11-05 01:28:25
    • created: 2024-11-05 01:10:11
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcron_groups`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcron_groups`\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_newbookcron_groups/2024-11-04/1730783283'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcron_groups"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcron_groups/2024-11-04/1730783283
    • id: 4740167
    • 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: 2662
    • schema_scan_id: 6665384
    • updated: 2024-11-05 01:10:22
    • created: 2024-11-05 00:50:14
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcron_groups`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcron_groups`\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_newbookcron_groups/2024-11-04/1730782885'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcron_groups"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcron_groups/2024-11-04/1730782885
    • id: 4739423
    • 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: 2662
    • schema_scan_id: 6664638
    • updated: 2024-11-05 00:50:28
    • created: 2024-11-05 00:37:58
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcron_groups`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcron_groups`\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_newbookcron_groups/2024-11-04/1730782789'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcron_groups"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookcron_groups/2024-11-04/1730782789
    • id: 4738954
    • 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: 2662
    • schema_scan_id: 6664168
    • updated: 2024-11-05 00:38:12
Schema Scans: 15
Last at 2024-11-05 22:45:38
    • duration: 0:00:11.453590
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6674452
    • 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_newbookcron_groups/2024-11-05/1730866443",
              "key": "raw/newbookdev_newbookcron_groups/2024-11-05/1730866443/cron_groups.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_drivethru.newbookdev_newbookcron_groups",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 10202547156752889685,
              "service_name": "drive-thru",
              "span_id": 6003346034653314252,
              "trace_id": 15213388337891409019
          }
      }
    • running: False
    • schema_name_id: 2662
    • start_time: 2024-11-05 22:45:38
    • success: True
    • trace_id: 15213388337891409019
    • duration: 0:00:14.072753
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6674177
    • 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_newbookcron_groups/2024-11-05/1730866359",
              "key": "raw/newbookdev_newbookcron_groups/2024-11-05/1730866359/cron_groups.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_drivethru.newbookdev_newbookcron_groups",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 11753370187474110620,
              "service_name": "drive-thru",
              "span_id": 9976621758584398550,
              "trace_id": 14571768262587622161
          }
      }
    • running: False
    • schema_name_id: 2662
    • start_time: 2024-11-05 22:36:14
    • success: True
    • trace_id: 14571768262587622161
    • duration: 0:00:13.943001
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6673559
    • 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_newbookcron_groups/2024-11-05/1730866265",
              "key": "raw/newbookdev_newbookcron_groups/2024-11-05/1730866265/cron_groups.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_drivethru.newbookdev_newbookcron_groups",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 904784488931449517,
              "service_name": "drive-thru",
              "span_id": 13713821019905119850,
              "trace_id": 4253407188841811800
          }
      }
    • running: False
    • schema_name_id: 2662
    • start_time: 2024-11-05 22:19:11
    • success: True
    • trace_id: 4253407188841811800
    • duration: 0:00:11.467062
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6672197
    • 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_newbookcron_groups/2024-11-04/1730785685",
              "key": "raw/newbookdev_newbookcron_groups/2024-11-04/1730785685/cron_groups.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_drivethru.newbookdev_newbookcron_groups",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 17919084176327438832,
              "service_name": "drive-thru",
              "span_id": 2700760431162194410,
              "trace_id": 8250959019862382069
          }
      }
    • running: False
    • schema_name_id: 2662
    • start_time: 2024-11-05 04:36:03
    • success: True
    • trace_id: 8250959019862382069
    • duration: 0:00:11.285960
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6670749
    • 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_newbookcron_groups/2024-11-04/1730784799",
              "key": "raw/newbookdev_newbookcron_groups/2024-11-04/1730784799/cron_groups.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_drivethru.newbookdev_newbookcron_groups",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 884732358057335571,
              "service_name": "drive-thru",
              "span_id": 2467589885176436266,
              "trace_id": 14582226826813001730
          }
      }
    • running: False
    • schema_name_id: 2662
    • start_time: 2024-11-05 03:31:54
    • success: True
    • trace_id: 14582226826813001730
    • duration: 0:00:11.384682
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6670565
    • 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_newbookcron_groups/2024-11-04/1730785104",
              "key": "raw/newbookdev_newbookcron_groups/2024-11-04/1730785104/cron_groups.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_drivethru.newbookdev_newbookcron_groups",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 3895380340456262604,
              "service_name": "drive-thru",
              "span_id": 16195116364892398738,
              "trace_id": 6509607808683124129
          }
      }
    • running: False
    • schema_name_id: 2662
    • start_time: 2024-11-05 03:27:04
    • success: True
    • trace_id: 6509607808683124129
    • duration: 0:00:11.489148
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6669838
    • 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_newbookcron_groups/2024-11-04/1730784195",
              "key": "raw/newbookdev_newbookcron_groups/2024-11-04/1730784195/cron_groups.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_drivethru.newbookdev_newbookcron_groups",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 2785938378903184120,
              "service_name": "drive-thru",
              "span_id": 1498425498535573373,
              "trace_id": 14197324315116471139
          }
      }
    • running: False
    • schema_name_id: 2662
    • start_time: 2024-11-05 03:07:59
    • success: True
    • trace_id: 14197324315116471139
    • duration: 0:00:11.276374
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6669106
    • 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_newbookcron_groups/2024-11-04/1730784033",
              "key": "raw/newbookdev_newbookcron_groups/2024-11-04/1730784033/cron_groups.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_drivethru.newbookdev_newbookcron_groups",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 8902893435583625827,
              "service_name": "drive-thru",
              "span_id": 1425809463117641069,
              "trace_id": 16238532974906689213
          }
      }
    • running: False
    • schema_name_id: 2662
    • start_time: 2024-11-05 02:48:33
    • success: True
    • trace_id: 16238532974906689213
    • duration: 0:00:11.399960
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6668112
    • 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_newbookcron_groups/2024-11-04/1730783838",
              "key": "raw/newbookdev_newbookcron_groups/2024-11-04/1730783838/cron_groups.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_drivethru.newbookdev_newbookcron_groups",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 10931350069842010473,
              "service_name": "drive-thru",
              "span_id": 9750232394575460027,
              "trace_id": 5137734337634825856
          }
      }
    • running: False
    • schema_name_id: 2662
    • start_time: 2024-11-05 02:22:15
    • success: True
    • trace_id: 5137734337634825856
    • duration: 0:00:13.808715
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6667673
    • 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_newbookcron_groups/2024-11-04/1730783746",
              "key": "raw/newbookdev_newbookcron_groups/2024-11-04/1730783746/cron_groups.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_drivethru.newbookdev_newbookcron_groups",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 1004704639434737123,
              "service_name": "drive-thru",
              "span_id": 9787136455498300545,
              "trace_id": 289712329329191951
          }
      }
    • running: False
    • schema_name_id: 2662
    • start_time: 2024-11-05 02:10:42
    • success: True
    • trace_id: 289712329329191951
    • duration: 0:00:14.114337
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6667127
    • 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_newbookcron_groups/2024-11-04/1730783648",
              "key": "raw/newbookdev_newbookcron_groups/2024-11-04/1730783648/cron_groups.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_drivethru.newbookdev_newbookcron_groups",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 6249496144516236981,
              "service_name": "drive-thru",
              "span_id": 14420466865673645692,
              "trace_id": 1517881153352413232
          }
      }
    • running: False
    • schema_name_id: 2662
    • start_time: 2024-11-05 01:55:59
    • success: True
    • trace_id: 1517881153352413232
    • duration: 0:00:11.285608
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6666071
    • 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_newbookcron_groups/2024-11-04/1730783501",
              "key": "raw/newbookdev_newbookcron_groups/2024-11-04/1730783501/cron_groups.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_drivethru.newbookdev_newbookcron_groups",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 17222131711330697539,
              "service_name": "drive-thru",
              "span_id": 7717573246969708988,
              "trace_id": 1813575423464180620
          }
      }
    • running: False
    • schema_name_id: 2662
    • start_time: 2024-11-05 01:28:14
    • success: True
    • trace_id: 1813575423464180620
    • duration: 0:00:11.523176
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6665384
    • 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_newbookcron_groups/2024-11-04/1730783283",
              "key": "raw/newbookdev_newbookcron_groups/2024-11-04/1730783283/cron_groups.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_drivethru.newbookdev_newbookcron_groups",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 8690698761977584924,
              "service_name": "drive-thru",
              "span_id": 16642615676471357908,
              "trace_id": 15572195921357732069
          }
      }
    • running: False
    • schema_name_id: 2662
    • start_time: 2024-11-05 01:10:10
    • success: True
    • trace_id: 15572195921357732069
    • duration: 0:00:13.841909
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6664638
    • 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_newbookcron_groups/2024-11-04/1730782885",
              "key": "raw/newbookdev_newbookcron_groups/2024-11-04/1730782885/cron_groups.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_drivethru.newbookdev_newbookcron_groups",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 12954466282601755205,
              "service_name": "drive-thru",
              "span_id": 13837352709265852170,
              "trace_id": 14601589422628963504
          }
      }
    • running: False
    • schema_name_id: 2662
    • start_time: 2024-11-05 00:50:14
    • success: True
    • trace_id: 14601589422628963504
    • duration: 0:00:13.943218
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6664168
    • 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_newbookcron_groups/2024-11-04/1730782789",
              "key": "raw/newbookdev_newbookcron_groups/2024-11-04/1730782789/cron_groups.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_drivethru.newbookdev_newbookcron_groups",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 1097721626891348847,
              "service_name": "drive-thru",
              "span_id": 16042026431862516876,
              "trace_id": 12468067301675288814
          }
      }
    • running: False
    • schema_name_id: 2662
    • start_time: 2024-11-05 00:37:58
    • success: True
    • trace_id: 12468067301675288814
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 22:45:38
  • ddl:
    {
        "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
        "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcron_groups`\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_newbookcron_groups/2024-11-05/1730866443'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
        "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcron_groups`",
        "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcron_groups"
    }
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 17:55:15",
        "disabled": false,
        "format": "raw",
        "id": 2662,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_drivethru",
            "table": "newbookdev_newbookcron_groups"
        },
        "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 22:45:38",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookcron_groups`\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_newbookcron_groups/2024-11-05/1730866443'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookcron_groups`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookcron_groups"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}