Customer 360 Data Warehousing and Sync to Hubspot using BigQuery, dbt, Looker and Hightouch
In this blog I’ll show how we’ve used Google BigQuery together with Looker, Segment and our RA Warehouse for dbt to do just this, connecting offline and online data together for both clients and contacts and syncing that data to our Hubspot CRM system using a new “reverse ETL” service, Hightouch.
Deduplicating Company Records in a Multi-Source Data Centralization Project using dbt, Google BigQuery or Snowflake
One of the most common tasks in a data centralization project is to create single, deduplicated records for each of the companies, contacts, products and other entities the business interacts with. Doing this allows you to connect sales activity from Salesforce and Hubspot to project delivery and invoicing data from Jira and Xero, for example, and this article shows you how.
