MotherDuck
Motherduck is the hosted servless analytics OLAP engine that powers your organization's data, taking on the concept of small and easy data compared to the more infamous concept of Big Data. MotherDuck is the first analytics data warehouse that offers cloud scale and individualized, user-level tenancy. It allows for management of user-level compute limits and cost attribution without cumbersome upfront configuration and enables ML, AI, Data Warehousing, and Data Science capabilities from develop through to production lifecycles.
- Be sure to Our IP Grantlist / Whitelist the DLH.io IP Addresses for any cloud vendor or MotherDuck account or network access required
- Your MotherDuck account (usually in the URL/Address Bar)
- Create a new MotherDuck database for landing data from DLH.io synchronization jobs
- The recommended name for the database is, DATALAKEHOUSE_RAW
- Your MotherDuck User with administrator credentials and permissions
- Used to create an Access Token
- Create a MotherDuck Access Token
- Instructions from their site are found here, https://motherduck.com/docs/key-tasks/authenticating-and-connecting-to-motherduck/authenticating-to-motherduck/
MotherDuck Create Access Token
Per the prerequisites, capture all the necessary details about your MotherDuck account and prepare to use them for creating your DLH.io connection.
In DLH.io from the header or sidebar chose Targets. Search for, or directly locate, and select MotherDuck from the list of connectors. A new target connection form will appear for you to enter details about your account/workspace that will be used for the data integration process.
- On the DLH.io Connection Form :: Enter your Connection Information
- Enter in the Name/Alias field, the name you'll use within DLH.io to differentiate this connection from others
- Enter in the Server/Host field, the name of the endpoint server name:
- Leave the default, https://app.motherduck.com, whhich is pre-populated, and should not be altered unless yours is an advanced custom integration or first having contacted support
- Enter in the Database field, the name of the database/catalog to connect
- In most cases this is the DATALAKEHOUSE_RAW database that you create as a pre-requisite for landing data in your account
- Select Auth Type required from the dropdown
- Leave the default, Service/Access Token, option selected as this default and only supported authentication option available at this time
- Enter your Access Token string value, that you created as a pre-requisite in the Service/Access Token field.
- Click on Save & Test to save the connection and test that we can connect.
- If updating the form Click Save & Test or just Test
- Clicking on Save & Test will again save any changes such as tany updates to your Service/Access Token, connection nme, etc. Any test of the connection will attempt to connect to your database/account with the credentials and info provided.
- A message of success or failure will be shown:
- If success you'll be prompted with the schema objects objects of the database and will need to complete the final steps for configuration shown below.
- If failure happens with the test connection, the connection is still saved but you will need to correct the failure based on the failure reason information provided in the message
