Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbooktranslation_templates
  • created: 2024-10-08 18:35:42
  • disabled: False
  • format: raw
  • id: 3058
  • is_partitioned: False
  • is_schema_datatyped: True
  • name:
    {
        "database": "sfdl_dev_drivethru",
        "table": "newbookdev_newbooktranslation_templates"
    }
  • type: drivethrucsv
Schema Versions: 15
    • created: 2024-11-05 23:45:59
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooktranslation_templates`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooktranslation_templates`\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_newbooktranslation_templates/2024-11-05/1730866584'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooktranslation_templates"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktranslation_templates/2024-11-05/1730866584
    • id: 4749393
    • 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: 3058
    • schema_scan_id: 6675431
    • updated: 2024-11-05 23:46:10
    • created: 2024-11-05 23:34:24
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooktranslation_templates`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooktranslation_templates`\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_newbooktranslation_templates/2024-11-05/1730866624'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooktranslation_templates"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktranslation_templates/2024-11-05/1730866624
    • id: 4749285
    • 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: 3058
    • schema_scan_id: 6675317
    • updated: 2024-11-05 23:34:38
    • created: 2024-11-05 23:00:40
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooktranslation_templates`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooktranslation_templates`\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_newbooktranslation_templates/2024-11-05/1730866486'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooktranslation_templates"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktranslation_templates/2024-11-05/1730866486
    • id: 4748772
    • 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: 3058
    • schema_scan_id: 6674805
    • updated: 2024-11-05 23:00:51
    • created: 2024-11-05 05:01:23
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooktranslation_templates`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooktranslation_templates`\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_newbooktranslation_templates/2024-11-04/1730785823'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooktranslation_templates"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktranslation_templates/2024-11-04/1730785823
    • id: 4747203
    • 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: 3058
    • schema_scan_id: 6672435
    • updated: 2024-11-05 05:01:36
    • created: 2024-11-05 04:07:36
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooktranslation_templates`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooktranslation_templates`\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_newbooktranslation_templates/2024-11-04/1730785181'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooktranslation_templates"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktranslation_templates/2024-11-04/1730785181
    • id: 4746524
    • 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: 3058
    • schema_scan_id: 6671746
    • updated: 2024-11-05 04:07:47
    • created: 2024-11-05 03:48:20
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooktranslation_templates`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooktranslation_templates`\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_newbooktranslation_templates/2024-11-04/1730784879'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooktranslation_templates"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktranslation_templates/2024-11-04/1730784879
    • id: 4746074
    • 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: 3058
    • schema_scan_id: 6671295
    • updated: 2024-11-05 03:48:34
    • created: 2024-11-05 03:25:05
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooktranslation_templates`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooktranslation_templates`\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_newbooktranslation_templates/2024-11-04/1730784272'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooktranslation_templates"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktranslation_templates/2024-11-04/1730784272
    • id: 4745271
    • 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: 3058
    • schema_scan_id: 6670488
    • updated: 2024-11-05 03:25:19
    • created: 2024-11-05 03:08:21
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooktranslation_templates`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooktranslation_templates`\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_newbooktranslation_templates/2024-11-04/1730784111'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooktranslation_templates"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktranslation_templates/2024-11-04/1730784111
    • id: 4744634
    • 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: 3058
    • schema_scan_id: 6669851
    • updated: 2024-11-05 03:08:34
    • created: 2024-11-05 02:47:20
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooktranslation_templates`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooktranslation_templates`\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_newbooktranslation_templates/2024-11-04/1730783942'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooktranslation_templates"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktranslation_templates/2024-11-04/1730783942
    • id: 4743843
    • 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: 3058
    • schema_scan_id: 6669060
    • updated: 2024-11-05 02:47:31
    • created: 2024-11-05 02:22:58
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooktranslation_templates`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooktranslation_templates`\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_newbooktranslation_templates/2024-11-04/1730783824'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooktranslation_templates"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktranslation_templates/2024-11-04/1730783824
    • id: 4742922
    • 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: 3058
    • schema_scan_id: 6668139
    • updated: 2024-11-05 02:23:09
    • created: 2024-11-05 02:01:08
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooktranslation_templates`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooktranslation_templates`\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_newbooktranslation_templates/2024-11-04/1730783708'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooktranslation_templates"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktranslation_templates/2024-11-04/1730783708
    • id: 4742102
    • 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: 3058
    • schema_scan_id: 6667319
    • updated: 2024-11-05 02:01:21
    • created: 2024-11-05 01:41:36
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooktranslation_templates`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooktranslation_templates`\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_newbooktranslation_templates/2024-11-04/1730783582'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooktranslation_templates"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktranslation_templates/2024-11-04/1730783582
    • id: 4741361
    • 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: 3058
    • schema_scan_id: 6666578
    • updated: 2024-11-05 01:41:47
    • created: 2024-11-05 01:21:41
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooktranslation_templates`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooktranslation_templates`\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_newbooktranslation_templates/2024-11-04/1730783363'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooktranslation_templates"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktranslation_templates/2024-11-04/1730783363
    • id: 4740603
    • 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: 3058
    • schema_scan_id: 6665820
    • updated: 2024-11-05 01:21:52
    • created: 2024-11-05 01:02:57
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooktranslation_templates`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooktranslation_templates`\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_newbooktranslation_templates/2024-11-04/1730782961'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooktranslation_templates"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktranslation_templates/2024-11-04/1730782961
    • id: 4739900
    • 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: 3058
    • schema_scan_id: 6665117
    • updated: 2024-11-05 01:03:11
    • created: 2024-11-05 00:31:37
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooktranslation_templates`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooktranslation_templates`\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_newbooktranslation_templates/2024-11-04/1730782765'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooktranslation_templates"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooktranslation_templates/2024-11-04/1730782765
    • id: 4738713
    • 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: 3058
    • schema_scan_id: 6663926
    • updated: 2024-11-05 00:31:51
