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
DROP VIEW IF EXISTS v_view_log;
CREATE OR REPLACE VIEW v_view_log AS
(SELECT id, timestamp, coalesce(user_id, 0) AS user_id,
model AS entity_type,
model_id AS entity_id,
model || '_' || model_id AS entity_qualified_id,
embedding_client,
embedding_client_identifier,
embedding_route,
CASE WHEN embedding_client LIKE '%-preview' THEN TRUE ELSE FALSE END AS is_preview,
has_access,
context,
embedding_sdk_version,
metabase_version,
auth_method,
tenant_id,
embedding_hostname,
embedding_path,
user_agent,
sanitized_user_agent,
ip_address
FROM view_log)