Connectors
Databases
MotherDuck
3min
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 m otherduck 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 motherduck prerequisites be sure to our ip grantlist / whitelist docid\ ernsp9vcy4af88jk0uexc 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/ https //motherduck com/docs/key tasks/authenticating and connecting to motherduck/authenticating to motherduck/ instructions (basic connection setup) 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 issue handling if any issues occur with the authorization simply return to the sources page in datalakehouse io, edit the source details and click the save & test or authorize your account or re authorize account button to confirm connectivity if any issues persist please contact our support team via the datalakehouse io support portal https //datalakehouse zendesk com