Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration
  • created: 2024-10-08 18:22:04
  • disabled: False
  • format: raw
  • id: 2933
  • is_partitioned: False
  • is_schema_datatyped: True
  • name:
    {
        "database": "sfdl_dev_drivethru",
        "table": "newbookdev_newbookpage_column_configuration"
    }
  • type: drivethrucsv
Schema Versions: 15
    • created: 2024-11-05 23:42:43
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `user_id`  string , `action_id`  string , `interface`  string , `key`  string , `value`  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_newbookpage_column_configuration/2024-11-05/1730866577'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpage_column_configuration/2024-11-05/1730866577
    • id: 4749364
    • processed: 1
    • raw_data:
      {
          "action_id": 4,
          "id": 2,
          "interface": 5,
          "key": 6,
          "newbook_region": 0,
          "tenant": 1,
          "user_id": 3,
          "value": 7
      }
    • schema_attributes:
      {
          "action_id": "string",
          "id": "string",
          "interface": "string",
          "key": "string",
          "newbook_region": "string",
          "tenant": "string",
          "user_id": "string",
          "value": "string"
      }
    • schema_name_id: 2933
    • schema_scan_id: 6675398
    • updated: 2024-11-05 23:42:54
    • created: 2024-11-05 23:17:32
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `user_id`  string , `action_id`  string , `interface`  string , `key`  string , `value`  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_newbookpage_column_configuration/2024-11-05/1730866519'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpage_column_configuration/2024-11-05/1730866519
    • id: 4749063
    • processed: 1
    • raw_data:
      {
          "action_id": 4,
          "id": 2,
          "interface": 5,
          "key": 6,
          "newbook_region": 0,
          "tenant": 1,
          "user_id": 3,
          "value": 7
      }
    • schema_attributes:
      {
          "action_id": "string",
          "id": "string",
          "interface": "string",
          "key": "string",
          "newbook_region": "string",
          "tenant": "string",
          "user_id": "string",
          "value": "string"
      }
    • schema_name_id: 2933
    • schema_scan_id: 6675095
    • updated: 2024-11-05 23:17:46
    • created: 2024-11-05 22:38:17
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `user_id`  string , `action_id`  string , `interface`  string , `key`  string , `value`  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_newbookpage_column_configuration/2024-11-05/1730866392'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpage_column_configuration/2024-11-05/1730866392
    • id: 4748212
    • processed: 1
    • raw_data:
      {
          "action_id": 4,
          "id": 2,
          "interface": 5,
          "key": 6,
          "newbook_region": 0,
          "tenant": 1,
          "user_id": 3,
          "value": 7
      }
    • schema_attributes:
      {
          "action_id": "string",
          "id": "string",
          "interface": "string",
          "key": "string",
          "newbook_region": "string",
          "tenant": "string",
          "user_id": "string",
          "value": "string"
      }
    • schema_name_id: 2933
    • schema_scan_id: 6674244
    • updated: 2024-11-05 22:38:28
    • created: 2024-11-05 04:45:42
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `user_id`  string , `action_id`  string , `interface`  string , `key`  string , `value`  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_newbookpage_column_configuration/2024-11-04/1730785774'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpage_column_configuration/2024-11-04/1730785774
    • id: 4747056
    • processed: 1
    • raw_data:
      {
          "action_id": 4,
          "id": 2,
          "interface": 5,
          "key": 6,
          "newbook_region": 0,
          "tenant": 1,
          "user_id": 3,
          "value": 7
      }
    • schema_attributes:
      {
          "action_id": "string",
          "id": "string",
          "interface": "string",
          "key": "string",
          "newbook_region": "string",
          "tenant": "string",
          "user_id": "string",
          "value": "string"
      }
    • schema_name_id: 2933
    • schema_scan_id: 6672288
    • updated: 2024-11-05 04:45:53
    • created: 2024-11-05 04:00:29
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `user_id`  string , `action_id`  string , `interface`  string , `key`  string , `value`  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_newbookpage_column_configuration/2024-11-04/1730785154'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpage_column_configuration/2024-11-04/1730785154
    • id: 4746378
    • processed: 1
    • raw_data:
      {
          "action_id": 4,
          "id": 2,
          "interface": 5,
          "key": 6,
          "newbook_region": 0,
          "tenant": 1,
          "user_id": 3,
          "value": 7
      }
    • schema_attributes:
      {
          "action_id": "string",
          "id": "string",
          "interface": "string",
          "key": "string",
          "newbook_region": "string",
          "tenant": "string",
          "user_id": "string",
          "value": "string"
      }
    • schema_name_id: 2933
    • schema_scan_id: 6671599
    • updated: 2024-11-05 04:00:40
    • created: 2024-11-05 03:16:36
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `user_id`  string , `action_id`  string , `interface`  string , `key`  string , `value`  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_newbookpage_column_configuration/2024-11-04/1730784849'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpage_column_configuration/2024-11-04/1730784849
    • id: 4744945
    • processed: 1
    • raw_data:
      {
          "action_id": 4,
          "id": 2,
          "interface": 5,
          "key": 6,
          "newbook_region": 0,
          "tenant": 1,
          "user_id": 3,
          "value": 7
      }
    • schema_attributes:
      {
          "action_id": "string",
          "id": "string",
          "interface": "string",
          "key": "string",
          "newbook_region": "string",
          "tenant": "string",
          "user_id": "string",
          "value": "string"
      }
    • schema_name_id: 2933
    • schema_scan_id: 6670162
    • updated: 2024-11-05 03:16:47
    • created: 2024-11-05 03:14:17
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `user_id`  string , `action_id`  string , `interface`  string , `key`  string , `value`  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_newbookpage_column_configuration/2024-11-04/1730784246'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpage_column_configuration/2024-11-04/1730784246
    • id: 4744860
    • processed: 1
    • raw_data:
      {
          "action_id": 4,
          "id": 2,
          "interface": 5,
          "key": 6,
          "newbook_region": 0,
          "tenant": 1,
          "user_id": 3,
          "value": 7
      }
    • schema_attributes:
      {
          "action_id": "string",
          "id": "string",
          "interface": "string",
          "key": "string",
          "newbook_region": "string",
          "tenant": "string",
          "user_id": "string",
          "value": "string"
      }
    • schema_name_id: 2933
    • schema_scan_id: 6670077
    • updated: 2024-11-05 03:14:30
    • created: 2024-11-05 03:06:50
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `user_id`  string , `action_id`  string , `interface`  string , `key`  string , `value`  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_newbookpage_column_configuration/2024-11-04/1730784083'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpage_column_configuration/2024-11-04/1730784083
    • id: 4744578
    • processed: 1
    • raw_data:
      {
          "action_id": 4,
          "id": 2,
          "interface": 5,
          "key": 6,
          "newbook_region": 0,
          "tenant": 1,
          "user_id": 3,
          "value": 7
      }
    • schema_attributes:
      {
          "action_id": "string",
          "id": "string",
          "interface": "string",
          "key": "string",
          "newbook_region": "string",
          "tenant": "string",
          "user_id": "string",
          "value": "string"
      }
    • schema_name_id: 2933
    • schema_scan_id: 6669795
    • updated: 2024-11-05 03:07:03
    • created: 2024-11-05 02:43:00
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `user_id`  string , `action_id`  string , `interface`  string , `key`  string , `value`  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_newbookpage_column_configuration/2024-11-04/1730783921'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpage_column_configuration/2024-11-04/1730783921
    • id: 4743679
    • processed: 1
    • raw_data:
      {
          "action_id": 4,
          "id": 2,
          "interface": 5,
          "key": 6,
          "newbook_region": 0,
          "tenant": 1,
          "user_id": 3,
          "value": 7
      }
    • schema_attributes:
      {
          "action_id": "string",
          "id": "string",
          "interface": "string",
          "key": "string",
          "newbook_region": "string",
          "tenant": "string",
          "user_id": "string",
          "value": "string"
      }
    • schema_name_id: 2933
    • schema_scan_id: 6668896
    • updated: 2024-11-05 02:43:11
    • created: 2024-11-05 02:21:20
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `user_id`  string , `action_id`  string , `interface`  string , `key`  string , `value`  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_newbookpage_column_configuration/2024-11-04/1730783797'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpage_column_configuration/2024-11-04/1730783797
    • id: 4742860
    • processed: 1
    • raw_data:
      {
          "action_id": 4,
          "id": 2,
          "interface": 5,
          "key": 6,
          "newbook_region": 0,
          "tenant": 1,
          "user_id": 3,
          "value": 7
      }
    • schema_attributes:
      {
          "action_id": "string",
          "id": "string",
          "interface": "string",
          "key": "string",
          "newbook_region": "string",
          "tenant": "string",
          "user_id": "string",
          "value": "string"
      }
    • schema_name_id: 2933
    • schema_scan_id: 6668077
    • updated: 2024-11-05 02:21:31
    • created: 2024-11-05 01:55:37
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `user_id`  string , `action_id`  string , `interface`  string , `key`  string , `value`  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_newbookpage_column_configuration/2024-11-04/1730783687'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpage_column_configuration/2024-11-04/1730783687
    • id: 4741895
    • processed: 1
    • raw_data:
      {
          "action_id": 4,
          "id": 2,
          "interface": 5,
          "key": 6,
          "newbook_region": 0,
          "tenant": 1,
          "user_id": 3,
          "value": 7
      }
    • schema_attributes:
      {
          "action_id": "string",
          "id": "string",
          "interface": "string",
          "key": "string",
          "newbook_region": "string",
          "tenant": "string",
          "user_id": "string",
          "value": "string"
      }
    • schema_name_id: 2933
    • schema_scan_id: 6667112
    • updated: 2024-11-05 01:55:48
    • created: 2024-11-05 01:39:04
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `user_id`  string , `action_id`  string , `interface`  string , `key`  string , `value`  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_newbookpage_column_configuration/2024-11-04/1730783554'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpage_column_configuration/2024-11-04/1730783554
    • id: 4741264
    • processed: 1
    • raw_data:
      {
          "action_id": 4,
          "id": 2,
          "interface": 5,
          "key": 6,
          "newbook_region": 0,
          "tenant": 1,
          "user_id": 3,
          "value": 7
      }
    • schema_attributes:
      {
          "action_id": "string",
          "id": "string",
          "interface": "string",
          "key": "string",
          "newbook_region": "string",
          "tenant": "string",
          "user_id": "string",
          "value": "string"
      }
    • schema_name_id: 2933
    • schema_scan_id: 6666481
    • updated: 2024-11-05 01:39:18
    • created: 2024-11-05 01:16:56
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `user_id`  string , `action_id`  string , `interface`  string , `key`  string , `value`  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_newbookpage_column_configuration/2024-11-04/1730783335'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpage_column_configuration/2024-11-04/1730783335
    • id: 4740423
    • processed: 1
    • raw_data:
      {
          "action_id": 4,
          "id": 2,
          "interface": 5,
          "key": 6,
          "newbook_region": 0,
          "tenant": 1,
          "user_id": 3,
          "value": 7
      }
    • schema_attributes:
      {
          "action_id": "string",
          "id": "string",
          "interface": "string",
          "key": "string",
          "newbook_region": "string",
          "tenant": "string",
          "user_id": "string",
          "value": "string"
      }
    • schema_name_id: 2933
    • schema_scan_id: 6665640
    • updated: 2024-11-05 01:17:09
    • created: 2024-11-05 01:07:58
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `user_id`  string , `action_id`  string , `interface`  string , `key`  string , `value`  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_newbookpage_column_configuration/2024-11-04/1730782967'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpage_column_configuration/2024-11-04/1730782967
    • id: 4740084
    • processed: 1
    • raw_data:
      {
          "action_id": 4,
          "id": 2,
          "interface": 5,
          "key": 6,
          "newbook_region": 0,
          "tenant": 1,
          "user_id": 3,
          "value": 7
      }
    • schema_attributes:
      {
          "action_id": "string",
          "id": "string",
          "interface": "string",
          "key": "string",
          "newbook_region": "string",
          "tenant": "string",
          "user_id": "string",
          "value": "string"
      }
    • schema_name_id: 2933
    • schema_scan_id: 6665301
    • updated: 2024-11-05 01:08:12
    • created: 2024-11-05 00:38:16
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `user_id`  string , `action_id`  string , `interface`  string , `key`  string , `value`  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_newbookpage_column_configuration/2024-11-04/1730782827'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookpage_column_configuration/2024-11-04/1730782827
    • id: 4738964
    • processed: 1
    • raw_data:
      {
          "action_id": 4,
          "id": 2,
          "interface": 5,
          "key": 6,
          "newbook_region": 0,
          "tenant": 1,
          "user_id": 3,
          "value": 7
      }
    • schema_attributes:
      {
          "action_id": "string",
          "id": "string",
          "interface": "string",
          "key": "string",
          "newbook_region": "string",
          "tenant": "string",
          "user_id": "string",
          "value": "string"
      }
    • schema_name_id: 2933
    • schema_scan_id: 6664178
    • updated: 2024-11-05 00:38:27
