Writing robust data pipelines with AILivestream July 22

Skip to main content

Server Connection Management

Managing MotherDuck server connections

MD_ACTIVE_SERVER_CONNECTIONS

View active connections and running queries in MotherDuck using md_active_connections.

MD_INTERRUPT_SERVER_CONNECTION

Cancel running queries and terminate active connections to MotherDuck using SQL commands.

MD_CURRENT_CLIENT_CONNECTION_ID and MD_CURRENT_CLIENT_DUCKDB_ID

Retrieve connection identifiers and DuckDB instance IDs for debugging and monitoring.

MD_LAST_QUERY_ID

Use MD_LAST_QUERY_ID() to get the UUID of the most recent query sent to MotherDuck.