Ascend-managed DuckLake

Set up DuckDB in Ascend with fully managed DuckLake infrastructure. Ascend handles all the complexity for you, automatically managing both the PostgreSQL metadata store and object storage.

Prerequisites

• An Ascend Project
• An Ascend Workspace

Create a DuckDB Connection

From your Workspace Super Graph view, follow these steps:

Form

1. Create a Connection by either:
   • Clicking the + button next to Connections in the left Build panel
   
   • Right-clicking in the Super Graph and selecting Create Connection
   
2. Enter a descriptive name like data_plane_duckdb
3. Select DuckDB from the available options
4. Fill in the required fields (and any optional fields as needed)
5. Click Save at the bottom to create your Connection

Files panel

1. Open the Files panel in the top left
2. Right-click the connections directory and select New File

3. Give your file a descriptive name like data_plane_duckdb.yaml

For complete configuration options, see our Connection reference guide.

Your DuckDB Connection file should look like this:

connections/data_plane_ducklake.yaml

connection:
  duckdb:
    ducklake:
      $<: $ascend_managed.ducklake

This configuration uses Ascend's managed infrastructure through the $ascend_managed.ducklake object, which automatically handles all Connection details to the managed PostgreSQL and object storage.

Verify your setup

Test your DuckLake Connection to verify it's configured correctly.

🎉 Congratulations, you just set up a DuckDB Connection with Ascend-managed DuckLake!

Next steps

Now that your DuckDB Connection is set up:

• 💡 Read data - Connect to your data sources
• 🔄 Transform data - Process and transform your data
• 📤 Write data - Output your transformed data