Connect to MotherDuck

Introduction

This documentation provides a comprehensive guide on connecting MotherDuck to Holistics as a data source. In the following sections, we will walk you through the necessary steps:

• Creating a personal access token and granting permissions for Holistics to interact with MotherDuck.
• Establishing the connection between MotherDuck and Holistics as a data source.

Step 1: Create a MotherDuck access token

1. Go to the MotherDuck UI
2. In top left click on organization name and then Settings
3. Click + Create token
4. Specify a name for the token that you'll recognize (like "Token for Holistics")
5. Specify the type of token you want. Tokens can be Read/Write (default) or Read Scaling.
6. Choose whether you want the token to expire and then click on Create token
7. Copy the access token token to your clipboard by clicking on the copy icon

For more details, please visit MotherDuck Documentation

Step 2: Connect MotherDuck to Holistics as a Data Source

From the Holistics app's header bar, open Organization Settings menu -> Data Sources.

Click New Data Source button and fill in the details:

• Database Type: Select MotherDuck.
• Display Name: Provide a name for your connection.
• Token: Input the Token that you generated in step 1

FAQs

Can I speed up queries with connection pooling?

MotherDuck data sources always use the Canal engine, so Connection pooling is available and worth a look if your dashboards feel slow to start.

The trade-off is cost. Ducklings are billed for the wall-clock time they stay running, and the 15-minute ping that holds a pooled connection open can extend that. See Idle warehouses can still cost money.