Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbookinstances_translations
  • created: 2024-10-08 17:53:02
  • disabled: False
  • format: raw
  • id: 2631
  • is_partitioned: False
  • is_schema_datatyped: True
  • name:
    {
        "database": "sfdl_dev_drivethru",
        "table": "newbookdev_newbookinstances_translations"
    }
  • type: drivethrucsv
Schema Versions: 15
    • created: 2024-11-05 23:15:54
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstances_translations`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstances_translations`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `translation_id`  string , `language`  string , `translation`  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_newbookinstances_translations/2024-11-05/1730866515'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstances_translations"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstances_translations/2024-11-05/1730866515
    • id: 4749039
    • processed: 1
    • raw_data:
      {
          "id": 2,
          "language": 4,
          "newbook_region": 0,
          "tenant": 1,
          "translation": 5,
          "translation_id": 3
      }
    • schema_attributes:
      {
          "id": "string",
          "language": "string",
          "newbook_region": "string",
          "tenant": "string",
          "translation": "string",
          "translation_id": "string"
      }
    • schema_name_id: 2631
    • schema_scan_id: 6675071
    • updated: 2024-11-05 23:16:05
    • created: 2024-11-05 22:47:01
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstances_translations`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstances_translations`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `translation_id`  string , `language`  string , `translation`  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_newbookinstances_translations/2024-11-05/1730866441'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstances_translations"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstances_translations/2024-11-05/1730866441
    • id: 4748458
    • processed: 1
    • raw_data:
      {
          "id": 2,
          "language": 4,
          "newbook_region": 0,
          "tenant": 1,
          "translation": 5,
          "translation_id": 3
      }
    • schema_attributes:
      {
          "id": "string",
          "language": "string",
          "newbook_region": "string",
          "tenant": "string",
          "translation": "string",
          "translation_id": "string"
      }
    • schema_name_id: 2631
    • schema_scan_id: 6674491
    • updated: 2024-11-05 22:47:14
    • created: 2024-11-05 22:26:16
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstances_translations`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstances_translations`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `translation_id`  string , `language`  string , `translation`  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_newbookinstances_translations/2024-11-05/1730866318'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstances_translations"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstances_translations/2024-11-05/1730866318
    • id: 4747799
    • processed: 1
    • raw_data:
      {
          "id": 2,
          "language": 4,
          "newbook_region": 0,
          "tenant": 1,
          "translation": 5,
          "translation_id": 3
      }
    • schema_attributes:
      {
          "id": "string",
          "language": "string",
          "newbook_region": "string",
          "tenant": "string",
          "translation": "string",
          "translation_id": "string"
      }
    • schema_name_id: 2631
    • schema_scan_id: 6673831
    • updated: 2024-11-05 22:26:27
    • created: 2024-11-05 04:22:34
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstances_translations`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstances_translations`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `translation_id`  string , `language`  string , `translation`  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_newbookinstances_translations/2024-11-04/1730785727'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstances_translations"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstances_translations/2024-11-04/1730785727
    • id: 4746779
    • processed: 1
    • raw_data:
      {
          "id": 2,
          "language": 4,
          "newbook_region": 0,
          "tenant": 1,
          "translation": 5,
          "translation_id": 3
      }
    • schema_attributes:
      {
          "id": "string",
          "language": "string",
          "newbook_region": "string",
          "tenant": "string",
          "translation": "string",
          "translation_id": "string"
      }
    • schema_name_id: 2631
    • schema_scan_id: 6672007
    • updated: 2024-11-05 04:22:48
    • created: 2024-11-05 03:51:31
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstances_translations`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstances_translations`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `translation_id`  string , `language`  string , `translation`  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_newbookinstances_translations/2024-11-04/1730785128'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstances_translations"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstances_translations/2024-11-04/1730785128
    • id: 4746163
    • processed: 1
    • raw_data:
      {
          "id": 2,
          "language": 4,
          "newbook_region": 0,
          "tenant": 1,
          "translation": 5,
          "translation_id": 3
      }
    • schema_attributes:
      {
          "id": "string",
          "language": "string",
          "newbook_region": "string",
          "tenant": "string",
          "translation": "string",
          "translation_id": "string"
      }
    • schema_name_id: 2631
    • schema_scan_id: 6671384
    • updated: 2024-11-05 03:51:41
    • created: 2024-11-05 03:11:34
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstances_translations`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstances_translations`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `translation_id`  string , `language`  string , `translation`  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_newbookinstances_translations/2024-11-04/1730784823'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstances_translations"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstances_translations/2024-11-04/1730784823
    • id: 4744756
    • processed: 1
    • raw_data:
      {
          "id": 2,
          "language": 4,
          "newbook_region": 0,
          "tenant": 1,
          "translation": 5,
          "translation_id": 3
      }
    • schema_attributes:
      {
          "id": "string",
          "language": "string",
          "newbook_region": "string",
          "tenant": "string",
          "translation": "string",
          "translation_id": "string"
      }
    • schema_name_id: 2631
    • schema_scan_id: 6669973
    • updated: 2024-11-05 03:11:45
    • created: 2024-11-05 02:54:52
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstances_translations`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstances_translations`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `translation_id`  string , `language`  string , `translation`  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_newbookinstances_translations/2024-11-04/1730784219'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstances_translations"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstances_translations/2024-11-04/1730784219
    • id: 4744133
    • processed: 1
    • raw_data:
      {
          "id": 2,
          "language": 4,
          "newbook_region": 0,
          "tenant": 1,
          "translation": 5,
          "translation_id": 3
      }
    • schema_attributes:
      {
          "id": "string",
          "language": "string",
          "newbook_region": "string",
          "tenant": "string",
          "translation": "string",
          "translation_id": "string"
      }
    • schema_name_id: 2631
    • schema_scan_id: 6669350
    • updated: 2024-11-05 02:55:03
    • created: 2024-11-05 02:35:58
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstances_translations`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstances_translations`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `translation_id`  string , `language`  string , `translation`  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_newbookinstances_translations/2024-11-04/1730784057'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstances_translations"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstances_translations/2024-11-04/1730784057
    • id: 4743413
    • processed: 1
    • raw_data:
      {
          "id": 2,
          "language": 4,
          "newbook_region": 0,
          "tenant": 1,
          "translation": 5,
          "translation_id": 3
      }
    • schema_attributes:
      {
          "id": "string",
          "language": "string",
          "newbook_region": "string",
          "tenant": "string",
          "translation": "string",
          "translation_id": "string"
      }
    • schema_name_id: 2631
    • schema_scan_id: 6668630
    • updated: 2024-11-05 02:36:12
    • created: 2024-11-05 02:31:31
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstances_translations`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstances_translations`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `translation_id`  string , `language`  string , `translation`  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_newbookinstances_translations/2024-11-04/1730783902'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstances_translations"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstances_translations/2024-11-04/1730783902
    • id: 4743248
    • processed: 1
    • raw_data:
      {
          "id": 2,
          "language": 4,
          "newbook_region": 0,
          "tenant": 1,
          "translation": 5,
          "translation_id": 3
      }
    • schema_attributes:
      {
          "id": "string",
          "language": "string",
          "newbook_region": "string",
          "tenant": "string",
          "translation": "string",
          "translation_id": "string"
      }
    • schema_name_id: 2631
    • schema_scan_id: 6668465
    • updated: 2024-11-05 02:31:42
    • created: 2024-11-05 02:15:33
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstances_translations`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstances_translations`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `translation_id`  string , `language`  string , `translation`  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_newbookinstances_translations/2024-11-04/1730783770'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstances_translations"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstances_translations/2024-11-04/1730783770
    • id: 4742640
    • processed: 1
    • raw_data:
      {
          "id": 2,
          "language": 4,
          "newbook_region": 0,
          "tenant": 1,
          "translation": 5,
          "translation_id": 3
      }
    • schema_attributes:
      {
          "id": "string",
          "language": "string",
          "newbook_region": "string",
          "tenant": "string",
          "translation": "string",
          "translation_id": "string"
      }
    • schema_name_id: 2631
    • schema_scan_id: 6667857
    • updated: 2024-11-05 02:15:43
    • created: 2024-11-05 01:58:58
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstances_translations`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstances_translations`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `translation_id`  string , `language`  string , `translation`  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_newbookinstances_translations/2024-11-04/1730783667'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstances_translations"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstances_translations/2024-11-04/1730783667
    • id: 4742023
    • processed: 1
    • raw_data:
      {
          "id": 2,
          "language": 4,
          "newbook_region": 0,
          "tenant": 1,
          "translation": 5,
          "translation_id": 3
      }
    • schema_attributes:
      {
          "id": "string",
          "language": "string",
          "newbook_region": "string",
          "tenant": "string",
          "translation": "string",
          "translation_id": "string"
      }
    • schema_name_id: 2631
    • schema_scan_id: 6667240
    • updated: 2024-11-05 01:59:09
    • created: 2024-11-05 01:35:05
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstances_translations`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstances_translations`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `translation_id`  string , `language`  string , `translation`  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_newbookinstances_translations/2024-11-04/1730783526'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstances_translations"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstances_translations/2024-11-04/1730783526
    • id: 4741111
    • processed: 1
    • raw_data:
      {
          "id": 2,
          "language": 4,
          "newbook_region": 0,
          "tenant": 1,
          "translation": 5,
          "translation_id": 3
      }
    • schema_attributes:
      {
          "id": "string",
          "language": "string",
          "newbook_region": "string",
          "tenant": "string",
          "translation": "string",
          "translation_id": "string"
      }
    • schema_name_id: 2631
    • schema_scan_id: 6666328
    • updated: 2024-11-05 01:35:19
    • created: 2024-11-05 01:15:07
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstances_translations`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstances_translations`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `translation_id`  string , `language`  string , `translation`  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_newbookinstances_translations/2024-11-04/1730783308'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstances_translations"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstances_translations/2024-11-04/1730783308
    • id: 4740355
    • processed: 1
    • raw_data:
      {
          "id": 2,
          "language": 4,
          "newbook_region": 0,
          "tenant": 1,
          "translation": 5,
          "translation_id": 3
      }
    • schema_attributes:
      {
          "id": "string",
          "language": "string",
          "newbook_region": "string",
          "tenant": "string",
          "translation": "string",
          "translation_id": "string"
      }
    • schema_name_id: 2631
    • schema_scan_id: 6665572
    • updated: 2024-11-05 01:15:20
    • created: 2024-11-05 00:57:54
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstances_translations`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstances_translations`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `translation_id`  string , `language`  string , `translation`  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_newbookinstances_translations/2024-11-04/1730782909'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstances_translations"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstances_translations/2024-11-04/1730782909
    • id: 4739713
    • processed: 1
    • raw_data:
      {
          "id": 2,
          "language": 4,
          "newbook_region": 0,
          "tenant": 1,
          "translation": 5,
          "translation_id": 3
      }
    • schema_attributes:
      {
          "id": "string",
          "language": "string",
          "newbook_region": "string",
          "tenant": "string",
          "translation": "string",
          "translation_id": "string"
      }
    • schema_name_id: 2631
    • schema_scan_id: 6664930
    • updated: 2024-11-05 00:58:05
    • created: 2024-11-05 00:25:44
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstances_translations`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstances_translations`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `translation_id`  string , `language`  string , `translation`  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_newbookinstances_translations/2024-11-04/1730782751'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstances_translations"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstances_translations/2024-11-04/1730782751
    • id: 4738488
    • processed: 1
    • raw_data:
      {
          "id": 2,
          "language": 4,
          "newbook_region": 0,
          "tenant": 1,
          "translation": 5,
          "translation_id": 3
      }
    • schema_attributes:
      {
          "id": "string",
          "language": "string",
          "newbook_region": "string",
          "tenant": "string",
          "translation": "string",
          "translation_id": "string"
      }
    • schema_name_id: 2631
    • schema_scan_id: 6663699
    • updated: 2024-11-05 00:25:55
