Big data tables are tables where events are collected. These tables can only receive data through SDK and GTM. In a regular table, data can be transferred via API, FTP or remote source. Regular tables need to be connected in the star schema in order to use them in interactive segments. Lastly, the tables where you can import the lists are called sendlist tables.
To create a Sendable table, it is necessary to establish a connection between a particular table and the master_contact table by associating one of its columns with the primary key of the corresponding table. Ensure that the selected column is configured to store TEXT type data, and ensure it aligns with a primary key column of TEXT type in the corresponding table.
Yes, the primary key serves to uniquely identify each record within a table.This functionality not only ensures data accuracy but also enhances query performance and simplifies the management and maintenance of the database in the long run.
You have the ability to customise retention periods and update options while setting up an Automated Flow from the D·engage Data Space. Here you can specify how long files or data dropped onto the platform should be retained before they are deleted, and also you can define how the data in these files should be processed
(e.g., insert, update, truncate, delete). /sql
To delete an empty table, open the table menu, click the three dots on the right, and select Delete. For tables with data, create a ticket for the DB team to handle deletion.
🛑 It is not possible to delete Master Contact Table or Master Device Table , but you can the individual records.
Absolutely ✔️, in D-engage, you have the capability to both eliminate existing relationships and establish multiple relationships with the same table.