MotherDuck SQL

📄️ ATTACH

The ATTACH command in MotherDuck can be used to:

📄️ COPY FROM DATABASE (OVERWRITE)

The COPY FROM DATABASE ... (OVERWRITE) statement will make the targetdb contain exactly the same data as sourcedb via zero-copy cloning, effectively overwriting it.

📄️ COPY FROM DATABASE

Copy a database from one location to another in MotherDuck

The CREATE DATABASE statement creates a new database in MotherDuck. In addition to creating a database, it can be used to copy entire databases into MotherDuck from your local environment, or to zero-copy clone databases inside of MotherDuck.

📄️ CREATE SECRET

MotherDuck enables you to store your cloud storage credentials for convenience, using the familiar DuckDB CREATE SECRET syntax. See DuckDB CREATE SECRET documentation.

📄️ CREATE SHARE

The CREATE SHARE statement creates a new a share from a database. This command is used to share databases with other users. Learn more about sharing in MotherDuck.

📄️ CREATE SNAPSHOT

CREATE SNAPSHOT OF creates a new read-only snapshot of the specified database for read-scaling ducklings. Only one database can be snapshotted per command.

📄️ DROP SECRET

The DuckDB DROP SECRET statement (see DuckDB DROP SECRET documentation) works in MotherDuck to delete the secret previously created with CREATE SECRET statement.

📄️ DESCRIBE SHARE

The DESCRIBE SHARE statement is used to get details about a specific share.

📄️ DETACH

The DETACH command in MotherDuck can be used to:

📄️ DROP DATABASE

The DROP statement removes a database entry added previously with the CREATE command.

📄️ DROP SHARE

DROP SHARE is used to delete a share by the share creator. Users who have attached the share will lose access.

📄️ EXPLAIN ANALYZE

EXPLAIN ANALYZE displays and executes the query plan, showing performance metrics and cardinality information for each operator.

📄️ EXPLAIN

The EXPLAIN statement shows the physical query plan that will be executed. It displays a tree of operators that will run in sequence to produce the query results. The query optimizer transforms this plan to improve performance.

📄️ GRANT READ ON SHARE

For restricted shares, use the GRANT command to explicitly give users access to the share. After a user has been GRANT-ed access they will still need to run an ATTACH command to be able to run queries against the shared database. Only the owner of the share can use the GRANT command to give access to others.

📄️ LIST SECRETS

Secrets can be listed in the same way as in DuckDB by using the table function duckdb_secrets().

📄️ LIST SHARES

The LIST SHARES statement lists all shares created by the current user.

📄️ MD_RUN parameter

For certain DuckDB Table Functions, MotherDuck now provides an additional parameter, MD_RUN that gives explicit control over where the query is executed.

📄️ PRINT_MD_TOKEN pragma

You can retrieve your MotherDuck authentication token using the PRINTMDTOKEN pragma.

📄️ REFRESH DATABASE

There are two types of databases that can be refreshed: database shares and databases attached to read-scaling

📄️ REVOKE READ ON SHARE

For restricted shares, use the REVOKE command to explicitly remove share access from users that have an existing GRANT. After running a REVOKE command there may be a delay of a few minutes before access is fully removed if a user is currently querying the share. Only the owner of the share can use the REVOKE command to remove access from others. GRANT and REVOKE do not apply to UNRESTRICTED shares.

🗃️ AI