Hightouch lets you pull data stored in Metabase and push it to downstream destinations. You can sync data from Metabase Cloud or your own self-hosted instance. Most of the setup occurs in the Hightouch UI, but you need access to Metabase for information like your server URL and credentials.
You may need to allowlist Hightouch's IP addresses to let our systems connect to your warehouse. Reference our networking docs to determine which IP addresses you need to allowlist.
Hightouch can connect directly to Metabase over the public internet or via an SSH tunnel. Since data is encrypted in transit via TLS, a direct connection is suitable for most use cases. You may need to set up a tunnel if your Metabase instance is on a private network or virtual private cloud (VPC).
Hightouch supports both standard and reverse SSH tunnels. To learn more about SSH tunneling, refer to Hightouch's tunneling documentation.
Enter the following required fields into Hightouch:
Server: The URL for your Metabase server, for example, https://mycompanyname.metabaseapp.com/. Alternatively, you may provide an IP address and port number, for example 127.0.0.1:443.
Username: This can be your personal Metabase login or a dedicated user for Hightouch.
Password: The password for the user specified above.
(Optional) Database for native SQL queries: By default, this source supports reading data from Metabase questions and tables. If you wish to execute native SQL queries, you must specify the name of the database to be queried.
When setting up Metabase as a source for the first time, Hightouch checks that you have the correct permissions. Once the test passes, click Continue to finish setup.
Once your source configuration has passed the necessary validation, your source setup is complete. Next, you can set up models to define which data you want to pull from Metabase.
You can run queries against your warehouse via Metabase using Hightouch models. If you've connected a warehouse to your Metabase instance, copy the name in the Metabase UI and add it to the Database for native SQL queries field in the source configuration form.
Then, use the Hightouch the SQL editor to create your model.