MotherDuck / DuckDB | Tableau Exchange

MotherDuck / DuckDB

by MotherDuck

Description

MotherDuck provides a simplified, performant and efficient data warehouse (based on the lightweight DuckDB engine) for the 95% of data teams and data app developers that don’t need petabyte scale.

Its unique architecture blends the flexibility and scale of cloud, with the power of users' own laptops for analytics. The current data warehouse model is a big mainframe monolith that everyone shares, often leading to resource contention. With MotherDuck, each user gets her own duckling (isolated runtime), so users have a consistently-performant experience.

Analyst-focused: MotherDuck focuses on key tasks [loading data, analyzing data, integration with ecosystem], providing a simplified experience.

  • Serverless, no need to worry about tinkering with setup
  • UI makes key data engineering tasks easy
  • AI assists
  • Beautiful, lightning-fast SQL
  • Use your laptop for horsepower: speed up analytics and reduce cloud costs.

Architected for Data Apps as a fast and cost-effective solution to handle high-concurrency, low-latency workloads

  • Each user gets her own duckling (isolated runtime), so users have a consistently-performant experience.
  • WASM client for 60 frame-per-second experiences in the browser

World class support provided by a customer love organization driven by creating superfans

Installation

  1. Download a recent release of the DuckDB JDBC driver from Maven Central by going to "Versions", clicking "Browse" for your preferred DuckDB version, say a.b.c.d, and then downloading duckdb_jdbc-a.b.c.d.jar. You can also go to the DuckDB installation page for a direct download link for the latest (LTS) driver version.
  2. Copy the driver into the Tableau Drivers directory:
    • MacOS: ~/Library/Tableau/Drivers/
    • Windows: C:\Program Files\Tableau\Drivers
    • Linux: /opt/tableau/tableau_driver/jdbc
  3. Download the signed tableau connector (aka "Taco file") file from the latest available release and copy it into the Connectors directory:
    • Desktop MacOS: /Users/[YourUser]/Documents/My Tableau Repository/Connectors
    • Desktop Windows: C:\Users\[YourUser]\Documents\My Tableau Repository\Connectors
    • Server Windows: C:\ProgramData\Tableau\Tableau Server\data\tabsvc\vizqlserver\Connectors
    • Server Linux: [Your Tableau Server Install Directory]/data/tabsvc/vizqlserver/Connectors

Full Instructions with screenshots here

Tech Specifications

Version
1.1.1
Works with
Tableau 2020.4 and later

Resources