Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbookreports_configuration_user_link
  • created: 2024-10-08 18:26:11
  • disabled: False
  • format: raw
  • id: 2972
  • is_partitioned: False
  • is_schema_datatyped: True
  • name:
    {
        "database": "sfdl_dev_drivethru",
        "table": "newbookdev_newbookreports_configuration_user_link"
    }
  • type: drivethrucsv
Schema Versions: 15
    • created: 2024-11-05 23:50:25
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookreports_configuration_user_link`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookreports_configuration_user_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `report_id`  string , `user_id`  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_newbookreports_configuration_user_link/2024-11-05/1730866594'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookreports_configuration_user_link"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookreports_configuration_user_link/2024-11-05/1730866594
    • id: 4749433
    • processed: 1
    • raw_data:
      {
          "id": 2,
          "newbook_region": 0,
          "report_id": 3,
          "tenant": 1,
          "user_id": 4
      }
    • schema_attributes:
      {
          "id": "string",
          "newbook_region": "string",
          "report_id": "string",
          "tenant": "string",
          "user_id": "string"
      }
    • schema_name_id: 2972
    • schema_scan_id: 6675484
    • updated: 2024-11-05 23:50:38
    • created: 2024-11-05 23:09:46
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookreports_configuration_user_link`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookreports_configuration_user_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `report_id`  string , `user_id`  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_newbookreports_configuration_user_link/2024-11-05/1730866535'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookreports_configuration_user_link"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookreports_configuration_user_link/2024-11-05/1730866535
    • id: 4748937
    • processed: 1
    • raw_data:
      {
          "id": 2,
          "newbook_region": 0,
          "report_id": 3,
          "tenant": 1,
          "user_id": 4
      }
    • schema_attributes:
      {
          "id": "string",
          "newbook_region": "string",
          "report_id": "string",
          "tenant": "string",
          "user_id": "string"
      }
    • schema_name_id: 2972
    • schema_scan_id: 6674969
    • updated: 2024-11-05 23:09:59
    • created: 2024-11-05 22:46:23
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookreports_configuration_user_link`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookreports_configuration_user_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `report_id`  string , `user_id`  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_newbookreports_configuration_user_link/2024-11-05/1730866418'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookreports_configuration_user_link"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookreports_configuration_user_link/2024-11-05/1730866418
    • id: 4748440
    • processed: 1
    • raw_data:
      {
          "id": 2,
          "newbook_region": 0,
          "report_id": 3,
          "tenant": 1,
          "user_id": 4
      }
    • schema_attributes:
      {
          "id": "string",
          "newbook_region": "string",
          "report_id": "string",
          "tenant": "string",
          "user_id": "string"
      }
    • schema_name_id: 2972
    • schema_scan_id: 6674472
    • updated: 2024-11-05 22:46:34
    • created: 2024-11-05 04:40:02
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookreports_configuration_user_link`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookreports_configuration_user_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `report_id`  string , `user_id`  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_newbookreports_configuration_user_link/2024-11-04/1730785787'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookreports_configuration_user_link"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookreports_configuration_user_link/2024-11-04/1730785787
    • id: 4747004
    • processed: 1
    • raw_data:
      {
          "id": 2,
          "newbook_region": 0,
          "report_id": 3,
          "tenant": 1,
          "user_id": 4
      }
    • schema_attributes:
      {
          "id": "string",
          "newbook_region": "string",
          "report_id": "string",
          "tenant": "string",
          "user_id": "string"
      }
    • schema_name_id: 2972
    • schema_scan_id: 6672235
    • updated: 2024-11-05 04:40:13
    • created: 2024-11-05 03:41:56
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookreports_configuration_user_link`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookreports_configuration_user_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `report_id`  string , `user_id`  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_newbookreports_configuration_user_link/2024-11-04/1730784857'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookreports_configuration_user_link"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookreports_configuration_user_link/2024-11-04/1730784857
    • id: 4745886
    • processed: 1
    • raw_data:
      {
          "id": 2,
          "newbook_region": 0,
          "report_id": 3,
          "tenant": 1,
          "user_id": 4
      }
    • schema_attributes:
      {
          "id": "string",
          "newbook_region": "string",
          "report_id": "string",
          "tenant": "string",
          "user_id": "string"
      }
    • schema_name_id: 2972
    • schema_scan_id: 6671104
    • updated: 2024-11-05 03:42:07
    • created: 2024-11-05 03:35:29
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookreports_configuration_user_link`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookreports_configuration_user_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `report_id`  string , `user_id`  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_newbookreports_configuration_user_link/2024-11-04/1730785162'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookreports_configuration_user_link"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookreports_configuration_user_link/2024-11-04/1730785162
    • id: 4745668
    • processed: 1
    • raw_data:
      {
          "id": 2,
          "newbook_region": 0,
          "report_id": 3,
          "tenant": 1,
          "user_id": 4
      }
    • schema_attributes:
      {
          "id": "string",
          "newbook_region": "string",
          "report_id": "string",
          "tenant": "string",
          "user_id": "string"
      }
    • schema_name_id: 2972
    • schema_scan_id: 6670885
    • updated: 2024-11-05 03:35:43
    • created: 2024-11-05 03:21:29
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookreports_configuration_user_link`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookreports_configuration_user_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `report_id`  string , `user_id`  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_newbookreports_configuration_user_link/2024-11-04/1730784253'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookreports_configuration_user_link"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookreports_configuration_user_link/2024-11-04/1730784253
    • id: 4745134
    • processed: 1
    • raw_data:
      {
          "id": 2,
          "newbook_region": 0,
          "report_id": 3,
          "tenant": 1,
          "user_id": 4
      }
    • schema_attributes:
      {
          "id": "string",
          "newbook_region": "string",
          "report_id": "string",
          "tenant": "string",
          "user_id": "string"
      }
    • schema_name_id: 2972
    • schema_scan_id: 6670351
    • updated: 2024-11-05 03:21:40
    • created: 2024-11-05 02:58:55
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookreports_configuration_user_link`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookreports_configuration_user_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `report_id`  string , `user_id`  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_newbookreports_configuration_user_link/2024-11-04/1730784090'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookreports_configuration_user_link"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookreports_configuration_user_link/2024-11-04/1730784090
    • id: 4744288
    • processed: 1
    • raw_data:
      {
          "id": 2,
          "newbook_region": 0,
          "report_id": 3,
          "tenant": 1,
          "user_id": 4
      }
    • schema_attributes:
      {
          "id": "string",
          "newbook_region": "string",
          "report_id": "string",
          "tenant": "string",
          "user_id": "string"
      }
    • schema_name_id: 2972
    • schema_scan_id: 6669505
    • updated: 2024-11-05 02:59:06
    • created: 2024-11-05 02:38:17
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookreports_configuration_user_link`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookreports_configuration_user_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `report_id`  string , `user_id`  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_newbookreports_configuration_user_link/2024-11-04/1730783927'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookreports_configuration_user_link"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookreports_configuration_user_link/2024-11-04/1730783927
    • id: 4743500
    • processed: 1
    • raw_data:
      {
          "id": 2,
          "newbook_region": 0,
          "report_id": 3,
          "tenant": 1,
          "user_id": 4
      }
    • schema_attributes:
      {
          "id": "string",
          "newbook_region": "string",
          "report_id": "string",
          "tenant": "string",
          "user_id": "string"
      }
    • schema_name_id: 2972
    • schema_scan_id: 6668718
    • updated: 2024-11-05 02:38:28
    • created: 2024-11-05 02:05:32
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookreports_configuration_user_link`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookreports_configuration_user_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `report_id`  string , `user_id`  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_newbookreports_configuration_user_link/2024-11-04/1730783804'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookreports_configuration_user_link"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookreports_configuration_user_link/2024-11-04/1730783804
    • id: 4742263
    • processed: 1
    • raw_data:
      {
          "id": 2,
          "newbook_region": 0,
          "report_id": 3,
          "tenant": 1,
          "user_id": 4
      }
    • schema_attributes:
      {
          "id": "string",
          "newbook_region": "string",
          "report_id": "string",
          "tenant": "string",
          "user_id": "string"
      }
    • schema_name_id: 2972
    • schema_scan_id: 6667480
    • updated: 2024-11-05 02:05:45
    • created: 2024-11-05 02:01:58
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookreports_configuration_user_link`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookreports_configuration_user_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `report_id`  string , `user_id`  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_newbookreports_configuration_user_link/2024-11-04/1730783693'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookreports_configuration_user_link"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookreports_configuration_user_link/2024-11-04/1730783693
    • id: 4742133
    • processed: 1
    • raw_data:
      {
          "id": 2,
          "newbook_region": 0,
          "report_id": 3,
          "tenant": 1,
          "user_id": 4
      }
    • schema_attributes:
      {
          "id": "string",
          "newbook_region": "string",
          "report_id": "string",
          "tenant": "string",
          "user_id": "string"
      }
    • schema_name_id: 2972
    • schema_scan_id: 6667350
    • updated: 2024-11-05 02:02:11
    • created: 2024-11-05 01:43:59
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookreports_configuration_user_link`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookreports_configuration_user_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `report_id`  string , `user_id`  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_newbookreports_configuration_user_link/2024-11-04/1730783561'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookreports_configuration_user_link"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookreports_configuration_user_link/2024-11-04/1730783561
    • id: 4741453
    • processed: 1
    • raw_data:
      {
          "id": 2,
          "newbook_region": 0,
          "report_id": 3,
          "tenant": 1,
          "user_id": 4
      }
    • schema_attributes:
      {
          "id": "string",
          "newbook_region": "string",
          "report_id": "string",
          "tenant": "string",
          "user_id": "string"
      }
    • schema_name_id: 2972
    • schema_scan_id: 6666670
    • updated: 2024-11-05 01:44:12
    • created: 2024-11-05 01:17:51
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookreports_configuration_user_link`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookreports_configuration_user_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `report_id`  string , `user_id`  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_newbookreports_configuration_user_link/2024-11-04/1730783343'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookreports_configuration_user_link"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookreports_configuration_user_link/2024-11-04/1730783343
    • id: 4740458
    • processed: 1
    • raw_data:
      {
          "id": 2,
          "newbook_region": 0,
          "report_id": 3,
          "tenant": 1,
          "user_id": 4
      }
    • schema_attributes:
      {
          "id": "string",
          "newbook_region": "string",
          "report_id": "string",
          "tenant": "string",
          "user_id": "string"
      }
    • schema_name_id: 2972
    • schema_scan_id: 6665675
    • updated: 2024-11-05 01:18:02
    • created: 2024-11-05 01:01:34
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookreports_configuration_user_link`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookreports_configuration_user_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `report_id`  string , `user_id`  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_newbookreports_configuration_user_link/2024-11-04/1730782941'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookreports_configuration_user_link"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookreports_configuration_user_link/2024-11-04/1730782941
    • id: 4739849
    • processed: 1
    • raw_data:
      {
          "id": 2,
          "newbook_region": 0,
          "report_id": 3,
          "tenant": 1,
          "user_id": 4
      }
    • schema_attributes:
      {
          "id": "string",
          "newbook_region": "string",
          "report_id": "string",
          "tenant": "string",
          "user_id": "string"
      }
    • schema_name_id: 2972
    • schema_scan_id: 6665066
    • updated: 2024-11-05 01:01:47
    • created: 2024-11-05 00:32:50
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookreports_configuration_user_link`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookreports_configuration_user_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `report_id`  string , `user_id`  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_newbookreports_configuration_user_link/2024-11-04/1730782760'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookreports_configuration_user_link"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookreports_configuration_user_link/2024-11-04/1730782760
    • id: 4738757
    • processed: 1
    • raw_data:
      {
          "id": 2,
          "newbook_region": 0,
          "report_id": 3,
          "tenant": 1,
          "user_id": 4
      }
    • schema_attributes:
      {
          "id": "string",
          "newbook_region": "string",
          "report_id": "string",
          "tenant": "string",
          "user_id": "string"
      }
    • schema_name_id: 2972
    • schema_scan_id: 6663970
    • updated: 2024-11-05 00:33:00
Schema Scans: 15
Last at 2024-11-05 23:50:24
    • duration: 0:00:14.026948
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6675484
    • 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_newbookreports_configuration_user_link/2024-11-05/1730866594",
              "key": "raw/newbookdev_newbookreports_configuration_user_link/2024-11-05/1730866594/reports_configuration_user_link.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_drivethru.newbookdev_newbookreports_configuration_user_link",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 597009795962176248,
              "service_name": "drive-thru",
              "span_id": 14372820058074290053,
              "trace_id": 17364245208597049101
          }
      }
    • running: False
    • schema_name_id: 2972
    • start_time: 2024-11-05 23:50:24
    • success: True
    • trace_id: 17364245208597049101
    • duration: 0:00:14.001714
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6674969
    • 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_newbookreports_configuration_user_link/2024-11-05/1730866535",
              "key": "raw/newbookdev_newbookreports_configuration_user_link/2024-11-05/1730866535/reports_configuration_user_link.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_drivethru.newbookdev_newbookreports_configuration_user_link",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 2375820924651324146,
              "service_name": "drive-thru",
              "span_id": 985334152025632862,
              "trace_id": 753839441457692720
          }
      }
    • running: False
    • schema_name_id: 2972
    • start_time: 2024-11-05 23:09:45
    • success: True
    • trace_id: 753839441457692720
    • duration: 0:00:11.461094
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6674472
    • 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_newbookreports_configuration_user_link/2024-11-05/1730866418",
              "key": "raw/newbookdev_newbookreports_configuration_user_link/2024-11-05/1730866418/reports_configuration_user_link.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_drivethru.newbookdev_newbookreports_configuration_user_link",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 2974672206528597074,
              "service_name": "drive-thru",
              "span_id": 2571588802680785902,
              "trace_id": 2105508908660385062
          }
      }
    • running: False
    • schema_name_id: 2972
    • start_time: 2024-11-05 22:46:22
    • success: True
    • trace_id: 2105508908660385062
    • duration: 0:00:11.461075
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6672235
    • 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_newbookreports_configuration_user_link/2024-11-04/1730785787",
              "key": "raw/newbookdev_newbookreports_configuration_user_link/2024-11-04/1730785787/reports_configuration_user_link.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_drivethru.newbookdev_newbookreports_configuration_user_link",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 17718879983610942162,
              "service_name": "drive-thru",
              "span_id": 9932354893074087052,
              "trace_id": 11499399816139840101
          }
      }
    • running: False
    • schema_name_id: 2972
    • start_time: 2024-11-05 04:40:02
    • success: True
    • trace_id: 11499399816139840101
    • duration: 0:00:11.459117
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6671104
    • 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_newbookreports_configuration_user_link/2024-11-04/1730784857",
              "key": "raw/newbookdev_newbookreports_configuration_user_link/2024-11-04/1730784857/reports_configuration_user_link.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_drivethru.newbookdev_newbookreports_configuration_user_link",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 18212177126047328280,
              "service_name": "drive-thru",
              "span_id": 5088977825181617174,
              "trace_id": 17902279394693547410
          }
      }
    • running: False
    • schema_name_id: 2972
    • start_time: 2024-11-05 03:41:56
    • success: True
    • trace_id: 17902279394693547410
    • duration: 0:00:13.839016
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6670885
    • 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_newbookreports_configuration_user_link/2024-11-04/1730785162",
              "key": "raw/newbookdev_newbookreports_configuration_user_link/2024-11-04/1730785162/reports_configuration_user_link.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_drivethru.newbookdev_newbookreports_configuration_user_link",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 16097347868225073872,
              "service_name": "drive-thru",
              "span_id": 6523557487744050501,
              "trace_id": 3169105784603458178
          }
      }
    • running: False
    • schema_name_id: 2972
    • start_time: 2024-11-05 03:35:29
    • success: True
    • trace_id: 3169105784603458178
    • duration: 0:00:11.405882
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6670351
    • 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_newbookreports_configuration_user_link/2024-11-04/1730784253",
              "key": "raw/newbookdev_newbookreports_configuration_user_link/2024-11-04/1730784253/reports_configuration_user_link.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_drivethru.newbookdev_newbookreports_configuration_user_link",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 15249415795816438375,
              "service_name": "drive-thru",
              "span_id": 4176024198995693230,
              "trace_id": 1209563525771180423
          }
      }
    • running: False
    • schema_name_id: 2972
    • start_time: 2024-11-05 03:21:28
    • success: True
    • trace_id: 1209563525771180423
    • duration: 0:00:11.319529
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6669505
    • 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_newbookreports_configuration_user_link/2024-11-04/1730784090",
              "key": "raw/newbookdev_newbookreports_configuration_user_link/2024-11-04/1730784090/reports_configuration_user_link.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_drivethru.newbookdev_newbookreports_configuration_user_link",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 9916948690573725012,
              "service_name": "drive-thru",
              "span_id": 10972554048803171377,
              "trace_id": 14125817535199900250
          }
      }
    • running: False
    • schema_name_id: 2972
    • start_time: 2024-11-05 02:58:54
    • success: True
    • trace_id: 14125817535199900250
    • duration: 0:00:11.311966
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6668718
    • 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_newbookreports_configuration_user_link/2024-11-04/1730783927",
              "key": "raw/newbookdev_newbookreports_configuration_user_link/2024-11-04/1730783927/reports_configuration_user_link.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_drivethru.newbookdev_newbookreports_configuration_user_link",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 9450645178070744271,
              "service_name": "drive-thru",
              "span_id": 2608747602028836986,
              "trace_id": 15706174160957227867
          }
      }
    • running: False
    • schema_name_id: 2972
    • start_time: 2024-11-05 02:38:17
    • success: True
    • trace_id: 15706174160957227867
    • duration: 0:00:13.937821
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6667480
    • 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_newbookreports_configuration_user_link/2024-11-04/1730783804",
              "key": "raw/newbookdev_newbookreports_configuration_user_link/2024-11-04/1730783804/reports_configuration_user_link.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_drivethru.newbookdev_newbookreports_configuration_user_link",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 14049189910011175514,
              "service_name": "drive-thru",
              "span_id": 15759830179119828391,
              "trace_id": 3151100746561827062
          }
      }
    • running: False
    • schema_name_id: 2972
    • start_time: 2024-11-05 02:05:31
    • success: True
    • trace_id: 3151100746561827062
    • duration: 0:00:13.798986
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6667350
    • 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_newbookreports_configuration_user_link/2024-11-04/1730783693",
              "key": "raw/newbookdev_newbookreports_configuration_user_link/2024-11-04/1730783693/reports_configuration_user_link.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_drivethru.newbookdev_newbookreports_configuration_user_link",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 2133123782974383567,
              "service_name": "drive-thru",
              "span_id": 11331373422607323917,
              "trace_id": 9735203869034251136
          }
      }
    • running: False
    • schema_name_id: 2972
    • start_time: 2024-11-05 02:01:58
    • success: True
    • trace_id: 9735203869034251136
    • duration: 0:00:13.878234
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6666670
    • 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_newbookreports_configuration_user_link/2024-11-04/1730783561",
              "key": "raw/newbookdev_newbookreports_configuration_user_link/2024-11-04/1730783561/reports_configuration_user_link.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_drivethru.newbookdev_newbookreports_configuration_user_link",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 1086927212364617077,
              "service_name": "drive-thru",
              "span_id": 6247064162138993198,
              "trace_id": 16621390771902575056
          }
      }
    • running: False
    • schema_name_id: 2972
    • start_time: 2024-11-05 01:43:59
    • success: True
    • trace_id: 16621390771902575056
    • duration: 0:00:11.509259
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6665675
    • 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_newbookreports_configuration_user_link/2024-11-04/1730783343",
              "key": "raw/newbookdev_newbookreports_configuration_user_link/2024-11-04/1730783343/reports_configuration_user_link.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_drivethru.newbookdev_newbookreports_configuration_user_link",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 3391223206831893864,
              "service_name": "drive-thru",
              "span_id": 7395443343750422200,
              "trace_id": 16515506595201305515
          }
      }
    • running: False
    • schema_name_id: 2972
    • start_time: 2024-11-05 01:17:51
    • success: True
    • trace_id: 16515506595201305515
    • duration: 0:00:13.888209
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6665066
    • 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_newbookreports_configuration_user_link/2024-11-04/1730782941",
              "key": "raw/newbookdev_newbookreports_configuration_user_link/2024-11-04/1730782941/reports_configuration_user_link.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_drivethru.newbookdev_newbookreports_configuration_user_link",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 18155714941815672139,
              "service_name": "drive-thru",
              "span_id": 8119725353781709273,
              "trace_id": 15749535941353307415
          }
      }
    • running: False
    • schema_name_id: 2972
    • start_time: 2024-11-05 01:01:33
    • success: True
    • trace_id: 15749535941353307415
    • duration: 0:00:11.334402
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6663970
    • 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_newbookreports_configuration_user_link/2024-11-04/1730782760",
              "key": "raw/newbookdev_newbookreports_configuration_user_link/2024-11-04/1730782760/reports_configuration_user_link.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_drivethru.newbookdev_newbookreports_configuration_user_link",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 5702437925166971121,
              "service_name": "drive-thru",
              "span_id": 2724515825234257030,
              "trace_id": 1007562793582130627
          }
      }
    • running: False
    • schema_name_id: 2972
    • start_time: 2024-11-05 00:32:49
    • success: True
    • trace_id: 1007562793582130627
Partitions:
  • count: 0
  • ddl: None
  • name: None
  • state:
    []
  • type: None
Schema:
  • attributes:
    {
        "id": "string",
        "newbook_region": "string",
        "report_id": "string",
        "tenant": "string",
        "user_id": "string"
    }
  • created: 2024-11-05 23:50: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_newbookreports_configuration_user_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `report_id`  string , `user_id`  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_newbookreports_configuration_user_link/2024-11-05/1730866594'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
        "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookreports_configuration_user_link`",
        "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookreports_configuration_user_link"
    }
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:26:11",
        "disabled": false,
        "format": "raw",
        "id": 2972,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_drivethru",
            "table": "newbookdev_newbookreports_configuration_user_link"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "id": "string",
            "newbook_region": "string",
            "report_id": "string",
            "tenant": "string",
            "user_id": "string"
        },
        "created": "2024-11-05 23:50: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_newbookreports_configuration_user_link`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `report_id`  string , `user_id`  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_newbookreports_configuration_user_link/2024-11-05/1730866594'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookreports_configuration_user_link`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookreports_configuration_user_link"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}