Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbooklicenses_templates
  • created: 2024-10-08 18:18:19
  • disabled: False
  • format: raw
  • id: 2898
  • is_partitioned: False
  • is_schema_datatyped: True
  • name: 
    {
    "database": "sfdl_dev_drivethru",
    "table": "newbookdev_newbooklicenses_templates"
}
  • type: drivethrucsv
Schema Versions: 15
    • created: 2024-11-05 23:11:39
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooklicenses_templates`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooklicenses_templates`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `generate`  string , `group_id`  string , `name`  string , `sale_name`  string , `type`  string , `primary_license`  string , `sale_option`  string , `sale_description`  string , `sale_display_order`  string , `sale_contact_template_id`  string , `license_period`  string , `privileges`  string , `software`  string , `desktop_users`  string , `desktop_users_gl_category_id`  string , `desktop_users_gl_account_id`  string , `desktop_users_amount`  string , `desktop_users_discount_amount`  string , `mobile_users`  string , `mobile_users_gl_category_id`  string , `mobile_users_gl_account_id`  string , `mobile_users_amount`  string , `mobile_users_discount_amount`  string , `tv_users`  string , `tv_users_gl_category_id`  string , `tv_users_gl_account_id`  string , `tv_users_amount`  string , `tv_users_discount_amount`  string , `site_tablets`  string , `site_tablets_gl_category_id`  string , `site_tablets_gl_account_id`  string , `site_tablets_amount`  string , `site_tablets_discount_amount`  string , `site_limit`  string , `site_limit_gl_category_id`  string , `site_limit_gl_account_id`  string , `site_limit_amount`  string , `site_limit_discount_amount`  string , `kiosks_limit`  string , `kiosks_limit_gl_category_id`  string , `kiosks_limit_gl_account_id`  string , `kiosks_limit_amount`  string , `kiosks_limit_discount_amount`  string , `storage_limit`  string , `storage_limit_gl_category_id`  string , `storage_limit_gl_account_id`  string , `storage_limit_amount`  string , `storage_limit_discount_amount`  string , `inboxes_limit`  string , `license`  string , `license_gl_category_id`  string , `license_gl_account_id`  string , `license_amount`  string , `license_discount_amount`  string , `inboxes_limit_gl_category_id`  string , `inboxes_limit_gl_account_id`  string , `inboxes_limit_amount`  string , `inboxes_limit_discount_amount`  string , `tax_free`  string , `interval`  string , `interval_multiplier`  string , `active`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooklicenses_templates/2024-11-05/1730866541'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooklicenses_templates"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooklicenses_templates/2024-11-05/1730866541
    • id: 4748971
    • processed: 1
    • raw_data: 
      {
    "active": 64,
    "desktop_users": 16,
    "desktop_users_amount": 19,
    "desktop_users_discount_amount": 20,
    "desktop_users_gl_account_id": 18,
    "desktop_users_gl_category_id": 17,
    "generate": 3,
    "group_id": 4,
    "id": 2,
    "inboxes_limit": 51,
    "inboxes_limit_amount": 59,
    "inboxes_limit_discount_amount": 60,
    "inboxes_limit_gl_account_id": 58,
    "inboxes_limit_gl_category_id": 57,
    "interval": 62,
    "interval_multiplier": 63,
    "kiosks_limit": 41,
    "kiosks_limit_amount": 44,
    "kiosks_limit_discount_amount": 45,
    "kiosks_limit_gl_account_id": 43,
    "kiosks_limit_gl_category_id": 42,
    "license": 52,
    "license_amount": 55,
    "license_discount_amount": 56,
    "license_gl_account_id": 54,
    "license_gl_category_id": 53,
    "license_period": 13,
    "mobile_users": 21,
    "mobile_users_amount": 24,
    "mobile_users_discount_amount": 25,
    "mobile_users_gl_account_id": 23,
    "mobile_users_gl_category_id": 22,
    "name": 5,
    "newbook_region": 0,
    "primary_license": 8,
    "privileges": 14,
    "sale_contact_template_id": 12,
    "sale_description": 10,
    "sale_display_order": 11,
    "sale_name": 6,
    "sale_option": 9,
    "site_limit": 36,
    "site_limit_amount": 39,
    "site_limit_discount_amount": 40,
    "site_limit_gl_account_id": 38,
    "site_limit_gl_category_id": 37,
    "site_tablets": 31,
    "site_tablets_amount": 34,
    "site_tablets_discount_amount": 35,
    "site_tablets_gl_account_id": 33,
    "site_tablets_gl_category_id": 32,
    "software": 15,
    "storage_limit": 46,
    "storage_limit_amount": 49,
    "storage_limit_discount_amount": 50,
    "storage_limit_gl_account_id": 48,
    "storage_limit_gl_category_id": 47,
    "tax_free": 61,
    "tenant": 1,
    "tv_users": 26,
    "tv_users_amount": 29,
    "tv_users_discount_amount": 30,
    "tv_users_gl_account_id": 28,
    "tv_users_gl_category_id": 27,
    "type": 7
}
    • schema_attributes: 
      {
    "active": "string",
    "desktop_users": "string",
    "desktop_users_amount": "string",
    "desktop_users_discount_amount": "string",
    "desktop_users_gl_account_id": "string",
    "desktop_users_gl_category_id": "string",
    "generate": "string",
    "group_id": "string",
    "id": "string",
    "inboxes_limit": "string",
    "inboxes_limit_amount": "string",
    "inboxes_limit_discount_amount": "string",
    "inboxes_limit_gl_account_id": "string",
    "inboxes_limit_gl_category_id": "string",
    "interval": "string",
    "interval_multiplier": "string",
    "kiosks_limit": "string",
    "kiosks_limit_amount": "string",
    "kiosks_limit_discount_amount": "string",
    "kiosks_limit_gl_account_id": "string",
    "kiosks_limit_gl_category_id": "string",
    "license": "string",
    "license_amount": "string",
    "license_discount_amount": "string",
    "license_gl_account_id": "string",
    "license_gl_category_id": "string",
    "license_period": "string",
    "mobile_users": "string",
    "mobile_users_amount": "string",
    "mobile_users_discount_amount": "string",
    "mobile_users_gl_account_id": "string",
    "mobile_users_gl_category_id": "string",
    "name": "string",
    "newbook_region": "string",
    "primary_license": "string",
    "privileges": "string",
    "sale_contact_template_id": "string",
    "sale_description": "string",
    "sale_display_order": "string",
    "sale_name": "string",
    "sale_option": "string",
    "site_limit": "string",
    "site_limit_amount": "string",
    "site_limit_discount_amount": "string",
    "site_limit_gl_account_id": "string",
    "site_limit_gl_category_id": "string",
    "site_tablets": "string",
    "site_tablets_amount": "string",
    "site_tablets_discount_amount": "string",
    "site_tablets_gl_account_id": "string",
    "site_tablets_gl_category_id": "string",
    "software": "string",
    "storage_limit": "string",
    "storage_limit_amount": "string",
    "storage_limit_discount_amount": "string",
    "storage_limit_gl_account_id": "string",
    "storage_limit_gl_category_id": "string",
    "tax_free": "string",
    "tenant": "string",
    "tv_users": "string",
    "tv_users_amount": "string",
    "tv_users_discount_amount": "string",
    "tv_users_gl_account_id": "string",
    "tv_users_gl_category_id": "string",
    "type": "string"
}
    • schema_name_id: 2898
    • schema_scan_id: 6675003
    • updated: 2024-11-05 23:11:50
    • created: 2024-11-05 22:57:50
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooklicenses_templates`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooklicenses_templates`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `generate`  string , `group_id`  string , `name`  string , `sale_name`  string , `type`  string , `primary_license`  string , `sale_option`  string , `sale_description`  string , `sale_display_order`  string , `sale_contact_template_id`  string , `license_period`  string , `privileges`  string , `software`  string , `desktop_users`  string , `desktop_users_gl_category_id`  string , `desktop_users_gl_account_id`  string , `desktop_users_amount`  string , `desktop_users_discount_amount`  string , `mobile_users`  string , `mobile_users_gl_category_id`  string , `mobile_users_gl_account_id`  string , `mobile_users_amount`  string , `mobile_users_discount_amount`  string , `tv_users`  string , `tv_users_gl_category_id`  string , `tv_users_gl_account_id`  string , `tv_users_amount`  string , `tv_users_discount_amount`  string , `site_tablets`  string , `site_tablets_gl_category_id`  string , `site_tablets_gl_account_id`  string , `site_tablets_amount`  string , `site_tablets_discount_amount`  string , `site_limit`  string , `site_limit_gl_category_id`  string , `site_limit_gl_account_id`  string , `site_limit_amount`  string , `site_limit_discount_amount`  string , `kiosks_limit`  string , `kiosks_limit_gl_category_id`  string , `kiosks_limit_gl_account_id`  string , `kiosks_limit_amount`  string , `kiosks_limit_discount_amount`  string , `storage_limit`  string , `storage_limit_gl_category_id`  string , `storage_limit_gl_account_id`  string , `storage_limit_amount`  string , `storage_limit_discount_amount`  string , `inboxes_limit`  string , `license`  string , `license_gl_category_id`  string , `license_gl_account_id`  string , `license_amount`  string , `license_discount_amount`  string , `inboxes_limit_gl_category_id`  string , `inboxes_limit_gl_account_id`  string , `inboxes_limit_amount`  string , `inboxes_limit_discount_amount`  string , `tax_free`  string , `interval`  string , `interval_multiplier`  string , `active`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooklicenses_templates/2024-11-05/1730866479'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooklicenses_templates"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooklicenses_templates/2024-11-05/1730866479
    • id: 4748716
    • processed: 1
    • raw_data: 
      {
    "active": 64,
    "desktop_users": 16,
    "desktop_users_amount": 19,
    "desktop_users_discount_amount": 20,
    "desktop_users_gl_account_id": 18,
    "desktop_users_gl_category_id": 17,
    "generate": 3,
    "group_id": 4,
    "id": 2,
    "inboxes_limit": 51,
    "inboxes_limit_amount": 59,
    "inboxes_limit_discount_amount": 60,
    "inboxes_limit_gl_account_id": 58,
    "inboxes_limit_gl_category_id": 57,
    "interval": 62,
    "interval_multiplier": 63,
    "kiosks_limit": 41,
    "kiosks_limit_amount": 44,
    "kiosks_limit_discount_amount": 45,
    "kiosks_limit_gl_account_id": 43,
    "kiosks_limit_gl_category_id": 42,
    "license": 52,
    "license_amount": 55,
    "license_discount_amount": 56,
    "license_gl_account_id": 54,
    "license_gl_category_id": 53,
    "license_period": 13,
    "mobile_users": 21,
    "mobile_users_amount": 24,
    "mobile_users_discount_amount": 25,
    "mobile_users_gl_account_id": 23,
    "mobile_users_gl_category_id": 22,
    "name": 5,
    "newbook_region": 0,
    "primary_license": 8,
    "privileges": 14,
    "sale_contact_template_id": 12,
    "sale_description": 10,
    "sale_display_order": 11,
    "sale_name": 6,
    "sale_option": 9,
    "site_limit": 36,
    "site_limit_amount": 39,
    "site_limit_discount_amount": 40,
    "site_limit_gl_account_id": 38,
    "site_limit_gl_category_id": 37,
    "site_tablets": 31,
    "site_tablets_amount": 34,
    "site_tablets_discount_amount": 35,
    "site_tablets_gl_account_id": 33,
    "site_tablets_gl_category_id": 32,
    "software": 15,
    "storage_limit": 46,
    "storage_limit_amount": 49,
    "storage_limit_discount_amount": 50,
    "storage_limit_gl_account_id": 48,
    "storage_limit_gl_category_id": 47,
    "tax_free": 61,
    "tenant": 1,
    "tv_users": 26,
    "tv_users_amount": 29,
    "tv_users_discount_amount": 30,
    "tv_users_gl_account_id": 28,
    "tv_users_gl_category_id": 27,
    "type": 7
}
    • schema_attributes: 
      {
    "active": "string",
    "desktop_users": "string",
    "desktop_users_amount": "string",
    "desktop_users_discount_amount": "string",
    "desktop_users_gl_account_id": "string",
    "desktop_users_gl_category_id": "string",
    "generate": "string",
    "group_id": "string",
    "id": "string",
    "inboxes_limit": "string",
    "inboxes_limit_amount": "string",
    "inboxes_limit_discount_amount": "string",
    "inboxes_limit_gl_account_id": "string",
    "inboxes_limit_gl_category_id": "string",
    "interval": "string",
    "interval_multiplier": "string",
    "kiosks_limit": "string",
    "kiosks_limit_amount": "string",
    "kiosks_limit_discount_amount": "string",
    "kiosks_limit_gl_account_id": "string",
    "kiosks_limit_gl_category_id": "string",
    "license": "string",
    "license_amount": "string",
    "license_discount_amount": "string",
    "license_gl_account_id": "string",
    "license_gl_category_id": "string",
    "license_period": "string",
    "mobile_users": "string",
    "mobile_users_amount": "string",
    "mobile_users_discount_amount": "string",
    "mobile_users_gl_account_id": "string",
    "mobile_users_gl_category_id": "string",
    "name": "string",
    "newbook_region": "string",
    "primary_license": "string",
    "privileges": "string",
    "sale_contact_template_id": "string",
    "sale_description": "string",
    "sale_display_order": "string",
    "sale_name": "string",
    "sale_option": "string",
    "site_limit": "string",
    "site_limit_amount": "string",
    "site_limit_discount_amount": "string",
    "site_limit_gl_account_id": "string",
    "site_limit_gl_category_id": "string",
    "site_tablets": "string",
    "site_tablets_amount": "string",
    "site_tablets_discount_amount": "string",
    "site_tablets_gl_account_id": "string",
    "site_tablets_gl_category_id": "string",
    "software": "string",
    "storage_limit": "string",
    "storage_limit_amount": "string",
    "storage_limit_discount_amount": "string",
    "storage_limit_gl_account_id": "string",
    "storage_limit_gl_category_id": "string",
    "tax_free": "string",
    "tenant": "string",
    "tv_users": "string",
    "tv_users_amount": "string",
    "tv_users_discount_amount": "string",
    "tv_users_gl_account_id": "string",
    "tv_users_gl_category_id": "string",
    "type": "string"
}
    • schema_name_id: 2898
    • schema_scan_id: 6674748
    • updated: 2024-11-05 22:58:01
    • created: 2024-11-05 22:26:55
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooklicenses_templates`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooklicenses_templates`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `generate`  string , `group_id`  string , `name`  string , `sale_name`  string , `type`  string , `primary_license`  string , `sale_option`  string , `sale_description`  string , `sale_display_order`  string , `sale_contact_template_id`  string , `license_period`  string , `privileges`  string , `software`  string , `desktop_users`  string , `desktop_users_gl_category_id`  string , `desktop_users_gl_account_id`  string , `desktop_users_amount`  string , `desktop_users_discount_amount`  string , `mobile_users`  string , `mobile_users_gl_category_id`  string , `mobile_users_gl_account_id`  string , `mobile_users_amount`  string , `mobile_users_discount_amount`  string , `tv_users`  string , `tv_users_gl_category_id`  string , `tv_users_gl_account_id`  string , `tv_users_amount`  string , `tv_users_discount_amount`  string , `site_tablets`  string , `site_tablets_gl_category_id`  string , `site_tablets_gl_account_id`  string , `site_tablets_amount`  string , `site_tablets_discount_amount`  string , `site_limit`  string , `site_limit_gl_category_id`  string , `site_limit_gl_account_id`  string , `site_limit_amount`  string , `site_limit_discount_amount`  string , `kiosks_limit`  string , `kiosks_limit_gl_category_id`  string , `kiosks_limit_gl_account_id`  string , `kiosks_limit_amount`  string , `kiosks_limit_discount_amount`  string , `storage_limit`  string , `storage_limit_gl_category_id`  string , `storage_limit_gl_account_id`  string , `storage_limit_amount`  string , `storage_limit_discount_amount`  string , `inboxes_limit`  string , `license`  string , `license_gl_category_id`  string , `license_gl_account_id`  string , `license_amount`  string , `license_discount_amount`  string , `inboxes_limit_gl_category_id`  string , `inboxes_limit_gl_account_id`  string , `inboxes_limit_amount`  string , `inboxes_limit_discount_amount`  string , `tax_free`  string , `interval`  string , `interval_multiplier`  string , `active`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooklicenses_templates/2024-11-05/1730866345'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooklicenses_templates"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooklicenses_templates/2024-11-05/1730866345
    • id: 4747822
    • processed: 1
    • raw_data: 
      {
    "active": 64,
    "desktop_users": 16,
    "desktop_users_amount": 19,
    "desktop_users_discount_amount": 20,
    "desktop_users_gl_account_id": 18,
    "desktop_users_gl_category_id": 17,
    "generate": 3,
    "group_id": 4,
    "id": 2,
    "inboxes_limit": 51,
    "inboxes_limit_amount": 59,
    "inboxes_limit_discount_amount": 60,
    "inboxes_limit_gl_account_id": 58,
    "inboxes_limit_gl_category_id": 57,
    "interval": 62,
    "interval_multiplier": 63,
    "kiosks_limit": 41,
    "kiosks_limit_amount": 44,
    "kiosks_limit_discount_amount": 45,
    "kiosks_limit_gl_account_id": 43,
    "kiosks_limit_gl_category_id": 42,
    "license": 52,
    "license_amount": 55,
    "license_discount_amount": 56,
    "license_gl_account_id": 54,
    "license_gl_category_id": 53,
    "license_period": 13,
    "mobile_users": 21,
    "mobile_users_amount": 24,
    "mobile_users_discount_amount": 25,
    "mobile_users_gl_account_id": 23,
    "mobile_users_gl_category_id": 22,
    "name": 5,
    "newbook_region": 0,
    "primary_license": 8,
    "privileges": 14,
    "sale_contact_template_id": 12,
    "sale_description": 10,
    "sale_display_order": 11,
    "sale_name": 6,
    "sale_option": 9,
    "site_limit": 36,
    "site_limit_amount": 39,
    "site_limit_discount_amount": 40,
    "site_limit_gl_account_id": 38,
    "site_limit_gl_category_id": 37,
    "site_tablets": 31,
    "site_tablets_amount": 34,
    "site_tablets_discount_amount": 35,
    "site_tablets_gl_account_id": 33,
    "site_tablets_gl_category_id": 32,
    "software": 15,
    "storage_limit": 46,
    "storage_limit_amount": 49,
    "storage_limit_discount_amount": 50,
    "storage_limit_gl_account_id": 48,
    "storage_limit_gl_category_id": 47,
    "tax_free": 61,
    "tenant": 1,
    "tv_users": 26,
    "tv_users_amount": 29,
    "tv_users_discount_amount": 30,
    "tv_users_gl_account_id": 28,
    "tv_users_gl_category_id": 27,
    "type": 7
}
    • schema_attributes: 
      {
    "active": "string",
    "desktop_users": "string",
    "desktop_users_amount": "string",
    "desktop_users_discount_amount": "string",
    "desktop_users_gl_account_id": "string",
    "desktop_users_gl_category_id": "string",
    "generate": "string",
    "group_id": "string",
    "id": "string",
    "inboxes_limit": "string",
    "inboxes_limit_amount": "string",
    "inboxes_limit_discount_amount": "string",
    "inboxes_limit_gl_account_id": "string",
    "inboxes_limit_gl_category_id": "string",
    "interval": "string",
    "interval_multiplier": "string",
    "kiosks_limit": "string",
    "kiosks_limit_amount": "string",
    "kiosks_limit_discount_amount": "string",
    "kiosks_limit_gl_account_id": "string",
    "kiosks_limit_gl_category_id": "string",
    "license": "string",
    "license_amount": "string",
    "license_discount_amount": "string",
    "license_gl_account_id": "string",
    "license_gl_category_id": "string",
    "license_period": "string",
    "mobile_users": "string",
    "mobile_users_amount": "string",
    "mobile_users_discount_amount": "string",
    "mobile_users_gl_account_id": "string",
    "mobile_users_gl_category_id": "string",
    "name": "string",
    "newbook_region": "string",
    "primary_license": "string",
    "privileges": "string",
    "sale_contact_template_id": "string",
    "sale_description": "string",
    "sale_display_order": "string",
    "sale_name": "string",
    "sale_option": "string",
    "site_limit": "string",
    "site_limit_amount": "string",
    "site_limit_discount_amount": "string",
    "site_limit_gl_account_id": "string",
    "site_limit_gl_category_id": "string",
    "site_tablets": "string",
    "site_tablets_amount": "string",
    "site_tablets_discount_amount": "string",
    "site_tablets_gl_account_id": "string",
    "site_tablets_gl_category_id": "string",
    "software": "string",
    "storage_limit": "string",
    "storage_limit_amount": "string",
    "storage_limit_discount_amount": "string",
    "storage_limit_gl_account_id": "string",
    "storage_limit_gl_category_id": "string",
    "tax_free": "string",
    "tenant": "string",
    "tv_users": "string",
    "tv_users_amount": "string",
    "tv_users_discount_amount": "string",
    "tv_users_gl_account_id": "string",
    "tv_users_gl_category_id": "string",
    "type": "string"
}
    • schema_name_id: 2898
    • schema_scan_id: 6673853
    • updated: 2024-11-05 22:27:05
    • created: 2024-11-05 04:40:43
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooklicenses_templates`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooklicenses_templates`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `generate`  string , `group_id`  string , `name`  string , `sale_name`  string , `type`  string , `primary_license`  string , `sale_option`  string , `sale_description`  string , `sale_display_order`  string , `sale_contact_template_id`  string , `license_period`  string , `privileges`  string , `software`  string , `desktop_users`  string , `desktop_users_gl_category_id`  string , `desktop_users_gl_account_id`  string , `desktop_users_amount`  string , `desktop_users_discount_amount`  string , `mobile_users`  string , `mobile_users_gl_category_id`  string , `mobile_users_gl_account_id`  string , `mobile_users_amount`  string , `mobile_users_discount_amount`  string , `tv_users`  string , `tv_users_gl_category_id`  string , `tv_users_gl_account_id`  string , `tv_users_amount`  string , `tv_users_discount_amount`  string , `site_tablets`  string , `site_tablets_gl_category_id`  string , `site_tablets_gl_account_id`  string , `site_tablets_amount`  string , `site_tablets_discount_amount`  string , `site_limit`  string , `site_limit_gl_category_id`  string , `site_limit_gl_account_id`  string , `site_limit_amount`  string , `site_limit_discount_amount`  string , `kiosks_limit`  string , `kiosks_limit_gl_category_id`  string , `kiosks_limit_gl_account_id`  string , `kiosks_limit_amount`  string , `kiosks_limit_discount_amount`  string , `storage_limit`  string , `storage_limit_gl_category_id`  string , `storage_limit_gl_account_id`  string , `storage_limit_amount`  string , `storage_limit_discount_amount`  string , `inboxes_limit`  string , `license`  string , `license_gl_category_id`  string , `license_gl_account_id`  string , `license_amount`  string , `license_discount_amount`  string , `inboxes_limit_gl_category_id`  string , `inboxes_limit_gl_account_id`  string , `inboxes_limit_amount`  string , `inboxes_limit_discount_amount`  string , `tax_free`  string , `interval`  string , `interval_multiplier`  string , `active`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooklicenses_templates/2024-11-04/1730785748'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooklicenses_templates"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooklicenses_templates/2024-11-04/1730785748
    • id: 4747010
    • processed: 1
    • raw_data: 
      {
    "active": 64,
    "desktop_users": 16,
    "desktop_users_amount": 19,
    "desktop_users_discount_amount": 20,
    "desktop_users_gl_account_id": 18,
    "desktop_users_gl_category_id": 17,
    "generate": 3,
    "group_id": 4,
    "id": 2,
    "inboxes_limit": 51,
    "inboxes_limit_amount": 59,
    "inboxes_limit_discount_amount": 60,
    "inboxes_limit_gl_account_id": 58,
    "inboxes_limit_gl_category_id": 57,
    "interval": 62,
    "interval_multiplier": 63,
    "kiosks_limit": 41,
    "kiosks_limit_amount": 44,
    "kiosks_limit_discount_amount": 45,
    "kiosks_limit_gl_account_id": 43,
    "kiosks_limit_gl_category_id": 42,
    "license": 52,
    "license_amount": 55,
    "license_discount_amount": 56,
    "license_gl_account_id": 54,
    "license_gl_category_id": 53,
    "license_period": 13,
    "mobile_users": 21,
    "mobile_users_amount": 24,
    "mobile_users_discount_amount": 25,
    "mobile_users_gl_account_id": 23,
    "mobile_users_gl_category_id": 22,
    "name": 5,
    "newbook_region": 0,
    "primary_license": 8,
    "privileges": 14,
    "sale_contact_template_id": 12,
    "sale_description": 10,
    "sale_display_order": 11,
    "sale_name": 6,
    "sale_option": 9,
    "site_limit": 36,
    "site_limit_amount": 39,
    "site_limit_discount_amount": 40,
    "site_limit_gl_account_id": 38,
    "site_limit_gl_category_id": 37,
    "site_tablets": 31,
    "site_tablets_amount": 34,
    "site_tablets_discount_amount": 35,
    "site_tablets_gl_account_id": 33,
    "site_tablets_gl_category_id": 32,
    "software": 15,
    "storage_limit": 46,
    "storage_limit_amount": 49,
    "storage_limit_discount_amount": 50,
    "storage_limit_gl_account_id": 48,
    "storage_limit_gl_category_id": 47,
    "tax_free": 61,
    "tenant": 1,
    "tv_users": 26,
    "tv_users_amount": 29,
    "tv_users_discount_amount": 30,
    "tv_users_gl_account_id": 28,
    "tv_users_gl_category_id": 27,
    "type": 7
}
    • schema_attributes: 
      {
    "active": "string",
    "desktop_users": "string",
    "desktop_users_amount": "string",
    "desktop_users_discount_amount": "string",
    "desktop_users_gl_account_id": "string",
    "desktop_users_gl_category_id": "string",
    "generate": "string",
    "group_id": "string",
    "id": "string",
    "inboxes_limit": "string",
    "inboxes_limit_amount": "string",
    "inboxes_limit_discount_amount": "string",
    "inboxes_limit_gl_account_id": "string",
    "inboxes_limit_gl_category_id": "string",
    "interval": "string",
    "interval_multiplier": "string",
    "kiosks_limit": "string",
    "kiosks_limit_amount": "string",
    "kiosks_limit_discount_amount": "string",
    "kiosks_limit_gl_account_id": "string",
    "kiosks_limit_gl_category_id": "string",
    "license": "string",
    "license_amount": "string",
    "license_discount_amount": "string",
    "license_gl_account_id": "string",
    "license_gl_category_id": "string",
    "license_period": "string",
    "mobile_users": "string",
    "mobile_users_amount": "string",
    "mobile_users_discount_amount": "string",
    "mobile_users_gl_account_id": "string",
    "mobile_users_gl_category_id": "string",
    "name": "string",
    "newbook_region": "string",
    "primary_license": "string",
    "privileges": "string",
    "sale_contact_template_id": "string",
    "sale_description": "string",
    "sale_display_order": "string",
    "sale_name": "string",
    "sale_option": "string",
    "site_limit": "string",
    "site_limit_amount": "string",
    "site_limit_discount_amount": "string",
    "site_limit_gl_account_id": "string",
    "site_limit_gl_category_id": "string",
    "site_tablets": "string",
    "site_tablets_amount": "string",
    "site_tablets_discount_amount": "string",
    "site_tablets_gl_account_id": "string",
    "site_tablets_gl_category_id": "string",
    "software": "string",
    "storage_limit": "string",
    "storage_limit_amount": "string",
    "storage_limit_discount_amount": "string",
    "storage_limit_gl_account_id": "string",
    "storage_limit_gl_category_id": "string",
    "tax_free": "string",
    "tenant": "string",
    "tv_users": "string",
    "tv_users_amount": "string",
    "tv_users_discount_amount": "string",
    "tv_users_gl_account_id": "string",
    "tv_users_gl_category_id": "string",
    "type": "string"
}
    • schema_name_id: 2898
    • schema_scan_id: 6672241
    • updated: 2024-11-05 04:40:57
    • created: 2024-11-05 03:54:06
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooklicenses_templates`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooklicenses_templates`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `generate`  string , `group_id`  string , `name`  string , `sale_name`  string , `type`  string , `primary_license`  string , `sale_option`  string , `sale_description`  string , `sale_display_order`  string , `sale_contact_template_id`  string , `license_period`  string , `privileges`  string , `software`  string , `desktop_users`  string , `desktop_users_gl_category_id`  string , `desktop_users_gl_account_id`  string , `desktop_users_amount`  string , `desktop_users_discount_amount`  string , `mobile_users`  string , `mobile_users_gl_category_id`  string , `mobile_users_gl_account_id`  string , `mobile_users_amount`  string , `mobile_users_discount_amount`  string , `tv_users`  string , `tv_users_gl_category_id`  string , `tv_users_gl_account_id`  string , `tv_users_amount`  string , `tv_users_discount_amount`  string , `site_tablets`  string , `site_tablets_gl_category_id`  string , `site_tablets_gl_account_id`  string , `site_tablets_amount`  string , `site_tablets_discount_amount`  string , `site_limit`  string , `site_limit_gl_category_id`  string , `site_limit_gl_account_id`  string , `site_limit_amount`  string , `site_limit_discount_amount`  string , `kiosks_limit`  string , `kiosks_limit_gl_category_id`  string , `kiosks_limit_gl_account_id`  string , `kiosks_limit_amount`  string , `kiosks_limit_discount_amount`  string , `storage_limit`  string , `storage_limit_gl_category_id`  string , `storage_limit_gl_account_id`  string , `storage_limit_amount`  string , `storage_limit_discount_amount`  string , `inboxes_limit`  string , `license`  string , `license_gl_category_id`  string , `license_gl_account_id`  string , `license_amount`  string , `license_discount_amount`  string , `inboxes_limit_gl_category_id`  string , `inboxes_limit_gl_account_id`  string , `inboxes_limit_amount`  string , `inboxes_limit_discount_amount`  string , `tax_free`  string , `interval`  string , `interval_multiplier`  string , `active`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooklicenses_templates/2024-11-04/1730785139'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooklicenses_templates"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooklicenses_templates/2024-11-04/1730785139
    • id: 4746231
    • processed: 1
    • raw_data: 
      {
    "active": 64,
    "desktop_users": 16,
    "desktop_users_amount": 19,
    "desktop_users_discount_amount": 20,
    "desktop_users_gl_account_id": 18,
    "desktop_users_gl_category_id": 17,
    "generate": 3,
    "group_id": 4,
    "id": 2,
    "inboxes_limit": 51,
    "inboxes_limit_amount": 59,
    "inboxes_limit_discount_amount": 60,
    "inboxes_limit_gl_account_id": 58,
    "inboxes_limit_gl_category_id": 57,
    "interval": 62,
    "interval_multiplier": 63,
    "kiosks_limit": 41,
    "kiosks_limit_amount": 44,
    "kiosks_limit_discount_amount": 45,
    "kiosks_limit_gl_account_id": 43,
    "kiosks_limit_gl_category_id": 42,
    "license": 52,
    "license_amount": 55,
    "license_discount_amount": 56,
    "license_gl_account_id": 54,
    "license_gl_category_id": 53,
    "license_period": 13,
    "mobile_users": 21,
    "mobile_users_amount": 24,
    "mobile_users_discount_amount": 25,
    "mobile_users_gl_account_id": 23,
    "mobile_users_gl_category_id": 22,
    "name": 5,
    "newbook_region": 0,
    "primary_license": 8,
    "privileges": 14,
    "sale_contact_template_id": 12,
    "sale_description": 10,
    "sale_display_order": 11,
    "sale_name": 6,
    "sale_option": 9,
    "site_limit": 36,
    "site_limit_amount": 39,
    "site_limit_discount_amount": 40,
    "site_limit_gl_account_id": 38,
    "site_limit_gl_category_id": 37,
    "site_tablets": 31,
    "site_tablets_amount": 34,
    "site_tablets_discount_amount": 35,
    "site_tablets_gl_account_id": 33,
    "site_tablets_gl_category_id": 32,
    "software": 15,
    "storage_limit": 46,
    "storage_limit_amount": 49,
    "storage_limit_discount_amount": 50,
    "storage_limit_gl_account_id": 48,
    "storage_limit_gl_category_id": 47,
    "tax_free": 61,
    "tenant": 1,
    "tv_users": 26,
    "tv_users_amount": 29,
    "tv_users_discount_amount": 30,
    "tv_users_gl_account_id": 28,
    "tv_users_gl_category_id": 27,
    "type": 7
}
    • schema_attributes: 
      {
    "active": "string",
    "desktop_users": "string",
    "desktop_users_amount": "string",
    "desktop_users_discount_amount": "string",
    "desktop_users_gl_account_id": "string",
    "desktop_users_gl_category_id": "string",
    "generate": "string",
    "group_id": "string",
    "id": "string",
    "inboxes_limit": "string",
    "inboxes_limit_amount": "string",
    "inboxes_limit_discount_amount": "string",
    "inboxes_limit_gl_account_id": "string",
    "inboxes_limit_gl_category_id": "string",
    "interval": "string",
    "interval_multiplier": "string",
    "kiosks_limit": "string",
    "kiosks_limit_amount": "string",
    "kiosks_limit_discount_amount": "string",
    "kiosks_limit_gl_account_id": "string",
    "kiosks_limit_gl_category_id": "string",
    "license": "string",
    "license_amount": "string",
    "license_discount_amount": "string",
    "license_gl_account_id": "string",
    "license_gl_category_id": "string",
    "license_period": "string",
    "mobile_users": "string",
    "mobile_users_amount": "string",
    "mobile_users_discount_amount": "string",
    "mobile_users_gl_account_id": "string",
    "mobile_users_gl_category_id": "string",
    "name": "string",
    "newbook_region": "string",
    "primary_license": "string",
    "privileges": "string",
    "sale_contact_template_id": "string",
    "sale_description": "string",
    "sale_display_order": "string",
    "sale_name": "string",
    "sale_option": "string",
    "site_limit": "string",
    "site_limit_amount": "string",
    "site_limit_discount_amount": "string",
    "site_limit_gl_account_id": "string",
    "site_limit_gl_category_id": "string",
    "site_tablets": "string",
    "site_tablets_amount": "string",
    "site_tablets_discount_amount": "string",
    "site_tablets_gl_account_id": "string",
    "site_tablets_gl_category_id": "string",
    "software": "string",
    "storage_limit": "string",
    "storage_limit_amount": "string",
    "storage_limit_discount_amount": "string",
    "storage_limit_gl_account_id": "string",
    "storage_limit_gl_category_id": "string",
    "tax_free": "string",
    "tenant": "string",
    "tv_users": "string",
    "tv_users_amount": "string",
    "tv_users_discount_amount": "string",
    "tv_users_gl_account_id": "string",
    "tv_users_gl_category_id": "string",
    "type": "string"
}
    • schema_name_id: 2898
    • schema_scan_id: 6671450
    • updated: 2024-11-05 03:54:20
    • created: 2024-11-05 03:32:08
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooklicenses_templates`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooklicenses_templates`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `generate`  string , `group_id`  string , `name`  string , `sale_name`  string , `type`  string , `primary_license`  string , `sale_option`  string , `sale_description`  string , `sale_display_order`  string , `sale_contact_template_id`  string , `license_period`  string , `privileges`  string , `software`  string , `desktop_users`  string , `desktop_users_gl_category_id`  string , `desktop_users_gl_account_id`  string , `desktop_users_amount`  string , `desktop_users_discount_amount`  string , `mobile_users`  string , `mobile_users_gl_category_id`  string , `mobile_users_gl_account_id`  string , `mobile_users_amount`  string , `mobile_users_discount_amount`  string , `tv_users`  string , `tv_users_gl_category_id`  string , `tv_users_gl_account_id`  string , `tv_users_amount`  string , `tv_users_discount_amount`  string , `site_tablets`  string , `site_tablets_gl_category_id`  string , `site_tablets_gl_account_id`  string , `site_tablets_amount`  string , `site_tablets_discount_amount`  string , `site_limit`  string , `site_limit_gl_category_id`  string , `site_limit_gl_account_id`  string , `site_limit_amount`  string , `site_limit_discount_amount`  string , `kiosks_limit`  string , `kiosks_limit_gl_category_id`  string , `kiosks_limit_gl_account_id`  string , `kiosks_limit_amount`  string , `kiosks_limit_discount_amount`  string , `storage_limit`  string , `storage_limit_gl_category_id`  string , `storage_limit_gl_account_id`  string , `storage_limit_amount`  string , `storage_limit_discount_amount`  string , `inboxes_limit`  string , `license`  string , `license_gl_category_id`  string , `license_gl_account_id`  string , `license_amount`  string , `license_discount_amount`  string , `inboxes_limit_gl_category_id`  string , `inboxes_limit_gl_account_id`  string , `inboxes_limit_amount`  string , `inboxes_limit_discount_amount`  string , `tax_free`  string , `interval`  string , `interval_multiplier`  string , `active`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooklicenses_templates/2024-11-04/1730784834'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooklicenses_templates"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooklicenses_templates/2024-11-04/1730784834
    • id: 4745539
    • processed: 1
    • raw_data: 
      {
    "active": 64,
    "desktop_users": 16,
    "desktop_users_amount": 19,
    "desktop_users_discount_amount": 20,
    "desktop_users_gl_account_id": 18,
    "desktop_users_gl_category_id": 17,
    "generate": 3,
    "group_id": 4,
    "id": 2,
    "inboxes_limit": 51,
    "inboxes_limit_amount": 59,
    "inboxes_limit_discount_amount": 60,
    "inboxes_limit_gl_account_id": 58,
    "inboxes_limit_gl_category_id": 57,
    "interval": 62,
    "interval_multiplier": 63,
    "kiosks_limit": 41,
    "kiosks_limit_amount": 44,
    "kiosks_limit_discount_amount": 45,
    "kiosks_limit_gl_account_id": 43,
    "kiosks_limit_gl_category_id": 42,
    "license": 52,
    "license_amount": 55,
    "license_discount_amount": 56,
    "license_gl_account_id": 54,
    "license_gl_category_id": 53,
    "license_period": 13,
    "mobile_users": 21,
    "mobile_users_amount": 24,
    "mobile_users_discount_amount": 25,
    "mobile_users_gl_account_id": 23,
    "mobile_users_gl_category_id": 22,
    "name": 5,
    "newbook_region": 0,
    "primary_license": 8,
    "privileges": 14,
    "sale_contact_template_id": 12,
    "sale_description": 10,
    "sale_display_order": 11,
    "sale_name": 6,
    "sale_option": 9,
    "site_limit": 36,
    "site_limit_amount": 39,
    "site_limit_discount_amount": 40,
    "site_limit_gl_account_id": 38,
    "site_limit_gl_category_id": 37,
    "site_tablets": 31,
    "site_tablets_amount": 34,
    "site_tablets_discount_amount": 35,
    "site_tablets_gl_account_id": 33,
    "site_tablets_gl_category_id": 32,
    "software": 15,
    "storage_limit": 46,
    "storage_limit_amount": 49,
    "storage_limit_discount_amount": 50,
    "storage_limit_gl_account_id": 48,
    "storage_limit_gl_category_id": 47,
    "tax_free": 61,
    "tenant": 1,
    "tv_users": 26,
    "tv_users_amount": 29,
    "tv_users_discount_amount": 30,
    "tv_users_gl_account_id": 28,
    "tv_users_gl_category_id": 27,
    "type": 7
}
    • schema_attributes: 
      {
    "active": "string",
    "desktop_users": "string",
    "desktop_users_amount": "string",
    "desktop_users_discount_amount": "string",
    "desktop_users_gl_account_id": "string",
    "desktop_users_gl_category_id": "string",
    "generate": "string",
    "group_id": "string",
    "id": "string",
    "inboxes_limit": "string",
    "inboxes_limit_amount": "string",
    "inboxes_limit_discount_amount": "string",
    "inboxes_limit_gl_account_id": "string",
    "inboxes_limit_gl_category_id": "string",
    "interval": "string",
    "interval_multiplier": "string",
    "kiosks_limit": "string",
    "kiosks_limit_amount": "string",
    "kiosks_limit_discount_amount": "string",
    "kiosks_limit_gl_account_id": "string",
    "kiosks_limit_gl_category_id": "string",
    "license": "string",
    "license_amount": "string",
    "license_discount_amount": "string",
    "license_gl_account_id": "string",
    "license_gl_category_id": "string",
    "license_period": "string",
    "mobile_users": "string",
    "mobile_users_amount": "string",
    "mobile_users_discount_amount": "string",
    "mobile_users_gl_account_id": "string",
    "mobile_users_gl_category_id": "string",
    "name": "string",
    "newbook_region": "string",
    "primary_license": "string",
    "privileges": "string",
    "sale_contact_template_id": "string",
    "sale_description": "string",
    "sale_display_order": "string",
    "sale_name": "string",
    "sale_option": "string",
    "site_limit": "string",
    "site_limit_amount": "string",
    "site_limit_discount_amount": "string",
    "site_limit_gl_account_id": "string",
    "site_limit_gl_category_id": "string",
    "site_tablets": "string",
    "site_tablets_amount": "string",
    "site_tablets_discount_amount": "string",
    "site_tablets_gl_account_id": "string",
    "site_tablets_gl_category_id": "string",
    "software": "string",
    "storage_limit": "string",
    "storage_limit_amount": "string",
    "storage_limit_discount_amount": "string",
    "storage_limit_gl_account_id": "string",
    "storage_limit_gl_category_id": "string",
    "tax_free": "string",
    "tenant": "string",
    "tv_users": "string",
    "tv_users_amount": "string",
    "tv_users_discount_amount": "string",
    "tv_users_gl_account_id": "string",
    "tv_users_gl_category_id": "string",
    "type": "string"
}
    • schema_name_id: 2898
    • schema_scan_id: 6670756
    • updated: 2024-11-05 03:32:22
    • created: 2024-11-05 03:18:07
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooklicenses_templates`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooklicenses_templates`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `generate`  string , `group_id`  string , `name`  string , `sale_name`  string , `type`  string , `primary_license`  string , `sale_option`  string , `sale_description`  string , `sale_display_order`  string , `sale_contact_template_id`  string , `license_period`  string , `privileges`  string , `software`  string , `desktop_users`  string , `desktop_users_gl_category_id`  string , `desktop_users_gl_account_id`  string , `desktop_users_amount`  string , `desktop_users_discount_amount`  string , `mobile_users`  string , `mobile_users_gl_category_id`  string , `mobile_users_gl_account_id`  string , `mobile_users_amount`  string , `mobile_users_discount_amount`  string , `tv_users`  string , `tv_users_gl_category_id`  string , `tv_users_gl_account_id`  string , `tv_users_amount`  string , `tv_users_discount_amount`  string , `site_tablets`  string , `site_tablets_gl_category_id`  string , `site_tablets_gl_account_id`  string , `site_tablets_amount`  string , `site_tablets_discount_amount`  string , `site_limit`  string , `site_limit_gl_category_id`  string , `site_limit_gl_account_id`  string , `site_limit_amount`  string , `site_limit_discount_amount`  string , `kiosks_limit`  string , `kiosks_limit_gl_category_id`  string , `kiosks_limit_gl_account_id`  string , `kiosks_limit_amount`  string , `kiosks_limit_discount_amount`  string , `storage_limit`  string , `storage_limit_gl_category_id`  string , `storage_limit_gl_account_id`  string , `storage_limit_amount`  string , `storage_limit_discount_amount`  string , `inboxes_limit`  string , `license`  string , `license_gl_category_id`  string , `license_gl_account_id`  string , `license_amount`  string , `license_discount_amount`  string , `inboxes_limit_gl_category_id`  string , `inboxes_limit_gl_account_id`  string , `inboxes_limit_amount`  string , `inboxes_limit_discount_amount`  string , `tax_free`  string , `interval`  string , `interval_multiplier`  string , `active`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooklicenses_templates/2024-11-04/1730784230'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooklicenses_templates"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooklicenses_templates/2024-11-04/1730784230
    • id: 4745005
    • processed: 1
    • raw_data: 
      {
    "active": 64,
    "desktop_users": 16,
    "desktop_users_amount": 19,
    "desktop_users_discount_amount": 20,
    "desktop_users_gl_account_id": 18,
    "desktop_users_gl_category_id": 17,
    "generate": 3,
    "group_id": 4,
    "id": 2,
    "inboxes_limit": 51,
    "inboxes_limit_amount": 59,
    "inboxes_limit_discount_amount": 60,
    "inboxes_limit_gl_account_id": 58,
    "inboxes_limit_gl_category_id": 57,
    "interval": 62,
    "interval_multiplier": 63,
    "kiosks_limit": 41,
    "kiosks_limit_amount": 44,
    "kiosks_limit_discount_amount": 45,
    "kiosks_limit_gl_account_id": 43,
    "kiosks_limit_gl_category_id": 42,
    "license": 52,
    "license_amount": 55,
    "license_discount_amount": 56,
    "license_gl_account_id": 54,
    "license_gl_category_id": 53,
    "license_period": 13,
    "mobile_users": 21,
    "mobile_users_amount": 24,
    "mobile_users_discount_amount": 25,
    "mobile_users_gl_account_id": 23,
    "mobile_users_gl_category_id": 22,
    "name": 5,
    "newbook_region": 0,
    "primary_license": 8,
    "privileges": 14,
    "sale_contact_template_id": 12,
    "sale_description": 10,
    "sale_display_order": 11,
    "sale_name": 6,
    "sale_option": 9,
    "site_limit": 36,
    "site_limit_amount": 39,
    "site_limit_discount_amount": 40,
    "site_limit_gl_account_id": 38,
    "site_limit_gl_category_id": 37,
    "site_tablets": 31,
    "site_tablets_amount": 34,
    "site_tablets_discount_amount": 35,
    "site_tablets_gl_account_id": 33,
    "site_tablets_gl_category_id": 32,
    "software": 15,
    "storage_limit": 46,
    "storage_limit_amount": 49,
    "storage_limit_discount_amount": 50,
    "storage_limit_gl_account_id": 48,
    "storage_limit_gl_category_id": 47,
    "tax_free": 61,
    "tenant": 1,
    "tv_users": 26,
    "tv_users_amount": 29,
    "tv_users_discount_amount": 30,
    "tv_users_gl_account_id": 28,
    "tv_users_gl_category_id": 27,
    "type": 7
}
    • schema_attributes: 
      {
    "active": "string",
    "desktop_users": "string",
    "desktop_users_amount": "string",
    "desktop_users_discount_amount": "string",
    "desktop_users_gl_account_id": "string",
    "desktop_users_gl_category_id": "string",
    "generate": "string",
    "group_id": "string",
    "id": "string",
    "inboxes_limit": "string",
    "inboxes_limit_amount": "string",
    "inboxes_limit_discount_amount": "string",
    "inboxes_limit_gl_account_id": "string",
    "inboxes_limit_gl_category_id": "string",
    "interval": "string",
    "interval_multiplier": "string",
    "kiosks_limit": "string",
    "kiosks_limit_amount": "string",
    "kiosks_limit_discount_amount": "string",
    "kiosks_limit_gl_account_id": "string",
    "kiosks_limit_gl_category_id": "string",
    "license": "string",
    "license_amount": "string",
    "license_discount_amount": "string",
    "license_gl_account_id": "string",
    "license_gl_category_id": "string",
    "license_period": "string",
    "mobile_users": "string",
    "mobile_users_amount": "string",
    "mobile_users_discount_amount": "string",
    "mobile_users_gl_account_id": "string",
    "mobile_users_gl_category_id": "string",
    "name": "string",
    "newbook_region": "string",
    "primary_license": "string",
    "privileges": "string",
    "sale_contact_template_id": "string",
    "sale_description": "string",
    "sale_display_order": "string",
    "sale_name": "string",
    "sale_option": "string",
    "site_limit": "string",
    "site_limit_amount": "string",
    "site_limit_discount_amount": "string",
    "site_limit_gl_account_id": "string",
    "site_limit_gl_category_id": "string",
    "site_tablets": "string",
    "site_tablets_amount": "string",
    "site_tablets_discount_amount": "string",
    "site_tablets_gl_account_id": "string",
    "site_tablets_gl_category_id": "string",
    "software": "string",
    "storage_limit": "string",
    "storage_limit_amount": "string",
    "storage_limit_discount_amount": "string",
    "storage_limit_gl_account_id": "string",
    "storage_limit_gl_category_id": "string",
    "tax_free": "string",
    "tenant": "string",
    "tv_users": "string",
    "tv_users_amount": "string",
    "tv_users_discount_amount": "string",
    "tv_users_gl_account_id": "string",
    "tv_users_gl_category_id": "string",
    "type": "string"
}
    • schema_name_id: 2898
    • schema_scan_id: 6670221
    • updated: 2024-11-05 03:18:18
    • created: 2024-11-05 02:38:31
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooklicenses_templates`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooklicenses_templates`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `generate`  string , `group_id`  string , `name`  string , `sale_name`  string , `type`  string , `primary_license`  string , `sale_option`  string , `sale_description`  string , `sale_display_order`  string , `sale_contact_template_id`  string , `license_period`  string , `privileges`  string , `software`  string , `desktop_users`  string , `desktop_users_gl_category_id`  string , `desktop_users_gl_account_id`  string , `desktop_users_amount`  string , `desktop_users_discount_amount`  string , `mobile_users`  string , `mobile_users_gl_category_id`  string , `mobile_users_gl_account_id`  string , `mobile_users_amount`  string , `mobile_users_discount_amount`  string , `tv_users`  string , `tv_users_gl_category_id`  string , `tv_users_gl_account_id`  string , `tv_users_amount`  string , `tv_users_discount_amount`  string , `site_tablets`  string , `site_tablets_gl_category_id`  string , `site_tablets_gl_account_id`  string , `site_tablets_amount`  string , `site_tablets_discount_amount`  string , `site_limit`  string , `site_limit_gl_category_id`  string , `site_limit_gl_account_id`  string , `site_limit_amount`  string , `site_limit_discount_amount`  string , `kiosks_limit`  string , `kiosks_limit_gl_category_id`  string , `kiosks_limit_gl_account_id`  string , `kiosks_limit_amount`  string , `kiosks_limit_discount_amount`  string , `storage_limit`  string , `storage_limit_gl_category_id`  string , `storage_limit_gl_account_id`  string , `storage_limit_amount`  string , `storage_limit_discount_amount`  string , `inboxes_limit`  string , `license`  string , `license_gl_category_id`  string , `license_gl_account_id`  string , `license_amount`  string , `license_discount_amount`  string , `inboxes_limit_gl_category_id`  string , `inboxes_limit_gl_account_id`  string , `inboxes_limit_amount`  string , `inboxes_limit_discount_amount`  string , `tax_free`  string , `interval`  string , `interval_multiplier`  string , `active`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooklicenses_templates/2024-11-04/1730784068'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooklicenses_templates"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooklicenses_templates/2024-11-04/1730784068
    • id: 4743509
    • processed: 1
    • raw_data: 
      {
    "active": 64,
    "desktop_users": 16,
    "desktop_users_amount": 19,
    "desktop_users_discount_amount": 20,
    "desktop_users_gl_account_id": 18,
    "desktop_users_gl_category_id": 17,
    "generate": 3,
    "group_id": 4,
    "id": 2,
    "inboxes_limit": 51,
    "inboxes_limit_amount": 59,
    "inboxes_limit_discount_amount": 60,
    "inboxes_limit_gl_account_id": 58,
    "inboxes_limit_gl_category_id": 57,
    "interval": 62,
    "interval_multiplier": 63,
    "kiosks_limit": 41,
    "kiosks_limit_amount": 44,
    "kiosks_limit_discount_amount": 45,
    "kiosks_limit_gl_account_id": 43,
    "kiosks_limit_gl_category_id": 42,
    "license": 52,
    "license_amount": 55,
    "license_discount_amount": 56,
    "license_gl_account_id": 54,
    "license_gl_category_id": 53,
    "license_period": 13,
    "mobile_users": 21,
    "mobile_users_amount": 24,
    "mobile_users_discount_amount": 25,
    "mobile_users_gl_account_id": 23,
    "mobile_users_gl_category_id": 22,
    "name": 5,
    "newbook_region": 0,
    "primary_license": 8,
    "privileges": 14,
    "sale_contact_template_id": 12,
    "sale_description": 10,
    "sale_display_order": 11,
    "sale_name": 6,
    "sale_option": 9,
    "site_limit": 36,
    "site_limit_amount": 39,
    "site_limit_discount_amount": 40,
    "site_limit_gl_account_id": 38,
    "site_limit_gl_category_id": 37,
    "site_tablets": 31,
    "site_tablets_amount": 34,
    "site_tablets_discount_amount": 35,
    "site_tablets_gl_account_id": 33,
    "site_tablets_gl_category_id": 32,
    "software": 15,
    "storage_limit": 46,
    "storage_limit_amount": 49,
    "storage_limit_discount_amount": 50,
    "storage_limit_gl_account_id": 48,
    "storage_limit_gl_category_id": 47,
    "tax_free": 61,
    "tenant": 1,
    "tv_users": 26,
    "tv_users_amount": 29,
    "tv_users_discount_amount": 30,
    "tv_users_gl_account_id": 28,
    "tv_users_gl_category_id": 27,
    "type": 7
}
    • schema_attributes: 
      {
    "active": "string",
    "desktop_users": "string",
    "desktop_users_amount": "string",
    "desktop_users_discount_amount": "string",
    "desktop_users_gl_account_id": "string",
    "desktop_users_gl_category_id": "string",
    "generate": "string",
    "group_id": "string",
    "id": "string",
    "inboxes_limit": "string",
    "inboxes_limit_amount": "string",
    "inboxes_limit_discount_amount": "string",
    "inboxes_limit_gl_account_id": "string",
    "inboxes_limit_gl_category_id": "string",
    "interval": "string",
    "interval_multiplier": "string",
    "kiosks_limit": "string",
    "kiosks_limit_amount": "string",
    "kiosks_limit_discount_amount": "string",
    "kiosks_limit_gl_account_id": "string",
    "kiosks_limit_gl_category_id": "string",
    "license": "string",
    "license_amount": "string",
    "license_discount_amount": "string",
    "license_gl_account_id": "string",
    "license_gl_category_id": "string",
    "license_period": "string",
    "mobile_users": "string",
    "mobile_users_amount": "string",
    "mobile_users_discount_amount": "string",
    "mobile_users_gl_account_id": "string",
    "mobile_users_gl_category_id": "string",
    "name": "string",
    "newbook_region": "string",
    "primary_license": "string",
    "privileges": "string",
    "sale_contact_template_id": "string",
    "sale_description": "string",
    "sale_display_order": "string",
    "sale_name": "string",
    "sale_option": "string",
    "site_limit": "string",
    "site_limit_amount": "string",
    "site_limit_discount_amount": "string",
    "site_limit_gl_account_id": "string",
    "site_limit_gl_category_id": "string",
    "site_tablets": "string",
    "site_tablets_amount": "string",
    "site_tablets_discount_amount": "string",
    "site_tablets_gl_account_id": "string",
    "site_tablets_gl_category_id": "string",
    "software": "string",
    "storage_limit": "string",
    "storage_limit_amount": "string",
    "storage_limit_discount_amount": "string",
    "storage_limit_gl_account_id": "string",
    "storage_limit_gl_category_id": "string",
    "tax_free": "string",
    "tenant": "string",
    "tv_users": "string",
    "tv_users_amount": "string",
    "tv_users_discount_amount": "string",
    "tv_users_gl_account_id": "string",
    "tv_users_gl_category_id": "string",
    "type": "string"
}
    • schema_name_id: 2898
    • schema_scan_id: 6668726
    • updated: 2024-11-05 02:38:44
    • created: 2024-11-05 02:28:35
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooklicenses_templates`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooklicenses_templates`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `generate`  string , `group_id`  string , `name`  string , `sale_name`  string , `type`  string , `primary_license`  string , `sale_option`  string , `sale_description`  string , `sale_display_order`  string , `sale_contact_template_id`  string , `license_period`  string , `privileges`  string , `software`  string , `desktop_users`  string , `desktop_users_gl_category_id`  string , `desktop_users_gl_account_id`  string , `desktop_users_amount`  string , `desktop_users_discount_amount`  string , `mobile_users`  string , `mobile_users_gl_category_id`  string , `mobile_users_gl_account_id`  string , `mobile_users_amount`  string , `mobile_users_discount_amount`  string , `tv_users`  string , `tv_users_gl_category_id`  string , `tv_users_gl_account_id`  string , `tv_users_amount`  string , `tv_users_discount_amount`  string , `site_tablets`  string , `site_tablets_gl_category_id`  string , `site_tablets_gl_account_id`  string , `site_tablets_amount`  string , `site_tablets_discount_amount`  string , `site_limit`  string , `site_limit_gl_category_id`  string , `site_limit_gl_account_id`  string , `site_limit_amount`  string , `site_limit_discount_amount`  string , `kiosks_limit`  string , `kiosks_limit_gl_category_id`  string , `kiosks_limit_gl_account_id`  string , `kiosks_limit_amount`  string , `kiosks_limit_discount_amount`  string , `storage_limit`  string , `storage_limit_gl_category_id`  string , `storage_limit_gl_account_id`  string , `storage_limit_amount`  string , `storage_limit_discount_amount`  string , `inboxes_limit`  string , `license`  string , `license_gl_category_id`  string , `license_gl_account_id`  string , `license_amount`  string , `license_discount_amount`  string , `inboxes_limit_gl_category_id`  string , `inboxes_limit_gl_account_id`  string , `inboxes_limit_amount`  string , `inboxes_limit_discount_amount`  string , `tax_free`  string , `interval`  string , `interval_multiplier`  string , `active`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooklicenses_templates/2024-11-04/1730783847'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooklicenses_templates"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooklicenses_templates/2024-11-04/1730783847
    • id: 4743135
    • processed: 1
    • raw_data: 
      {
    "active": 64,
    "desktop_users": 16,
    "desktop_users_amount": 19,
    "desktop_users_discount_amount": 20,
    "desktop_users_gl_account_id": 18,
    "desktop_users_gl_category_id": 17,
    "generate": 3,
    "group_id": 4,
    "id": 2,
    "inboxes_limit": 51,
    "inboxes_limit_amount": 59,
    "inboxes_limit_discount_amount": 60,
    "inboxes_limit_gl_account_id": 58,
    "inboxes_limit_gl_category_id": 57,
    "interval": 62,
    "interval_multiplier": 63,
    "kiosks_limit": 41,
    "kiosks_limit_amount": 44,
    "kiosks_limit_discount_amount": 45,
    "kiosks_limit_gl_account_id": 43,
    "kiosks_limit_gl_category_id": 42,
    "license": 52,
    "license_amount": 55,
    "license_discount_amount": 56,
    "license_gl_account_id": 54,
    "license_gl_category_id": 53,
    "license_period": 13,
    "mobile_users": 21,
    "mobile_users_amount": 24,
    "mobile_users_discount_amount": 25,
    "mobile_users_gl_account_id": 23,
    "mobile_users_gl_category_id": 22,
    "name": 5,
    "newbook_region": 0,
    "primary_license": 8,
    "privileges": 14,
    "sale_contact_template_id": 12,
    "sale_description": 10,
    "sale_display_order": 11,
    "sale_name": 6,
    "sale_option": 9,
    "site_limit": 36,
    "site_limit_amount": 39,
    "site_limit_discount_amount": 40,
    "site_limit_gl_account_id": 38,
    "site_limit_gl_category_id": 37,
    "site_tablets": 31,
    "site_tablets_amount": 34,
    "site_tablets_discount_amount": 35,
    "site_tablets_gl_account_id": 33,
    "site_tablets_gl_category_id": 32,
    "software": 15,
    "storage_limit": 46,
    "storage_limit_amount": 49,
    "storage_limit_discount_amount": 50,
    "storage_limit_gl_account_id": 48,
    "storage_limit_gl_category_id": 47,
    "tax_free": 61,
    "tenant": 1,
    "tv_users": 26,
    "tv_users_amount": 29,
    "tv_users_discount_amount": 30,
    "tv_users_gl_account_id": 28,
    "tv_users_gl_category_id": 27,
    "type": 7
}
    • schema_attributes: 
      {
    "active": "string",
    "desktop_users": "string",
    "desktop_users_amount": "string",
    "desktop_users_discount_amount": "string",
    "desktop_users_gl_account_id": "string",
    "desktop_users_gl_category_id": "string",
    "generate": "string",
    "group_id": "string",
    "id": "string",
    "inboxes_limit": "string",
    "inboxes_limit_amount": "string",
    "inboxes_limit_discount_amount": "string",
    "inboxes_limit_gl_account_id": "string",
    "inboxes_limit_gl_category_id": "string",
    "interval": "string",
    "interval_multiplier": "string",
    "kiosks_limit": "string",
    "kiosks_limit_amount": "string",
    "kiosks_limit_discount_amount": "string",
    "kiosks_limit_gl_account_id": "string",
    "kiosks_limit_gl_category_id": "string",
    "license": "string",
    "license_amount": "string",
    "license_discount_amount": "string",
    "license_gl_account_id": "string",
    "license_gl_category_id": "string",
    "license_period": "string",
    "mobile_users": "string",
    "mobile_users_amount": "string",
    "mobile_users_discount_amount": "string",
    "mobile_users_gl_account_id": "string",
    "mobile_users_gl_category_id": "string",
    "name": "string",
    "newbook_region": "string",
    "primary_license": "string",
    "privileges": "string",
    "sale_contact_template_id": "string",
    "sale_description": "string",
    "sale_display_order": "string",
    "sale_name": "string",
    "sale_option": "string",
    "site_limit": "string",
    "site_limit_amount": "string",
    "site_limit_discount_amount": "string",
    "site_limit_gl_account_id": "string",
    "site_limit_gl_category_id": "string",
    "site_tablets": "string",
    "site_tablets_amount": "string",
    "site_tablets_discount_amount": "string",
    "site_tablets_gl_account_id": "string",
    "site_tablets_gl_category_id": "string",
    "software": "string",
    "storage_limit": "string",
    "storage_limit_amount": "string",
    "storage_limit_discount_amount": "string",
    "storage_limit_gl_account_id": "string",
    "storage_limit_gl_category_id": "string",
    "tax_free": "string",
    "tenant": "string",
    "tv_users": "string",
    "tv_users_amount": "string",
    "tv_users_discount_amount": "string",
    "tv_users_gl_account_id": "string",
    "tv_users_gl_category_id": "string",
    "type": "string"
}
    • schema_name_id: 2898
    • schema_scan_id: 6668352
    • updated: 2024-11-05 02:28:46
    • created: 2024-11-05 02:17:00
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooklicenses_templates`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooklicenses_templates`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `generate`  string , `group_id`  string , `name`  string , `sale_name`  string , `type`  string , `primary_license`  string , `sale_option`  string , `sale_description`  string , `sale_display_order`  string , `sale_contact_template_id`  string , `license_period`  string , `privileges`  string , `software`  string , `desktop_users`  string , `desktop_users_gl_category_id`  string , `desktop_users_gl_account_id`  string , `desktop_users_amount`  string , `desktop_users_discount_amount`  string , `mobile_users`  string , `mobile_users_gl_category_id`  string , `mobile_users_gl_account_id`  string , `mobile_users_amount`  string , `mobile_users_discount_amount`  string , `tv_users`  string , `tv_users_gl_category_id`  string , `tv_users_gl_account_id`  string , `tv_users_amount`  string , `tv_users_discount_amount`  string , `site_tablets`  string , `site_tablets_gl_category_id`  string , `site_tablets_gl_account_id`  string , `site_tablets_amount`  string , `site_tablets_discount_amount`  string , `site_limit`  string , `site_limit_gl_category_id`  string , `site_limit_gl_account_id`  string , `site_limit_amount`  string , `site_limit_discount_amount`  string , `kiosks_limit`  string , `kiosks_limit_gl_category_id`  string , `kiosks_limit_gl_account_id`  string , `kiosks_limit_amount`  string , `kiosks_limit_discount_amount`  string , `storage_limit`  string , `storage_limit_gl_category_id`  string , `storage_limit_gl_account_id`  string , `storage_limit_amount`  string , `storage_limit_discount_amount`  string , `inboxes_limit`  string , `license`  string , `license_gl_category_id`  string , `license_gl_account_id`  string , `license_amount`  string , `license_discount_amount`  string , `inboxes_limit_gl_category_id`  string , `inboxes_limit_gl_account_id`  string , `inboxes_limit_amount`  string , `inboxes_limit_discount_amount`  string , `tax_free`  string , `interval`  string , `interval_multiplier`  string , `active`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooklicenses_templates/2024-11-04/1730783782'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooklicenses_templates"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooklicenses_templates/2024-11-04/1730783782
    • id: 4742694
    • processed: 1
    • raw_data: 
      {
    "active": 64,
    "desktop_users": 16,
    "desktop_users_amount": 19,
    "desktop_users_discount_amount": 20,
    "desktop_users_gl_account_id": 18,
    "desktop_users_gl_category_id": 17,
    "generate": 3,
    "group_id": 4,
    "id": 2,
    "inboxes_limit": 51,
    "inboxes_limit_amount": 59,
    "inboxes_limit_discount_amount": 60,
    "inboxes_limit_gl_account_id": 58,
    "inboxes_limit_gl_category_id": 57,
    "interval": 62,
    "interval_multiplier": 63,
    "kiosks_limit": 41,
    "kiosks_limit_amount": 44,
    "kiosks_limit_discount_amount": 45,
    "kiosks_limit_gl_account_id": 43,
    "kiosks_limit_gl_category_id": 42,
    "license": 52,
    "license_amount": 55,
    "license_discount_amount": 56,
    "license_gl_account_id": 54,
    "license_gl_category_id": 53,
    "license_period": 13,
    "mobile_users": 21,
    "mobile_users_amount": 24,
    "mobile_users_discount_amount": 25,
    "mobile_users_gl_account_id": 23,
    "mobile_users_gl_category_id": 22,
    "name": 5,
    "newbook_region": 0,
    "primary_license": 8,
    "privileges": 14,
    "sale_contact_template_id": 12,
    "sale_description": 10,
    "sale_display_order": 11,
    "sale_name": 6,
    "sale_option": 9,
    "site_limit": 36,
    "site_limit_amount": 39,
    "site_limit_discount_amount": 40,
    "site_limit_gl_account_id": 38,
    "site_limit_gl_category_id": 37,
    "site_tablets": 31,
    "site_tablets_amount": 34,
    "site_tablets_discount_amount": 35,
    "site_tablets_gl_account_id": 33,
    "site_tablets_gl_category_id": 32,
    "software": 15,
    "storage_limit": 46,
    "storage_limit_amount": 49,
    "storage_limit_discount_amount": 50,
    "storage_limit_gl_account_id": 48,
    "storage_limit_gl_category_id": 47,
    "tax_free": 61,
    "tenant": 1,
    "tv_users": 26,
    "tv_users_amount": 29,
    "tv_users_discount_amount": 30,
    "tv_users_gl_account_id": 28,
    "tv_users_gl_category_id": 27,
    "type": 7
}
    • schema_attributes: 
      {
    "active": "string",
    "desktop_users": "string",
    "desktop_users_amount": "string",
    "desktop_users_discount_amount": "string",
    "desktop_users_gl_account_id": "string",
    "desktop_users_gl_category_id": "string",
    "generate": "string",
    "group_id": "string",
    "id": "string",
    "inboxes_limit": "string",
    "inboxes_limit_amount": "string",
    "inboxes_limit_discount_amount": "string",
    "inboxes_limit_gl_account_id": "string",
    "inboxes_limit_gl_category_id": "string",
    "interval": "string",
    "interval_multiplier": "string",
    "kiosks_limit": "string",
    "kiosks_limit_amount": "string",
    "kiosks_limit_discount_amount": "string",
    "kiosks_limit_gl_account_id": "string",
    "kiosks_limit_gl_category_id": "string",
    "license": "string",
    "license_amount": "string",
    "license_discount_amount": "string",
    "license_gl_account_id": "string",
    "license_gl_category_id": "string",
    "license_period": "string",
    "mobile_users": "string",
    "mobile_users_amount": "string",
    "mobile_users_discount_amount": "string",
    "mobile_users_gl_account_id": "string",
    "mobile_users_gl_category_id": "string",
    "name": "string",
    "newbook_region": "string",
    "primary_license": "string",
    "privileges": "string",
    "sale_contact_template_id": "string",
    "sale_description": "string",
    "sale_display_order": "string",
    "sale_name": "string",
    "sale_option": "string",
    "site_limit": "string",
    "site_limit_amount": "string",
    "site_limit_discount_amount": "string",
    "site_limit_gl_account_id": "string",
    "site_limit_gl_category_id": "string",
    "site_tablets": "string",
    "site_tablets_amount": "string",
    "site_tablets_discount_amount": "string",
    "site_tablets_gl_account_id": "string",
    "site_tablets_gl_category_id": "string",
    "software": "string",
    "storage_limit": "string",
    "storage_limit_amount": "string",
    "storage_limit_discount_amount": "string",
    "storage_limit_gl_account_id": "string",
    "storage_limit_gl_category_id": "string",
    "tax_free": "string",
    "tenant": "string",
    "tv_users": "string",
    "tv_users_amount": "string",
    "tv_users_discount_amount": "string",
    "tv_users_gl_account_id": "string",
    "tv_users_gl_category_id": "string",
    "type": "string"
}
    • schema_name_id: 2898
    • schema_scan_id: 6667909
    • updated: 2024-11-05 02:17:11
    • created: 2024-11-05 02:00:03
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooklicenses_templates`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooklicenses_templates`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `generate`  string , `group_id`  string , `name`  string , `sale_name`  string , `type`  string , `primary_license`  string , `sale_option`  string , `sale_description`  string , `sale_display_order`  string , `sale_contact_template_id`  string , `license_period`  string , `privileges`  string , `software`  string , `desktop_users`  string , `desktop_users_gl_category_id`  string , `desktop_users_gl_account_id`  string , `desktop_users_amount`  string , `desktop_users_discount_amount`  string , `mobile_users`  string , `mobile_users_gl_category_id`  string , `mobile_users_gl_account_id`  string , `mobile_users_amount`  string , `mobile_users_discount_amount`  string , `tv_users`  string , `tv_users_gl_category_id`  string , `tv_users_gl_account_id`  string , `tv_users_amount`  string , `tv_users_discount_amount`  string , `site_tablets`  string , `site_tablets_gl_category_id`  string , `site_tablets_gl_account_id`  string , `site_tablets_amount`  string , `site_tablets_discount_amount`  string , `site_limit`  string , `site_limit_gl_category_id`  string , `site_limit_gl_account_id`  string , `site_limit_amount`  string , `site_limit_discount_amount`  string , `kiosks_limit`  string , `kiosks_limit_gl_category_id`  string , `kiosks_limit_gl_account_id`  string , `kiosks_limit_amount`  string , `kiosks_limit_discount_amount`  string , `storage_limit`  string , `storage_limit_gl_category_id`  string , `storage_limit_gl_account_id`  string , `storage_limit_amount`  string , `storage_limit_discount_amount`  string , `inboxes_limit`  string , `license`  string , `license_gl_category_id`  string , `license_gl_account_id`  string , `license_amount`  string , `license_discount_amount`  string , `inboxes_limit_gl_category_id`  string , `inboxes_limit_gl_account_id`  string , `inboxes_limit_amount`  string , `inboxes_limit_discount_amount`  string , `tax_free`  string , `interval`  string , `interval_multiplier`  string , `active`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooklicenses_templates/2024-11-04/1730783676'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooklicenses_templates"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooklicenses_templates/2024-11-04/1730783676
    • id: 4742063
    • processed: 1
    • raw_data: 
      {
    "active": 64,
    "desktop_users": 16,
    "desktop_users_amount": 19,
    "desktop_users_discount_amount": 20,
    "desktop_users_gl_account_id": 18,
    "desktop_users_gl_category_id": 17,
    "generate": 3,
    "group_id": 4,
    "id": 2,
    "inboxes_limit": 51,
    "inboxes_limit_amount": 59,
    "inboxes_limit_discount_amount": 60,
    "inboxes_limit_gl_account_id": 58,
    "inboxes_limit_gl_category_id": 57,
    "interval": 62,
    "interval_multiplier": 63,
    "kiosks_limit": 41,
    "kiosks_limit_amount": 44,
    "kiosks_limit_discount_amount": 45,
    "kiosks_limit_gl_account_id": 43,
    "kiosks_limit_gl_category_id": 42,
    "license": 52,
    "license_amount": 55,
    "license_discount_amount": 56,
    "license_gl_account_id": 54,
    "license_gl_category_id": 53,
    "license_period": 13,
    "mobile_users": 21,
    "mobile_users_amount": 24,
    "mobile_users_discount_amount": 25,
    "mobile_users_gl_account_id": 23,
    "mobile_users_gl_category_id": 22,
    "name": 5,
    "newbook_region": 0,
    "primary_license": 8,
    "privileges": 14,
    "sale_contact_template_id": 12,
    "sale_description": 10,
    "sale_display_order": 11,
    "sale_name": 6,
    "sale_option": 9,
    "site_limit": 36,
    "site_limit_amount": 39,
    "site_limit_discount_amount": 40,
    "site_limit_gl_account_id": 38,
    "site_limit_gl_category_id": 37,
    "site_tablets": 31,
    "site_tablets_amount": 34,
    "site_tablets_discount_amount": 35,
    "site_tablets_gl_account_id": 33,
    "site_tablets_gl_category_id": 32,
    "software": 15,
    "storage_limit": 46,
    "storage_limit_amount": 49,
    "storage_limit_discount_amount": 50,
    "storage_limit_gl_account_id": 48,
    "storage_limit_gl_category_id": 47,
    "tax_free": 61,
    "tenant": 1,
    "tv_users": 26,
    "tv_users_amount": 29,
    "tv_users_discount_amount": 30,
    "tv_users_gl_account_id": 28,
    "tv_users_gl_category_id": 27,
    "type": 7
}
    • schema_attributes: 
      {
    "active": "string",
    "desktop_users": "string",
    "desktop_users_amount": "string",
    "desktop_users_discount_amount": "string",
    "desktop_users_gl_account_id": "string",
    "desktop_users_gl_category_id": "string",
    "generate": "string",
    "group_id": "string",
    "id": "string",
    "inboxes_limit": "string",
    "inboxes_limit_amount": "string",
    "inboxes_limit_discount_amount": "string",
    "inboxes_limit_gl_account_id": "string",
    "inboxes_limit_gl_category_id": "string",
    "interval": "string",
    "interval_multiplier": "string",
    "kiosks_limit": "string",
    "kiosks_limit_amount": "string",
    "kiosks_limit_discount_amount": "string",
    "kiosks_limit_gl_account_id": "string",
    "kiosks_limit_gl_category_id": "string",
    "license": "string",
    "license_amount": "string",
    "license_discount_amount": "string",
    "license_gl_account_id": "string",
    "license_gl_category_id": "string",
    "license_period": "string",
    "mobile_users": "string",
    "mobile_users_amount": "string",
    "mobile_users_discount_amount": "string",
    "mobile_users_gl_account_id": "string",
    "mobile_users_gl_category_id": "string",
    "name": "string",
    "newbook_region": "string",
    "primary_license": "string",
    "privileges": "string",
    "sale_contact_template_id": "string",
    "sale_description": "string",
    "sale_display_order": "string",
    "sale_name": "string",
    "sale_option": "string",
    "site_limit": "string",
    "site_limit_amount": "string",
    "site_limit_discount_amount": "string",
    "site_limit_gl_account_id": "string",
    "site_limit_gl_category_id": "string",
    "site_tablets": "string",
    "site_tablets_amount": "string",
    "site_tablets_discount_amount": "string",
    "site_tablets_gl_account_id": "string",
    "site_tablets_gl_category_id": "string",
    "software": "string",
    "storage_limit": "string",
    "storage_limit_amount": "string",
    "storage_limit_discount_amount": "string",
    "storage_limit_gl_account_id": "string",
    "storage_limit_gl_category_id": "string",
    "tax_free": "string",
    "tenant": "string",
    "tv_users": "string",
    "tv_users_amount": "string",
    "tv_users_discount_amount": "string",
    "tv_users_gl_account_id": "string",
    "tv_users_gl_category_id": "string",
    "type": "string"
}
    • schema_name_id: 2898
    • schema_scan_id: 6667278
    • updated: 2024-11-05 02:00:17
    • created: 2024-11-05 01:36:11
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooklicenses_templates`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooklicenses_templates`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `generate`  string , `group_id`  string , `name`  string , `sale_name`  string , `type`  string , `primary_license`  string , `sale_option`  string , `sale_description`  string , `sale_display_order`  string , `sale_contact_template_id`  string , `license_period`  string , `privileges`  string , `software`  string , `desktop_users`  string , `desktop_users_gl_category_id`  string , `desktop_users_gl_account_id`  string , `desktop_users_amount`  string , `desktop_users_discount_amount`  string , `mobile_users`  string , `mobile_users_gl_category_id`  string , `mobile_users_gl_account_id`  string , `mobile_users_amount`  string , `mobile_users_discount_amount`  string , `tv_users`  string , `tv_users_gl_category_id`  string , `tv_users_gl_account_id`  string , `tv_users_amount`  string , `tv_users_discount_amount`  string , `site_tablets`  string , `site_tablets_gl_category_id`  string , `site_tablets_gl_account_id`  string , `site_tablets_amount`  string , `site_tablets_discount_amount`  string , `site_limit`  string , `site_limit_gl_category_id`  string , `site_limit_gl_account_id`  string , `site_limit_amount`  string , `site_limit_discount_amount`  string , `kiosks_limit`  string , `kiosks_limit_gl_category_id`  string , `kiosks_limit_gl_account_id`  string , `kiosks_limit_amount`  string , `kiosks_limit_discount_amount`  string , `storage_limit`  string , `storage_limit_gl_category_id`  string , `storage_limit_gl_account_id`  string , `storage_limit_amount`  string , `storage_limit_discount_amount`  string , `inboxes_limit`  string , `license`  string , `license_gl_category_id`  string , `license_gl_account_id`  string , `license_amount`  string , `license_discount_amount`  string , `inboxes_limit_gl_category_id`  string , `inboxes_limit_gl_account_id`  string , `inboxes_limit_amount`  string , `inboxes_limit_discount_amount`  string , `tax_free`  string , `interval`  string , `interval_multiplier`  string , `active`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooklicenses_templates/2024-11-04/1730783538'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooklicenses_templates"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooklicenses_templates/2024-11-04/1730783538
    • id: 4741154
    • processed: 1
    • raw_data: 
      {
    "active": 64,
    "desktop_users": 16,
    "desktop_users_amount": 19,
    "desktop_users_discount_amount": 20,
    "desktop_users_gl_account_id": 18,
    "desktop_users_gl_category_id": 17,
    "generate": 3,
    "group_id": 4,
    "id": 2,
    "inboxes_limit": 51,
    "inboxes_limit_amount": 59,
    "inboxes_limit_discount_amount": 60,
    "inboxes_limit_gl_account_id": 58,
    "inboxes_limit_gl_category_id": 57,
    "interval": 62,
    "interval_multiplier": 63,
    "kiosks_limit": 41,
    "kiosks_limit_amount": 44,
    "kiosks_limit_discount_amount": 45,
    "kiosks_limit_gl_account_id": 43,
    "kiosks_limit_gl_category_id": 42,
    "license": 52,
    "license_amount": 55,
    "license_discount_amount": 56,
    "license_gl_account_id": 54,
    "license_gl_category_id": 53,
    "license_period": 13,
    "mobile_users": 21,
    "mobile_users_amount": 24,
    "mobile_users_discount_amount": 25,
    "mobile_users_gl_account_id": 23,
    "mobile_users_gl_category_id": 22,
    "name": 5,
    "newbook_region": 0,
    "primary_license": 8,
    "privileges": 14,
    "sale_contact_template_id": 12,
    "sale_description": 10,
    "sale_display_order": 11,
    "sale_name": 6,
    "sale_option": 9,
    "site_limit": 36,
    "site_limit_amount": 39,
    "site_limit_discount_amount": 40,
    "site_limit_gl_account_id": 38,
    "site_limit_gl_category_id": 37,
    "site_tablets": 31,
    "site_tablets_amount": 34,
    "site_tablets_discount_amount": 35,
    "site_tablets_gl_account_id": 33,
    "site_tablets_gl_category_id": 32,
    "software": 15,
    "storage_limit": 46,
    "storage_limit_amount": 49,
    "storage_limit_discount_amount": 50,
    "storage_limit_gl_account_id": 48,
    "storage_limit_gl_category_id": 47,
    "tax_free": 61,
    "tenant": 1,
    "tv_users": 26,
    "tv_users_amount": 29,
    "tv_users_discount_amount": 30,
    "tv_users_gl_account_id": 28,
    "tv_users_gl_category_id": 27,
    "type": 7
}
    • schema_attributes: 
      {
    "active": "string",
    "desktop_users": "string",
    "desktop_users_amount": "string",
    "desktop_users_discount_amount": "string",
    "desktop_users_gl_account_id": "string",
    "desktop_users_gl_category_id": "string",
    "generate": "string",
    "group_id": "string",
    "id": "string",
    "inboxes_limit": "string",
    "inboxes_limit_amount": "string",
    "inboxes_limit_discount_amount": "string",
    "inboxes_limit_gl_account_id": "string",
    "inboxes_limit_gl_category_id": "string",
    "interval": "string",
    "interval_multiplier": "string",
    "kiosks_limit": "string",
    "kiosks_limit_amount": "string",
    "kiosks_limit_discount_amount": "string",
    "kiosks_limit_gl_account_id": "string",
    "kiosks_limit_gl_category_id": "string",
    "license": "string",
    "license_amount": "string",
    "license_discount_amount": "string",
    "license_gl_account_id": "string",
    "license_gl_category_id": "string",
    "license_period": "string",
    "mobile_users": "string",
    "mobile_users_amount": "string",
    "mobile_users_discount_amount": "string",
    "mobile_users_gl_account_id": "string",
    "mobile_users_gl_category_id": "string",
    "name": "string",
    "newbook_region": "string",
    "primary_license": "string",
    "privileges": "string",
    "sale_contact_template_id": "string",
    "sale_description": "string",
    "sale_display_order": "string",
    "sale_name": "string",
    "sale_option": "string",
    "site_limit": "string",
    "site_limit_amount": "string",
    "site_limit_discount_amount": "string",
    "site_limit_gl_account_id": "string",
    "site_limit_gl_category_id": "string",
    "site_tablets": "string",
    "site_tablets_amount": "string",
    "site_tablets_discount_amount": "string",
    "site_tablets_gl_account_id": "string",
    "site_tablets_gl_category_id": "string",
    "software": "string",
    "storage_limit": "string",
    "storage_limit_amount": "string",
    "storage_limit_discount_amount": "string",
    "storage_limit_gl_account_id": "string",
    "storage_limit_gl_category_id": "string",
    "tax_free": "string",
    "tenant": "string",
    "tv_users": "string",
    "tv_users_amount": "string",
    "tv_users_discount_amount": "string",
    "tv_users_gl_account_id": "string",
    "tv_users_gl_category_id": "string",
    "type": "string"
}
    • schema_name_id: 2898
    • schema_scan_id: 6666369
    • updated: 2024-11-05 01:36:25
    • created: 2024-11-05 01:08:25
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooklicenses_templates`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooklicenses_templates`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `generate`  string , `group_id`  string , `name`  string , `sale_name`  string , `type`  string , `primary_license`  string , `sale_option`  string , `sale_description`  string , `sale_display_order`  string , `sale_contact_template_id`  string , `license_period`  string , `privileges`  string , `software`  string , `desktop_users`  string , `desktop_users_gl_category_id`  string , `desktop_users_gl_account_id`  string , `desktop_users_amount`  string , `desktop_users_discount_amount`  string , `mobile_users`  string , `mobile_users_gl_category_id`  string , `mobile_users_gl_account_id`  string , `mobile_users_amount`  string , `mobile_users_discount_amount`  string , `tv_users`  string , `tv_users_gl_category_id`  string , `tv_users_gl_account_id`  string , `tv_users_amount`  string , `tv_users_discount_amount`  string , `site_tablets`  string , `site_tablets_gl_category_id`  string , `site_tablets_gl_account_id`  string , `site_tablets_amount`  string , `site_tablets_discount_amount`  string , `site_limit`  string , `site_limit_gl_category_id`  string , `site_limit_gl_account_id`  string , `site_limit_amount`  string , `site_limit_discount_amount`  string , `kiosks_limit`  string , `kiosks_limit_gl_category_id`  string , `kiosks_limit_gl_account_id`  string , `kiosks_limit_amount`  string , `kiosks_limit_discount_amount`  string , `storage_limit`  string , `storage_limit_gl_category_id`  string , `storage_limit_gl_account_id`  string , `storage_limit_amount`  string , `storage_limit_discount_amount`  string , `inboxes_limit`  string , `license`  string , `license_gl_category_id`  string , `license_gl_account_id`  string , `license_amount`  string , `license_discount_amount`  string , `inboxes_limit_gl_category_id`  string , `inboxes_limit_gl_account_id`  string , `inboxes_limit_amount`  string , `inboxes_limit_discount_amount`  string , `tax_free`  string , `interval`  string , `interval_multiplier`  string , `active`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooklicenses_templates/2024-11-04/1730783320'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooklicenses_templates"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooklicenses_templates/2024-11-04/1730783320
    • id: 4740100
    • processed: 1
    • raw_data: 
      {
    "active": 64,
    "desktop_users": 16,
    "desktop_users_amount": 19,
    "desktop_users_discount_amount": 20,
    "desktop_users_gl_account_id": 18,
    "desktop_users_gl_category_id": 17,
    "generate": 3,
    "group_id": 4,
    "id": 2,
    "inboxes_limit": 51,
    "inboxes_limit_amount": 59,
    "inboxes_limit_discount_amount": 60,
    "inboxes_limit_gl_account_id": 58,
    "inboxes_limit_gl_category_id": 57,
    "interval": 62,
    "interval_multiplier": 63,
    "kiosks_limit": 41,
    "kiosks_limit_amount": 44,
    "kiosks_limit_discount_amount": 45,
    "kiosks_limit_gl_account_id": 43,
    "kiosks_limit_gl_category_id": 42,
    "license": 52,
    "license_amount": 55,
    "license_discount_amount": 56,
    "license_gl_account_id": 54,
    "license_gl_category_id": 53,
    "license_period": 13,
    "mobile_users": 21,
    "mobile_users_amount": 24,
    "mobile_users_discount_amount": 25,
    "mobile_users_gl_account_id": 23,
    "mobile_users_gl_category_id": 22,
    "name": 5,
    "newbook_region": 0,
    "primary_license": 8,
    "privileges": 14,
    "sale_contact_template_id": 12,
    "sale_description": 10,
    "sale_display_order": 11,
    "sale_name": 6,
    "sale_option": 9,
    "site_limit": 36,
    "site_limit_amount": 39,
    "site_limit_discount_amount": 40,
    "site_limit_gl_account_id": 38,
    "site_limit_gl_category_id": 37,
    "site_tablets": 31,
    "site_tablets_amount": 34,
    "site_tablets_discount_amount": 35,
    "site_tablets_gl_account_id": 33,
    "site_tablets_gl_category_id": 32,
    "software": 15,
    "storage_limit": 46,
    "storage_limit_amount": 49,
    "storage_limit_discount_amount": 50,
    "storage_limit_gl_account_id": 48,
    "storage_limit_gl_category_id": 47,
    "tax_free": 61,
    "tenant": 1,
    "tv_users": 26,
    "tv_users_amount": 29,
    "tv_users_discount_amount": 30,
    "tv_users_gl_account_id": 28,
    "tv_users_gl_category_id": 27,
    "type": 7
}
    • schema_attributes: 
      {
    "active": "string",
    "desktop_users": "string",
    "desktop_users_amount": "string",
    "desktop_users_discount_amount": "string",
    "desktop_users_gl_account_id": "string",
    "desktop_users_gl_category_id": "string",
    "generate": "string",
    "group_id": "string",
    "id": "string",
    "inboxes_limit": "string",
    "inboxes_limit_amount": "string",
    "inboxes_limit_discount_amount": "string",
    "inboxes_limit_gl_account_id": "string",
    "inboxes_limit_gl_category_id": "string",
    "interval": "string",
    "interval_multiplier": "string",
    "kiosks_limit": "string",
    "kiosks_limit_amount": "string",
    "kiosks_limit_discount_amount": "string",
    "kiosks_limit_gl_account_id": "string",
    "kiosks_limit_gl_category_id": "string",
    "license": "string",
    "license_amount": "string",
    "license_discount_amount": "string",
    "license_gl_account_id": "string",
    "license_gl_category_id": "string",
    "license_period": "string",
    "mobile_users": "string",
    "mobile_users_amount": "string",
    "mobile_users_discount_amount": "string",
    "mobile_users_gl_account_id": "string",
    "mobile_users_gl_category_id": "string",
    "name": "string",
    "newbook_region": "string",
    "primary_license": "string",
    "privileges": "string",
    "sale_contact_template_id": "string",
    "sale_description": "string",
    "sale_display_order": "string",
    "sale_name": "string",
    "sale_option": "string",
    "site_limit": "string",
    "site_limit_amount": "string",
    "site_limit_discount_amount": "string",
    "site_limit_gl_account_id": "string",
    "site_limit_gl_category_id": "string",
    "site_tablets": "string",
    "site_tablets_amount": "string",
    "site_tablets_discount_amount": "string",
    "site_tablets_gl_account_id": "string",
    "site_tablets_gl_category_id": "string",
    "software": "string",
    "storage_limit": "string",
    "storage_limit_amount": "string",
    "storage_limit_discount_amount": "string",
    "storage_limit_gl_account_id": "string",
    "storage_limit_gl_category_id": "string",
    "tax_free": "string",
    "tenant": "string",
    "tv_users": "string",
    "tv_users_amount": "string",
    "tv_users_discount_amount": "string",
    "tv_users_gl_account_id": "string",
    "tv_users_gl_category_id": "string",
    "type": "string"
}
    • schema_name_id: 2898
    • schema_scan_id: 6665317
    • updated: 2024-11-05 01:08:36
    • created: 2024-11-05 00:59:41
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooklicenses_templates`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooklicenses_templates`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `generate`  string , `group_id`  string , `name`  string , `sale_name`  string , `type`  string , `primary_license`  string , `sale_option`  string , `sale_description`  string , `sale_display_order`  string , `sale_contact_template_id`  string , `license_period`  string , `privileges`  string , `software`  string , `desktop_users`  string , `desktop_users_gl_category_id`  string , `desktop_users_gl_account_id`  string , `desktop_users_amount`  string , `desktop_users_discount_amount`  string , `mobile_users`  string , `mobile_users_gl_category_id`  string , `mobile_users_gl_account_id`  string , `mobile_users_amount`  string , `mobile_users_discount_amount`  string , `tv_users`  string , `tv_users_gl_category_id`  string , `tv_users_gl_account_id`  string , `tv_users_amount`  string , `tv_users_discount_amount`  string , `site_tablets`  string , `site_tablets_gl_category_id`  string , `site_tablets_gl_account_id`  string , `site_tablets_amount`  string , `site_tablets_discount_amount`  string , `site_limit`  string , `site_limit_gl_category_id`  string , `site_limit_gl_account_id`  string , `site_limit_amount`  string , `site_limit_discount_amount`  string , `kiosks_limit`  string , `kiosks_limit_gl_category_id`  string , `kiosks_limit_gl_account_id`  string , `kiosks_limit_amount`  string , `kiosks_limit_discount_amount`  string , `storage_limit`  string , `storage_limit_gl_category_id`  string , `storage_limit_gl_account_id`  string , `storage_limit_amount`  string , `storage_limit_discount_amount`  string , `inboxes_limit`  string , `license`  string , `license_gl_category_id`  string , `license_gl_account_id`  string , `license_amount`  string , `license_discount_amount`  string , `inboxes_limit_gl_category_id`  string , `inboxes_limit_gl_account_id`  string , `inboxes_limit_amount`  string , `inboxes_limit_discount_amount`  string , `tax_free`  string , `interval`  string , `interval_multiplier`  string , `active`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooklicenses_templates/2024-11-04/1730782920'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooklicenses_templates"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooklicenses_templates/2024-11-04/1730782920
    • id: 4739780
    • processed: 1
    • raw_data: 
      {
    "active": 64,
    "desktop_users": 16,
    "desktop_users_amount": 19,
    "desktop_users_discount_amount": 20,
    "desktop_users_gl_account_id": 18,
    "desktop_users_gl_category_id": 17,
    "generate": 3,
    "group_id": 4,
    "id": 2,
    "inboxes_limit": 51,
    "inboxes_limit_amount": 59,
    "inboxes_limit_discount_amount": 60,
    "inboxes_limit_gl_account_id": 58,
    "inboxes_limit_gl_category_id": 57,
    "interval": 62,
    "interval_multiplier": 63,
    "kiosks_limit": 41,
    "kiosks_limit_amount": 44,
    "kiosks_limit_discount_amount": 45,
    "kiosks_limit_gl_account_id": 43,
    "kiosks_limit_gl_category_id": 42,
    "license": 52,
    "license_amount": 55,
    "license_discount_amount": 56,
    "license_gl_account_id": 54,
    "license_gl_category_id": 53,
    "license_period": 13,
    "mobile_users": 21,
    "mobile_users_amount": 24,
    "mobile_users_discount_amount": 25,
    "mobile_users_gl_account_id": 23,
    "mobile_users_gl_category_id": 22,
    "name": 5,
    "newbook_region": 0,
    "primary_license": 8,
    "privileges": 14,
    "sale_contact_template_id": 12,
    "sale_description": 10,
    "sale_display_order": 11,
    "sale_name": 6,
    "sale_option": 9,
    "site_limit": 36,
    "site_limit_amount": 39,
    "site_limit_discount_amount": 40,
    "site_limit_gl_account_id": 38,
    "site_limit_gl_category_id": 37,
    "site_tablets": 31,
    "site_tablets_amount": 34,
    "site_tablets_discount_amount": 35,
    "site_tablets_gl_account_id": 33,
    "site_tablets_gl_category_id": 32,
    "software": 15,
    "storage_limit": 46,
    "storage_limit_amount": 49,
    "storage_limit_discount_amount": 50,
    "storage_limit_gl_account_id": 48,
    "storage_limit_gl_category_id": 47,
    "tax_free": 61,
    "tenant": 1,
    "tv_users": 26,
    "tv_users_amount": 29,
    "tv_users_discount_amount": 30,
    "tv_users_gl_account_id": 28,
    "tv_users_gl_category_id": 27,
    "type": 7
}
    • schema_attributes: 
      {
    "active": "string",
    "desktop_users": "string",
    "desktop_users_amount": "string",
    "desktop_users_discount_amount": "string",
    "desktop_users_gl_account_id": "string",
    "desktop_users_gl_category_id": "string",
    "generate": "string",
    "group_id": "string",
    "id": "string",
    "inboxes_limit": "string",
    "inboxes_limit_amount": "string",
    "inboxes_limit_discount_amount": "string",
    "inboxes_limit_gl_account_id": "string",
    "inboxes_limit_gl_category_id": "string",
    "interval": "string",
    "interval_multiplier": "string",
    "kiosks_limit": "string",
    "kiosks_limit_amount": "string",
    "kiosks_limit_discount_amount": "string",
    "kiosks_limit_gl_account_id": "string",
    "kiosks_limit_gl_category_id": "string",
    "license": "string",
    "license_amount": "string",
    "license_discount_amount": "string",
    "license_gl_account_id": "string",
    "license_gl_category_id": "string",
    "license_period": "string",
    "mobile_users": "string",
    "mobile_users_amount": "string",
    "mobile_users_discount_amount": "string",
    "mobile_users_gl_account_id": "string",
    "mobile_users_gl_category_id": "string",
    "name": "string",
    "newbook_region": "string",
    "primary_license": "string",
    "privileges": "string",
    "sale_contact_template_id": "string",
    "sale_description": "string",
    "sale_display_order": "string",
    "sale_name": "string",
    "sale_option": "string",
    "site_limit": "string",
    "site_limit_amount": "string",
    "site_limit_discount_amount": "string",
    "site_limit_gl_account_id": "string",
    "site_limit_gl_category_id": "string",
    "site_tablets": "string",
    "site_tablets_amount": "string",
    "site_tablets_discount_amount": "string",
    "site_tablets_gl_account_id": "string",
    "site_tablets_gl_category_id": "string",
    "software": "string",
    "storage_limit": "string",
    "storage_limit_amount": "string",
    "storage_limit_discount_amount": "string",
    "storage_limit_gl_account_id": "string",
    "storage_limit_gl_category_id": "string",
    "tax_free": "string",
    "tenant": "string",
    "tv_users": "string",
    "tv_users_amount": "string",
    "tv_users_discount_amount": "string",
    "tv_users_gl_account_id": "string",
    "tv_users_gl_category_id": "string",
    "type": "string"
}
    • schema_name_id: 2898
    • schema_scan_id: 6664997
    • updated: 2024-11-05 00:59:54
    • created: 2024-11-05 00:36:27
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooklicenses_templates`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooklicenses_templates`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `generate`  string , `group_id`  string , `name`  string , `sale_name`  string , `type`  string , `primary_license`  string , `sale_option`  string , `sale_description`  string , `sale_display_order`  string , `sale_contact_template_id`  string , `license_period`  string , `privileges`  string , `software`  string , `desktop_users`  string , `desktop_users_gl_category_id`  string , `desktop_users_gl_account_id`  string , `desktop_users_amount`  string , `desktop_users_discount_amount`  string , `mobile_users`  string , `mobile_users_gl_category_id`  string , `mobile_users_gl_account_id`  string , `mobile_users_amount`  string , `mobile_users_discount_amount`  string , `tv_users`  string , `tv_users_gl_category_id`  string , `tv_users_gl_account_id`  string , `tv_users_amount`  string , `tv_users_discount_amount`  string , `site_tablets`  string , `site_tablets_gl_category_id`  string , `site_tablets_gl_account_id`  string , `site_tablets_amount`  string , `site_tablets_discount_amount`  string , `site_limit`  string , `site_limit_gl_category_id`  string , `site_limit_gl_account_id`  string , `site_limit_amount`  string , `site_limit_discount_amount`  string , `kiosks_limit`  string , `kiosks_limit_gl_category_id`  string , `kiosks_limit_gl_account_id`  string , `kiosks_limit_amount`  string , `kiosks_limit_discount_amount`  string , `storage_limit`  string , `storage_limit_gl_category_id`  string , `storage_limit_gl_account_id`  string , `storage_limit_amount`  string , `storage_limit_discount_amount`  string , `inboxes_limit`  string , `license`  string , `license_gl_category_id`  string , `license_gl_account_id`  string , `license_amount`  string , `license_discount_amount`  string , `inboxes_limit_gl_category_id`  string , `inboxes_limit_gl_account_id`  string , `inboxes_limit_amount`  string , `inboxes_limit_discount_amount`  string , `tax_free`  string , `interval`  string , `interval_multiplier`  string , `active`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooklicenses_templates/2024-11-04/1730782816'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooklicenses_templates"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooklicenses_templates/2024-11-04/1730782816
    • id: 4738896
    • processed: 1
    • raw_data: 
      {
    "active": 64,
    "desktop_users": 16,
    "desktop_users_amount": 19,
    "desktop_users_discount_amount": 20,
    "desktop_users_gl_account_id": 18,
    "desktop_users_gl_category_id": 17,
    "generate": 3,
    "group_id": 4,
    "id": 2,
    "inboxes_limit": 51,
    "inboxes_limit_amount": 59,
    "inboxes_limit_discount_amount": 60,
    "inboxes_limit_gl_account_id": 58,
    "inboxes_limit_gl_category_id": 57,
    "interval": 62,
    "interval_multiplier": 63,
    "kiosks_limit": 41,
    "kiosks_limit_amount": 44,
    "kiosks_limit_discount_amount": 45,
    "kiosks_limit_gl_account_id": 43,
    "kiosks_limit_gl_category_id": 42,
    "license": 52,
    "license_amount": 55,
    "license_discount_amount": 56,
    "license_gl_account_id": 54,
    "license_gl_category_id": 53,
    "license_period": 13,
    "mobile_users": 21,
    "mobile_users_amount": 24,
    "mobile_users_discount_amount": 25,
    "mobile_users_gl_account_id": 23,
    "mobile_users_gl_category_id": 22,
    "name": 5,
    "newbook_region": 0,
    "primary_license": 8,
    "privileges": 14,
    "sale_contact_template_id": 12,
    "sale_description": 10,
    "sale_display_order": 11,
    "sale_name": 6,
    "sale_option": 9,
    "site_limit": 36,
    "site_limit_amount": 39,
    "site_limit_discount_amount": 40,
    "site_limit_gl_account_id": 38,
    "site_limit_gl_category_id": 37,
    "site_tablets": 31,
    "site_tablets_amount": 34,
    "site_tablets_discount_amount": 35,
    "site_tablets_gl_account_id": 33,
    "site_tablets_gl_category_id": 32,
    "software": 15,
    "storage_limit": 46,
    "storage_limit_amount": 49,
    "storage_limit_discount_amount": 50,
    "storage_limit_gl_account_id": 48,
    "storage_limit_gl_category_id": 47,
    "tax_free": 61,
    "tenant": 1,
    "tv_users": 26,
    "tv_users_amount": 29,
    "tv_users_discount_amount": 30,
    "tv_users_gl_account_id": 28,
    "tv_users_gl_category_id": 27,
    "type": 7
}
    • schema_attributes: 
      {
    "active": "string",
    "desktop_users": "string",
    "desktop_users_amount": "string",
    "desktop_users_discount_amount": "string",
    "desktop_users_gl_account_id": "string",
    "desktop_users_gl_category_id": "string",
    "generate": "string",
    "group_id": "string",
    "id": "string",
    "inboxes_limit": "string",
    "inboxes_limit_amount": "string",
    "inboxes_limit_discount_amount": "string",
    "inboxes_limit_gl_account_id": "string",
    "inboxes_limit_gl_category_id": "string",
    "interval": "string",
    "interval_multiplier": "string",
    "kiosks_limit": "string",
    "kiosks_limit_amount": "string",
    "kiosks_limit_discount_amount": "string",
    "kiosks_limit_gl_account_id": "string",
    "kiosks_limit_gl_category_id": "string",
    "license": "string",
    "license_amount": "string",
    "license_discount_amount": "string",
    "license_gl_account_id": "string",
    "license_gl_category_id": "string",
    "license_period": "string",
    "mobile_users": "string",
    "mobile_users_amount": "string",
    "mobile_users_discount_amount": "string",
    "mobile_users_gl_account_id": "string",
    "mobile_users_gl_category_id": "string",
    "name": "string",
    "newbook_region": "string",
    "primary_license": "string",
    "privileges": "string",
    "sale_contact_template_id": "string",
    "sale_description": "string",
    "sale_display_order": "string",
    "sale_name": "string",
    "sale_option": "string",
    "site_limit": "string",
    "site_limit_amount": "string",
    "site_limit_discount_amount": "string",
    "site_limit_gl_account_id": "string",
    "site_limit_gl_category_id": "string",
    "site_tablets": "string",
    "site_tablets_amount": "string",
    "site_tablets_discount_amount": "string",
    "site_tablets_gl_account_id": "string",
    "site_tablets_gl_category_id": "string",
    "software": "string",
    "storage_limit": "string",
    "storage_limit_amount": "string",
    "storage_limit_discount_amount": "string",
    "storage_limit_gl_account_id": "string",
    "storage_limit_gl_category_id": "string",
    "tax_free": "string",
    "tenant": "string",
    "tv_users": "string",
    "tv_users_amount": "string",
    "tv_users_discount_amount": "string",
    "tv_users_gl_account_id": "string",
    "tv_users_gl_category_id": "string",
    "type": "string"
}
    • schema_name_id: 2898
    • schema_scan_id: 6664107
    • updated: 2024-11-05 00:36:38
