Datasources

How to navigate the Datasources page

Ed Campbell avatar
Written by Ed Campbell
Updated over a week ago

One a datasource has been added to the Report Engine, you will be able to see some basic information and configure necessary changes.

Example:

Above, the table dcm_data_aggregate has been added to the Report Engine. 

Name
This is the datasource name and will match the 'table name' field unless you edit this text box which will then update in the datasources tab sidebar. 

Integration
Allows you to specify whether the datasource belongs to a specific integration. In this case, the dcm_data_aggregate table is a report that is pulled via the Campaign Manager API so  it belongs to the Campaign Manager integration. 

This dropdown is only important if you would like to make the table available in Manage data.

If this is left blank the table will appear under 'Other datasources' in Manage Data.

Table Name
This is the table name in mySQL database. We request that you do not touch this field as this is managed by Bright Analytics.

Date Field
This is important for 'Data' tables and is usually  automatically be detected if the column in your datasource is called 'Date'. But, sometimes the date field in your data might have a different name e.g. the Facebook API returns date_start. In cases like these,  you will be able to select the date field in the table.

 If you try to create a metric based on a data table where the date has not been specified this will trigger an error message. Meta tables should be left as none. 

For more information on Data and Meta tables please use the link provided. 

Visibility
This is where you can specify whether a datasource is made available in Manage data.
For more information on this read here.

Special Type
Here you can specify whether your table is a 'Meta' table. If your table is a Meta (lookup) table,  then you must input 'lookup' into the text box as this will allow you to create joins to the meta table when creating dimensions. 

Info
A section to write a description for your datasource.

Last Updated
This will display the time at which the datasource was last updated.

Update Start Date
The start date for the data that was pulled in via API

Update End Date
The end date for the data that was pulled in via API


Columns View

You can view all the columns in the table by clicking on the 3 dots underneath the Fields section:

This will expand to show all columns in the table:

The first column is the Field ID which can be used to reference fields in the report engine.

The second column can be used to rename fields to a more user friendly name - these names will also appear in Manage data.

The third column are the table column names which should not be changed. 

Visibility refers to visibility in manage data. Please refer to this article for more information.

Joins
This section is where you can configure Utility joins. For more information on Utility Joins please read the article.

Data Overview
This gives you a preview of the first few rows of data in your table. This is useful if you are not sure what content is in the fields.

Data Changes
If you have made your table available in Manage Data you will be able to see the last 50 changes made to the table via Manage Data in this section.

 

Did this answer your question?