The easy-to-use open source Business Intelligence and Embedded Analytics tool that lets everyone work with data :bar_chart:
TypeScript analyticsbibusiness-intelligencebusinessintelligenceclojuredashboarddatadata-analysisdata-visualizationdatabasemetabasemysqlpostgrespostgresqlreportingslacksql-editorvisualization
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