LogoLogo
Home
  • Verb Documentation
  • Release Notes
  • Environment Settings
    • Authentication
      • Authentication Endpoint
  • Data Sources
    • Ingestion Methods
    • Table Sync Intervals
    • Data Source Integrations
      • Network Permissions
      • Microsoft SQL Server
      • PostgreSQL
      • MongoDB
      • Snowflake
      • Elasticsearch
      • DynamoDB
      • Google BigQuery
      • Firebase Cloud Firestore
      • Supabase
      • Cloud Files
      • Flat Files
    • Data Synchronization
      • Synchronization Methods
        • Full Synchronization
        • Incremental Synchronization
        • Change Tracking
        • Change Data Capture
      • Synchronization Intervals
      • Synchronization Status
        • Pausing and Resuming
      • Synchronization History
      • Schema Changes
      • Row Filtering
      • Schemaless & NoSQL
      • Managing Connections
      • Troubleshooting
  • Models
    • What is a Model
      • Elements of a Model
      • Model Management
    • Building a Model
      • Add/Remove Data
      • Relationships
      • Row-Level Security
      • Transformations
    • Advanced Model Information
      • Database Keys
      • Unstructured Data
      • Publishing Updates
      • Troubleshooting
      • Automatic Modeling
  • Data Transformations
    • What is a Transformation
      • Elements of a Transformation
      • Transformation Management
    • Building Transformations
      • Creating Transformations
      • Configure Transformation Steps
      • Transformation Steps
        • Calculator
        • Manipulate Text
        • Map Values
        • Remove Duplicates
        • Date Operation
        • Select Columns
        • Change Type
        • Group Data
        • Filter Data
        • Join Data
        • Append Rows
        • Pivot Data
        • Rank Data
        • Window Data
      • Complete and Publish
  • Collections
    • What is a Collection
      • Elements of a Collection
    • Building Collections
    • API Collections
      • Building API Collections
        • Connect Data Sources
        • Data Model
        • Select Data
        • Authentication and Security
        • Data Access API Keys
        • Data Access API Documentation
      • API Collection Versions
    • Advanced Collection Options
      • Time Zones
      • Currency Symbols
  • Tiles
    • What is a Tile
      • Elements of a Tile
    • Tile Management
      • Tile Data
    • Tile Actions
    • Custom Date Formats
    • Currency Conversion
  • Design Themes
    • What is a Design Theme
    • General Theme Settings
    • Data Visualization Settings
  • Account Settings
    • Integrations
      • Slack
  • Legal
    • Terms of Use
    • Privacy Policy
    • Subscription Agreement Terms
    • Subscription Agreement
    • Data Processing Addendum
Powered by GitBook
On this page
  • Create a Relationship
  • Suggested Relationships
  • Remove Relationships

Was this helpful?

  1. Models
  2. Building a Model

Relationships

Relationships connect data and create more options when building collections

PreviousAdd/Remove DataNextRow-Level Security

Last updated 3 years ago

Was this helpful?

Create a Relationship

Once you’ve added at least two tables to the model canvas you will be able to create a relationship between the tables.

To establish a relationship start by selecting a table on the canvas. A circular menu will appear with options on this table, select “Create Relationship”.

Upon selecting “Create Relationship” you will have an arrow on your cursor, select the other table.

After two tables are selected, a left panel will slide out where you will then select the columns used to relate the data from the two tables. Next, select the “+” button and the relationship will be established.

Suggested Relationships

Verb creates Suggested Relationships for tables in your model that are based on existing relationships in your database and column and tables names.

You can find suggestions at the top of the left panel or in the table menu on the canvas and left panel. To add the suggested relationship select the blue plus button to the right of the suggested relationship.

This button is only visible when there are suggested relationships among the tables added to the model canvas.

Remove Relationships

To remove a relationship, select the relationship line and then select the trash can that appears on the highlighted line.

When removing a Relationship, Verb will validate that the Relationship is not used in a collection or a transformation. If the Relationship is used in a collection the system will alert you to which collections will be impacted. You cannot remove a relationship used in any step of a transformation.