########################
# 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 such as 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 ;;
  }

}