IntegrationAdvancedbigquerygcpanalytics
Implement Salesforce to Google BigQuery export patterns
Real World Scenario
Analytics on GCP needs Salesforce data in BigQuery for Looker dashboards refreshed hourly.
Expected Answer
• Fivetran or Dataflow Bulk API load to BigQuery
• Incremental merge on Id LastModifiedDate
• Nested JSON flattening Account Contact relationships
• Partition tables by _PARTITIONDATE ingestion
• Cost control clustering and partition pruning queries
• Dataform dbt transforms after landing raw
• Alert pipeline failure before executives see stale dashboard
Follow-Up Questions & Answers
Click to expand — each follow-up includes a direct, interview-ready answer
Main difference: use case and scale. Fivetran or Dataflow Bulk API load to BigQuery. Incremental merge on Id LastModifiedDate. Pick based on your integration pattern and team capability. Warehouse export is commodity—architect for incremental freshness and cost-aware query patterns. Optimize for scale and operational observability.
Architect Perspective
Warehouse export is commodity—architect for incremental freshness and cost-aware query patterns.