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, see the documentation on how to create a Peaka Table for detailed instructions.
  2. Connector data: You should have data from a connector source. If you don’t have any connector data, refer to the documentation on how to connect your data using a SaaS connector.

​
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. See the documentation on how to create a SQL query for further details.
sql query view
  1. 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.
  2. 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.
combined data view 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.