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.
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:
- Activity / Task
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.
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.