Omni Integration Discovered Resources
Omni Integration Discovered Resources
Overview
The Omni integration discovers the following resources:
Omni Account
Omni Folder
Omni Model
Omni View
Omni Topic
Omni Dimension
Omni Measure
Omni Document
Omni Query
Omni Dashboard
Data Warehouse Tables (referenced by models and queries)
Users (when "Observe users" is enabled)
User groups (when "Observe groups" is enabled)
Omni Account
A single resource of type omni_account is observed for each configured Omni integration, representing the top-level Omni organization.
Properties
name
The organization or instance name
type
always omni_account
subtype
always omni_account
Omni Folder
Folders are organizational containers in Omni for organizing documents. Folders can be nested to create a hierarchy.
Properties
name
The folder name
type
always omni_folder
subtype
always omni_folder
owner
The owner of the folder
created_at
The timestamp when the folder was created
updated_at
The timestamp when the folder was last modified
Omni Semantic Layer
Omni Model
Models are semantic layers in Omni that provide business-friendly views of your data warehouse. They contain views and topics, and serve as the data source for workbooks and dashboards.
Properties
name
The model name
type
always omni_model
subtype
always omni_model
created_at
The timestamp when the model was created
updated_at
The timestamp when the model was last modified
Omni View
Views are defined within Omni models and represent tables or logical structures with fields. They can reference other views or database tables.
Properties
name
The view name
type
always omni_view
subtype
always omni_view
created_at
The timestamp when the view was created (when available)
updated_at
The timestamp when the view was last modified (when available)
Omni Topic
Topics are business-friendly abstractions within Omni models that group related views and fields for analysis.
Properties
name
The topic name
type
always omni_topic
subtype
always omni_topic
created_at
The timestamp when the topic was created (when available)
updated_at
The timestamp when the topic was last modified (when available)
Omni Dimension
Dimensions are dimensional fields within Omni views or topics, typically used for grouping and filtering in queries.
Properties
name
The dimension name
type
always omni_dimension
subtype
always omni_dimension
upstream_fields
URIs of upstream columns or fields this dimension depends on
normalized_data_type
Standardized data type
is_calculated
Whether this is a calculated dimension
Omni Measure
Measures are aggregatable fields within Omni views or topics, typically used for numeric summarization in queries.
Properties
name
The measure name
type
always omni_measure
subtype
always omni_measure
upstream_fields
URIs of upstream columns or fields this measure depends on
normalized_data_type
Standardized data type
is_calculated
Whether this is a calculated measure
Omni Data Analysis Layer
Omni Document
In Omni, documents is the main organization unit for Queries. A document can either have a dashboard or not. In Euno, we model the document as a container, whose children are either Omni Queries, and up to one Omni Dashboard.
Properties
name
The document name
type
always omni_document
subtype
always omni_document
description
The document description (when provided)
created_at
The timestamp when the document was created
updated_at
The timestamp when the document was last modified
owner
The owner of the document
Omni Query
Queries are individual tabs within an Omni workbook. Each query tab represents a pivot-table or SQL-based analysis.
Properties
name
The query tab name
type
always omni_query
subtype
always omni_query
Omni Dashboard
Dashboards are visualization documents in Omni that display charts, tables, and KPIs. They may be standalone or part of a workbook.
Properties
name
The dashboard name
type
always omni_dashboard
subtype
always omni_dashboard
description
The dashboard description (when provided)
created_at
The timestamp when the dashboard was created
updated_at
The timestamp when the dashboard was last modified
owner
The owner of the dashboard
Data Warehouse Tables
When an Omni model, view, or query references a data warehouse table, Euno automatically observes that table if it hasn't been discovered yet.
Properties
name
The table name
type
always table
subtype
always table
database
The database name
schema
The schema name
Users (user)
user)Users are discovered when "Observe users" is enabled in the Omni integration configuration.
name
User's email address (used as the identifier)
email_address
User's email address
label
User's display name from Omni
User Groups (user_group)
user_group)User groups are discovered when "Observe groups" is enabled in the Omni integration configuration.
name
Display name of the group
native_id
Group ID from Omni
subtype
Always omni for groups discovered from Omni
Relationships
Container Relationships
Omni Account โ Folders: Top-level folders are direct children of the account
Omni Account โ Models: Models are direct children of the account
Folders โ Subfolders: Folders can be nested within other folders
Folders โ Documents: Documents (workbooks and dashboards) belong to folders
Omni Model โ Views: Views belong to models
Omni Model โ Topics: Topics belong to models
Omni View โ Dimensions: Dimensions belong to views
Omni View โ Measures: Measures belong to views
Omni Topic โ Dimensions: Dimensions can belong to topics
Omni Topic โ Measures: Measures can belong to topics
Omni Document โ Omni Query: Query tabs are children of workbook documents
Omni Document โ Omni Dashboard: Dashboards can be children of documents
Lineage Relationships
Omni Query โ Omni View or Omni Topic: Queries are
downstreamof either an Omni View or an Omni TopicOmni Dashboard โ Omni Query: Dashboards are
downstreamof the Omni Queries that they include as tilesOmni Topic โ Omni View: Topics are
downstreamof the Omni Views that they includeOmni View โ Table: Views have
downstreamof the tables that they read from
Column-Level Lineage
Omni Dimension โ Table Columns: Dimensions that reference database columns have
upstream_fieldsset to those column URIsOmni Measure โ Table Columns: Measures that reference database columns have
upstream_fieldsset to those column URIs
User and Group Relationships
User Group -> User: users are
memberof auser_groupOmni Model -> User: When an Omni user is granted access ot an Omni model, the user is
memberof that Omni ModelOmni Model -> User Group: When an Omni Group is granted access ot an Omni model, the group is
memberof that Omni Model, creating a two-layer access structure
Last updated