Metabase is an open-source business intelligence platform that transforms raw data into actionable insights through intuitive dashboards, automated reports, and self-service analytics. Designed for both technical and non-technical users, it connects seamlessly to various databases and enables organizations to democratize data access across teams.

Default hierarchy

In the chart below, you will find the organizational structure of Metabase objects. Objects are represented in green and folders are in yellow.

inline-svg-1

Object types

Dawiso ingests the following objects from Metabase:

Database

Maps to Metabase database object types.

Source AttributeTarget Attribute in Dawiso
descriptionScanned Description
dbnameDB Name (Long)
timezoneTimezone
points_of_interestPoints of Interest
caveatsCaveats
engineDatabase Engine
dbms_flavorDatabaes Flavor
dbms_versionDatabase Version
auto_run_queriesAuto Run Queries
is_full_syncIs Full Sync?
initial_sync_statusInitial Sync Status
cache_field_values_scheduleCahce Field Values Schedule
metadata_sync_scheduleMetadata Sync Schedule
uploads_enabledUploads Enabled
creator_idCreator ID
created_atCreated At
updated_atUpdated At

Table

Maps to Metabase table object types.

Source AttributeTarget Attribute in Dawiso
descriptionScanned Description
entity_typeEntity Type
view_countView Count
schemaSchema
activeActive
field_orderField Order
visibility_typeVisibility Type
show_in_getting_startedShow in Getting Started
points_of_interestPoints of Interest
caveatsCaveats
estimated_row_countEstimated Row Count
field_countField Count
initial_sync_statusInitial Sync Status
is_uploadIs Upload
created_atCreated At
updated_atUpdated At

Field

Maps to Metabase field object types.

Source AttributeTarget Attribute in Dawiso
descriptionScanned Description
display_nameDisplay Name
database_typeDatabase Type
base_typeBase Type
effective_typeEffective Type
semantic_typeSemantic Type
points_of_interestPoints of Interest
caveatsCaveats
positionPosition
database_positionDatabase Position
custom_positionCustom Position
activeActive
visibility_typeVisibility Type
preview_displayPreview Display
database_requiredDatabase Required
database_is_auto_incrementIs Auto Increment
database_indexedDatabase Indexed
database_partitionedDatabase Partitioned
fingerprint_versionFingerprint Version
fk_target_field_idFK Target Field ID
has_field_valuesHas Field Values
last_analyzedLast Analyzed
created_atCreated At
updated_atUpdated At

Collection

Maps to Metabase collection object types.

Source AttributeTarget Attribute in Dawiso
descriptionScanned Description
authority_levelAuthority Level
archivedCollection Archived
slugCollection Slug
can_writeCan Write
personal_owner_idPersonal Owner ID
locationLocation
namespaceNamespace
is_personalIs Personal
created_atCreated At
can_deleteCan Delete

Dashboard

Maps to Metabase dashboard object types.

Source AttributeTarget Attribute in Dawiso
descriptionScanned Description
archivedArchived
view_countView Count
collection_positionCollection Position
enable_embeddingEnable Embedding
show_in_getting_startedShow in Getting Started
widthWidth
points_of_interestPoints of Interest
caveatsCaveats
auto_apply_filtersAuto Apply Filters
cache_ttlCache TTL
public_uuidPublic UUID
entity_idEntity ID
creator_idCreator ID
creator_emailCreator E-Mail
creator_nameCreator Name
created_atCreated At
updated_atUpdated At
last_viewed_atLast Viewed At
initially_published_atInitially Published At
last_edited_byLast Edited By
last_edited_atLast Edited At
parameter_countParameter Count

Collection Card, Dashboard Card, Metric, Model

Maps to Metabase card (question) object types.

Source AttributeTarget Attribute in Dawiso
descriptionScanned Description
archivedArchived
query_typeQuery Type
database_idDatabase ID
table_idTable ID
collection_idCollection ID
creator_idCreator ID
made_public_by_idMade Public by ID
enable_embeddingEnable Embedding
entity_idEntity_ID
created_atCreated At
updated_atUpdated At
public_uuidPublic UUID
cache_ttlCache TTL
result_metadataResult Metadata
typeType