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_content;
create or replace view v_content as
select
action.id as entity_id,
'action_' || action.id as entity_qualified_id,
'action' as entity_type,
created_at,
updated_at,
creator_id,
name,
description,
cast(null as int) as collection_id,
made_public_by_id as made_public_by_user,
cast(null as boolean) as is_embedding_enabled,
null::bool as is_verified,
archived,
type as action_type,
model_id as action_model_id,
null as collection_is_official,
null as collection_is_personal,
null as question_viz_type,
null as question_database_id,
cast(null as boolean) as question_is_native,
cast(null as timestamp) as event_timestamp
from action
union
select
collection.id as entity_id,
'collection_' || collection.id as entity_qualified_id,
'collection' as entity_type,
created_at,
null as updated_at,
null as creator_id,
name,
description,
null as collection_id,
null as made_public_by_user,
null as is_embedding_enabled,
null::bool as is_verified,
archived,
null as action_type,
null as action_model_id,
case when authority_level='official' then true else false end as collection_is_official,
case when personal_owner_id is not null then true else false end as collection_is_personal,
null as question_viz_type,
null as question_database_id,
null as question_is_native,
null as event_timestamp
from collection
union
select
report_card.id as entity_id,
'card_' || report_card.id as entity_qualified_id,
type as entity_type,
created_at,
updated_at,
creator_id,
name,
description,
collection_id as collection_id,
made_public_by_id as made_public_by_user,
enable_embedding as is_embedding_enabled,
case when is_verified then true else false end as is_verified,
archived,
null as action_type,
null as action_model_id,
null as collection_is_official,
null as collection_is_personal,
display as question_viz_type,
'database_' || database_id as question_database_id,
case when query_type='native' then true else false end as question_is_native,
null as event_timestamp
from report_card
left join (
select
moderated_item_type || '_' || moderated_item_id as entity_qualified_id,
case when status = 'verified' then true else false end as is_verified
from moderation_review
where most_recent
) as moderation on 'card_' || report_card.id = moderation.entity_qualified_id
union
select
report_dashboard.id as entity_id,
'dashboard_' || report_dashboard.id as entity_qualified_id,
'dashboard' as entity_type,
created_at,
updated_at,
creator_id,
name,
description,
collection_id as collection_id,
made_public_by_id as made_public_by_user,
enable_embedding as is_embedding_enabled,
case when is_verified then true else false end as is_verified,
archived,
null as action_type,
null as action_model_id,
null as collection_is_official,
null as collection_is_personal,
null as question_viz_type,
null as question_database_id,
null as question_is_native,
null as event_timestamp
from report_dashboard
left join (
select
moderated_item_type || '_' || moderated_item_id as entity_qualified_id,
case when status = 'verified' then true else false end as is_verified
from moderation_review
where most_recent
) as moderation on 'dashboard_' || report_dashboard.id = moderation.entity_qualified_id
union
select
event.id as entity_id,
'event_' || event.id as entity_qualified_id,
'event' as entity_type,
event.created_at,
event.updated_at,
event.creator_id,
event.name,
event.description,
timeline.collection_id,
null as made_public_by_user,
null as is_embedding_enabled,
null::bool as is_verified,
event.archived,
null as action_type,
null as action_model_id,
null as collection_is_official,
null as collection_is_personal,
null as question_viz_type,
null as question_database_id,
null as question_is_native,
timestamp as event_timestamp
from timeline_event event
left join timeline on event.timeline_id = timeline.id