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.
