Frequently asked questions

What should I do if I receive an email from Braze Support about errors in my CDI sync?

Here are the common types of emails you might receive regarding errors in CDI sync:

• Error in CDI Sync [NAME]
  This type of email usually includes an error message that CDI encountered during the sync process. Often, it is due to a setup error. Some common issues include:
  • CDI cannot access the data warehouse or table with the credentials set up in the integration. This could mean the credentials in CDI are incorrect or are misconfigured on the data warehouse. Check out Data Warehouse Integrations for more details.
  • SQL error because the table wasn’t found. Update the integration with the correct database configuration or create matching resources (for example, database/table) on the data warehouse.
  • Catalog not found. The catalog set up in the integration does not exist in the Braze catalog. A catalog can be removed after the integration was set up. To resolve the issue, either update the integration to use a different catalog or create a new catalog that matches the catalog name in the integration.
• Row errors in your CDI sync
  This indicates that some data cannot be processed in the sync. To find out what is causing the errors, navigate to the CDI page in Braze. Open the Sync Log tab to check the error details for the sync job.

How can I update my email alert preferences for CDI integrations?

Each integration has its own notification preference. Go to the CDI page and select the integration name you want to update. In the Notification preferences section you can update how you receive alerts regarding the selected integration.

What to do if a future UPDATED_AT was synced in an integration?

CDI uses UPDATED_AT to decide what data is new. After a future UPDATED_AT is synced, any data prior to that future date and time will not be processed.

You need to clean up the data by correcting the UPDATED_AT and removing old data that wasx already synced to Braze, and then create a new integration to process the table again.

Why is the Rows Synced reported on the CDI dashboard different from the number of records in my warehouse? Or why doesn’t the synced value match what I have in my warehouse?

CDI uses UPDATED_AT to decide which records to pick up during a sync. Check out this illustration to see how it works. At the beginning of a sync run, CDI queries your warehouse to get all records with UPDATED_AT later than the previously processed value. Any record picked up at the time when the query executes will be synced into Braze. Here are common cases when a record might not be synced:

• You’re adding records to the table with an UPDATED_AT value that has already been processed.
• You’re updating record values after they have been processed by a sync, but leaving UPDATED_AT unchanged.
• You’re adding or updating records while a sync is in progress. Depending on when the CDI query executes, there could be race conditions that lead to records not being picked up.

To avoid these behaviors, we recommend using monotonically increasing UPDATED_AT values and not updating the table during your scheduled sync run.

Is order preserved when there are multiple records for the same ID in a sync?

The processing order is not 100% predictable. For example, if there are multiple rows with the same EXTERNAL_ID in the table during a sync, we cannot guarantee which value will end up in the final profile.

What security measures are there in CDI?

On the CDI side:

• All credentials are encrypted within our database, and only certain employees have authenticated access to them.
• We use encrypted connections to get data to customer warehouses.
• We make requests to the Braze API endpoints using the same API keys and TLS connections that we recommend our customers use.
• We regularly update our libraries and get any security patches.

On your side:

• We highly recommend that you restrict the credential access to the minimum required for CDI to operate. This is because we need to be able to run select (and count) on the specific tables and views.
• You can restrict the IPs that can access the tables to the officially published Braze IPs.