Motherduck · Resources

Resources listings from Motherduck on TechiSeek. 18 public listings.

• dbt with DuckDB and MotherDuck (Motherduck)
  dbt with DuckDB and Mother Duck Data Build Tool (dbt) is an open-source command-line tool that enables data analysts and engineers to trans…
• Cloud regions (Motherduck)
  Cloud regions Mother Duck runs on Amazon Web Services (AWS). Each Mother Duck Organization is scoped to a single cloud region, which is cho…
• Architecture and capabilities (Motherduck)
  Architecture and capabilities Mother Duck is a serverless cloud data warehouse built on DuckDB, with a unique architecture that combines th…
• RANK and DENSE_RANK (Motherduck)
  RANK() and DENSE_RANK() are window functions that assign ranking numbers to rows within a partition, differing in how they handle ties and…
• CREATE TABLE AS SELECT (CTAS) (Motherduck)
  AS SELECT (CTAS) creates a new table and populates it in one statement, using the result of a query to define both its schema and its data.
• DuckDB Extensions in MotherDuck | MotherDuck Docs (Motherduck)
  DuckDB extensions in Mother Duck Mother Duck supports a wide array of DuckDB extensions to enhance your analytics workflows.
• LIST and ARRAY type (Motherduck)
  LIST and ARRAY are nested SQL data types for storing an ordered collection of values in a single column — LIST is variable-length, ARRAY is…
• What Is Online Analytical Processing (OLAP)? Explained (Motherduck)
  A complete guide to Online Analytical Processing (OLAP). Learn about OLAP cubes, the differences between OLAP and OLTP, and the types of OL…
• Reading files in DuckDB (Motherduck)
  DuckDB can read CSV, Parquet, JSON, and other file formats directly with SQL table functions, whether the files are local, remote over HTTP…
• What Is dbt (data build tool)? Definition & Examples (Motherduck)
  dbt is an open-source command-line tool that enables data analysts and engineers to transform data in their warehouses more effectively.
• What Is dlt (data load tool)? Definition & Examples (Motherduck)
  Data Load Tool (dlt) is an open-source Python library designed to simplify the process of building data pipelines.
• Role-based access control (RBAC) (Motherduck)
  Role-based access control (RBAC) Use roles to control what users can do in the Mother Duck platform and which data they can read.
• UNION and UNION ALL (Motherduck)
  UNION combines the result sets of two or more SELECT queries into one, removing duplicate rows, while UNION ALL does the same but keeps all…
• Database Snapshots | MotherDuck Docs (Motherduck)
  Snapshots capture the complete state of a database at a specific point in time. Mother Duck creates historical snapshots in the background…
• SQL CTEs Explained: Common Table Expressions with Examples (Motherduck)
  A Common Table Expression (CTE) is a temporary named result set within a SQL query. Learn basic CTEs, chaining multiple CTEs, and recursive…
• Postgres endpoint (Motherduck)
  Postgres endpoint Mother Duck's Postgres endpoint lets you query your databases using any client that speaks the PostgreSQL wire protocol,…
• Object name resolution | MotherDuck Docs (Motherduck)
  Object name resolution Fully qualified naming convention Fully qualified names (FQN) in Mother Duck are of the form ...
• pg_duckdb Extension (Motherduck)
  pg_duckdb Extension pg_duckdb is an open-source Postgres extension that embeds DuckDB's columnar-vectorized analytics engine and features i…