Using the Data Union Feature for Your Data Blocks in the Cognetik Cloud Connector

What is the Data Union feature? How is it used?

What is the Data Union feature?

Data blocks allow you to pull data from multiple accounts/cloud platforms in Tableau in one query. The Cognetik Cloud Connector essentially mashes up multiple data extracts into one data extract, which simplifies the setup and management of these data extracts.

Learn more about data blocks in this article.

To use data blocks, you fill in two separate queries in one extract. When you submit your query, your data is returned in one table, with a separate column for each parameter in the query per data block.

To go even further than this, we’ve now added the ‘Data Union’ feature which gives you the possibility to merge two data blocks into one single table header. This means that if you query data from different accounts, the matching parameters will be aggregated in one column. This comes in handy if you want to aggregate data from different accounts.

To better understand how this feature works, we’re going to submit a query with two data blocks (same query from two different Facebook Pages accounts), with and without the Data Union feature.

Query 1 

Data blocks without the Data Union feature

Data block A - Facebook account A

2019-08-06_1837

 

2019-08-06_1839

Data block B - Facebook account B

2019-08-06_1841

 

2019-08-06_1842

This query will return your data in separate columns (different column for the same parameters based on data blocks)

2018-12-13_1916

Query 2 

Recreate Query 1 (two data blocks) with ‘Union’ button on

2019-08-06_1843

The Data Union feature will merge your data blocks into one single table, with one column per parameter, across your data blocks.

2018-12-13_1916_002