Schema Scans: 15
Last at 2024-11-05 23:11:37
    • duration: 0:00:13.174105
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6675003
    • 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_newbooklicenses_templates/2024-11-05/1730866541",
        "key": "raw/newbookdev_newbooklicenses_templates/2024-11-05/1730866541/licenses_templates.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooklicenses_templates",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16344307630514257992,
        "service_name": "drive-thru",
        "span_id": 2248147896216270622,
        "trace_id": 16415024366669481526
    }
}
    • running: False
    • schema_name_id: 2898
    • start_time: 2024-11-05 23:11:37
    • success: True
    • trace_id: 16415024366669481526
    • duration: 0:00:13.340375
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6674748
    • 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_newbooklicenses_templates/2024-11-05/1730866479",
        "key": "raw/newbookdev_newbooklicenses_templates/2024-11-05/1730866479/licenses_templates.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooklicenses_templates",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8347124374797735972,
        "service_name": "drive-thru",
        "span_id": 17085699076669967024,
        "trace_id": 15460151787218183019
    }
}
    • running: False
    • schema_name_id: 2898
    • start_time: 2024-11-05 22:57:48
    • success: True
    • trace_id: 15460151787218183019
    • duration: 0:00:13.009453
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6673853
    • 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_newbooklicenses_templates/2024-11-05/1730866345",
        "key": "raw/newbookdev_newbooklicenses_templates/2024-11-05/1730866345/licenses_templates.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooklicenses_templates",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14157625780163239228,
        "service_name": "drive-thru",
        "span_id": 3274023009931376394,
        "trace_id": 15541365192881557020
    }
}
    • running: False
    • schema_name_id: 2898
    • start_time: 2024-11-05 22:26:53
    • success: True
    • trace_id: 15541365192881557020
    • duration: 0:00:15.773995
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6672241
    • 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_newbooklicenses_templates/2024-11-04/1730785748",
        "key": "raw/newbookdev_newbooklicenses_templates/2024-11-04/1730785748/licenses_templates.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooklicenses_templates",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6314849061873779850,
        "service_name": "drive-thru",
        "span_id": 16673198732191341948,
        "trace_id": 5377848718008038977
    }
}
    • running: False
    • schema_name_id: 2898
    • start_time: 2024-11-05 04:40:41
    • success: True
    • trace_id: 5377848718008038977
    • duration: 0:00:15.876790
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6671450
    • 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_newbooklicenses_templates/2024-11-04/1730785139",
        "key": "raw/newbookdev_newbooklicenses_templates/2024-11-04/1730785139/licenses_templates.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooklicenses_templates",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12906141943801351180,
        "service_name": "drive-thru",
        "span_id": 10063217765095064236,
        "trace_id": 14866184788496291893
    }
}
    • running: False
    • schema_name_id: 2898
    • start_time: 2024-11-05 03:54:04
    • success: True
    • trace_id: 14866184788496291893
    • duration: 0:00:15.474238
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6670756
    • 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_newbooklicenses_templates/2024-11-04/1730784834",
        "key": "raw/newbookdev_newbooklicenses_templates/2024-11-04/1730784834/licenses_templates.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooklicenses_templates",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8271599206366868730,
        "service_name": "drive-thru",
        "span_id": 15405516229147143175,
        "trace_id": 17291263966566663579
    }
}
    • running: False
    • schema_name_id: 2898
    • start_time: 2024-11-05 03:32:06
    • success: True
    • trace_id: 17291263966566663579
    • duration: 0:00:12.986497
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6670221
    • 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_newbooklicenses_templates/2024-11-04/1730784230",
        "key": "raw/newbookdev_newbooklicenses_templates/2024-11-04/1730784230/licenses_templates.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooklicenses_templates",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6970231460952455601,
        "service_name": "drive-thru",
        "span_id": 17330768576286376580,
        "trace_id": 8138630133618161896
    }
}
    • running: False
    • schema_name_id: 2898
    • start_time: 2024-11-05 03:18:05
    • success: True
    • trace_id: 8138630133618161896
    • duration: 0:00:15.470686
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6668726
    • 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_newbooklicenses_templates/2024-11-04/1730784068",
        "key": "raw/newbookdev_newbooklicenses_templates/2024-11-04/1730784068/licenses_templates.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooklicenses_templates",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3066797908062631878,
        "service_name": "drive-thru",
        "span_id": 15943794663749119310,
        "trace_id": 12751489797432719996
    }
}
    • running: False
    • schema_name_id: 2898
    • start_time: 2024-11-05 02:38:29
    • success: True
    • trace_id: 12751489797432719996
    • duration: 0:00:12.946247
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6668352
    • 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_newbooklicenses_templates/2024-11-04/1730783847",
        "key": "raw/newbookdev_newbooklicenses_templates/2024-11-04/1730783847/licenses_templates.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooklicenses_templates",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9643337685631407227,
        "service_name": "drive-thru",
        "span_id": 6064948871178631480,
        "trace_id": 12953928467361816474
    }
}
    • running: False
    • schema_name_id: 2898
    • start_time: 2024-11-05 02:28:33
    • success: True
    • trace_id: 12953928467361816474
    • duration: 0:00:13.359442
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6667909
    • 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_newbooklicenses_templates/2024-11-04/1730783782",
        "key": "raw/newbookdev_newbooklicenses_templates/2024-11-04/1730783782/licenses_templates.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooklicenses_templates",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14088430573890630300,
        "service_name": "drive-thru",
        "span_id": 14893143964595639317,
        "trace_id": 136882675979990770
    }
}
    • running: False
    • schema_name_id: 2898
    • start_time: 2024-11-05 02:16:57
    • success: True
    • trace_id: 136882675979990770
    • duration: 0:00:17.344471
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6667278
    • 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_newbooklicenses_templates/2024-11-04/1730783676",
        "key": "raw/newbookdev_newbooklicenses_templates/2024-11-04/1730783676/licenses_templates.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooklicenses_templates",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17293358405578735400,
        "service_name": "drive-thru",
        "span_id": 18161243990509500365,
        "trace_id": 4476476910914269478
    }
}
    • running: False
    • schema_name_id: 2898
    • start_time: 2024-11-05 01:59:59
    • success: True
    • trace_id: 4476476910914269478
    • duration: 0:00:15.535604
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6666369
    • 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_newbooklicenses_templates/2024-11-04/1730783538",
        "key": "raw/newbookdev_newbooklicenses_templates/2024-11-04/1730783538/licenses_templates.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooklicenses_templates",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12234513679533766468,
        "service_name": "drive-thru",
        "span_id": 12092487656797957814,
        "trace_id": 13914486362359978207
    }
}
    • running: False
    • schema_name_id: 2898
    • start_time: 2024-11-05 01:36:09
    • success: True
    • trace_id: 13914486362359978207
    • duration: 0:00:12.923066
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6665317
    • 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_newbooklicenses_templates/2024-11-04/1730783320",
        "key": "raw/newbookdev_newbooklicenses_templates/2024-11-04/1730783320/licenses_templates.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooklicenses_templates",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3440220890596313226,
        "service_name": "drive-thru",
        "span_id": 3744864893173041288,
        "trace_id": 2076253572135072948
    }
}
    • running: False
    • schema_name_id: 2898
    • start_time: 2024-11-05 01:08:23
    • success: True
    • trace_id: 2076253572135072948
    • duration: 0:00:15.560116
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6664997
    • 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_newbooklicenses_templates/2024-11-04/1730782920",
        "key": "raw/newbookdev_newbooklicenses_templates/2024-11-04/1730782920/licenses_templates.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooklicenses_templates",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10805246020360999874,
        "service_name": "drive-thru",
        "span_id": 12404567217238122933,
        "trace_id": 14247506677210698172
    }
}
    • running: False
    • schema_name_id: 2898
    • start_time: 2024-11-05 00:59:39
    • success: True
    • trace_id: 14247506677210698172
    • duration: 0:00:13.014313
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6664107
    • 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_newbooklicenses_templates/2024-11-04/1730782816",
        "key": "raw/newbookdev_newbooklicenses_templates/2024-11-04/1730782816/licenses_templates.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooklicenses_templates",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4127175483723731368,
        "service_name": "drive-thru",
        "span_id": 11116101165167176123,
        "trace_id": 13791116098075437455
    }
}
    • running: False
    • schema_name_id: 2898
    • start_time: 2024-11-05 00:36:25
    • success: True
    • trace_id: 13791116098075437455
