Presight
  • 👋INTRODUCTION
    • What is Presight?
    • Core Concepts
      • Metrics
      • Events
      • Segments
        • Source Columns
        • Custom Segments
    • The Presight Workspace
      • Workspace Overview
      • The Data Docs
      • Data Library (Datahub)
    • ➡️DATA IN
      • Connect
        • Data Warehouse
        • Data Connectors
          • API Connector
          • Google Sheets Connection
          • CSV Import
          • Dimensional Dates (Dimdates table)
          • QuickBooks Online
          • HubSpot Connector
      • Sync
      • Tables & Columns
        • Browse & Edit
        • Primary Key
      • Governance
    • ⚙️MODEL
      • Data Relationships
        • Table Relationships
        • Hierarchy
      • Metrics
        • Create Metrics
        • Ownership & Permission
        • Deletion
      • Events
        • Creating Events
      • Custom Tables
        • Table Builder
          • Filter a Dataset
          • Simple Data Enrichment
          • Advanced Enrichment - Segmentation
        • Custom SQL Query
      • Segments & Custom Segments
        • Dimensions from Data Sources
        • Create a New Dimension
      • Formulas
        • Metric Formulas
        • Data Transformation Formulas
    • 📊ANALYSIS
      • The Data Docs
        • Explorations
          • Docs Widgets
        • Reports
        • Dashboards
        • Layout & Beautify
        • Organize
        • Collaboration
      • Data Widgets
        • Charts
          • Query Syntax
          • Data in a Chart
          • Interacting with a Chart
            • Breakdown
            • Chart Filter
            • Time Change
            • Chart Menu
            • View Constituent Records
            • Version views in Chart
          • Chart Configuration
        • Metric Table
          • Creating a Table
          • Interact with a Table
            • Adding Metrics
            • Adding Sections and Organizing metric list
            • Table Filter
            • Table Summaries
            • Quick Chart Creation from Table
            • Timeline Navigation
          • Table Menu
          • Table Breakdown
          • Breakdown Options
          • Interact with Table Metrics
          • [Advanced] Automatic Variance Calculation
        • Records Table
          • Accessing Data Records on-demand
      • Breakdowns & Filters
        • [Advanced] Dimension Path
      • Event Analytics
        • Event Funnel
        • Cohort
        • Event Path
      • Segmentations
        • Metric Segments
        • Filtered Segments
      • Ask AI (Beta)
        • Ask Presight
        • Presight AI in your Chat Tools
    • 📈PLANNING
      • Creating Versions
      • Interacting with Versions
      • Interacting with Future Data
      • Forecasting a Metric
    • 🏛️GOVERNANCE
      • Overview
      • Table Restriction
      • Metric Permission & Sharing
      • Doc Sharing
    • ⬇️DATA OUT
      • Export Data
    Powered by GitBook
    On this page
    1. MODEL

    Data Relationships

    PreviousGovernanceNextTable Relationships

    Last updated 1 month ago

    Why Tables Have Relationships

    In real-world scenarios, data is rarely confined to a single table. Information is often distributed across multiple tables that are logically connected. This is where relationships between tables come into play. Table relationships define how data in one table corresponds to data in another table, enabling more complex and meaningful queries and analyses.

    Types of Table Relationships

    • Has one (One-to-One Relationship): Each row in one table corresponds to exactly one row in another table.

    • Has many (One-to-Many Relationship): A single row in one table can relate to multiple rows in another table. For example, a Customer Table (one side) can relate to multiple rows in an Orders Table (many side), representing the orders placed by each customer.

    • Belongs to (Many-to-One Relationship): Many rows from one table are related to a single row in another table. For instance, multiple orders in the Orders Table can relate back to a single entry in the Customer Table.

    Getting Started with Data Relationships on Presight

    Locate your Data

    All tables connected with Presight are located at Data Hub, tab Data:

    Tab Data will show all the data sources based on your workspace configurations:

    • PostgreSQL: you database name connected to Presight via API Connector, this can be PostgreSQL, Amazon Redshift, Google BigQuery or any other cloud providers you are using. This will list all the tables coming from the database.

    • Query: your Custom Queries

    • Google Sheet: your Google Sheets Connection

    • Custom: all tables created on Presight via Table Builder

    Raw Table view

    You can view your raw tables/cubes from by clicking on View at the Table's row.

    You can change column permission, filter specific values and change data type at each column at the raw table:

    If you are the admin of your workspace, you can edit Table Restriction and Column Restriction for each table. Details for Access Restriction are in the following link:

    Data Relationship

    You can view Relationship between tables by dragging them to the Diagram Board:

    You can also make or edit Relationships here.

    Instructions for making and editing Relationships in the documentations below:

    Table Restriction
    Table Relationships
    ⚙️
    • Why Tables Have Relationships
    • Types of Table Relationships
    • Getting Started with Data Relationships on Presight
    • Locate your Data
    • Raw Table view
    • Data Relationship