Prep - Direct query

This section helps you to connect directly to your data warehouse in Datama Prep without writing a query

What is table connect ?

Table connect allow you to connect directly to your database and filter accordingly.
The advantages of table connect is to provide an easy to go interface and a plug & play way to connect your data to Datama. When filtering, the data will be automatically changed according to the filter you set up and this works even in our solutions

How does it work

Available connectors

For now, table connect is only limited to:

Step by step on BigQuery

First, connect to you bigquery account using your credentials, then, select a project and click on the “Use Table Connect Instead” button

1. Select Dimension and metrics

The first think you have to do, is to select dimensions and metrics that you would like to use from your database. The filtering comes at the end. When double-clicking on a pill, it’ll transform it from a dimension or metrics to the opposite form

2. Define your KPI & Metrics relation

Then you can define your KPI. Please see this section for what a KPI is

3. Filtering

This is where the True power of Table connect comes in.
This feature allows you to select date range, comparison and much more and the data will only be downloaded when these are set, limiting the size of the overall data.

3. Analysis

When you’re done, just click on the done button and your analysis will popout.

3 bis. Change in the analysis

You can change what you are analyzing directly on the overhead pannel (here for example, we changed the dimension we are analyzing to “Region” EU vs US)

You can also change these in Prep on the block too.