- Getting Started
- Managing Tenants and Spaces
- Using Development Mode
- Using Datasources
- Connecting Databases
- MySQL
- Postgres
- Amazon RedShift
- Microsoft SQL Server
- BigQuery
- Snowflake
- MongoDB
- ClickHouse
- Hive
- ETable
- Impala
- Oracle
- Teradata
- Google Sheets
- Google Analytics
- Public Dataset
- Using Projects
- Using Datasets and Reports
- Using Visualizations
- Using Dashboards
Create the Dataset
CONTENTS
Home
- Overview
- Getting Started
- Managing Tenants and Spaces
- Using Development Mode
- Using Datasources
- Connecting Databases
- MySQL
- Postgres
- Amazon RedShift
- Microsoft SQL Server
- BigQuery
- Snowflake
- MongoDB
- ClickHouse
- Hive
- ETable
- Impala
- Oracle
- Teradata
- Google Sheets
- Google Analytics
- Public Dataset
- Using Projects
- Using Datasets and Reports
- Using Visualizations
- Using Dashboards
The first step is to create a Dataset containing the tables needed for the model. For the Tennis example, you open the ATPTennisData Project and select the tables.
- Start from the ATPTennisData Project. Select:
Develop > Data Models > ATPTennisData
- Click on
Create table from datasource to Add a table from Datasource.
Another way to add a table to datasource is by clicking on + Add and then, Import table from datasource.
-
Select TennisData for the Datasource
-
Expand the Players schema, and select the tables as shown:
Then, click on Import.
Notice the changes to your project file:
- New Tables added to the Files menu and as tabs on the ribbon.
- Table and columns details are visible in Visual mode.
IN THIS PAGE
Sign up for a forever free account!
Connect to leading SQL databases
Build visual data models without learning a new language
Create two dashboards and ten reports for free