adding is_plugin_name_archive
Change-Id: Ic3fa82d551d5263baae40c647ee8612468576d3c

l4c_demo.view.lkml

diff --git a/l4c_demo.view.lkml b/l4c_demo.view.lkml
index 57070a8..faa4adb 100644
--- a/l4c_demo.view.lkml
+++ b/l4c_demo.view.lkml
@@ -8,10 +8,10 @@
 
   sql_table_name: information_schema.ALL_PLUGINS ;;
 
-  dimension: plugin_type {
-    description: "The type of plugin, such as STORAGE ENGINE, INFORMATION_SCHEMA, or AUTHENTICATION."
-    type: string
-    sql: ${TABLE}.PLUGIN_TYPE ;;
+  dimension: is_plugin_name_archive {
+    description: "Returns yes if the plugin name is archive"
+    type: yesno
+    sql: ${plugin_name} = "ARCHIVE" ;;
   }
 
   dimension: plugin_name {
@@ -22,4 +22,10 @@
     sql: ${TABLE}.PLUGIN_NAME ;;
   }
 
+  dimension: plugin_type {
+    description: "The type of plugin, such as STORAGE ENGINE, INFORMATION_SCHEMA, or AUTHENTICATION."
+    type: string
+    sql: ${TABLE}.PLUGIN_TYPE ;;
+  }
+
 }