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
    2. Custom Tables

    Custom SQL Query

    PreviousAdvanced Enrichment - SegmentationNextSegments & Custom Segments

    Last updated 5 months ago

    Your analyst can create a custom query on Presight and use them as a table for modeling data.

    You can find Custom Query Editor via Data Hub, tab Data Source

    Then, you can create a new table by your Query and Save Query

    Make sure you define the appropriate data type for all columns

    If you database is in Google BigQuery, the Column Data Type is fixed based on your raw tables. You can check the Column Data Type before saving.

    And name your Query

    After all, you can create Metrics and Dimensions from your newly created table as usual. For more information about how to create a Metric from data tables, check out the link below:

    ⚙️
    Choose data type for each column
    Name your Query