A manager at Cloud Kicks asks for data in a dashboard to be refreshed after the sync of an external connection to Google BigQuery. How should the…

For Cloud Kicks’ requirement to refresh dashboard data synchronously with the sync of an external

connection to Google BigQuery, the most efficient method is:

Event-Based Triggers: Using CRM Analytics, you can set up recipes to run on an event-based trigger.

This ensures that the recipe (which processes the data for the dashboard) only runs after the external

data sync is completed.

Salesforce External Connection Syncs: By specifically targeting the synchronization event of the

Salesforce external connection with Google BigQuery, the recipe ensures data consistency and

timeliness without manual intervention.

Automation and Efficiency: This approach minimizes latency and maximizes data freshness, aligning

data processing closely with data availability, thus enhancing dashboard accuracy.