Data & Data Relationship

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 via Cube 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:

Table Restriction

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 Relationships