Partitions:
  • count: 0
  • ddl: None
  • name: None
  • state: 
    []
  • type: None
Schema:
  • attributes: 
    {
    "active": "string",
    "desktop_users": "string",
    "desktop_users_amount": "string",
    "desktop_users_discount_amount": "string",
    "desktop_users_gl_account_id": "string",
    "desktop_users_gl_category_id": "string",
    "generate": "string",
    "group_id": "string",
    "id": "string",
    "inboxes_limit": "string",
    "inboxes_limit_amount": "string",
    "inboxes_limit_discount_amount": "string",
    "inboxes_limit_gl_account_id": "string",
    "inboxes_limit_gl_category_id": "string",
    "interval": "string",
    "interval_multiplier": "string",
    "kiosks_limit": "string",
    "kiosks_limit_amount": "string",
    "kiosks_limit_discount_amount": "string",
    "kiosks_limit_gl_account_id": "string",
    "kiosks_limit_gl_category_id": "string",
    "license": "string",
    "license_amount": "string",
    "license_discount_amount": "string",
    "license_gl_account_id": "string",
    "license_gl_category_id": "string",
    "license_period": "string",
    "mobile_users": "string",
    "mobile_users_amount": "string",
    "mobile_users_discount_amount": "string",
    "mobile_users_gl_account_id": "string",
    "mobile_users_gl_category_id": "string",
    "name": "string",
    "newbook_region": "string",
    "primary_license": "string",
    "privileges": "string",
    "sale_contact_template_id": "string",
    "sale_description": "string",
    "sale_display_order": "string",
    "sale_name": "string",
    "sale_option": "string",
    "site_limit": "string",
    "site_limit_amount": "string",
    "site_limit_discount_amount": "string",
    "site_limit_gl_account_id": "string",
    "site_limit_gl_category_id": "string",
    "site_tablets": "string",
    "site_tablets_amount": "string",
    "site_tablets_discount_amount": "string",
    "site_tablets_gl_account_id": "string",
    "site_tablets_gl_category_id": "string",
    "software": "string",
    "storage_limit": "string",
    "storage_limit_amount": "string",
    "storage_limit_discount_amount": "string",
    "storage_limit_gl_account_id": "string",
    "storage_limit_gl_category_id": "string",
    "tax_free": "string",
    "tenant": "string",
    "tv_users": "string",
    "tv_users_amount": "string",
    "tv_users_discount_amount": "string",
    "tv_users_gl_account_id": "string",
    "tv_users_gl_category_id": "string",
    "type": "string"
}
  • created: 2024-11-05 23:11:39
  • ddl: 
    {
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooklicenses_templates`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `generate`  string , `group_id`  string , `name`  string , `sale_name`  string , `type`  string , `primary_license`  string , `sale_option`  string , `sale_description`  string , `sale_display_order`  string , `sale_contact_template_id`  string , `license_period`  string , `privileges`  string , `software`  string , `desktop_users`  string , `desktop_users_gl_category_id`  string , `desktop_users_gl_account_id`  string , `desktop_users_amount`  string , `desktop_users_discount_amount`  string , `mobile_users`  string , `mobile_users_gl_category_id`  string , `mobile_users_gl_account_id`  string , `mobile_users_amount`  string , `mobile_users_discount_amount`  string , `tv_users`  string , `tv_users_gl_category_id`  string , `tv_users_gl_account_id`  string , `tv_users_amount`  string , `tv_users_discount_amount`  string , `site_tablets`  string , `site_tablets_gl_category_id`  string , `site_tablets_gl_account_id`  string , `site_tablets_amount`  string , `site_tablets_discount_amount`  string , `site_limit`  string , `site_limit_gl_category_id`  string , `site_limit_gl_account_id`  string , `site_limit_amount`  string , `site_limit_discount_amount`  string , `kiosks_limit`  string , `kiosks_limit_gl_category_id`  string , `kiosks_limit_gl_account_id`  string , `kiosks_limit_amount`  string , `kiosks_limit_discount_amount`  string , `storage_limit`  string , `storage_limit_gl_category_id`  string , `storage_limit_gl_account_id`  string , `storage_limit_amount`  string , `storage_limit_discount_amount`  string , `inboxes_limit`  string , `license`  string , `license_gl_category_id`  string , `license_gl_account_id`  string , `license_amount`  string , `license_discount_amount`  string , `inboxes_limit_gl_category_id`  string , `inboxes_limit_gl_account_id`  string , `inboxes_limit_amount`  string , `inboxes_limit_discount_amount`  string , `tax_free`  string , `interval`  string , `interval_multiplier`  string , `active`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooklicenses_templates/2024-11-05/1730866541'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooklicenses_templates`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooklicenses_templates"
}
Server:
  • hostname: schemamanager-5447774fc6-4w58v
  • name: schema_manager
  • process_start: 2026-04-02 21:43:44
  • sf_env: dev
  • version: 2427328685
