User Management API

Teams that support large numbers of users have been asking for a programmatic way to manage user accounts and access tokens.

We’re delighted to introduce the User Management API, which simplifies user management for organizations with complex workflows looking to spin up separate users for BI systems or fine-tune developer access for data ingestion and processing workloads.

The API also enables new possibilities for app developers by allowing you to issue short-lived, Read Scaling Tokens to provide read-only access to embedded analytics components or standalone data applications.

Introducing the Table Summary

Our new Table Summary in the MotherDuck UI allows you to move faster from raw data to insights before writing a SELECT * query to explore your data.

The Table Summary supports ad-hoc analysis by providing an overview of the shape of your underlying data table and fields. It empowers technical and non-technical users to easily profile and understand your data without requiring SQL for basic analysis. It also increases your data team’s bandwidth to focus on more strategic work.

View column names, types, distributions, and null percentages with just a click, access table previews and DDL statements in the Object Explorer, and empower your team to self-serve insights.

This feature was inspired by customer feedback about the Column Explorer and takes ease of use to the next level directly in the object explorer panel on the left side of the MotherDuck UI.

Metadata at your Fingertips with MD_INFORMATION_SCHEMA

We have recently introduced the MD_INFORMATION_SCHEMA, a read-only, system-defined view that provides SQL-based access to metadata about your MotherDuck objects.

This new feature helps you retrieve information about databases, owned_shares, and shared_with_me databases.

Shares are read-only databases designed for collaboration and ad-hoc analytics. They allow users to access the same dataset as a zero-copy clone without duplicating data, enabling seamless collaboration across teams. Shares can be attached and updated manually or automatically by the Share’s creator.

With MD_INFORMATION_SCHEMA, you can now easily retrieve and query metadata to streamline how you understand and manage your shared data resources.

Get Started

We’re always eager to learn more about how you’re using MotherDuck: Share your success stories and feedback with us on Slack. If you’d like to discuss your use case in more detail, please connect with us - we’d love to hear about what you’re building and how we can make your MotherDuck experience even better!