Creating a Data Mart Configuration

Overview

This page explains how to set up a Data Mart Configuration in trocco.

Data Mart

In trocco, you can transform and model data stored in your data warehouse with SQL, using the Data Mart feature.
The following documents explain how to set up and run a Data Mart Configuration:

Create a Data Mart Configuration by following the steps below:

1. From the main page in trocco, access the Create Data Mart Configuration page in one of the following ways:

   a. Under Data Mart Configurations, click Add New.

   

   b. From the side menu under the Data Mart tab, click Data Mart Configurations, and then click Create New at the top right of the page.

   

   

2. Selecting a data warehouse.

   Select the data warehouse you wish to use for creating your Data Mart Configuration.
   In this tutorial we will use Google BigQuery.

3. Fill in the required fields and save your settings.

   After completing the required fields, click Confirm at the bottom of the page. Next, from the confirmation page, click Apply.

The information required when creating a Data Mart Configuration varies depending on your data warehouse.
It may be necessary to set up and grant permissions in your data warehouse.

For more information on each data warehouse service, see our Data Mart documentation.