Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbooklicenses
  • created: 2024-10-08 18:02:14
  • disabled: False
  • format: raw
  • id: 2751
  • is_partitioned: False
  • is_schema_datatyped: True
  • name: 
    {
    "database": "sfdl_dev_drivethru",
    "table": "newbookdev_newbooklicenses"
}
  • type: drivethrucsv
Schema Versions: 15
    • created: 2024-11-05 23:10:28
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooklicenses`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooklicenses`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `template_id`  string , `generate`  string , `type`  string , `type_id`  string , `name`  string , `sale_name`  string , `primary_license`  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 , `grant_date`  string , `next_run`  string , `prorata_start`  string , `generated_when`  string , `generated_by`  string , `sold_by`  string , `cancelled_when`  string , `cancelled_by`  string , `cancelled_reason`  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/2024-11-05/1730866539'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooklicenses"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooklicenses/2024-11-05/1730866539
    • id: 4748949
    • processed: 1
    • raw_data: 
      {
    "cancelled_by": 67,
    "cancelled_reason": 68,
    "cancelled_when": 66,
    "desktop_users": 12,
    "desktop_users_amount": 15,
    "desktop_users_discount_amount": 16,
    "desktop_users_gl_account_id": 14,
    "desktop_users_gl_category_id": 13,
    "generate": 4,
    "generated_by": 64,
    "generated_when": 63,
    "grant_date": 60,
    "id": 2,
    "inboxes_limit": 47,
    "inboxes_limit_amount": 55,
    "inboxes_limit_discount_amount": 56,
    "inboxes_limit_gl_account_id": 54,
    "inboxes_limit_gl_category_id": 53,
    "interval": 58,
    "interval_multiplier": 59,
    "kiosks_limit": 37,
    "kiosks_limit_amount": 40,
    "kiosks_limit_discount_amount": 41,
    "kiosks_limit_gl_account_id": 39,
    "kiosks_limit_gl_category_id": 38,
    "license": 48,
    "license_amount": 51,
    "license_discount_amount": 52,
    "license_gl_account_id": 50,
    "license_gl_category_id": 49,
    "mobile_users": 17,
    "mobile_users_amount": 20,
    "mobile_users_discount_amount": 21,
    "mobile_users_gl_account_id": 19,
    "mobile_users_gl_category_id": 18,
    "name": 7,
    "newbook_region": 0,
    "next_run": 61,
    "primary_license": 9,
    "privileges": 10,
    "prorata_start": 62,
    "sale_name": 8,
    "site_limit": 32,
    "site_limit_amount": 35,
    "site_limit_discount_amount": 36,
    "site_limit_gl_account_id": 34,
    "site_limit_gl_category_id": 33,
    "site_tablets": 27,
    "site_tablets_amount": 30,
    "site_tablets_discount_amount": 31,
    "site_tablets_gl_account_id": 29,
    "site_tablets_gl_category_id": 28,
    "software": 11,
    "sold_by": 65,
    "storage_limit": 42,
    "storage_limit_amount": 45,
    "storage_limit_discount_amount": 46,
    "storage_limit_gl_account_id": 44,
    "storage_limit_gl_category_id": 43,
    "tax_free": 57,
    "template_id": 3,
    "tenant": 1,
    "tv_users": 22,
    "tv_users_amount": 25,
    "tv_users_discount_amount": 26,
    "tv_users_gl_account_id": 24,
    "tv_users_gl_category_id": 23,
    "type": 5,
    "type_id": 6
}
    • schema_attributes: 
      {
    "cancelled_by": "string",
    "cancelled_reason": "string",
    "cancelled_when": "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",
    "generated_by": "string",
    "generated_when": "string",
    "grant_date": "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",
    "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",
    "next_run": "string",
    "primary_license": "string",
    "privileges": "string",
    "prorata_start": "string",
    "sale_name": "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",
    "sold_by": "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",
    "template_id": "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",
    "type_id": "string"
}
    • schema_name_id: 2751
    • schema_scan_id: 6674981
    • updated: 2024-11-05 23:10:41
    • created: 2024-11-05 23:02:38
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooklicenses`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooklicenses`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `template_id`  string , `generate`  string , `type`  string , `type_id`  string , `name`  string , `sale_name`  string , `primary_license`  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 , `grant_date`  string , `next_run`  string , `prorata_start`  string , `generated_when`  string , `generated_by`  string , `sold_by`  string , `cancelled_when`  string , `cancelled_by`  string , `cancelled_reason`  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/2024-11-05/1730866477'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooklicenses"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooklicenses/2024-11-05/1730866477
    • id: 4748808
    • processed: 1
    • raw_data: 
      {
    "cancelled_by": 67,
    "cancelled_reason": 68,
    "cancelled_when": 66,
    "desktop_users": 12,
    "desktop_users_amount": 15,
    "desktop_users_discount_amount": 16,
    "desktop_users_gl_account_id": 14,
    "desktop_users_gl_category_id": 13,
    "generate": 4,
    "generated_by": 64,
    "generated_when": 63,
    "grant_date": 60,
    "id": 2,
    "inboxes_limit": 47,
    "inboxes_limit_amount": 55,
    "inboxes_limit_discount_amount": 56,
    "inboxes_limit_gl_account_id": 54,
    "inboxes_limit_gl_category_id": 53,
    "interval": 58,
    "interval_multiplier": 59,
    "kiosks_limit": 37,
    "kiosks_limit_amount": 40,
    "kiosks_limit_discount_amount": 41,
    "kiosks_limit_gl_account_id": 39,
    "kiosks_limit_gl_category_id": 38,
    "license": 48,
    "license_amount": 51,
    "license_discount_amount": 52,
    "license_gl_account_id": 50,
    "license_gl_category_id": 49,
    "mobile_users": 17,
    "mobile_users_amount": 20,
    "mobile_users_discount_amount": 21,
    "mobile_users_gl_account_id": 19,
    "mobile_users_gl_category_id": 18,
    "name": 7,
    "newbook_region": 0,
    "next_run": 61,
    "primary_license": 9,
    "privileges": 10,
    "prorata_start": 62,
    "sale_name": 8,
    "site_limit": 32,
    "site_limit_amount": 35,
    "site_limit_discount_amount": 36,
    "site_limit_gl_account_id": 34,
    "site_limit_gl_category_id": 33,
    "site_tablets": 27,
    "site_tablets_amount": 30,
    "site_tablets_discount_amount": 31,
    "site_tablets_gl_account_id": 29,
    "site_tablets_gl_category_id": 28,
    "software": 11,
    "sold_by": 65,
    "storage_limit": 42,
    "storage_limit_amount": 45,
    "storage_limit_discount_amount": 46,
    "storage_limit_gl_account_id": 44,
    "storage_limit_gl_category_id": 43,
    "tax_free": 57,
    "template_id": 3,
    "tenant": 1,
    "tv_users": 22,
    "tv_users_amount": 25,
    "tv_users_discount_amount": 26,
    "tv_users_gl_account_id": 24,
    "tv_users_gl_category_id": 23,
    "type": 5,
    "type_id": 6
}
    • schema_attributes: 
      {
    "cancelled_by": "string",
    "cancelled_reason": "string",
    "cancelled_when": "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",
    "generated_by": "string",
    "generated_when": "string",
    "grant_date": "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",
    "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",
    "next_run": "string",
    "primary_license": "string",
    "privileges": "string",
    "prorata_start": "string",
    "sale_name": "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",
    "sold_by": "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",
    "template_id": "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",
    "type_id": "string"
}
    • schema_name_id: 2751
    • schema_scan_id: 6674840
    • updated: 2024-11-05 23:02:49
    • created: 2024-11-05 22:32:20
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooklicenses`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooklicenses`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `template_id`  string , `generate`  string , `type`  string , `type_id`  string , `name`  string , `sale_name`  string , `primary_license`  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 , `grant_date`  string , `next_run`  string , `prorata_start`  string , `generated_when`  string , `generated_by`  string , `sold_by`  string , `cancelled_when`  string , `cancelled_by`  string , `cancelled_reason`  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/2024-11-05/1730866343'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooklicenses"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooklicenses/2024-11-05/1730866343
    • id: 4748017
    • processed: 1
    • raw_data: 
      {
    "cancelled_by": 67,
    "cancelled_reason": 68,
    "cancelled_when": 66,
    "desktop_users": 12,
    "desktop_users_amount": 15,
    "desktop_users_discount_amount": 16,
    "desktop_users_gl_account_id": 14,
    "desktop_users_gl_category_id": 13,
    "generate": 4,
    "generated_by": 64,
    "generated_when": 63,
    "grant_date": 60,
    "id": 2,
    "inboxes_limit": 47,
    "inboxes_limit_amount": 55,
    "inboxes_limit_discount_amount": 56,
    "inboxes_limit_gl_account_id": 54,
    "inboxes_limit_gl_category_id": 53,
    "interval": 58,
    "interval_multiplier": 59,
    "kiosks_limit": 37,
    "kiosks_limit_amount": 40,
    "kiosks_limit_discount_amount": 41,
    "kiosks_limit_gl_account_id": 39,
    "kiosks_limit_gl_category_id": 38,
    "license": 48,
    "license_amount": 51,
    "license_discount_amount": 52,
    "license_gl_account_id": 50,
    "license_gl_category_id": 49,
    "mobile_users": 17,
    "mobile_users_amount": 20,
    "mobile_users_discount_amount": 21,
    "mobile_users_gl_account_id": 19,
    "mobile_users_gl_category_id": 18,
    "name": 7,
    "newbook_region": 0,
    "next_run": 61,
    "primary_license": 9,
    "privileges": 10,
    "prorata_start": 62,
    "sale_name": 8,
    "site_limit": 32,
    "site_limit_amount": 35,
    "site_limit_discount_amount": 36,
    "site_limit_gl_account_id": 34,
    "site_limit_gl_category_id": 33,
    "site_tablets": 27,
    "site_tablets_amount": 30,
    "site_tablets_discount_amount": 31,
    "site_tablets_gl_account_id": 29,
    "site_tablets_gl_category_id": 28,
    "software": 11,
    "sold_by": 65,
    "storage_limit": 42,
    "storage_limit_amount": 45,
    "storage_limit_discount_amount": 46,
    "storage_limit_gl_account_id": 44,
    "storage_limit_gl_category_id": 43,
    "tax_free": 57,
    "template_id": 3,
    "tenant": 1,
    "tv_users": 22,
    "tv_users_amount": 25,
    "tv_users_discount_amount": 26,
    "tv_users_gl_account_id": 24,
    "tv_users_gl_category_id": 23,
    "type": 5,
    "type_id": 6
}
    • schema_attributes: 
      {
    "cancelled_by": "string",
    "cancelled_reason": "string",
    "cancelled_when": "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",
    "generated_by": "string",
    "generated_when": "string",
    "grant_date": "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",
    "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",
    "next_run": "string",
    "primary_license": "string",
    "privileges": "string",
    "prorata_start": "string",
    "sale_name": "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",
    "sold_by": "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",
    "template_id": "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",
    "type_id": "string"
}
    • schema_name_id: 2751
    • schema_scan_id: 6674049
    • updated: 2024-11-05 22:32:33
    • created: 2024-11-05 04:51:41
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooklicenses`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooklicenses`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `template_id`  string , `generate`  string , `type`  string , `type_id`  string , `name`  string , `sale_name`  string , `primary_license`  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 , `grant_date`  string , `next_run`  string , `prorata_start`  string , `generated_when`  string , `generated_by`  string , `sold_by`  string , `cancelled_when`  string , `cancelled_by`  string , `cancelled_reason`  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/2024-11-04/1730785746'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooklicenses"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooklicenses/2024-11-04/1730785746
    • id: 4747113
    • processed: 1
    • raw_data: 
      {
    "cancelled_by": 67,
    "cancelled_reason": 68,
    "cancelled_when": 66,
    "desktop_users": 12,
    "desktop_users_amount": 15,
    "desktop_users_discount_amount": 16,
    "desktop_users_gl_account_id": 14,
    "desktop_users_gl_category_id": 13,
    "generate": 4,
    "generated_by": 64,
    "generated_when": 63,
    "grant_date": 60,
    "id": 2,
    "inboxes_limit": 47,
    "inboxes_limit_amount": 55,
    "inboxes_limit_discount_amount": 56,
    "inboxes_limit_gl_account_id": 54,
    "inboxes_limit_gl_category_id": 53,
    "interval": 58,
    "interval_multiplier": 59,
    "kiosks_limit": 37,
    "kiosks_limit_amount": 40,
    "kiosks_limit_discount_amount": 41,
    "kiosks_limit_gl_account_id": 39,
    "kiosks_limit_gl_category_id": 38,
    "license": 48,
    "license_amount": 51,
    "license_discount_amount": 52,
    "license_gl_account_id": 50,
    "license_gl_category_id": 49,
    "mobile_users": 17,
    "mobile_users_amount": 20,
    "mobile_users_discount_amount": 21,
    "mobile_users_gl_account_id": 19,
    "mobile_users_gl_category_id": 18,
    "name": 7,
    "newbook_region": 0,
    "next_run": 61,
    "primary_license": 9,
    "privileges": 10,
    "prorata_start": 62,
    "sale_name": 8,
    "site_limit": 32,
    "site_limit_amount": 35,
    "site_limit_discount_amount": 36,
    "site_limit_gl_account_id": 34,
    "site_limit_gl_category_id": 33,
    "site_tablets": 27,
    "site_tablets_amount": 30,
    "site_tablets_discount_amount": 31,
    "site_tablets_gl_account_id": 29,
    "site_tablets_gl_category_id": 28,
    "software": 11,
    "sold_by": 65,
    "storage_limit": 42,
    "storage_limit_amount": 45,
    "storage_limit_discount_amount": 46,
    "storage_limit_gl_account_id": 44,
    "storage_limit_gl_category_id": 43,
    "tax_free": 57,
    "template_id": 3,
    "tenant": 1,
    "tv_users": 22,
    "tv_users_amount": 25,
    "tv_users_discount_amount": 26,
    "tv_users_gl_account_id": 24,
    "tv_users_gl_category_id": 23,
    "type": 5,
    "type_id": 6
}
    • schema_attributes: 
      {
    "cancelled_by": "string",
    "cancelled_reason": "string",
    "cancelled_when": "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",
    "generated_by": "string",
    "generated_when": "string",
    "grant_date": "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",
    "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",
    "next_run": "string",
    "primary_license": "string",
    "privileges": "string",
    "prorata_start": "string",
    "sale_name": "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",
    "sold_by": "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",
    "template_id": "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",
    "type_id": "string"
}
    • schema_name_id: 2751
    • schema_scan_id: 6672344
    • updated: 2024-11-05 04:51:55
    • created: 2024-11-05 04:09:37
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooklicenses`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooklicenses`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `template_id`  string , `generate`  string , `type`  string , `type_id`  string , `name`  string , `sale_name`  string , `primary_license`  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 , `grant_date`  string , `next_run`  string , `prorata_start`  string , `generated_when`  string , `generated_by`  string , `sold_by`  string , `cancelled_when`  string , `cancelled_by`  string , `cancelled_reason`  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/2024-11-04/1730785138'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooklicenses"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooklicenses/2024-11-04/1730785138
    • id: 4746561
    • processed: 1
    • raw_data: 
      {
    "cancelled_by": 67,
    "cancelled_reason": 68,
    "cancelled_when": 66,
    "desktop_users": 12,
    "desktop_users_amount": 15,
    "desktop_users_discount_amount": 16,
    "desktop_users_gl_account_id": 14,
    "desktop_users_gl_category_id": 13,
    "generate": 4,
    "generated_by": 64,
    "generated_when": 63,
    "grant_date": 60,
    "id": 2,
    "inboxes_limit": 47,
    "inboxes_limit_amount": 55,
    "inboxes_limit_discount_amount": 56,
    "inboxes_limit_gl_account_id": 54,
    "inboxes_limit_gl_category_id": 53,
    "interval": 58,
    "interval_multiplier": 59,
    "kiosks_limit": 37,
    "kiosks_limit_amount": 40,
    "kiosks_limit_discount_amount": 41,
    "kiosks_limit_gl_account_id": 39,
    "kiosks_limit_gl_category_id": 38,
    "license": 48,
    "license_amount": 51,
    "license_discount_amount": 52,
    "license_gl_account_id": 50,
    "license_gl_category_id": 49,
    "mobile_users": 17,
    "mobile_users_amount": 20,
    "mobile_users_discount_amount": 21,
    "mobile_users_gl_account_id": 19,
    "mobile_users_gl_category_id": 18,
    "name": 7,
    "newbook_region": 0,
    "next_run": 61,
    "primary_license": 9,
    "privileges": 10,
    "prorata_start": 62,
    "sale_name": 8,
    "site_limit": 32,
    "site_limit_amount": 35,
    "site_limit_discount_amount": 36,
    "site_limit_gl_account_id": 34,
    "site_limit_gl_category_id": 33,
    "site_tablets": 27,
    "site_tablets_amount": 30,
    "site_tablets_discount_amount": 31,
    "site_tablets_gl_account_id": 29,
    "site_tablets_gl_category_id": 28,
    "software": 11,
    "sold_by": 65,
    "storage_limit": 42,
    "storage_limit_amount": 45,
    "storage_limit_discount_amount": 46,
    "storage_limit_gl_account_id": 44,
    "storage_limit_gl_category_id": 43,
    "tax_free": 57,
    "template_id": 3,
    "tenant": 1,
    "tv_users": 22,
    "tv_users_amount": 25,
    "tv_users_discount_amount": 26,
    "tv_users_gl_account_id": 24,
    "tv_users_gl_category_id": 23,
    "type": 5,
    "type_id": 6
}
    • schema_attributes: 
      {
    "cancelled_by": "string",
    "cancelled_reason": "string",
    "cancelled_when": "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",
    "generated_by": "string",
    "generated_when": "string",
    "grant_date": "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",
    "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",
    "next_run": "string",
    "primary_license": "string",
    "privileges": "string",
    "prorata_start": "string",
    "sale_name": "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",
    "sold_by": "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",
    "template_id": "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",
    "type_id": "string"
}
    • schema_name_id: 2751
    • schema_scan_id: 6671783
    • updated: 2024-11-05 04:09:50
    • created: 2024-11-05 03:36:37
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooklicenses`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooklicenses`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `template_id`  string , `generate`  string , `type`  string , `type_id`  string , `name`  string , `sale_name`  string , `primary_license`  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 , `grant_date`  string , `next_run`  string , `prorata_start`  string , `generated_when`  string , `generated_by`  string , `sold_by`  string , `cancelled_when`  string , `cancelled_by`  string , `cancelled_reason`  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/2024-11-04/1730784833'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooklicenses"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooklicenses/2024-11-04/1730784833
    • id: 4745711
    • processed: 1
    • raw_data: 
      {
    "cancelled_by": 67,
    "cancelled_reason": 68,
    "cancelled_when": 66,
    "desktop_users": 12,
    "desktop_users_amount": 15,
    "desktop_users_discount_amount": 16,
    "desktop_users_gl_account_id": 14,
    "desktop_users_gl_category_id": 13,
    "generate": 4,
    "generated_by": 64,
    "generated_when": 63,
    "grant_date": 60,
    "id": 2,
    "inboxes_limit": 47,
    "inboxes_limit_amount": 55,
    "inboxes_limit_discount_amount": 56,
    "inboxes_limit_gl_account_id": 54,
    "inboxes_limit_gl_category_id": 53,
    "interval": 58,
    "interval_multiplier": 59,
    "kiosks_limit": 37,
    "kiosks_limit_amount": 40,
    "kiosks_limit_discount_amount": 41,
    "kiosks_limit_gl_account_id": 39,
    "kiosks_limit_gl_category_id": 38,
    "license": 48,
    "license_amount": 51,
    "license_discount_amount": 52,
    "license_gl_account_id": 50,
    "license_gl_category_id": 49,
    "mobile_users": 17,
    "mobile_users_amount": 20,
    "mobile_users_discount_amount": 21,
    "mobile_users_gl_account_id": 19,
    "mobile_users_gl_category_id": 18,
    "name": 7,
    "newbook_region": 0,
    "next_run": 61,
    "primary_license": 9,
    "privileges": 10,
    "prorata_start": 62,
    "sale_name": 8,
    "site_limit": 32,
    "site_limit_amount": 35,
    "site_limit_discount_amount": 36,
    "site_limit_gl_account_id": 34,
    "site_limit_gl_category_id": 33,
    "site_tablets": 27,
    "site_tablets_amount": 30,
    "site_tablets_discount_amount": 31,
    "site_tablets_gl_account_id": 29,
    "site_tablets_gl_category_id": 28,
    "software": 11,
    "sold_by": 65,
    "storage_limit": 42,
    "storage_limit_amount": 45,
    "storage_limit_discount_amount": 46,
    "storage_limit_gl_account_id": 44,
    "storage_limit_gl_category_id": 43,
    "tax_free": 57,
    "template_id": 3,
    "tenant": 1,
    "tv_users": 22,
    "tv_users_amount": 25,
    "tv_users_discount_amount": 26,
    "tv_users_gl_account_id": 24,
    "tv_users_gl_category_id": 23,
    "type": 5,
    "type_id": 6
}
    • schema_attributes: 
      {
    "cancelled_by": "string",
    "cancelled_reason": "string",
    "cancelled_when": "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",
    "generated_by": "string",
    "generated_when": "string",
    "grant_date": "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",
    "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",
    "next_run": "string",
    "primary_license": "string",
    "privileges": "string",
    "prorata_start": "string",
    "sale_name": "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",
    "sold_by": "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",
    "template_id": "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",
    "type_id": "string"
}
    • schema_name_id: 2751
    • schema_scan_id: 6670927
    • updated: 2024-11-05 03:36:48
    • created: 2024-11-05 03:25:27
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooklicenses`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooklicenses`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `template_id`  string , `generate`  string , `type`  string , `type_id`  string , `name`  string , `sale_name`  string , `primary_license`  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 , `grant_date`  string , `next_run`  string , `prorata_start`  string , `generated_when`  string , `generated_by`  string , `sold_by`  string , `cancelled_when`  string , `cancelled_by`  string , `cancelled_reason`  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/2024-11-04/1730784230'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooklicenses"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooklicenses/2024-11-04/1730784230
    • id: 4745284
    • processed: 1
    • raw_data: 
      {
    "cancelled_by": 67,
    "cancelled_reason": 68,
    "cancelled_when": 66,
    "desktop_users": 12,
    "desktop_users_amount": 15,
    "desktop_users_discount_amount": 16,
    "desktop_users_gl_account_id": 14,
    "desktop_users_gl_category_id": 13,
    "generate": 4,
    "generated_by": 64,
    "generated_when": 63,
    "grant_date": 60,
    "id": 2,
    "inboxes_limit": 47,
    "inboxes_limit_amount": 55,
    "inboxes_limit_discount_amount": 56,
    "inboxes_limit_gl_account_id": 54,
    "inboxes_limit_gl_category_id": 53,
    "interval": 58,
    "interval_multiplier": 59,
    "kiosks_limit": 37,
    "kiosks_limit_amount": 40,
    "kiosks_limit_discount_amount": 41,
    "kiosks_limit_gl_account_id": 39,
    "kiosks_limit_gl_category_id": 38,
    "license": 48,
    "license_amount": 51,
    "license_discount_amount": 52,
    "license_gl_account_id": 50,
    "license_gl_category_id": 49,
    "mobile_users": 17,
    "mobile_users_amount": 20,
    "mobile_users_discount_amount": 21,
    "mobile_users_gl_account_id": 19,
    "mobile_users_gl_category_id": 18,
    "name": 7,
    "newbook_region": 0,
    "next_run": 61,
    "primary_license": 9,
    "privileges": 10,
    "prorata_start": 62,
    "sale_name": 8,
    "site_limit": 32,
    "site_limit_amount": 35,
    "site_limit_discount_amount": 36,
    "site_limit_gl_account_id": 34,
    "site_limit_gl_category_id": 33,
    "site_tablets": 27,
    "site_tablets_amount": 30,
    "site_tablets_discount_amount": 31,
    "site_tablets_gl_account_id": 29,
    "site_tablets_gl_category_id": 28,
    "software": 11,
    "sold_by": 65,
    "storage_limit": 42,
    "storage_limit_amount": 45,
    "storage_limit_discount_amount": 46,
    "storage_limit_gl_account_id": 44,
    "storage_limit_gl_category_id": 43,
    "tax_free": 57,
    "template_id": 3,
    "tenant": 1,
    "tv_users": 22,
    "tv_users_amount": 25,
    "tv_users_discount_amount": 26,
    "tv_users_gl_account_id": 24,
    "tv_users_gl_category_id": 23,
    "type": 5,
    "type_id": 6
}
    • schema_attributes: 
      {
    "cancelled_by": "string",
    "cancelled_reason": "string",
    "cancelled_when": "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",
    "generated_by": "string",
    "generated_when": "string",
    "grant_date": "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",
    "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",
    "next_run": "string",
    "primary_license": "string",
    "privileges": "string",
    "prorata_start": "string",
    "sale_name": "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",
    "sold_by": "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",
    "template_id": "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",
    "type_id": "string"
}
    • schema_name_id: 2751
    • schema_scan_id: 6670500
    • updated: 2024-11-05 03:25:38
    • created: 2024-11-05 02:38:03
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooklicenses`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooklicenses`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `template_id`  string , `generate`  string , `type`  string , `type_id`  string , `name`  string , `sale_name`  string , `primary_license`  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 , `grant_date`  string , `next_run`  string , `prorata_start`  string , `generated_when`  string , `generated_by`  string , `sold_by`  string , `cancelled_when`  string , `cancelled_by`  string , `cancelled_reason`  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/2024-11-04/1730784067'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooklicenses"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooklicenses/2024-11-04/1730784067
    • id: 4743492
    • processed: 1
    • raw_data: 
      {
    "cancelled_by": 67,
    "cancelled_reason": 68,
    "cancelled_when": 66,
    "desktop_users": 12,
    "desktop_users_amount": 15,
    "desktop_users_discount_amount": 16,
    "desktop_users_gl_account_id": 14,
    "desktop_users_gl_category_id": 13,
    "generate": 4,
    "generated_by": 64,
    "generated_when": 63,
    "grant_date": 60,
    "id": 2,
    "inboxes_limit": 47,
    "inboxes_limit_amount": 55,
    "inboxes_limit_discount_amount": 56,
    "inboxes_limit_gl_account_id": 54,
    "inboxes_limit_gl_category_id": 53,
    "interval": 58,
    "interval_multiplier": 59,
    "kiosks_limit": 37,
    "kiosks_limit_amount": 40,
    "kiosks_limit_discount_amount": 41,
    "kiosks_limit_gl_account_id": 39,
    "kiosks_limit_gl_category_id": 38,
    "license": 48,
    "license_amount": 51,
    "license_discount_amount": 52,
    "license_gl_account_id": 50,
    "license_gl_category_id": 49,
    "mobile_users": 17,
    "mobile_users_amount": 20,
    "mobile_users_discount_amount": 21,
    "mobile_users_gl_account_id": 19,
    "mobile_users_gl_category_id": 18,
    "name": 7,
    "newbook_region": 0,
    "next_run": 61,
    "primary_license": 9,
    "privileges": 10,
    "prorata_start": 62,
    "sale_name": 8,
    "site_limit": 32,
    "site_limit_amount": 35,
    "site_limit_discount_amount": 36,
    "site_limit_gl_account_id": 34,
    "site_limit_gl_category_id": 33,
    "site_tablets": 27,
    "site_tablets_amount": 30,
    "site_tablets_discount_amount": 31,
    "site_tablets_gl_account_id": 29,
    "site_tablets_gl_category_id": 28,
    "software": 11,
    "sold_by": 65,
    "storage_limit": 42,
    "storage_limit_amount": 45,
    "storage_limit_discount_amount": 46,
    "storage_limit_gl_account_id": 44,
    "storage_limit_gl_category_id": 43,
    "tax_free": 57,
    "template_id": 3,
    "tenant": 1,
    "tv_users": 22,
    "tv_users_amount": 25,
    "tv_users_discount_amount": 26,
    "tv_users_gl_account_id": 24,
    "tv_users_gl_category_id": 23,
    "type": 5,
    "type_id": 6
}
    • schema_attributes: 
      {
    "cancelled_by": "string",
    "cancelled_reason": "string",
    "cancelled_when": "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",
    "generated_by": "string",
    "generated_when": "string",
    "grant_date": "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",
    "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",
    "next_run": "string",
    "primary_license": "string",
    "privileges": "string",
    "prorata_start": "string",
    "sale_name": "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",
    "sold_by": "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",
    "template_id": "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",
    "type_id": "string"
}
    • schema_name_id: 2751
    • schema_scan_id: 6668708
    • updated: 2024-11-05 02:38:17
    • created: 2024-11-05 02:18:39
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooklicenses`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooklicenses`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `template_id`  string , `generate`  string , `type`  string , `type_id`  string , `name`  string , `sale_name`  string , `primary_license`  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 , `grant_date`  string , `next_run`  string , `prorata_start`  string , `generated_when`  string , `generated_by`  string , `sold_by`  string , `cancelled_when`  string , `cancelled_by`  string , `cancelled_reason`  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/2024-11-04/1730783910'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooklicenses"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooklicenses/2024-11-04/1730783910
    • id: 4742757
    • processed: 1
    • raw_data: 
      {
    "cancelled_by": 67,
    "cancelled_reason": 68,
    "cancelled_when": 66,
    "desktop_users": 12,
    "desktop_users_amount": 15,
    "desktop_users_discount_amount": 16,
    "desktop_users_gl_account_id": 14,
    "desktop_users_gl_category_id": 13,
    "generate": 4,
    "generated_by": 64,
    "generated_when": 63,
    "grant_date": 60,
    "id": 2,
    "inboxes_limit": 47,
    "inboxes_limit_amount": 55,
    "inboxes_limit_discount_amount": 56,
    "inboxes_limit_gl_account_id": 54,
    "inboxes_limit_gl_category_id": 53,
    "interval": 58,
    "interval_multiplier": 59,
    "kiosks_limit": 37,
    "kiosks_limit_amount": 40,
    "kiosks_limit_discount_amount": 41,
    "kiosks_limit_gl_account_id": 39,
    "kiosks_limit_gl_category_id": 38,
    "license": 48,
    "license_amount": 51,
    "license_discount_amount": 52,
    "license_gl_account_id": 50,
    "license_gl_category_id": 49,
    "mobile_users": 17,
    "mobile_users_amount": 20,
    "mobile_users_discount_amount": 21,
    "mobile_users_gl_account_id": 19,
    "mobile_users_gl_category_id": 18,
    "name": 7,
    "newbook_region": 0,
    "next_run": 61,
    "primary_license": 9,
    "privileges": 10,
    "prorata_start": 62,
    "sale_name": 8,
    "site_limit": 32,
    "site_limit_amount": 35,
    "site_limit_discount_amount": 36,
    "site_limit_gl_account_id": 34,
    "site_limit_gl_category_id": 33,
    "site_tablets": 27,
    "site_tablets_amount": 30,
    "site_tablets_discount_amount": 31,
    "site_tablets_gl_account_id": 29,
    "site_tablets_gl_category_id": 28,
    "software": 11,
    "sold_by": 65,
    "storage_limit": 42,
    "storage_limit_amount": 45,
    "storage_limit_discount_amount": 46,
    "storage_limit_gl_account_id": 44,
    "storage_limit_gl_category_id": 43,
    "tax_free": 57,
    "template_id": 3,
    "tenant": 1,
    "tv_users": 22,
    "tv_users_amount": 25,
    "tv_users_discount_amount": 26,
    "tv_users_gl_account_id": 24,
    "tv_users_gl_category_id": 23,
    "type": 5,
    "type_id": 6
}
    • schema_attributes: 
      {
    "cancelled_by": "string",
    "cancelled_reason": "string",
    "cancelled_when": "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",
    "generated_by": "string",
    "generated_when": "string",
    "grant_date": "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",
    "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",
    "next_run": "string",
    "primary_license": "string",
    "privileges": "string",
    "prorata_start": "string",
    "sale_name": "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",
    "sold_by": "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",
    "template_id": "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",
    "type_id": "string"
}
    • schema_name_id: 2751
    • schema_scan_id: 6667973
    • updated: 2024-11-05 02:18:50
    • created: 2024-11-05 02:16:53
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooklicenses`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooklicenses`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `template_id`  string , `generate`  string , `type`  string , `type_id`  string , `name`  string , `sale_name`  string , `primary_license`  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 , `grant_date`  string , `next_run`  string , `prorata_start`  string , `generated_when`  string , `generated_by`  string , `sold_by`  string , `cancelled_when`  string , `cancelled_by`  string , `cancelled_reason`  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/2024-11-04/1730783781'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooklicenses"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooklicenses/2024-11-04/1730783781
    • id: 4742689
    • processed: 1
    • raw_data: 
      {
    "cancelled_by": 67,
    "cancelled_reason": 68,
    "cancelled_when": 66,
    "desktop_users": 12,
    "desktop_users_amount": 15,
    "desktop_users_discount_amount": 16,
    "desktop_users_gl_account_id": 14,
    "desktop_users_gl_category_id": 13,
    "generate": 4,
    "generated_by": 64,
    "generated_when": 63,
    "grant_date": 60,
    "id": 2,
    "inboxes_limit": 47,
    "inboxes_limit_amount": 55,
    "inboxes_limit_discount_amount": 56,
    "inboxes_limit_gl_account_id": 54,
    "inboxes_limit_gl_category_id": 53,
    "interval": 58,
    "interval_multiplier": 59,
    "kiosks_limit": 37,
    "kiosks_limit_amount": 40,
    "kiosks_limit_discount_amount": 41,
    "kiosks_limit_gl_account_id": 39,
    "kiosks_limit_gl_category_id": 38,
    "license": 48,
    "license_amount": 51,
    "license_discount_amount": 52,
    "license_gl_account_id": 50,
    "license_gl_category_id": 49,
    "mobile_users": 17,
    "mobile_users_amount": 20,
    "mobile_users_discount_amount": 21,
    "mobile_users_gl_account_id": 19,
    "mobile_users_gl_category_id": 18,
    "name": 7,
    "newbook_region": 0,
    "next_run": 61,
    "primary_license": 9,
    "privileges": 10,
    "prorata_start": 62,
    "sale_name": 8,
    "site_limit": 32,
    "site_limit_amount": 35,
    "site_limit_discount_amount": 36,
    "site_limit_gl_account_id": 34,
    "site_limit_gl_category_id": 33,
    "site_tablets": 27,
    "site_tablets_amount": 30,
    "site_tablets_discount_amount": 31,
    "site_tablets_gl_account_id": 29,
    "site_tablets_gl_category_id": 28,
    "software": 11,
    "sold_by": 65,
    "storage_limit": 42,
    "storage_limit_amount": 45,
    "storage_limit_discount_amount": 46,
    "storage_limit_gl_account_id": 44,
    "storage_limit_gl_category_id": 43,
    "tax_free": 57,
    "template_id": 3,
    "tenant": 1,
    "tv_users": 22,
    "tv_users_amount": 25,
    "tv_users_discount_amount": 26,
    "tv_users_gl_account_id": 24,
    "tv_users_gl_category_id": 23,
    "type": 5,
    "type_id": 6
}
    • schema_attributes: 
      {
    "cancelled_by": "string",
    "cancelled_reason": "string",
    "cancelled_when": "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",
    "generated_by": "string",
    "generated_when": "string",
    "grant_date": "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",
    "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",
    "next_run": "string",
    "primary_license": "string",
    "privileges": "string",
    "prorata_start": "string",
    "sale_name": "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",
    "sold_by": "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",
    "template_id": "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",
    "type_id": "string"
}
    • schema_name_id: 2751
    • schema_scan_id: 6667906
    • updated: 2024-11-05 02:17:06
    • created: 2024-11-05 02:00:47
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooklicenses`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooklicenses`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `template_id`  string , `generate`  string , `type`  string , `type_id`  string , `name`  string , `sale_name`  string , `primary_license`  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 , `grant_date`  string , `next_run`  string , `prorata_start`  string , `generated_when`  string , `generated_by`  string , `sold_by`  string , `cancelled_when`  string , `cancelled_by`  string , `cancelled_reason`  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/2024-11-04/1730783675'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooklicenses"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooklicenses/2024-11-04/1730783675
    • id: 4742089
    • processed: 1
    • raw_data: 
      {
    "cancelled_by": 67,
    "cancelled_reason": 68,
    "cancelled_when": 66,
    "desktop_users": 12,
    "desktop_users_amount": 15,
    "desktop_users_discount_amount": 16,
    "desktop_users_gl_account_id": 14,
    "desktop_users_gl_category_id": 13,
    "generate": 4,
    "generated_by": 64,
    "generated_when": 63,
    "grant_date": 60,
    "id": 2,
    "inboxes_limit": 47,
    "inboxes_limit_amount": 55,
    "inboxes_limit_discount_amount": 56,
    "inboxes_limit_gl_account_id": 54,
    "inboxes_limit_gl_category_id": 53,
    "interval": 58,
    "interval_multiplier": 59,
    "kiosks_limit": 37,
    "kiosks_limit_amount": 40,
    "kiosks_limit_discount_amount": 41,
    "kiosks_limit_gl_account_id": 39,
    "kiosks_limit_gl_category_id": 38,
    "license": 48,
    "license_amount": 51,
    "license_discount_amount": 52,
    "license_gl_account_id": 50,
    "license_gl_category_id": 49,
    "mobile_users": 17,
    "mobile_users_amount": 20,
    "mobile_users_discount_amount": 21,
    "mobile_users_gl_account_id": 19,
    "mobile_users_gl_category_id": 18,
    "name": 7,
    "newbook_region": 0,
    "next_run": 61,
    "primary_license": 9,
    "privileges": 10,
    "prorata_start": 62,
    "sale_name": 8,
    "site_limit": 32,
    "site_limit_amount": 35,
    "site_limit_discount_amount": 36,
    "site_limit_gl_account_id": 34,
    "site_limit_gl_category_id": 33,
    "site_tablets": 27,
    "site_tablets_amount": 30,
    "site_tablets_discount_amount": 31,
    "site_tablets_gl_account_id": 29,
    "site_tablets_gl_category_id": 28,
    "software": 11,
    "sold_by": 65,
    "storage_limit": 42,
    "storage_limit_amount": 45,
    "storage_limit_discount_amount": 46,
    "storage_limit_gl_account_id": 44,
    "storage_limit_gl_category_id": 43,
    "tax_free": 57,
    "template_id": 3,
    "tenant": 1,
    "tv_users": 22,
    "tv_users_amount": 25,
    "tv_users_discount_amount": 26,
    "tv_users_gl_account_id": 24,
    "tv_users_gl_category_id": 23,
    "type": 5,
    "type_id": 6
}
    • schema_attributes: 
      {
    "cancelled_by": "string",
    "cancelled_reason": "string",
    "cancelled_when": "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",
    "generated_by": "string",
    "generated_when": "string",
    "grant_date": "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",
    "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",
    "next_run": "string",
    "primary_license": "string",
    "privileges": "string",
    "prorata_start": "string",
    "sale_name": "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",
    "sold_by": "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",
    "template_id": "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",
    "type_id": "string"
}
    • schema_name_id: 2751
    • schema_scan_id: 6667306
    • updated: 2024-11-05 02:01:00
    • created: 2024-11-05 01:36:25
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooklicenses`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooklicenses`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `template_id`  string , `generate`  string , `type`  string , `type_id`  string , `name`  string , `sale_name`  string , `primary_license`  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 , `grant_date`  string , `next_run`  string , `prorata_start`  string , `generated_when`  string , `generated_by`  string , `sold_by`  string , `cancelled_when`  string , `cancelled_by`  string , `cancelled_reason`  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/2024-11-04/1730783539'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooklicenses"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooklicenses/2024-11-04/1730783539
    • id: 4741161
    • processed: 1
    • raw_data: 
      {
    "cancelled_by": 67,
    "cancelled_reason": 68,
    "cancelled_when": 66,
    "desktop_users": 12,
    "desktop_users_amount": 15,
    "desktop_users_discount_amount": 16,
    "desktop_users_gl_account_id": 14,
    "desktop_users_gl_category_id": 13,
    "generate": 4,
    "generated_by": 64,
    "generated_when": 63,
    "grant_date": 60,
    "id": 2,
    "inboxes_limit": 47,
    "inboxes_limit_amount": 55,
    "inboxes_limit_discount_amount": 56,
    "inboxes_limit_gl_account_id": 54,
    "inboxes_limit_gl_category_id": 53,
    "interval": 58,
    "interval_multiplier": 59,
    "kiosks_limit": 37,
    "kiosks_limit_amount": 40,
    "kiosks_limit_discount_amount": 41,
    "kiosks_limit_gl_account_id": 39,
    "kiosks_limit_gl_category_id": 38,
    "license": 48,
    "license_amount": 51,
    "license_discount_amount": 52,
    "license_gl_account_id": 50,
    "license_gl_category_id": 49,
    "mobile_users": 17,
    "mobile_users_amount": 20,
    "mobile_users_discount_amount": 21,
    "mobile_users_gl_account_id": 19,
    "mobile_users_gl_category_id": 18,
    "name": 7,
    "newbook_region": 0,
    "next_run": 61,
    "primary_license": 9,
    "privileges": 10,
    "prorata_start": 62,
    "sale_name": 8,
    "site_limit": 32,
    "site_limit_amount": 35,
    "site_limit_discount_amount": 36,
    "site_limit_gl_account_id": 34,
    "site_limit_gl_category_id": 33,
    "site_tablets": 27,
    "site_tablets_amount": 30,
    "site_tablets_discount_amount": 31,
    "site_tablets_gl_account_id": 29,
    "site_tablets_gl_category_id": 28,
    "software": 11,
    "sold_by": 65,
    "storage_limit": 42,
    "storage_limit_amount": 45,
    "storage_limit_discount_amount": 46,
    "storage_limit_gl_account_id": 44,
    "storage_limit_gl_category_id": 43,
    "tax_free": 57,
    "template_id": 3,
    "tenant": 1,
    "tv_users": 22,
    "tv_users_amount": 25,
    "tv_users_discount_amount": 26,
    "tv_users_gl_account_id": 24,
    "tv_users_gl_category_id": 23,
    "type": 5,
    "type_id": 6
}
    • schema_attributes: 
      {
    "cancelled_by": "string",
    "cancelled_reason": "string",
    "cancelled_when": "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",
    "generated_by": "string",
    "generated_when": "string",
    "grant_date": "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",
    "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",
    "next_run": "string",
    "primary_license": "string",
    "privileges": "string",
    "prorata_start": "string",
    "sale_name": "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",
    "sold_by": "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",
    "template_id": "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",
    "type_id": "string"
}
    • schema_name_id: 2751
    • schema_scan_id: 6666378
    • updated: 2024-11-05 01:36:36
    • created: 2024-11-05 01:18:22
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooklicenses`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooklicenses`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `template_id`  string , `generate`  string , `type`  string , `type_id`  string , `name`  string , `sale_name`  string , `primary_license`  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 , `grant_date`  string , `next_run`  string , `prorata_start`  string , `generated_when`  string , `generated_by`  string , `sold_by`  string , `cancelled_when`  string , `cancelled_by`  string , `cancelled_reason`  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/2024-11-04/1730783319'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooklicenses"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooklicenses/2024-11-04/1730783319
    • id: 4740477
    • processed: 1
    • raw_data: 
      {
    "cancelled_by": 67,
    "cancelled_reason": 68,
    "cancelled_when": 66,
    "desktop_users": 12,
    "desktop_users_amount": 15,
    "desktop_users_discount_amount": 16,
    "desktop_users_gl_account_id": 14,
    "desktop_users_gl_category_id": 13,
    "generate": 4,
    "generated_by": 64,
    "generated_when": 63,
    "grant_date": 60,
    "id": 2,
    "inboxes_limit": 47,
    "inboxes_limit_amount": 55,
    "inboxes_limit_discount_amount": 56,
    "inboxes_limit_gl_account_id": 54,
    "inboxes_limit_gl_category_id": 53,
    "interval": 58,
    "interval_multiplier": 59,
    "kiosks_limit": 37,
    "kiosks_limit_amount": 40,
    "kiosks_limit_discount_amount": 41,
    "kiosks_limit_gl_account_id": 39,
    "kiosks_limit_gl_category_id": 38,
    "license": 48,
    "license_amount": 51,
    "license_discount_amount": 52,
    "license_gl_account_id": 50,
    "license_gl_category_id": 49,
    "mobile_users": 17,
    "mobile_users_amount": 20,
    "mobile_users_discount_amount": 21,
    "mobile_users_gl_account_id": 19,
    "mobile_users_gl_category_id": 18,
    "name": 7,
    "newbook_region": 0,
    "next_run": 61,
    "primary_license": 9,
    "privileges": 10,
    "prorata_start": 62,
    "sale_name": 8,
    "site_limit": 32,
    "site_limit_amount": 35,
    "site_limit_discount_amount": 36,
    "site_limit_gl_account_id": 34,
    "site_limit_gl_category_id": 33,
    "site_tablets": 27,
    "site_tablets_amount": 30,
    "site_tablets_discount_amount": 31,
    "site_tablets_gl_account_id": 29,
    "site_tablets_gl_category_id": 28,
    "software": 11,
    "sold_by": 65,
    "storage_limit": 42,
    "storage_limit_amount": 45,
    "storage_limit_discount_amount": 46,
    "storage_limit_gl_account_id": 44,
    "storage_limit_gl_category_id": 43,
    "tax_free": 57,
    "template_id": 3,
    "tenant": 1,
    "tv_users": 22,
    "tv_users_amount": 25,
    "tv_users_discount_amount": 26,
    "tv_users_gl_account_id": 24,
    "tv_users_gl_category_id": 23,
    "type": 5,
    "type_id": 6
}
    • schema_attributes: 
      {
    "cancelled_by": "string",
    "cancelled_reason": "string",
    "cancelled_when": "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",
    "generated_by": "string",
    "generated_when": "string",
    "grant_date": "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",
    "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",
    "next_run": "string",
    "primary_license": "string",
    "privileges": "string",
    "prorata_start": "string",
    "sale_name": "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",
    "sold_by": "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",
    "template_id": "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",
    "type_id": "string"
}
    • schema_name_id: 2751
    • schema_scan_id: 6665693
    • updated: 2024-11-05 01:18:35
    • created: 2024-11-05 00:58:32
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooklicenses`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooklicenses`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `template_id`  string , `generate`  string , `type`  string , `type_id`  string , `name`  string , `sale_name`  string , `primary_license`  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 , `grant_date`  string , `next_run`  string , `prorata_start`  string , `generated_when`  string , `generated_by`  string , `sold_by`  string , `cancelled_when`  string , `cancelled_by`  string , `cancelled_reason`  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/2024-11-04/1730782919'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooklicenses"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooklicenses/2024-11-04/1730782919
    • id: 4739737
    • processed: 1
    • raw_data: 
      {
    "cancelled_by": 67,
    "cancelled_reason": 68,
    "cancelled_when": 66,
    "desktop_users": 12,
    "desktop_users_amount": 15,
    "desktop_users_discount_amount": 16,
    "desktop_users_gl_account_id": 14,
    "desktop_users_gl_category_id": 13,
    "generate": 4,
    "generated_by": 64,
    "generated_when": 63,
    "grant_date": 60,
    "id": 2,
    "inboxes_limit": 47,
    "inboxes_limit_amount": 55,
    "inboxes_limit_discount_amount": 56,
    "inboxes_limit_gl_account_id": 54,
    "inboxes_limit_gl_category_id": 53,
    "interval": 58,
    "interval_multiplier": 59,
    "kiosks_limit": 37,
    "kiosks_limit_amount": 40,
    "kiosks_limit_discount_amount": 41,
    "kiosks_limit_gl_account_id": 39,
    "kiosks_limit_gl_category_id": 38,
    "license": 48,
    "license_amount": 51,
    "license_discount_amount": 52,
    "license_gl_account_id": 50,
    "license_gl_category_id": 49,
    "mobile_users": 17,
    "mobile_users_amount": 20,
    "mobile_users_discount_amount": 21,
    "mobile_users_gl_account_id": 19,
    "mobile_users_gl_category_id": 18,
    "name": 7,
    "newbook_region": 0,
    "next_run": 61,
    "primary_license": 9,
    "privileges": 10,
    "prorata_start": 62,
    "sale_name": 8,
    "site_limit": 32,
    "site_limit_amount": 35,
    "site_limit_discount_amount": 36,
    "site_limit_gl_account_id": 34,
    "site_limit_gl_category_id": 33,
    "site_tablets": 27,
    "site_tablets_amount": 30,
    "site_tablets_discount_amount": 31,
    "site_tablets_gl_account_id": 29,
    "site_tablets_gl_category_id": 28,
    "software": 11,
    "sold_by": 65,
    "storage_limit": 42,
    "storage_limit_amount": 45,
    "storage_limit_discount_amount": 46,
    "storage_limit_gl_account_id": 44,
    "storage_limit_gl_category_id": 43,
    "tax_free": 57,
    "template_id": 3,
    "tenant": 1,
    "tv_users": 22,
    "tv_users_amount": 25,
    "tv_users_discount_amount": 26,
    "tv_users_gl_account_id": 24,
    "tv_users_gl_category_id": 23,
    "type": 5,
    "type_id": 6
}
    • schema_attributes: 
      {
    "cancelled_by": "string",
    "cancelled_reason": "string",
    "cancelled_when": "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",
    "generated_by": "string",
    "generated_when": "string",
    "grant_date": "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",
    "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",
    "next_run": "string",
    "primary_license": "string",
    "privileges": "string",
    "prorata_start": "string",
    "sale_name": "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",
    "sold_by": "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",
    "template_id": "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",
    "type_id": "string"
}
    • schema_name_id: 2751
    • schema_scan_id: 6664953
    • updated: 2024-11-05 00:58:43
    • created: 2024-11-05 00:31:32
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooklicenses`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbooklicenses`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `template_id`  string , `generate`  string , `type`  string , `type_id`  string , `name`  string , `sale_name`  string , `primary_license`  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 , `grant_date`  string , `next_run`  string , `prorata_start`  string , `generated_when`  string , `generated_by`  string , `sold_by`  string , `cancelled_when`  string , `cancelled_by`  string , `cancelled_reason`  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/2024-11-04/1730782754'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooklicenses"
]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbooklicenses/2024-11-04/1730782754
    • id: 4738709
    • processed: 1
    • raw_data: 
      {
    "cancelled_by": 67,
    "cancelled_reason": 68,
    "cancelled_when": 66,
    "desktop_users": 12,
    "desktop_users_amount": 15,
    "desktop_users_discount_amount": 16,
    "desktop_users_gl_account_id": 14,
    "desktop_users_gl_category_id": 13,
    "generate": 4,
    "generated_by": 64,
    "generated_when": 63,
    "grant_date": 60,
    "id": 2,
    "inboxes_limit": 47,
    "inboxes_limit_amount": 55,
    "inboxes_limit_discount_amount": 56,
    "inboxes_limit_gl_account_id": 54,
    "inboxes_limit_gl_category_id": 53,
    "interval": 58,
    "interval_multiplier": 59,
    "kiosks_limit": 37,
    "kiosks_limit_amount": 40,
    "kiosks_limit_discount_amount": 41,
    "kiosks_limit_gl_account_id": 39,
    "kiosks_limit_gl_category_id": 38,
    "license": 48,
    "license_amount": 51,
    "license_discount_amount": 52,
    "license_gl_account_id": 50,
    "license_gl_category_id": 49,
    "mobile_users": 17,
    "mobile_users_amount": 20,
    "mobile_users_discount_amount": 21,
    "mobile_users_gl_account_id": 19,
    "mobile_users_gl_category_id": 18,
    "name": 7,
    "newbook_region": 0,
    "next_run": 61,
    "primary_license": 9,
    "privileges": 10,
    "prorata_start": 62,
    "sale_name": 8,
    "site_limit": 32,
    "site_limit_amount": 35,
    "site_limit_discount_amount": 36,
    "site_limit_gl_account_id": 34,
    "site_limit_gl_category_id": 33,
    "site_tablets": 27,
    "site_tablets_amount": 30,
    "site_tablets_discount_amount": 31,
    "site_tablets_gl_account_id": 29,
    "site_tablets_gl_category_id": 28,
    "software": 11,
    "sold_by": 65,
    "storage_limit": 42,
    "storage_limit_amount": 45,
    "storage_limit_discount_amount": 46,
    "storage_limit_gl_account_id": 44,
    "storage_limit_gl_category_id": 43,
    "tax_free": 57,
    "template_id": 3,
    "tenant": 1,
    "tv_users": 22,
    "tv_users_amount": 25,
    "tv_users_discount_amount": 26,
    "tv_users_gl_account_id": 24,
    "tv_users_gl_category_id": 23,
    "type": 5,
    "type_id": 6
}
    • schema_attributes: 
      {
    "cancelled_by": "string",
    "cancelled_reason": "string",
    "cancelled_when": "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",
    "generated_by": "string",
    "generated_when": "string",
    "grant_date": "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",
    "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",
    "next_run": "string",
    "primary_license": "string",
    "privileges": "string",
    "prorata_start": "string",
    "sale_name": "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",
    "sold_by": "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",
    "template_id": "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",
    "type_id": "string"
}
    • schema_name_id: 2751
    • schema_scan_id: 6663921
    • updated: 2024-11-05 00:31:45
