Yes ✔️ , the connection between your Google BigQuery database and your tables in D-engage is feasible. Once the linkage is established, you will gain access to and be able to manipulate the tables in your Google BigQuery database within D-engage.
To initiate the connection process, follow these steps:Sign in to your D-engage account and navigate to the settings section.
Within settings, locate the "Remote Sources" option.
In the Remote Sources section, initiate the addition of a new remote source by clicking on the "Add" button.
Provide the requisite details for connecting to your Google BigQuery database, including the database name, credentials, and any other necessary connection parameters.
Once the information is entered, proceed by clicking the "Connect" button to establish the connection between D-engage and your Google BigQuery database.
Once your Remote Source is connected, you can create a segment under Audience - Remote Segments.
This segment can be defined using SQL queries, allowing you to incorporate variables as needed.
Furthermore, this remote segment is also compatible with the interactive segment feature. This means that platform users without SQL expertise can still modify segments by adjusting variables.
Yes ✔️
you can do so by following these steps:Access the D-engage Admin Panel by logging into your D-engage account.
Navigate to the Admin Panel: Once logged in, locate and select the "Settings" option within the Admin Panel.
Add a Remote Source: Within the Settings section, click on "Remote Sources."
Configure the Connection: Click the "Add" button, triggering a pop-up window. In this window:
Assign a name to your Redshift database.
Specify the database type as "Amazon Redshift."
Input the required credentials to establish a connection to your Redshift instance.Write Your Query: Utilize the provided configuration to input your desired SQL query, tailored to interact with your Amazon Redshift database.
Save Your Configuration: Upon completing the connection and query configuration, ensure to save your settings successfully.
By adhering to these steps, you'll successfully establish a connection between your Amazon Redshift database and the tables in D-engage, enabling seamless access and manipulation of your data.