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
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 ;