Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbookshared_users_languages
  • created: 2024-10-08 18:28:46
  • disabled: False
  • format: raw
  • id: 2996
  • is_partitioned: False
  • is_schema_datatyped: True
  • name:
    {
        "database": "sfdl_dev_drivethru",
        "table": "newbookdev_newbookshared_users_languages"
    }
  • type: drivethrucsv
Schema Versions: 15
    • created: 2024-11-05 23:30:25
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookshared_users_languages`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookshared_users_languages`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `user_id`  string , `language`  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_newbookshared_users_languages/2024-11-05/1730866600'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookshared_users_languages"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookshared_users_languages/2024-11-05/1730866600
    • id: 4749244
    • processed: 1
    • raw_data:
      {
          "id": 2,
          "language": 4,
          "newbook_region": 0,
          "tenant": 1,
          "user_id": 3
      }
    • schema_attributes:
      {
          "id": "string",
          "language": "string",
          "newbook_region": "string",
          "tenant": "string",
          "user_id": "string"
      }
    • schema_name_id: 2996
    • schema_scan_id: 6675276
    • updated: 2024-11-05 23:30:39
    • created: 2024-11-05 23:11:49
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookshared_users_languages`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookshared_users_languages`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `user_id`  string , `language`  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_newbookshared_users_languages/2024-11-05/1730866544'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookshared_users_languages"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookshared_users_languages/2024-11-05/1730866544
    • id: 4748974
    • processed: 1
    • raw_data:
      {
          "id": 2,
          "language": 4,
          "newbook_region": 0,
          "tenant": 1,
          "user_id": 3
      }
    • schema_attributes:
      {
          "id": "string",
          "language": "string",
          "newbook_region": "string",
          "tenant": "string",
          "user_id": "string"
      }
    • schema_name_id: 2996
    • schema_scan_id: 6675006
    • updated: 2024-11-05 23:12:00
    • created: 2024-11-05 22:45:22
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookshared_users_languages`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookshared_users_languages`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `user_id`  string , `language`  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_newbookshared_users_languages/2024-11-05/1730866432'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookshared_users_languages"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookshared_users_languages/2024-11-05/1730866432
    • id: 4748412
    • processed: 1
    • raw_data:
      {
          "id": 2,
          "language": 4,
          "newbook_region": 0,
          "tenant": 1,
          "user_id": 3
      }
    • schema_attributes:
      {
          "id": "string",
          "language": "string",
          "newbook_region": "string",
          "tenant": "string",
          "user_id": "string"
      }
    • schema_name_id: 2996
    • schema_scan_id: 6674444
    • updated: 2024-11-05 22:45:34
    • created: 2024-11-05 04:48:56
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookshared_users_languages`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookshared_users_languages`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `user_id`  string , `language`  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_newbookshared_users_languages/2024-11-04/1730785794'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookshared_users_languages"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookshared_users_languages/2024-11-04/1730785794
    • id: 4747087
    • processed: 1
    • raw_data:
      {
          "id": 2,
          "language": 4,
          "newbook_region": 0,
          "tenant": 1,
          "user_id": 3
      }
    • schema_attributes:
      {
          "id": "string",
          "language": "string",
          "newbook_region": "string",
          "tenant": "string",
          "user_id": "string"
      }
    • schema_name_id: 2996
    • schema_scan_id: 6672319
    • updated: 2024-11-05 04:49:07
    • created: 2024-11-05 04:03:53
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookshared_users_languages`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookshared_users_languages`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `user_id`  string , `language`  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_newbookshared_users_languages/2024-11-04/1730785165'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookshared_users_languages"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookshared_users_languages/2024-11-04/1730785165
    • id: 4746456
    • processed: 1
    • raw_data:
      {
          "id": 2,
          "language": 4,
          "newbook_region": 0,
          "tenant": 1,
          "user_id": 3
      }
    • schema_attributes:
      {
          "id": "string",
          "language": "string",
          "newbook_region": "string",
          "tenant": "string",
          "user_id": "string"
      }
    • schema_name_id: 2996
    • schema_scan_id: 6671677
    • updated: 2024-11-05 04:04:06
    • created: 2024-11-05 03:36:59
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookshared_users_languages`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookshared_users_languages`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `user_id`  string , `language`  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_newbookshared_users_languages/2024-11-04/1730784860'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookshared_users_languages"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookshared_users_languages/2024-11-04/1730784860
    • id: 4745725
    • processed: 1
    • raw_data:
      {
          "id": 2,
          "language": 4,
          "newbook_region": 0,
          "tenant": 1,
          "user_id": 3
      }
    • schema_attributes:
      {
          "id": "string",
          "language": "string",
          "newbook_region": "string",
          "tenant": "string",
          "user_id": "string"
      }
    • schema_name_id: 2996
    • schema_scan_id: 6670942
    • updated: 2024-11-05 03:37:10
    • created: 2024-11-05 03:22:01
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookshared_users_languages`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookshared_users_languages`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `user_id`  string , `language`  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_newbookshared_users_languages/2024-11-04/1730784257'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookshared_users_languages"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookshared_users_languages/2024-11-04/1730784257
    • id: 4745154
    • processed: 1
    • raw_data:
      {
          "id": 2,
          "language": 4,
          "newbook_region": 0,
          "tenant": 1,
          "user_id": 3
      }
    • schema_attributes:
      {
          "id": "string",
          "language": "string",
          "newbook_region": "string",
          "tenant": "string",
          "user_id": "string"
      }
    • schema_name_id: 2996
    • schema_scan_id: 6670371
    • updated: 2024-11-05 03:22:14
    • created: 2024-11-05 02:54:36
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookshared_users_languages`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookshared_users_languages`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `user_id`  string , `language`  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_newbookshared_users_languages/2024-11-04/1730784094'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookshared_users_languages"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookshared_users_languages/2024-11-04/1730784094
    • id: 4744122
    • processed: 1
    • raw_data:
      {
          "id": 2,
          "language": 4,
          "newbook_region": 0,
          "tenant": 1,
          "user_id": 3
      }
    • schema_attributes:
      {
          "id": "string",
          "language": "string",
          "newbook_region": "string",
          "tenant": "string",
          "user_id": "string"
      }
    • schema_name_id: 2996
    • schema_scan_id: 6669339
    • updated: 2024-11-05 02:54:47
    • created: 2024-11-05 02:33:37
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookshared_users_languages`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookshared_users_languages`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `user_id`  string , `language`  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_newbookshared_users_languages/2024-11-04/1730783854'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookshared_users_languages"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookshared_users_languages/2024-11-04/1730783854
    • id: 4743324
    • processed: 1
    • raw_data:
      {
          "id": 2,
          "language": 4,
          "newbook_region": 0,
          "tenant": 1,
          "user_id": 3
      }
    • schema_attributes:
      {
          "id": "string",
          "language": "string",
          "newbook_region": "string",
          "tenant": "string",
          "user_id": "string"
      }
    • schema_name_id: 2996
    • schema_scan_id: 6668541
    • updated: 2024-11-05 02:33:48
    • created: 2024-11-05 02:19:47
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookshared_users_languages`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookshared_users_languages`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `user_id`  string , `language`  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_newbookshared_users_languages/2024-11-04/1730783808'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookshared_users_languages"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookshared_users_languages/2024-11-04/1730783808
    • id: 4742802
    • processed: 1
    • raw_data:
      {
          "id": 2,
          "language": 4,
          "newbook_region": 0,
          "tenant": 1,
          "user_id": 3
      }
    • schema_attributes:
      {
          "id": "string",
          "language": "string",
          "newbook_region": "string",
          "tenant": "string",
          "user_id": "string"
      }
    • schema_name_id: 2996
    • schema_scan_id: 6668019
    • updated: 2024-11-05 02:19:58
    • created: 2024-11-05 01:57:40
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookshared_users_languages`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookshared_users_languages`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `user_id`  string , `language`  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_newbookshared_users_languages/2024-11-04/1730783696'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookshared_users_languages"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookshared_users_languages/2024-11-04/1730783696
    • id: 4741971
    • processed: 1
    • raw_data:
      {
          "id": 2,
          "language": 4,
          "newbook_region": 0,
          "tenant": 1,
          "user_id": 3
      }
    • schema_attributes:
      {
          "id": "string",
          "language": "string",
          "newbook_region": "string",
          "tenant": "string",
          "user_id": "string"
      }
    • schema_name_id: 2996
    • schema_scan_id: 6667189
    • updated: 2024-11-05 01:57:51
    • created: 2024-11-05 01:43:17
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookshared_users_languages`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookshared_users_languages`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `user_id`  string , `language`  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_newbookshared_users_languages/2024-11-04/1730783565'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookshared_users_languages"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookshared_users_languages/2024-11-04/1730783565
    • id: 4741427
    • processed: 1
    • raw_data:
      {
          "id": 2,
          "language": 4,
          "newbook_region": 0,
          "tenant": 1,
          "user_id": 3
      }
    • schema_attributes:
      {
          "id": "string",
          "language": "string",
          "newbook_region": "string",
          "tenant": "string",
          "user_id": "string"
      }
    • schema_name_id: 2996
    • schema_scan_id: 6666644
    • updated: 2024-11-05 01:43:28
    • created: 2024-11-05 01:20:58
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookshared_users_languages`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookshared_users_languages`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `user_id`  string , `language`  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_newbookshared_users_languages/2024-11-04/1730783347'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookshared_users_languages"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookshared_users_languages/2024-11-04/1730783347
    • id: 4740577
    • processed: 1
    • raw_data:
      {
          "id": 2,
          "language": 4,
          "newbook_region": 0,
          "tenant": 1,
          "user_id": 3
      }
    • schema_attributes:
      {
          "id": "string",
          "language": "string",
          "newbook_region": "string",
          "tenant": "string",
          "user_id": "string"
      }
    • schema_name_id: 2996
    • schema_scan_id: 6665794
    • updated: 2024-11-05 01:21:09
    • created: 2024-11-05 01:03:57
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookshared_users_languages`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookshared_users_languages`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `user_id`  string , `language`  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_newbookshared_users_languages/2024-11-04/1730782945'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookshared_users_languages"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookshared_users_languages/2024-11-04/1730782945
    • id: 4739936
    • processed: 1
    • raw_data:
      {
          "id": 2,
          "language": 4,
          "newbook_region": 0,
          "tenant": 1,
          "user_id": 3
      }
    • schema_attributes:
      {
          "id": "string",
          "language": "string",
          "newbook_region": "string",
          "tenant": "string",
          "user_id": "string"
      }
    • schema_name_id: 2996
    • schema_scan_id: 6665153
    • updated: 2024-11-05 01:04:08
    • created: 2024-11-05 00:45:10
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookshared_users_languages`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookshared_users_languages`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `user_id`  string , `language`  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_newbookshared_users_languages/2024-11-04/1730782835'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookshared_users_languages"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookshared_users_languages/2024-11-04/1730782835
    • id: 4739229
    • processed: 1
    • raw_data:
      {
          "id": 2,
          "language": 4,
          "newbook_region": 0,
          "tenant": 1,
          "user_id": 3
      }
    • schema_attributes:
      {
          "id": "string",
          "language": "string",
          "newbook_region": "string",
          "tenant": "string",
          "user_id": "string"
      }
    • schema_name_id: 2996
    • schema_scan_id: 6664444
    • updated: 2024-11-05 00:45:23
