Adding Remote Data Sources

You can use your data located in Google BigQuery or Amazon Redshift from the dEngage platform. Please follow the instructions below in order to create and use your data located in remote sources.

Prerequisites

• Create a Remote Source from the Web UI to configure and connect your Google BigQuery or Amazon Redshift account with D.engage.
• Create an Automated Data Job to import data from a remote data source by building an SQL query.
  

Adding Google BigQuery as a Remote Data Source

1. Go to Settings > Remote Sources
2. Click Add and Select Google BigQuery
3. Paste your Key Json to the text editor
   

Adding Amazon Redshift as a Remote Data Source

1. Go to Settings > Remote Sources
2. Click Add and Select Amazon Redshift
3. Fill out the form and enter your Amazon Redshift credentials
   

Importing Data from your Remote Data Sources

Once you have created and configured Google BigQuery or Amazon Redshift to your account, you can use Automated Jobs from the web UI in order to import your data from these remote sources.

1. Go to Data Space > Automated Jobs 
2. Click Add to create a new job
3. Drag and drop the "Audience Builder" or "Data Builder" node to import your data
4. Select the "Create from Remote Source" option
5. Import data from the selected Remote Source by building an SQL query
6. Click "Validate and Preview" once you have built your query
   

• Related Articles

• Adding Remote Filters

  You can add filters to your data located in Google BigQuery or Amazon Redshift from the dEngage platform. Please follow the instructions below in order to create and use the remote filters. Prerequisites Create a Remote Source from the Web UI to ...

• Event Data Integration

  There are two options to send Event Data to D·engage: 1. Send event data via D·engage SDK First, you need to create a website application to use the dEngage Web SDK. Go to D·engage Event SDK page for detailed instructions to 'create an ...

• CDMP Data Import

  Data imports enables you to import new records (or) update existing data through a CSV file. This is particularly useful when migrating from other platforms to D·engage, or performing mass updates to a large chunks od records. The process is quite ...

• Data Integration

  If you are using only our Email and SMS channels, you will only need to integrate the master_contact table. If you are using our Mobile and Web Push channels, you will need to integrate the master_device table as well. Sending your Contact Data to ...

• Intro to Data Space

  dEngage Data Space offers a wide range of features and capabilities for creating, retrieving, updating and deleting data and data tables in the system. This section gives an introduction and an overview on the general functions and terms you will ...