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
-- audit_log
create index if not exists idx_audit_log_entity_qualified_id
on audit_log((case when model = 'Dataset' then 'card_' || model_id
when model_id is null then null
else lower(model) || '_' || model_id
end));
-- activity
create index if not exists idx_activity_entity_qualified_id
on activity((case when model = 'Dataset' then 'card_' || model_id
when model_id is null then null
else lower(model) || '_' || model_id
end));
-- field
create index if not exists idx_field_entity_qualified_id
on metabase_field(('field_' || id));
-- query_execution
create index if not exists idx_query_execution_card_qualified_id
on query_execution(('card_' || card_id));
-- user
create index if not exists idx_user_qualified_id
on core_user(('user_' || id));
create index if not exists idx_user_full_name
on core_user((first_name || ' ' || last_name));
-- view_log
drop index if exists idx_view_log_timestamp;
create index if not exists idx_view_log_model_id
on view_log(model_id);
create index if not exists idx_view_log_timestamp
on view_log(timestamp);
create index if not exists idx_view_log_entity_qualified_id
on view_log((model || '_' || model_id));