Announcing the Hightouch integration
By Brian Morrison II |
Hightouch offers an easy way to sync data between multiple platforms using simple connections that anyone can set up. We recently partnered with Hightouch to provide direct access to your PlanetScale account, which can simplify the process of syncing data to and from your database.
The power of Hightouch + PlanetScale
Connecting your PlanetScale database to a Hightouch workflow can be used in a number of different ways, but here are a few ideas to get you started:
- Automatically update customer records in your CRM when they are created or changed in your database.
- Send a notification to your Slack workspace when data is changed in your PlanetScale database.
- Execute asynchronous operations by sending data from your PlanetScale database to a data queue like AWS SQS.
- Automate paid ad targeting, suppression, and conversion uploads by syncing audiences from your database to ad platforms.
- Automatically sync account and user health scores to your customer success platforms.
How to use the PlanetScale Hightouch integration
In Hightouch, you set up a sync by configuring a data source, destination to send the data, and sync method. You can use your PlanetScale database as a source or destination for your syncs. Let's take a look at how to use PlanetScale in both scenarios.
PlanetScale as a source
Using a PlanetScale database as a source allows you to take the data from your database and sync it to all of your downstream tools. At the time of this writing, Hightouch natively supports over 200 destinations. In the following example, I’ll take a small table named hotels from my bookings_db database and sync it to a spreadsheet in my Google Drive account.
When configuring the connection to PlanetScale database, you'll provide a set of credentials to establish a connection between Hightouch and your database. Then you can use a SQL query that gathers the data to sync or specify a table to scan for changes.
Opting for "Table selector" lets you search for the specific table you want and preview the results so you know you're looking at the right data.
When connecting to Google Sheets, you choose to create a snapshot of the data with each run, or mirror the data to a specific document and sheet.
You have the ability to set automated recurring syncs based on a time interval or trigger, or manually which allows you to run it via the Hightouch dashboard or using the API.
Once the sync runs, all of the data from the hotels table in my PlanetScale database is now mirrored in google Sheets.
PlanetScale as a destination
You can also configure data to be sent to a PlanetScale database from Google Sheets. In the following example, I created a new sheet called new hotels that I will send to my bookings_db database.
Hightouch allows you to map fields between different systems, so you aren't required to make them match. If you do have matching field names, Hightouch can automatically map the fields for you.
Once this sync runs, I can validate that the data from Google Sheets was synced to my database by running a simple SELECT query on the hotels table:
Try it out
For more info on how to use PlanetScale and Hightouch, check out the Hightouch article on our documentation portal, or the PlanetScale article in the Hightouch docs. You can get started with Hightouch today as it takes users an average of only 23 minutes to start their first sync.
Do you have any interesting ways you could use Hightouch with your PlanetScale database? Share it on Twitter and tag @PlanetScale and @HightouchData!