Search documentation...

K
ChangelogBook a demoSign up

Metabase

Meet the easy, open source way for everyone in your company to ask questions and learn from data.

Metabase limits query results to one million rows. If you need to sync a larger dataset, connect your warehouse directly to Hightouch.

Overview

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.

Connection configuration

To get started, go to the Sources overview page and click the Add source button. Select Metabase and follow the steps below.

Choose connection type

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).

Direct connection vs. SSH tunnel

Hightouch supports both standard and reverse SSH tunnels. To learn more about SSH tunneling, refer to Hightouch's tunneling documentation.

Configure your source

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.

Test your connection

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.

Next steps

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.

Model setup

Hightouch allows to extract data from Metabase questions and tables.

  1. In Hightouch, go to the Models overview page.
  2. Click Add model.
  3. Select the Metabase source you previously created.
  4. Select Browse available data. You can then select the question or table you want to query. You can query both private and public questions and tables.
  5. Preview your model's query results.
  6. Click Continue.
  7. Give your model a descriptive Name.

Raw SQL

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.

Tips and troubleshooting

If you encounter an error or question not listed below and need assistance, don't hesitate to . We're here to help.

Hidden Columns

There is a known issue when querying Metabase questions and tables containing hidden columns. Hightough recommends unhiding all columns.

Renaming Columns

There is a known issue when querying Metabase questions and tables containing renamed columns. Hightough recommends not renaming any columns.

Ready to get started?

Jump right in or a book a demo. Your first destination is always free.

Book a demoSign upBook a demo

Need help?

Our team is relentlessly focused on your success. Don't hesitate to reach out!

Feature requests?

We'd love to hear your suggestions for integrations and other features.

Last updated: Oct 1, 2024

On this page

OverviewConnection configurationChoose connection typeConfigure your sourceTest your connectionNext stepsModel setupRaw SQLTips and troubleshootingHidden ColumnsRenaming Columns

Was this page helpful?