Schema Scans: 15
Last at 2024-11-05 23:10:25
    • duration: 0:00:15.996679
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6674981
    • 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/2024-11-05/1730866539",
        "key": "raw/newbookdev_newbooklicenses/2024-11-05/1730866539/licenses.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooklicenses",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1444448966524687956,
        "service_name": "drive-thru",
        "span_id": 11227972552959842444,
        "trace_id": 9205562402547563540
    }
}
    • running: False
    • schema_name_id: 2751
    • start_time: 2024-11-05 23:10:25
    • success: True
    • trace_id: 9205562402547563540
    • duration: 0:00:13.715797
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6674840
    • 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/2024-11-05/1730866477",
        "key": "raw/newbookdev_newbooklicenses/2024-11-05/1730866477/licenses.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooklicenses",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11499458335360572496,
        "service_name": "drive-thru",
        "span_id": 8048348569439009631,
        "trace_id": 14384147708738664747
    }
}
    • running: False
    • schema_name_id: 2751
    • start_time: 2024-11-05 23:02:36
    • success: True
    • trace_id: 14384147708738664747
    • duration: 0:00:16.181189
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6674049
    • 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/2024-11-05/1730866343",
        "key": "raw/newbookdev_newbooklicenses/2024-11-05/1730866343/licenses.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooklicenses",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4912376494764413392,
        "service_name": "drive-thru",
        "span_id": 398546697921231082,
        "trace_id": 3230219596473933074
    }
}
    • running: False
    • schema_name_id: 2751
    • start_time: 2024-11-05 22:32:17
    • success: True
    • trace_id: 3230219596473933074
    • duration: 0:00:16.017352
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6672344
    • 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/2024-11-04/1730785746",
        "key": "raw/newbookdev_newbooklicenses/2024-11-04/1730785746/licenses.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooklicenses",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2268974008883122566,
        "service_name": "drive-thru",
        "span_id": 1802228308576648507,
        "trace_id": 8834785531939905138
    }
}
    • running: False
    • schema_name_id: 2751
    • start_time: 2024-11-05 04:51:39
    • success: True
    • trace_id: 8834785531939905138
    • duration: 0:00:16.362054
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6671783
    • 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/2024-11-04/1730785138",
        "key": "raw/newbookdev_newbooklicenses/2024-11-04/1730785138/licenses.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooklicenses",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13907675028454063320,
        "service_name": "drive-thru",
        "span_id": 7960397506992594151,
        "trace_id": 12520106349757518764
    }
}
    • running: False
    • schema_name_id: 2751
    • start_time: 2024-11-05 04:09:34
    • success: True
    • trace_id: 12520106349757518764
    • duration: 0:00:13.106028
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6670927
    • 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/2024-11-04/1730784833",
        "key": "raw/newbookdev_newbooklicenses/2024-11-04/1730784833/licenses.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooklicenses",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1565794755331868702,
        "service_name": "drive-thru",
        "span_id": 12556180506507225863,
        "trace_id": 9395739522260377089
    }
}
    • running: False
    • schema_name_id: 2751
    • start_time: 2024-11-05 03:36:35
    • success: True
    • trace_id: 9395739522260377089
    • duration: 0:00:13.201934
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6670500
    • 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/2024-11-04/1730784230",
        "key": "raw/newbookdev_newbooklicenses/2024-11-04/1730784230/licenses.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooklicenses",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16817801685056115507,
        "service_name": "drive-thru",
        "span_id": 9246804602889003178,
        "trace_id": 16716347488995137011
    }
}
    • running: False
    • schema_name_id: 2751
    • start_time: 2024-11-05 03:25:25
    • success: True
    • trace_id: 16716347488995137011
    • duration: 0:00:15.704402
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6668708
    • 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/2024-11-04/1730784067",
        "key": "raw/newbookdev_newbooklicenses/2024-11-04/1730784067/licenses.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooklicenses",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17882801157528940870,
        "service_name": "drive-thru",
        "span_id": 8108656579085433470,
        "trace_id": 13720628810712481270
    }
}
    • running: False
    • schema_name_id: 2751
    • start_time: 2024-11-05 02:38:01
    • success: True
    • trace_id: 13720628810712481270
    • duration: 0:00:13.135408
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6667973
    • 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/2024-11-04/1730783910",
        "key": "raw/newbookdev_newbooklicenses/2024-11-04/1730783910/licenses.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooklicenses",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14721770977885755656,
        "service_name": "drive-thru",
        "span_id": 9240131477081119013,
        "trace_id": 4155590362348235283
    }
}
    • running: False
    • schema_name_id: 2751
    • start_time: 2024-11-05 02:18:37
    • success: True
    • trace_id: 4155590362348235283
    • duration: 0:00:15.671066
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6667906
    • 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/2024-11-04/1730783781",
        "key": "raw/newbookdev_newbooklicenses/2024-11-04/1730783781/licenses.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooklicenses",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3953212510329288707,
        "service_name": "drive-thru",
        "span_id": 243769781994413385,
        "trace_id": 4021303816144627050
    }
}
    • running: False
    • schema_name_id: 2751
    • start_time: 2024-11-05 02:16:51
    • success: True
    • trace_id: 4021303816144627050
    • duration: 0:00:15.642126
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6667306
    • 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/2024-11-04/1730783675",
        "key": "raw/newbookdev_newbooklicenses/2024-11-04/1730783675/licenses.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooklicenses",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6452349054138287882,
        "service_name": "drive-thru",
        "span_id": 8112488891910691244,
        "trace_id": 5592224626583563745
    }
}
    • running: False
    • schema_name_id: 2751
    • start_time: 2024-11-05 02:00:45
    • success: True
    • trace_id: 5592224626583563745
    • duration: 0:00:13.320910
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6666378
    • 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/2024-11-04/1730783539",
        "key": "raw/newbookdev_newbooklicenses/2024-11-04/1730783539/licenses.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooklicenses",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14338586907210681524,
        "service_name": "drive-thru",
        "span_id": 9643489277759007900,
        "trace_id": 7978632736376217133
    }
}
    • running: False
    • schema_name_id: 2751
    • start_time: 2024-11-05 01:36:23
    • success: True
    • trace_id: 7978632736376217133
    • duration: 0:00:15.841487
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6665693
    • 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/2024-11-04/1730783319",
        "key": "raw/newbookdev_newbooklicenses/2024-11-04/1730783319/licenses.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooklicenses",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5816316541118230339,
        "service_name": "drive-thru",
        "span_id": 7302804999004303389,
        "trace_id": 7071157904266084958
    }
}
    • running: False
    • schema_name_id: 2751
    • start_time: 2024-11-05 01:18:19
    • success: True
    • trace_id: 7071157904266084958
    • duration: 0:00:13.217659
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6664953
    • 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/2024-11-04/1730782919",
        "key": "raw/newbookdev_newbooklicenses/2024-11-04/1730782919/licenses.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooklicenses",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15933076156213290546,
        "service_name": "drive-thru",
        "span_id": 9398357670484385218,
        "trace_id": 16115968230176816807
    }
}
    • running: False
    • schema_name_id: 2751
    • start_time: 2024-11-05 00:58:29
    • success: True
    • trace_id: 16115968230176816807
    • duration: 0:00:15.786641
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6663921
    • 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/2024-11-04/1730782754",
        "key": "raw/newbookdev_newbooklicenses/2024-11-04/1730782754/licenses.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbooklicenses",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13316841775808514584,
        "service_name": "drive-thru",
        "span_id": 13671773836259040673,
        "trace_id": 13017900805943117987
    }
}
    • running: False
    • schema_name_id: 2751
    • start_time: 2024-11-05 00:31:29
    • success: True
    • trace_id: 13017900805943117987
