adding l4c_demo via dev-stanley-yang-8xqf Change-Id: I5cb7e745e6d9fa6b8fe891f5ed70c2ba0cb9a219
diff --git a/l4c_demo.view.lkml b/l4c_demo.view.lkml new file mode 100644 index 0000000..faa4adb --- /dev/null +++ b/l4c_demo.view.lkml
@@ -0,0 +1,31 @@ +######################## +# Project: L4C Testing +# Author: Data Team +# Date: 04/19/2021 +####################### + +view: l4c_demo { + + sql_table_name: information_schema.ALL_PLUGINS ;; + + dimension: is_plugin_name_archive { + description: "Returns yes if the plugin name is archive" + type: yesno + sql: ${plugin_name} = "ARCHIVE" ;; + } + + dimension: plugin_name { + description: "The name used to refer to the plugin in statements INSTALL PLUGIN and UNINSTALL PLUGIN." + view_label: "Plug-In" + label: "Name" + type: string + 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 ;; + } + +}