Skip to content

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

952 B
Raw Blame
CREATE OR REPLACE SQL SECURITY INVOKER
VIEW v_users AS
SELECT id AS user_id,
       concat('user_', id) AS entity_qualified_id,
       type,
       CASE WHEN type = 'api-key' THEN null ELSE email END as email,
       first_name,
       last_name,
       COALESCE(concat(first_name, ' ', last_name),
                first_name,
                last_name) as full_name,
       date_joined,
       last_login,
       updated_at,
       is_superuser AS is_admin,
       is_active,
       sso_source,
       locale
FROM core_user
UNION
SELECT 0 AS user_id,
       'user_0' AS entity_qualified_id,
       'anonymous' as type,
       NULL AS email,
       'External' AS first_name,
       'User' AS last_name,
       'External User' AS full_name,
       NULL AS date_joined,
       NULL AS last_login,
       NULL AS updated_at,
       FALSE AS is_admin,
                NULL AS is_active,
                NULL AS sso_source,
                NULL AS locale ;