Skip to content

The easy-to-use open source Business Intelligence and Embedded Analytics tool that lets everyone work with data :bar_chart:

6.9 KB
Raw Blame
name: People
description: Everyone who's ever had an account in your Metabase, including both active and deactivated accounts.
entity_id: 0wVIfjBJWclD0lKeABYYl
created_at: '2023-06-08T14:18:48.912368Z'
creator_id: [email protected]
display: table
collection_id: vG58R8k-QddHWA7_47umn
collection_position: 12
query_type: query
database_id: Internal Metabase Database
table_id: [Internal Metabase Database, public, v_users]
parameters: []
parameter_mappings: []
dataset_query:
  database: Internal Metabase Database
  stages:
  - source-table: [Internal Metabase Database, public, v_users]
    lib/type: mbql.stage/mbql
  lib/type: mbql/query
result_metadata:
- base_type: type/Integer
  coercion_strategy: null
  description: null
  display_name: User ID
  effective_type: type/Integer
  field_ref:
  - field
  - [Internal Metabase Database, public, v_users, user_id]
  - null
  fk_target_field_id: null
  id: [Internal Metabase Database, public, v_users, user_id]
  name: user_id
  semantic_type: type/PK
  settings: null
  visibility_type: normal
- base_type: type/Text
  coercion_strategy: null
  description: null
  display_name: Entity Qualified ID
  effective_type: type/Text
  field_ref:
  - field
  - [Internal Metabase Database, public, v_users, entity_qualified_id]
  - null
  fk_target_field_id: null
  id: [Internal Metabase Database, public, v_users, entity_qualified_id]
  name: entity_qualified_id
  semantic_type: null
  settings: null
  visibility_type: normal
- base_type: type/Text
  coercion_strategy: null
  description: ''
  display_name: Type
  effective_type: type/Text
  field_ref:
  - field
  - [Internal Metabase Database, public, v_users, type]
  - null
  fk_target_field_id: null
  id: [Internal Metabase Database, public, v_users, type]
  name: type
  semantic_type: type/Category
  settings: null
  visibility_type: normal
- base_type: type/Text
  coercion_strategy: null
  description: null
  display_name: Email
  effective_type: type/Text
  field_ref:
  - field
  - [Internal Metabase Database, public, v_users, email]
  - null
  fk_target_field_id: null
  id: [Internal Metabase Database, public, v_users, email]
  name: email
  semantic_type: type/Name
  settings: null
  visibility_type: normal
- base_type: type/Text
  coercion_strategy: null
  description: null
  display_name: First Name
  effective_type: type/Text
  field_ref:
  - field
  - [Internal Metabase Database, public, v_users, first_name]
  - null
  fk_target_field_id: null
  id: [Internal Metabase Database, public, v_users, first_name]
  name: first_name
  semantic_type: type/Name
  settings: null
  visibility_type: normal
- base_type: type/Text
  coercion_strategy: null
  description: null
  display_name: Last Name
  effective_type: type/Text
  field_ref:
  - field
  - [Internal Metabase Database, public, v_users, last_name]
  - null
  fk_target_field_id: null
  id: [Internal Metabase Database, public, v_users, last_name]
  name: last_name
  semantic_type: type/Name
  settings: null
  visibility_type: normal
- base_type: type/Text
  coercion_strategy: null
  description: null
  display_name: Full Name
  effective_type: type/Text
  field_ref:
  - field
  - [Internal Metabase Database, public, v_users, full_name]
  - null
  fk_target_field_id: null
  id: [Internal Metabase Database, public, v_users, full_name]
  name: full_name
  semantic_type: type/Name
  settings: null
  visibility_type: normal
- base_type: type/DateTimeWithLocalTZ
  coercion_strategy: null
  description: null
  display_name: Date Joined
  effective_type: type/DateTimeWithLocalTZ
  field_ref:
  - field
  - [Internal Metabase Database, public, v_users, date_joined]
  - {temporal-unit: default}
  fk_target_field_id: null
  id: [Internal Metabase Database, public, v_users, date_joined]
  name: date_joined
  semantic_type: type/JoinTimestamp
  settings: null
  unit: default
  visibility_type: normal
- base_type: type/DateTimeWithLocalTZ
  coercion_strategy: null
  description: null
  display_name: Last Login
  effective_type: type/DateTimeWithLocalTZ
  field_ref:
  - field
  - [Internal Metabase Database, public, v_users, last_login]
  - {temporal-unit: default}
  fk_target_field_id: null
  id: [Internal Metabase Database, public, v_users, last_login]
  name: last_login
  semantic_type: null
  settings: null
  unit: default
  visibility_type: normal
- base_type: type/DateTime
  coercion_strategy: null
  description: null
  display_name: Updated At
  effective_type: type/DateTime
  field_ref:
  - field
  - [Internal Metabase Database, public, v_users, updated_at]
  - {temporal-unit: default}
  fk_target_field_id: null
  id: [Internal Metabase Database, public, v_users, updated_at]
  name: updated_at
  semantic_type: type/UpdatedTimestamp
  settings: null
  unit: default
  visibility_type: normal
- base_type: type/Boolean
  coercion_strategy: null
  description: null
  display_name: Is Admin
  effective_type: type/Boolean
  field_ref:
  - field
  - [Internal Metabase Database, public, v_users, is_admin]
  - null
  fk_target_field_id: null
  id: [Internal Metabase Database, public, v_users, is_admin]
  name: is_admin
  semantic_type: type/Category
  settings: null
  visibility_type: normal
- base_type: type/Boolean
  coercion_strategy: null
  description: null
  display_name: Is Active
  effective_type: type/Boolean
  field_ref:
  - field
  - [Internal Metabase Database, public, v_users, is_active]
  - null
  fk_target_field_id: null
  id: [Internal Metabase Database, public, v_users, is_active]
  name: is_active
  semantic_type: type/Category
  settings: null
  visibility_type: normal
- base_type: type/Text
  coercion_strategy: null
  description: null
  display_name: Sso Source
  effective_type: type/Text
  field_ref:
  - field
  - [Internal Metabase Database, public, v_users, sso_source]
  - null
  fk_target_field_id: null
  id: [Internal Metabase Database, public, v_users, sso_source]
  name: sso_source
  semantic_type: type/Source
  settings: null
  visibility_type: normal
- base_type: type/Text
  coercion_strategy: null
  description: null
  display_name: Locale
  effective_type: type/Text
  field_ref:
  - field
  - [Internal Metabase Database, public, v_users, locale]
  - null
  fk_target_field_id: null
  id: [Internal Metabase Database, public, v_users, locale]
  name: locale
  semantic_type: null
  settings: null
  visibility_type: normal
- base_type: type/Integer
  coercion_strategy: null
  description: null
  display_name: Tenant ID
  effective_type: type/Integer
  field_ref:
  - field
  - [Internal Metabase Database, public, v_users, tenant_id]
  - null
  fk_target_field_id: [Internal Metabase Database, public, v_tenants, tenant_id]
  id: [Internal Metabase Database, public, v_users, tenant_id]
  name: tenant_id
  semantic_type: type/FK
  settings: null
  visibility_type: normal
visualization_settings: {column_settings: null, table.cell_column: locale, table.pivot_column: sso_source}
card_schema: 23
serdes/meta:
- {id: 0wVIfjBJWclD0lKeABYYl, label: people, model: Card}
type: model