🎉 Bedrock Data is now Formstack Sync! · Learn More 🎉

Ryan Plunkett | January 31, 2018

Work with your Fused Warehouse using MySQL Workbench

 

Overview of MySQL Workbench

MySQL Workbench is fast, free, and available on Windows, Linux and Mac OS X. The environment is also compatible with your Fusion Warehouse, which uses MySQL.

For users new to MySQL Workbench, you’ll find that it’s a very practical and easy-to-use SQL querying interface that allows you to save snippets of queries for later use.

Using MySQL Workbench with your Fused Warehouse

Your Fused Warehouse is a standardized database of all objects, consolidated, de-duplicated and connected from multiple of your SaaS applications. 

You can connect your Fused Warehouse to your MySQL Workbench account in a couple clicks by selecting the Database tab within MySQL Workbench, and clicking Connect to Database, which opens a modal window where you will insert your Fusion Warehouse Keys.

Screen Shot 2018-01-22 at 2.25.26 PM.png

At the click of OK you’ll create a live connection to your Fused Warehouse, where you can directly access your schema and tables.

A SHOW TABLES query will display your Fused Warehouse in the Result Grid, where you can see fused objects such as:

  • Company
  • Contact
  • Opportunity
  • Activity / Task
  • Ticket 
show tables mysql workbench

Familiarize yourself with the links tables. Links tables are a design pattern for many to many relationships, and are useful for doing joins. For example, the table Company_Contact_Links would have all the Company Contacts for the systems you’ve connected, and Contact_Ticket_Links would associate Contacts to Tickets.

 

SQL Queries at Your Fingertips

To get started, we created a few SQL queries in this Github repo. Now that you have full and immediate access to the warehouse, you can run any SQL query from your fused dataset. You might run a basic SELECT * FROM Company_Contact_Links to verify that all the contacts in your warehouse are there. 

company links table mysql workbench 

 

Or SELECT * FROM Activities, something you may have overlooked at in Salesforce, or Lead Status (e.g. why do we have so many open leads?). 

Tickets are a good area to explore. HelpScout, for example, doesn’t have a Company Object; its tickets are instead associated with Contact. So with Fusion, you could link Tickets to Contacts and Contacts to Companies, using the Contact_Ticket_Links, Company_Contact_Links, and Tickets tables. Running the following SQL query will return an average count of all the tickets opened, by month, across companies.

By joining these three tables we are accessing the fused records, which has saved us a ton of time by automating the process of data ingestion and prep.

 

Subscribe Here!