Skip to main content
Version: 0.0.36

DuckDB

Integrating DuckDB with Lakehousecat allows efficient data processing and analytics using DuckDB's powerful analytical engine. This guide will walk you through the steps to set up a DuckDB connection within your Lakehousecat workspace.

Prerequisites​

Ensure you have the following before starting the integration process:

  • Access to Lakehousecat as an admin or builder
  • DuckDB installed and accessible from your environment

Step-by-Step Guide​

  1. Start in the Workspace

    • Log into your Lakehousecat workspace where data connections are managed.

  2. Go to the Data Section

    • Select the 'Data' menu to access data-related functionalities within Lakehousecat.

  3. Select "Datasource Types"

    • To view the list of available data sources, select the "Datasource Types" option.

  4. Choose "DuckDB Datasource Type"

    • Click on the "DuckDB Datasource Type" to start the configuration process.

Step 3: Configure the DuckDB Connection​

  • Connection Name: Assign a meaningful name to your DuckDB connection. This name will help you and others identify the connection within Lakehousecat.
  • DuckDB Connection-Uri: Enter the connection URI for DuckDB. Ensure this URI is formatted correctly to facilitate the connection.
  • Description (Optional): Add an optional description for the connection. This helps provide context or clarification for others who might use or manage the connection.

Step 4: Validate and Establish the Connection​

  1. Once you've inputted the necessary information, click on the Create button to proceed.
  2. Lakehousecat will validate the connection parameters. Make sure all inputs are accurate to prevent validation failures.
  3. After successful validation, your DuckDB connection will be established and ready for use.

Best Practices​

  • Consistent Naming: Implement a logical naming convention for connection names to enhance recognizability and management efficiency.
  • Utilize Descriptions: Use the description field to relay useful information regarding the connection's purpose or aimed functionalities.

Troubleshooting​

If you face challenges while setting up the connection:

  • Error Validation: Review the entered DuckDB Connection-Uri for potential inaccuracies.
  • Permission Difficulties: Confirm you have the requisite permissions within Lakehousecat and DuckDB.