Partitions:
  • count: 0
  • ddl: None
  • name: None
  • state: 
    []
  • type: None
Schema:
  • attributes: 
    {
    "cancelled_by": "string",
    "cancelled_reason": "string",
    "cancelled_when": "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",
    "generated_by": "string",
    "generated_when": "string",
    "grant_date": "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",
    "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",
    "next_run": "string",
    "primary_license": "string",
    "privileges": "string",
    "prorata_start": "string",
    "sale_name": "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",
    "sold_by": "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",
    "template_id": "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",
    "type_id": "string"
}
  • created: 2024-11-05 23:10:28
  • 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`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `template_id`  string , `generate`  string , `type`  string , `type_id`  string , `name`  string , `sale_name`  string , `primary_license`  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 , `grant_date`  string , `next_run`  string , `prorata_start`  string , `generated_when`  string , `generated_by`  string , `sold_by`  string , `cancelled_when`  string , `cancelled_by`  string , `cancelled_reason`  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/2024-11-05/1730866539'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooklicenses`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooklicenses"
}
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:02:14",
        "disabled": false,
        "format": "raw",
        "id": 2751,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_drivethru",
            "table": "newbookdev_newbooklicenses"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "cancelled_by": "string",
            "cancelled_reason": "string",
            "cancelled_when": "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",
            "generated_by": "string",
            "generated_when": "string",
            "grant_date": "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",
            "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",
            "next_run": "string",
            "primary_license": "string",
            "privileges": "string",
            "prorata_start": "string",
            "sale_name": "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",
            "sold_by": "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",
            "template_id": "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",
            "type_id": "string"
        },
        "created": "2024-11-05 23:10:28",
        "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`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `template_id`  string , `generate`  string , `type`  string , `type_id`  string , `name`  string , `sale_name`  string , `primary_license`  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 , `grant_date`  string , `next_run`  string , `prorata_start`  string , `generated_when`  string , `generated_by`  string , `sold_by`  string , `cancelled_when`  string , `cancelled_by`  string , `cancelled_reason`  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/2024-11-05/1730866539'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbooklicenses`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbooklicenses"
        }
    },
    "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