Schema Scans: 15
Last at 2024-11-05 23:42:43
    • duration: 0:00:11.649552
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6675398
    • 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_newbookpage_column_configuration/2024-11-05/1730866577",
              "key": "raw/newbookdev_newbookpage_column_configuration/2024-11-05/1730866577/page_column_configuration.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 4951945496110798722,
              "service_name": "drive-thru",
              "span_id": 2914821749916539308,
              "trace_id": 6090913616273385793
          }
      }
    • running: False
    • schema_name_id: 2933
    • start_time: 2024-11-05 23:42:43
    • success: True
    • trace_id: 6090913616273385793
    • duration: 0:00:14.124014
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6675095
    • 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_newbookpage_column_configuration/2024-11-05/1730866519",
              "key": "raw/newbookdev_newbookpage_column_configuration/2024-11-05/1730866519/page_column_configuration.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 3342272937640063781,
              "service_name": "drive-thru",
              "span_id": 14937255868758666687,
              "trace_id": 6549087419141673069
          }
      }
    • running: False
    • schema_name_id: 2933
    • start_time: 2024-11-05 23:17:32
    • success: True
    • trace_id: 6549087419141673069
    • duration: 0:00:11.548511
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6674244
    • 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_newbookpage_column_configuration/2024-11-05/1730866392",
              "key": "raw/newbookdev_newbookpage_column_configuration/2024-11-05/1730866392/page_column_configuration.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 3663121706678028334,
              "service_name": "drive-thru",
              "span_id": 13954124758675461381,
              "trace_id": 1291129420372408982
          }
      }
    • running: False
    • schema_name_id: 2933
    • start_time: 2024-11-05 22:38:16
    • success: True
    • trace_id: 1291129420372408982
    • duration: 0:00:11.628454
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6672288
    • 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_newbookpage_column_configuration/2024-11-04/1730785774",
              "key": "raw/newbookdev_newbookpage_column_configuration/2024-11-04/1730785774/page_column_configuration.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 2656889096048256196,
              "service_name": "drive-thru",
              "span_id": 7772572209246979763,
              "trace_id": 4716591765036055200
          }
      }
    • running: False
    • schema_name_id: 2933
    • start_time: 2024-11-05 04:45:41
    • success: True
    • trace_id: 4716591765036055200
    • duration: 0:00:11.597454
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6671599
    • 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_newbookpage_column_configuration/2024-11-04/1730785154",
              "key": "raw/newbookdev_newbookpage_column_configuration/2024-11-04/1730785154/page_column_configuration.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 4916540657039976764,
              "service_name": "drive-thru",
              "span_id": 6599188638266364503,
              "trace_id": 12673274469647678496
          }
      }
    • running: False
    • schema_name_id: 2933
    • start_time: 2024-11-05 04:00:28
    • success: True
    • trace_id: 12673274469647678496
    • duration: 0:00:11.491447
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6670162
    • 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_newbookpage_column_configuration/2024-11-04/1730784849",
              "key": "raw/newbookdev_newbookpage_column_configuration/2024-11-04/1730784849/page_column_configuration.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 10585962618295967341,
              "service_name": "drive-thru",
              "span_id": 10843464006418873963,
              "trace_id": 13314776947550392899
          }
      }
    • running: False
    • schema_name_id: 2933
    • start_time: 2024-11-05 03:16:36
    • success: True
    • trace_id: 13314776947550392899
    • duration: 0:00:13.917163
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6670077
    • 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_newbookpage_column_configuration/2024-11-04/1730784246",
              "key": "raw/newbookdev_newbookpage_column_configuration/2024-11-04/1730784246/page_column_configuration.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 17716445027622603654,
              "service_name": "drive-thru",
              "span_id": 11132083557654801931,
              "trace_id": 8644383144444283434
          }
      }
    • running: False
    • schema_name_id: 2933
    • start_time: 2024-11-05 03:14:16
    • success: True
    • trace_id: 8644383144444283434
    • duration: 0:00:13.963805
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6669795
    • 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_newbookpage_column_configuration/2024-11-04/1730784083",
              "key": "raw/newbookdev_newbookpage_column_configuration/2024-11-04/1730784083/page_column_configuration.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 6289618420958583407,
              "service_name": "drive-thru",
              "span_id": 5950491220721226731,
              "trace_id": 1231780964140500177
          }
      }
    • running: False
    • schema_name_id: 2933
    • start_time: 2024-11-05 03:06:50
    • success: True
    • trace_id: 1231780964140500177
    • duration: 0:00:11.683534
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6668896
    • 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_newbookpage_column_configuration/2024-11-04/1730783921",
              "key": "raw/newbookdev_newbookpage_column_configuration/2024-11-04/1730783921/page_column_configuration.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 17759373998467335221,
              "service_name": "drive-thru",
              "span_id": 14814160957166884348,
              "trace_id": 4263395216790680843
          }
      }
    • running: False
    • schema_name_id: 2933
    • start_time: 2024-11-05 02:43:00
    • success: True
    • trace_id: 4263395216790680843
    • duration: 0:00:11.638564
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6668077
    • 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_newbookpage_column_configuration/2024-11-04/1730783797",
              "key": "raw/newbookdev_newbookpage_column_configuration/2024-11-04/1730783797/page_column_configuration.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 11318764312779911499,
              "service_name": "drive-thru",
              "span_id": 16823934637320655644,
              "trace_id": 7754307454324687110
          }
      }
    • running: False
    • schema_name_id: 2933
    • start_time: 2024-11-05 02:21:19
    • success: True
    • trace_id: 7754307454324687110
    • duration: 0:00:11.479005
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6667112
    • 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_newbookpage_column_configuration/2024-11-04/1730783687",
              "key": "raw/newbookdev_newbookpage_column_configuration/2024-11-04/1730783687/page_column_configuration.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 15394334121801147124,
              "service_name": "drive-thru",
              "span_id": 6010502558900462608,
              "trace_id": 15296617728992636004
          }
      }
    • running: False
    • schema_name_id: 2933
    • start_time: 2024-11-05 01:55:36
    • success: True
    • trace_id: 15296617728992636004
    • duration: 0:00:13.909233
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6666481
    • 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_newbookpage_column_configuration/2024-11-04/1730783554",
              "key": "raw/newbookdev_newbookpage_column_configuration/2024-11-04/1730783554/page_column_configuration.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 13335642811701008414,
              "service_name": "drive-thru",
              "span_id": 13142905676694958037,
              "trace_id": 6821959300194290156
          }
      }
    • running: False
    • schema_name_id: 2933
    • start_time: 2024-11-05 01:39:04
    • success: True
    • trace_id: 6821959300194290156
    • duration: 0:00:13.949289
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6665640
    • 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_newbookpage_column_configuration/2024-11-04/1730783335",
              "key": "raw/newbookdev_newbookpage_column_configuration/2024-11-04/1730783335/page_column_configuration.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 14815987385426308325,
              "service_name": "drive-thru",
              "span_id": 14048512863628704558,
              "trace_id": 15068183085994487637
          }
      }
    • running: False
    • schema_name_id: 2933
    • start_time: 2024-11-05 01:16:55
    • success: True
    • trace_id: 15068183085994487637
    • duration: 0:00:14.031445
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6665301
    • 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_newbookpage_column_configuration/2024-11-04/1730782967",
              "key": "raw/newbookdev_newbookpage_column_configuration/2024-11-04/1730782967/page_column_configuration.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 5519343585527388365,
              "service_name": "drive-thru",
              "span_id": 18005545414990122007,
              "trace_id": 8801656660562777857
          }
      }
    • running: False
    • schema_name_id: 2933
    • start_time: 2024-11-05 01:07:58
    • success: True
    • trace_id: 8801656660562777857
    • duration: 0:00:11.492181
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6664178
    • 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_newbookpage_column_configuration/2024-11-04/1730782827",
              "key": "raw/newbookdev_newbookpage_column_configuration/2024-11-04/1730782827/page_column_configuration.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 7012296377416804651,
              "service_name": "drive-thru",
              "span_id": 11190691207532732733,
              "trace_id": 14967098925527899019
          }
      }
    • running: False
    • schema_name_id: 2933
    • start_time: 2024-11-05 00:38:15
    • success: True
    • trace_id: 14967098925527899019
Partitions:
  • count: 0
  • ddl: None
  • name: None
  • state:
    []
  • type: None
Schema:
  • attributes:
    {
        "action_id": "string",
        "id": "string",
        "interface": "string",
        "key": "string",
        "newbook_region": "string",
        "tenant": "string",
        "user_id": "string",
        "value": "string"
    }
  • created: 2024-11-05 23:42:43
  • ddl:
    {
        "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
        "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `user_id`  string , `action_id`  string , `interface`  string , `key`  string , `value`  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_newbookpage_column_configuration/2024-11-05/1730866577'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
        "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration`",
        "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration"
    }
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:22:04",
        "disabled": false,
        "format": "raw",
        "id": 2933,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_drivethru",
            "table": "newbookdev_newbookpage_column_configuration"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "action_id": "string",
            "id": "string",
            "interface": "string",
            "key": "string",
            "newbook_region": "string",
            "tenant": "string",
            "user_id": "string",
            "value": "string"
        },
        "created": "2024-11-05 23:42:43",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `user_id`  string , `action_id`  string , `interface`  string , `key`  string , `value`  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_newbookpage_column_configuration/2024-11-05/1730866577'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookpage_column_configuration"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}