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. DATA IN
  2. Connect
  3. Data Connectors

API Connector

PreviousData ConnectorsNextGoogle Sheets Connection

Last updated 1 year ago

Presight facilitates communication between Presight platform and different software systems or applications by allowing them to exchange data through APIs. Currently, Presight supports direct connection from following databases:

  • Google BigQuery

  • PostgreSQL

  • MSSQL

  • MySQL

Steps API Connector

  1. Select Use Data Connectors

  1. Select a Data Connector

  1. Input Connector information, then click Next

  1. Then, review your tables before connecting: clicking on each table to review:

Then click Next to continue connecting.

  1. After successfully connecting click Back to Data Hub to view your tables and dimensions.

  1. Join the Date column of your transactional tables to Date column of Presight's Dimdates table. Then, you can start creating metrics.

Instructions for joining with the Dimdates table, creating metrics and editing dimensions in the documentations below:

Our support team is available to support via support@presight.io.

If your database type is not in the list, please contact our support team for assistance.

➡️
Dimensional Dates (Dimdates table)
Creating a new Dimension