Raw: 
{
    "name": {
        "created": "2024-10-08 18:18:19",
        "disabled": false,
        "format": "raw",
        "id": 2898,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_drivethru",
            "table": "newbookdev_newbooklicenses_templates"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "active": "string",
            "desktop_users": "string",
            "desktop_users_amount": "string",
            "desktop_users_discount_amount": "string",
            "desktop_users_gl_account_id": "string",
            "desktop_users_gl_category_id": "string",
            "generate": "string",
            "group_id": "string",
            "id": "string",
            "inboxes_limit": "string",
            "inboxes_limit_amount": "string",
            "inboxes_limit_discount_amount": "string",
            "inboxes_limit_gl_account_id": "string",
            "inboxes_limit_gl_category_id": "string",
            "interval": "string",
            "interval_multiplier": "string",
            "kiosks_limit": "string",
            "kiosks_limit_amount": "string",
            "kiosks_limit_discount_amount": "string",
            "kiosks_limit_gl_account_id": "string",
            "kiosks_limit_gl_category_id": "string",
            "license": "string",
            "license_amount": "string",
            "license_discount_amount": "string",
            "license_gl_account_id": "string",
            "license_gl_category_id": "string",
            "license_period": "string",
            "mobile_users": "string",
            "mobile_users_amount": "string",
            "mobile_users_discount_amount": "string",
            "mobile_users_gl_account_id": "string",
            "mobile_users_gl_category_id": "string",
            "name": "string",
            "newbook_region": "string",
            "primary_license": "string",
            "privileges": "string",
            "sale_contact_template_id": "string",
            "sale_description": "string",
            "sale_display_order": "string",
            "sale_name": "string",
            "sale_option": "string",
            "site_limit": "string",
            "site_limit_amount": "string",
            "site_limit_discount_amount": "string",
            "site_limit_gl_account_id": "string",
            "site_limit_gl_category_id": "string",
            "site_tablets": "string",
            "site_tablets_amount": "string",
            "site_tablets_discount_amount": "string",
            "site_tablets_gl_account_id": "string",
            "site_tablets_gl_category_id": "string",
            "software": "string",
            "storage_limit": "string",
            "storage_limit_amount": "string",
            "storage_limit_discount_amount": "string",
            "storage_limit_gl_account_id": "string",
            "storage_limit_gl_category_id": "string",
            "tax_free": "string",
            "tenant": "string",
            "tv_users": "string",
            "tv_users_amount": "string",
            "tv_users_discount_amount": "string",
            "tv_users_gl_account_id": "string",
            "tv_users_gl_category_id": "string",
            "type": "string"
        },
        "created": "2024-11-05 23:11:39",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooklicenses_templates`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `generate`  string , `group_id`  string , `name`  string , `sale_name`  string , `type`  string , `primary_license`  string , `sale_option`  string , `sale_description`  string , `sale_display_order`  string , `sale_contact_template_id`  string , `license_period`  string , `privileges`  string , `software`  string , `desktop_users`  string , `desktop_users_gl_category_id`  string , `desktop_users_gl_account_id`  string , `desktop_users_amount`  string , `desktop_users_discount_amount`  string , `mobile_users`  string , `mobile_users_gl_category_id`  string , `mobile_users_gl_account_id`  string , `mobile_users_amount`  string , `mobile_users_discount_amount`  string , `tv_users`  string , `tv_users_gl_category_id`  string , `tv_users_gl_account_id`  string , `tv_users_amount`  string , `tv_users_discount_amount`  string , `site_tablets`  string , `site_tablets_gl_category_id`  string , `site_tablets_gl_account_id`  string , `site_tablets_amount`  string , `site_tablets_discount_amount`  string , `site_limit`  string , `site_limit_gl_category_id`  string , `site_limit_gl_account_id`  string , `site_limit_amount`  string , `site_limit_discount_amount`  string , `kiosks_limit`  string , `kiosks_limit_gl_category_id`  string , `kiosks_limit_gl_account_id`  string , `kiosks_limit_amount`  string , `kiosks_limit_discount_amount`  string , `storage_limit`  string , `storage_limit_gl_category_id`  string , `storage_limit_gl_account_id`  string , `storage_limit_amount`  string , `storage_limit_discount_amount`  string , `inboxes_limit`  string , `license`  string , `license_gl_category_id`  string , `license_gl_account_id`  string , `license_amount`  string , `license_discount_amount`  string , `inboxes_limit_gl_category_id`  string , `inboxes_limit_gl_account_id`  string , `inboxes_limit_amount`  string , `inboxes_limit_discount_amount`  string , `tax_free`  string , `interval`  string , `interval_multiplier`  string , `active`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooklicenses_templates/2024-11-05/1730866541'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooklicenses_templates`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooklicenses_templates"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}
©2019 SpareFoot Data Platform