Schema Scans: 15
Last at 2024-11-05 23:30:25
    • duration: 0:00:13.971906
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6675276
    • 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_newbookshared_users_languages/2024-11-05/1730866600",
              "key": "raw/newbookdev_newbookshared_users_languages/2024-11-05/1730866600/shared_users_languages.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_drivethru.newbookdev_newbookshared_users_languages",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 76718932560108382,
              "service_name": "drive-thru",
              "span_id": 10038316750168123940,
              "trace_id": 2606899075581882186
          }
      }
    • running: False
    • schema_name_id: 2996
    • start_time: 2024-11-05 23:30:25
    • success: True
    • trace_id: 2606899075581882186
    • duration: 0:00:11.562198
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6675006
    • 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_newbookshared_users_languages/2024-11-05/1730866544",
              "key": "raw/newbookdev_newbookshared_users_languages/2024-11-05/1730866544/shared_users_languages.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_drivethru.newbookdev_newbookshared_users_languages",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 896801120540723298,
              "service_name": "drive-thru",
              "span_id": 11292312060665675536,
              "trace_id": 6045288204799049135
          }
      }
    • running: False
    • schema_name_id: 2996
    • start_time: 2024-11-05 23:11:48
    • success: True
    • trace_id: 6045288204799049135
    • duration: 0:00:11.566281
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6674444
    • 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_newbookshared_users_languages/2024-11-05/1730866432",
              "key": "raw/newbookdev_newbookshared_users_languages/2024-11-05/1730866432/shared_users_languages.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_drivethru.newbookdev_newbookshared_users_languages",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 9860557920861136167,
              "service_name": "drive-thru",
              "span_id": 4871776726690175638,
              "trace_id": 8101783153852190567
          }
      }
    • running: False
    • schema_name_id: 2996
    • start_time: 2024-11-05 22:45:22
    • success: True
    • trace_id: 8101783153852190567
    • duration: 0:00:11.477299
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6672319
    • 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_newbookshared_users_languages/2024-11-04/1730785794",
              "key": "raw/newbookdev_newbookshared_users_languages/2024-11-04/1730785794/shared_users_languages.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_drivethru.newbookdev_newbookshared_users_languages",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 10544695955698142983,
              "service_name": "drive-thru",
              "span_id": 9406921278004541843,
              "trace_id": 3944632050860660874
          }
      }
    • running: False
    • schema_name_id: 2996
    • start_time: 2024-11-05 04:48:55
    • success: True
    • trace_id: 3944632050860660874
    • duration: 0:00:13.972571
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6671677
    • 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_newbookshared_users_languages/2024-11-04/1730785165",
              "key": "raw/newbookdev_newbookshared_users_languages/2024-11-04/1730785165/shared_users_languages.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_drivethru.newbookdev_newbookshared_users_languages",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 1877552700000777277,
              "service_name": "drive-thru",
              "span_id": 8733810423907563136,
              "trace_id": 225325754367466246
          }
      }
    • running: False
    • schema_name_id: 2996
    • start_time: 2024-11-05 04:03:52
    • success: True
    • trace_id: 225325754367466246
    • duration: 0:00:11.468555
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6670942
    • 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_newbookshared_users_languages/2024-11-04/1730784860",
              "key": "raw/newbookdev_newbookshared_users_languages/2024-11-04/1730784860/shared_users_languages.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_drivethru.newbookdev_newbookshared_users_languages",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 12093958476564804313,
              "service_name": "drive-thru",
              "span_id": 12711177329239844997,
              "trace_id": 7502590339562783389
          }
      }
    • running: False
    • schema_name_id: 2996
    • start_time: 2024-11-05 03:36:59
    • success: True
    • trace_id: 7502590339562783389
    • duration: 0:00:13.790548
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6670371
    • 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_newbookshared_users_languages/2024-11-04/1730784257",
              "key": "raw/newbookdev_newbookshared_users_languages/2024-11-04/1730784257/shared_users_languages.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_drivethru.newbookdev_newbookshared_users_languages",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 1593395170421792576,
              "service_name": "drive-thru",
              "span_id": 13974965661230639533,
              "trace_id": 5113398631693793278
          }
      }
    • running: False
    • schema_name_id: 2996
    • start_time: 2024-11-05 03:22:00
    • success: True
    • trace_id: 5113398631693793278
    • duration: 0:00:11.309656
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6669339
    • 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_newbookshared_users_languages/2024-11-04/1730784094",
              "key": "raw/newbookdev_newbookshared_users_languages/2024-11-04/1730784094/shared_users_languages.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_drivethru.newbookdev_newbookshared_users_languages",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 10457861046031968864,
              "service_name": "drive-thru",
              "span_id": 13950557316411656843,
              "trace_id": 9950463031630365421
          }
      }
    • running: False
    • schema_name_id: 2996
    • start_time: 2024-11-05 02:54:35
    • success: True
    • trace_id: 9950463031630365421
    • duration: 0:00:11.314991
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6668541
    • 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_newbookshared_users_languages/2024-11-04/1730783854",
              "key": "raw/newbookdev_newbookshared_users_languages/2024-11-04/1730783854/shared_users_languages.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_drivethru.newbookdev_newbookshared_users_languages",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 14313837391367488260,
              "service_name": "drive-thru",
              "span_id": 9184435653339323334,
              "trace_id": 17606883292160286044
          }
      }
    • running: False
    • schema_name_id: 2996
    • start_time: 2024-11-05 02:33:37
    • success: True
    • trace_id: 17606883292160286044
    • duration: 0:00:11.336248
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6668019
    • 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_newbookshared_users_languages/2024-11-04/1730783808",
              "key": "raw/newbookdev_newbookshared_users_languages/2024-11-04/1730783808/shared_users_languages.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_drivethru.newbookdev_newbookshared_users_languages",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 4894379153801442349,
              "service_name": "drive-thru",
              "span_id": 811121064665299027,
              "trace_id": 10088338728994779071
          }
      }
    • running: False
    • schema_name_id: 2996
    • start_time: 2024-11-05 02:19:46
    • success: True
    • trace_id: 10088338728994779071
    • duration: 0:00:11.309023
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6667189
    • 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_newbookshared_users_languages/2024-11-04/1730783696",
              "key": "raw/newbookdev_newbookshared_users_languages/2024-11-04/1730783696/shared_users_languages.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_drivethru.newbookdev_newbookshared_users_languages",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 3135641593649842609,
              "service_name": "drive-thru",
              "span_id": 5921935427815469626,
              "trace_id": 7184316977427636136
          }
      }
    • running: False
    • schema_name_id: 2996
    • start_time: 2024-11-05 01:57:40
    • success: True
    • trace_id: 7184316977427636136
    • duration: 0:00:11.315479
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6666644
    • 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_newbookshared_users_languages/2024-11-04/1730783565",
              "key": "raw/newbookdev_newbookshared_users_languages/2024-11-04/1730783565/shared_users_languages.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_drivethru.newbookdev_newbookshared_users_languages",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 2143775026534750243,
              "service_name": "drive-thru",
              "span_id": 15262695148951156638,
              "trace_id": 18370723210537456970
          }
      }
    • running: False
    • schema_name_id: 2996
    • start_time: 2024-11-05 01:43:17
    • success: True
    • trace_id: 18370723210537456970
    • duration: 0:00:11.271561
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6665794
    • 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_newbookshared_users_languages/2024-11-04/1730783347",
              "key": "raw/newbookdev_newbookshared_users_languages/2024-11-04/1730783347/shared_users_languages.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_drivethru.newbookdev_newbookshared_users_languages",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 11577091195831825267,
              "service_name": "drive-thru",
              "span_id": 5664341362383745488,
              "trace_id": 6131438907111101928
          }
      }
    • running: False
    • schema_name_id: 2996
    • start_time: 2024-11-05 01:20:58
    • success: True
    • trace_id: 6131438907111101928
    • duration: 0:00:11.443457
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6665153
    • 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_newbookshared_users_languages/2024-11-04/1730782945",
              "key": "raw/newbookdev_newbookshared_users_languages/2024-11-04/1730782945/shared_users_languages.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_drivethru.newbookdev_newbookshared_users_languages",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 4750537793963115743,
              "service_name": "drive-thru",
              "span_id": 13554678989410495131,
              "trace_id": 7233663085561297128
          }
      }
    • running: False
    • schema_name_id: 2996
    • start_time: 2024-11-05 01:03:57
    • success: True
    • trace_id: 7233663085561297128
    • duration: 0:00:13.891297
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6664444
    • 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_newbookshared_users_languages/2024-11-04/1730782835",
              "key": "raw/newbookdev_newbookshared_users_languages/2024-11-04/1730782835/shared_users_languages.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_drivethru.newbookdev_newbookshared_users_languages",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 18401072333125949027,
              "service_name": "drive-thru",
              "span_id": 16892171919697510932,
              "trace_id": 10700777675726767062
          }
      }
    • running: False
    • schema_name_id: 2996
    • start_time: 2024-11-05 00:45:09
    • success: True
    • trace_id: 10700777675726767062
Partitions:
  • count: 0
  • ddl: None
  • name: None
  • state:
    []
  • type: None
Schema:
  • attributes:
    {
        "id": "string",
        "language": "string",
        "newbook_region": "string",
        "tenant": "string",
        "user_id": "string"
    }
  • created: 2024-11-05 23:30:25
  • ddl:
    {
        "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
        "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookshared_users_languages`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `user_id`  string , `language`  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_newbookshared_users_languages/2024-11-05/1730866600'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
        "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookshared_users_languages`",
        "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookshared_users_languages"
    }
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:28:46",
        "disabled": false,
        "format": "raw",
        "id": 2996,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_drivethru",
            "table": "newbookdev_newbookshared_users_languages"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "id": "string",
            "language": "string",
            "newbook_region": "string",
            "tenant": "string",
            "user_id": "string"
        },
        "created": "2024-11-05 23:30:25",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookshared_users_languages`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `user_id`  string , `language`  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_newbookshared_users_languages/2024-11-05/1730866600'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookshared_users_languages`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookshared_users_languages"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}