To connect to a database other than Google Analytics you will need an enterprise plan.
Contact sales

What are Identifiers?

Identifiers represent real-world concepts within a business context, like customers, transactions, or ad campaigns. Analyses often revolve around specific identifiers such as customer churn or annual recurring revenue modeling. These identifiers are depicted in semantic models using id columns, acting as join keys linking other semantic models in the semantic graph.

Identifiers offer a clear structure to the underlying data, enabling more coherent and insightful analysis.

How to Define Identifiers

Every identifier requires a name and type. The name can reference the key column name from the data table, or function as an alias with the column name referenced in the expr parameter.

Name

Either refers to the key column name from the underlying data table or serves as an alias with the column name referenced in the expr parameter.

Type

This identifies the identifier’s role in join logic and determines the nature of the join. Types include: Primary, Foreign and Unique.

Expression (optional)

Indicates the underlying column that signifies the identifier. If not provided, We default to the identifier name.

How to create and edit an identifier

In the Catalog section click click on a table you want to set up an identifier for. Then click on the Entities tab.

Specification for Identifiers

Identifiers are illustrated using these parameters:

identifiers:
  - name: [name]
    type: [Primary or Natural or Foreign or Unique]
    description: [description of the field or role]
    expr: [column name or expression, defaults to the name if not provided]

For instance, in a semantic model detailing sales, identifiers can be defined as:

identifiers:
  - name: transaction
    type: primary
    expr: id_transaction
  - name: order
    type: foreign
    expr: id_order
  - name: user
    type: foreign
    expr: substring(id_order from 2)

Identifier Types and Join Logic

We leverage different join logics based on the identifier type:

This identifier type signifies that each row in the table has only one unique record, encompassing all records in the data platform.


Identifiers (or join keys) in a semantic model are identified by their name. They need to be unique within a model, but not across different models.

Utilizing Identifiers as Dimensions

Identifiers can also function as dimensions, permitting the aggregation of a metric to the identifier’s granularity.

Wrapping up

Identifiers are foundational, establishing relationships and ensuring seamless data analysis. Through a keen understanding of identifiers and their applications, businesses can derive richer insights and make data-driven decisions.