Schema Scans: 15
Last at 2024-11-05 23:15:53
    • duration: 0:00:11.515492
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6675071
    • 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_newbookinstances_translations/2024-11-05/1730866515",
              "key": "raw/newbookdev_newbookinstances_translations/2024-11-05/1730866515/instances_translations.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_drivethru.newbookdev_newbookinstances_translations",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 8393188081948868094,
              "service_name": "drive-thru",
              "span_id": 10469764498413264416,
              "trace_id": 10668399111388730339
          }
      }
    • running: False
    • schema_name_id: 2631
    • start_time: 2024-11-05 23:15:53
    • success: True
    • trace_id: 10668399111388730339
    • duration: 0:00:14.220997
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6674491
    • 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_newbookinstances_translations/2024-11-05/1730866441",
              "key": "raw/newbookdev_newbookinstances_translations/2024-11-05/1730866441/instances_translations.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_drivethru.newbookdev_newbookinstances_translations",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 16741394016058277142,
              "service_name": "drive-thru",
              "span_id": 5479303057284120276,
              "trace_id": 7802529925720591562
          }
      }
    • running: False
    • schema_name_id: 2631
    • start_time: 2024-11-05 22:47:00
    • success: True
    • trace_id: 7802529925720591562
    • duration: 0:00:11.322293
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6673831
    • 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_newbookinstances_translations/2024-11-05/1730866318",
              "key": "raw/newbookdev_newbookinstances_translations/2024-11-05/1730866318/instances_translations.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_drivethru.newbookdev_newbookinstances_translations",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 7129902242861098845,
              "service_name": "drive-thru",
              "span_id": 7558076193149357350,
              "trace_id": 2795314866899258121
          }
      }
    • running: False
    • schema_name_id: 2631
    • start_time: 2024-11-05 22:26:16
    • success: True
    • trace_id: 2795314866899258121
    • duration: 0:00:14.105344
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6672007
    • 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_newbookinstances_translations/2024-11-04/1730785727",
              "key": "raw/newbookdev_newbookinstances_translations/2024-11-04/1730785727/instances_translations.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_drivethru.newbookdev_newbookinstances_translations",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 1353014249515687257,
              "service_name": "drive-thru",
              "span_id": 10030008479929256467,
              "trace_id": 10108491912101921161
          }
      }
    • running: False
    • schema_name_id: 2631
    • start_time: 2024-11-05 04:22:33
    • success: True
    • trace_id: 10108491912101921161
    • duration: 0:00:11.492376
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6671384
    • 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_newbookinstances_translations/2024-11-04/1730785128",
              "key": "raw/newbookdev_newbookinstances_translations/2024-11-04/1730785128/instances_translations.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_drivethru.newbookdev_newbookinstances_translations",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 17227399200106191369,
              "service_name": "drive-thru",
              "span_id": 12003906389013918706,
              "trace_id": 4618399055748640684
          }
      }
    • running: False
    • schema_name_id: 2631
    • start_time: 2024-11-05 03:51:30
    • success: True
    • trace_id: 4618399055748640684
    • duration: 0:00:11.297753
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6669973
    • 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_newbookinstances_translations/2024-11-04/1730784823",
              "key": "raw/newbookdev_newbookinstances_translations/2024-11-04/1730784823/instances_translations.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_drivethru.newbookdev_newbookinstances_translations",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 4457225609222862642,
              "service_name": "drive-thru",
              "span_id": 5918350494344447999,
              "trace_id": 13861074293971509889
          }
      }
    • running: False
    • schema_name_id: 2631
    • start_time: 2024-11-05 03:11:34
    • success: True
    • trace_id: 13861074293971509889
    • duration: 0:00:11.319396
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6669350
    • 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_newbookinstances_translations/2024-11-04/1730784219",
              "key": "raw/newbookdev_newbookinstances_translations/2024-11-04/1730784219/instances_translations.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_drivethru.newbookdev_newbookinstances_translations",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 14341539751438207641,
              "service_name": "drive-thru",
              "span_id": 1738561346449248709,
              "trace_id": 18143322292403069006
          }
      }
    • running: False
    • schema_name_id: 2631
    • start_time: 2024-11-05 02:54:51
    • success: True
    • trace_id: 18143322292403069006
    • duration: 0:00:13.805858
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6668630
    • 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_newbookinstances_translations/2024-11-04/1730784057",
              "key": "raw/newbookdev_newbookinstances_translations/2024-11-04/1730784057/instances_translations.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_drivethru.newbookdev_newbookinstances_translations",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 1615172074032088091,
              "service_name": "drive-thru",
              "span_id": 17824887089413649163,
              "trace_id": 5839076315612489042
          }
      }
    • running: False
    • schema_name_id: 2631
    • start_time: 2024-11-05 02:35:58
    • success: True
    • trace_id: 5839076315612489042
    • duration: 0:00:11.413184
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6668465
    • 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_newbookinstances_translations/2024-11-04/1730783902",
              "key": "raw/newbookdev_newbookinstances_translations/2024-11-04/1730783902/instances_translations.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_drivethru.newbookdev_newbookinstances_translations",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 7745898207405977380,
              "service_name": "drive-thru",
              "span_id": 4456643560334648342,
              "trace_id": 16800980608415883087
          }
      }
    • running: False
    • schema_name_id: 2631
    • start_time: 2024-11-05 02:31:30
    • success: True
    • trace_id: 16800980608415883087
    • duration: 0:00:11.376399
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6667857
    • 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_newbookinstances_translations/2024-11-04/1730783770",
              "key": "raw/newbookdev_newbookinstances_translations/2024-11-04/1730783770/instances_translations.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_drivethru.newbookdev_newbookinstances_translations",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 3114619244275056226,
              "service_name": "drive-thru",
              "span_id": 9355928795384019544,
              "trace_id": 15087656473528336629
          }
      }
    • running: False
    • schema_name_id: 2631
    • start_time: 2024-11-05 02:15:32
    • success: True
    • trace_id: 15087656473528336629
    • duration: 0:00:11.376825
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6667240
    • 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_newbookinstances_translations/2024-11-04/1730783667",
              "key": "raw/newbookdev_newbookinstances_translations/2024-11-04/1730783667/instances_translations.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_drivethru.newbookdev_newbookinstances_translations",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 6836996998850000047,
              "service_name": "drive-thru",
              "span_id": 10670208959415374175,
              "trace_id": 11377842824458766187
          }
      }
    • running: False
    • schema_name_id: 2631
    • start_time: 2024-11-05 01:58:57
    • success: True
    • trace_id: 11377842824458766187
    • duration: 0:00:13.875555
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6666328
    • 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_newbookinstances_translations/2024-11-04/1730783526",
              "key": "raw/newbookdev_newbookinstances_translations/2024-11-04/1730783526/instances_translations.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_drivethru.newbookdev_newbookinstances_translations",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 15158171759081745862,
              "service_name": "drive-thru",
              "span_id": 8607084539412830060,
              "trace_id": 4554466568030342607
          }
      }
    • running: False
    • schema_name_id: 2631
    • start_time: 2024-11-05 01:35:05
    • success: True
    • trace_id: 4554466568030342607
    • duration: 0:00:13.881823
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6665572
    • 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_newbookinstances_translations/2024-11-04/1730783308",
              "key": "raw/newbookdev_newbookinstances_translations/2024-11-04/1730783308/instances_translations.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_drivethru.newbookdev_newbookinstances_translations",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 4614111959811433374,
              "service_name": "drive-thru",
              "span_id": 1927805147088607367,
              "trace_id": 10156767912832287073
          }
      }
    • running: False
    • schema_name_id: 2631
    • start_time: 2024-11-05 01:15:06
    • success: True
    • trace_id: 10156767912832287073
    • duration: 0:00:11.435055
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6664930
    • 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_newbookinstances_translations/2024-11-04/1730782909",
              "key": "raw/newbookdev_newbookinstances_translations/2024-11-04/1730782909/instances_translations.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_drivethru.newbookdev_newbookinstances_translations",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 6084343231526593547,
              "service_name": "drive-thru",
              "span_id": 14993178745863132653,
              "trace_id": 17137119832659810486
          }
      }
    • running: False
    • schema_name_id: 2631
    • start_time: 2024-11-05 00:57:54
    • success: True
    • trace_id: 17137119832659810486
    • duration: 0:00:11.441900
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6663699
    • 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_newbookinstances_translations/2024-11-04/1730782751",
              "key": "raw/newbookdev_newbookinstances_translations/2024-11-04/1730782751/instances_translations.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_drivethru.newbookdev_newbookinstances_translations",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 17957472998700866718,
              "service_name": "drive-thru",
              "span_id": 7495377526640131824,
              "trace_id": 17159419368213498100
          }
      }
    • running: False
    • schema_name_id: 2631
    • start_time: 2024-11-05 00:25:44
    • success: True
    • trace_id: 17159419368213498100
Partitions:
  • count: 0
  • ddl: None
  • name: None
  • state:
    []
  • type: None
Schema:
  • attributes:
    {
        "id": "string",
        "language": "string",
        "newbook_region": "string",
        "tenant": "string",
        "translation": "string",
        "translation_id": "string"
    }
  • created: 2024-11-05 23:15:54
  • ddl:
    {
        "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
        "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstances_translations`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `translation_id`  string , `language`  string , `translation`  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_newbookinstances_translations/2024-11-05/1730866515'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
        "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstances_translations`",
        "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstances_translations"
    }
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:53:02",
        "disabled": false,
        "format": "raw",
        "id": 2631,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_drivethru",
            "table": "newbookdev_newbookinstances_translations"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "id": "string",
            "language": "string",
            "newbook_region": "string",
            "tenant": "string",
            "translation": "string",
            "translation_id": "string"
        },
        "created": "2024-11-05 23:15:54",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstances_translations`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `translation_id`  string , `language`  string , `translation`  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_newbookinstances_translations/2024-11-05/1730866515'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstances_translations`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstances_translations"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}