commit 6a0b47a35a64959c29ecaa6af9dbe94e57f53137
author Stanley Yang <yangstanley@google.com> Fri May 14 21:02:10 2021 +0000
committer Stanley Yang <yangstanley@google.com> Fri May 14 21:02:10 2021 +0000
tree b4f1c7a72d44602b695b693fc5e65feaa5205933
parent 5cce83cccbed1899cdfcd7f5c4efab9c038d5acd

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 ;;
+  }
+
 }