Schema Scans: 15
Last at 2024-11-05 23:45:58
    • duration: 0:00:11.590388
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6675431
    • 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_newbooktranslation_templates/2024-11-05/1730866584",
              "key": "raw/newbookdev_newbooktranslation_templates/2024-11-05/1730866584/translation_templates.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_drivethru.newbookdev_newbooktranslation_templates",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 7296421043572741387,
              "service_name": "drive-thru",
              "span_id": 17549184335037864203,
              "trace_id": 5670918255666073051
          }
      }
    • running: False
    • schema_name_id: 3058
    • start_time: 2024-11-05 23:45:58
    • success: True
    • trace_id: 5670918255666073051
    • duration: 0:00:13.929084
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6675317
    • 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_newbooktranslation_templates/2024-11-05/1730866624",
              "key": "raw/newbookdev_newbooktranslation_templates/2024-11-05/1730866624/translation_templates.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_drivethru.newbookdev_newbooktranslation_templates",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 11969781092632443138,
              "service_name": "drive-thru",
              "span_id": 7207704882735088757,
              "trace_id": 5446833868923525684
          }
      }
    • running: False
    • schema_name_id: 3058
    • start_time: 2024-11-05 23:34:24
    • success: True
    • trace_id: 5446833868923525684
    • duration: 0:00:11.540930
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6674805
    • 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_newbooktranslation_templates/2024-11-05/1730866486",
              "key": "raw/newbookdev_newbooktranslation_templates/2024-11-05/1730866486/translation_templates.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_drivethru.newbookdev_newbooktranslation_templates",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 17290890336955042466,
              "service_name": "drive-thru",
              "span_id": 16115292283348800570,
              "trace_id": 17790901561305302193
          }
      }
    • running: False
    • schema_name_id: 3058
    • start_time: 2024-11-05 23:00:39
    • success: True
    • trace_id: 17790901561305302193
    • duration: 0:00:14.063500
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6672435
    • 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_newbooktranslation_templates/2024-11-04/1730785823",
              "key": "raw/newbookdev_newbooktranslation_templates/2024-11-04/1730785823/translation_templates.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_drivethru.newbookdev_newbooktranslation_templates",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 4008993278038816215,
              "service_name": "drive-thru",
              "span_id": 10588681931218882458,
              "trace_id": 6070773168757378111
          }
      }
    • running: False
    • schema_name_id: 3058
    • start_time: 2024-11-05 05:01:22
    • success: True
    • trace_id: 6070773168757378111
    • duration: 0:00:11.461068
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6671746
    • 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_newbooktranslation_templates/2024-11-04/1730785181",
              "key": "raw/newbookdev_newbooktranslation_templates/2024-11-04/1730785181/translation_templates.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_drivethru.newbookdev_newbooktranslation_templates",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 17964640893793180539,
              "service_name": "drive-thru",
              "span_id": 5522013205405302751,
              "trace_id": 9976318523370755528
          }
      }
    • running: False
    • schema_name_id: 3058
    • start_time: 2024-11-05 04:07:35
    • success: True
    • trace_id: 9976318523370755528
    • duration: 0:00:14.161319
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6671295
    • 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_newbooktranslation_templates/2024-11-04/1730784879",
              "key": "raw/newbookdev_newbooktranslation_templates/2024-11-04/1730784879/translation_templates.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_drivethru.newbookdev_newbooktranslation_templates",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 13429330651621527423,
              "service_name": "drive-thru",
              "span_id": 10545058922341851861,
              "trace_id": 5650997328090528138
          }
      }
    • running: False
    • schema_name_id: 3058
    • start_time: 2024-11-05 03:48:20
    • success: True
    • trace_id: 5650997328090528138
    • duration: 0:00:13.794510
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6670488
    • 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_newbooktranslation_templates/2024-11-04/1730784272",
              "key": "raw/newbookdev_newbooktranslation_templates/2024-11-04/1730784272/translation_templates.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_drivethru.newbookdev_newbooktranslation_templates",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 16479558836998372455,
              "service_name": "drive-thru",
              "span_id": 8286002374291574599,
              "trace_id": 7585161861779425452
          }
      }
    • running: False
    • schema_name_id: 3058
    • start_time: 2024-11-05 03:25:05
    • success: True
    • trace_id: 7585161861779425452
    • duration: 0:00:13.820388
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6669851
    • 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_newbooktranslation_templates/2024-11-04/1730784111",
              "key": "raw/newbookdev_newbooktranslation_templates/2024-11-04/1730784111/translation_templates.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_drivethru.newbookdev_newbooktranslation_templates",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 13858113904816442732,
              "service_name": "drive-thru",
              "span_id": 5496621206522528438,
              "trace_id": 17570705134914983905
          }
      }
    • running: False
    • schema_name_id: 3058
    • start_time: 2024-11-05 03:08:20
    • success: True
    • trace_id: 17570705134914983905
    • duration: 0:00:11.392871
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6669060
    • 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_newbooktranslation_templates/2024-11-04/1730783942",
              "key": "raw/newbookdev_newbooktranslation_templates/2024-11-04/1730783942/translation_templates.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_drivethru.newbookdev_newbooktranslation_templates",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 2693944057277481223,
              "service_name": "drive-thru",
              "span_id": 4801829903409464581,
              "trace_id": 5047022726311170963
          }
      }
    • running: False
    • schema_name_id: 3058
    • start_time: 2024-11-05 02:47:19
    • success: True
    • trace_id: 5047022726311170963
    • duration: 0:00:11.298591
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6668139
    • 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_newbooktranslation_templates/2024-11-04/1730783824",
              "key": "raw/newbookdev_newbooktranslation_templates/2024-11-04/1730783824/translation_templates.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_drivethru.newbookdev_newbooktranslation_templates",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 8948111195466504198,
              "service_name": "drive-thru",
              "span_id": 17982067256328156337,
              "trace_id": 10911065026570987978
          }
      }
    • running: False
    • schema_name_id: 3058
    • start_time: 2024-11-05 02:22:57
    • success: True
    • trace_id: 10911065026570987978
    • duration: 0:00:13.908942
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6667319
    • 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_newbooktranslation_templates/2024-11-04/1730783708",
              "key": "raw/newbookdev_newbooktranslation_templates/2024-11-04/1730783708/translation_templates.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_drivethru.newbookdev_newbooktranslation_templates",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 14731119679495074952,
              "service_name": "drive-thru",
              "span_id": 12166630763751584451,
              "trace_id": 4891611588019637486
          }
      }
    • running: False
    • schema_name_id: 3058
    • start_time: 2024-11-05 02:01:07
    • success: True
    • trace_id: 4891611588019637486
    • duration: 0:00:11.369718
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6666578
    • 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_newbooktranslation_templates/2024-11-04/1730783582",
              "key": "raw/newbookdev_newbooktranslation_templates/2024-11-04/1730783582/translation_templates.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_drivethru.newbookdev_newbooktranslation_templates",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 12716862183796268104,
              "service_name": "drive-thru",
              "span_id": 6012849188182910784,
              "trace_id": 14122701719558677647
          }
      }
    • running: False
    • schema_name_id: 3058
    • start_time: 2024-11-05 01:41:36
    • success: True
    • trace_id: 14122701719558677647
    • duration: 0:00:11.393784
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6665820
    • 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_newbooktranslation_templates/2024-11-04/1730783363",
              "key": "raw/newbookdev_newbooktranslation_templates/2024-11-04/1730783363/translation_templates.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_drivethru.newbookdev_newbooktranslation_templates",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 13963168623437136879,
              "service_name": "drive-thru",
              "span_id": 19185624630016794,
              "trace_id": 11759628768486327282
          }
      }
    • running: False
    • schema_name_id: 3058
    • start_time: 2024-11-05 01:21:40
    • success: True
    • trace_id: 11759628768486327282
    • duration: 0:00:13.959338
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6665117
    • 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_newbooktranslation_templates/2024-11-04/1730782961",
              "key": "raw/newbookdev_newbooktranslation_templates/2024-11-04/1730782961/translation_templates.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_drivethru.newbookdev_newbooktranslation_templates",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 3486961487465397203,
              "service_name": "drive-thru",
              "span_id": 10539102935228984968,
              "trace_id": 12288614858484512972
          }
      }
    • running: False
    • schema_name_id: 3058
    • start_time: 2024-11-05 01:02:57
    • success: True
    • trace_id: 12288614858484512972
    • duration: 0:00:13.933858
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6663926
    • 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_newbooktranslation_templates/2024-11-04/1730782765",
              "key": "raw/newbookdev_newbooktranslation_templates/2024-11-04/1730782765/translation_templates.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_drivethru.newbookdev_newbooktranslation_templates",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 1445917647383269488,
              "service_name": "drive-thru",
              "span_id": 15864485448885595410,
              "trace_id": 6710808848308317496
          }
      }
    • running: False
    • schema_name_id: 3058
    • start_time: 2024-11-05 00:31:37
    • success: True
    • trace_id: 6710808848308317496
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:45:59
  • ddl:
    {
        "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
        "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooktranslation_templates`\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_newbooktranslation_templates/2024-11-05/1730866584'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
        "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooktranslation_templates`",
        "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooktranslation_templates"
    }
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:35:42",
        "disabled": false,
        "format": "raw",
        "id": 3058,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_drivethru",
            "table": "newbookdev_newbooktranslation_templates"
        },
        "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:45:59",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooktranslation_templates`\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_newbooktranslation_templates/2024-11-05/1730866584'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooktranslation_templates`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooktranslation_templates"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}