How to join connector data with Peaka Table data

This article provides a step-by-step guide on how to join the data from a connector with the data from a Peaka Table and use the result in your Peaka application.

​

Prerequisites

Before joining data from a connector and a Peaka Table, ensure that you have the necessary data sources available. You will need:

1. Peaka Table: If you don’t have a Peaka Table yet, you can create one by following this guide.

2. Connector data: You should have data from a connector source. If you don’t have any connector data, you can connect your data using a SaaS connector with the help of this article.

​

Step-by-step Guide

Follow these steps to join and use the data from your connector and Peaka Table:

1. Create an SQL query: You’ll need to create a SQL query that combines data from your connector and Peaka Table. If you’re unsure how to create a SQL query, refer to this guide.

2. Execute the query: Execute the SQL query you’ve created while clicking on the “Run” button. This query will merge the data from your connector and Peaka Table.

3. View the merged data: Once the query has been executed, you can review the merged data. The results will be displayed as shown in the image below. Additionally, you can access the data in the “Data Model” page under the “Query” tables.

By following these steps, you can seamlessly join and utilize the data from your connector and Peaka Table in your Peaka application. This allows you to harness the power of both data sources to enhance your application’s functionality and capabilities.