# MotherDuck Docs ## Docs - [Billing](https://motherduck.com/docs/about-motherduck/billing) - [Instances](https://motherduck.com/docs/about-motherduck/billing/instances) - [Managing Billing](https://motherduck.com/docs/about-motherduck/billing/managing-billing) - [Pricing](https://motherduck.com/docs/about-motherduck/billing/pricing) - [About Motherduck](https://motherduck.com/docs/about-motherduck) - [Legal](https://motherduck.com/docs/about-motherduck/legal) - [Release Notes](https://motherduck.com/docs/about-motherduck/release-notes) - [Ai](https://motherduck.com/docs/category/ai) - [Motherduck Sql](https://motherduck.com/docs/category/motherduck-sql) - [Server Connection Management](https://motherduck.com/docs/category/server-connection-management) - [Sql Assistant](https://motherduck.com/docs/category/sql-assistant) - [Using Python](https://motherduck.com/docs/category/using-python) - [Architecture And Capabilities](https://motherduck.com/docs/concepts/architecture-and-capabilities) - [Data Warehousing](https://motherduck.com/docs/concepts/data-warehousing) - [Concepts](https://motherduck.com/docs/concepts) - [Pgduckdb](https://motherduck.com/docs/concepts/pgduckdb) - [Connect Query From Duckdb Cli](https://motherduck.com/docs/getting-started/connect-query-from-duckdb-cli) - [Choose Database](https://motherduck.com/docs/getting-started/connect-query-from-python/choose-database) - [Installation Authentication](https://motherduck.com/docs/getting-started/connect-query-from-python/installation-authentication) - [Loading Data Into Md](https://motherduck.com/docs/getting-started/connect-query-from-python/loading-data-into-md) - [Query Data](https://motherduck.com/docs/getting-started/connect-query-from-python/query-data) - [E2e Tutorial](https://motherduck.com/docs/getting-started/e2e-tutorial) - [Getting Started](https://motherduck.com/docs/getting-started) - [Motherduck Quick Tour](https://motherduck.com/docs/getting-started/motherduck-quick-tour) - [Air Quality](https://motherduck.com/docs/getting-started/sample-data-queries/air-quality) - [Datasets](https://motherduck.com/docs/getting-started/sample-data-queries/datasets) - [Foursquare](https://motherduck.com/docs/getting-started/sample-data-queries/foursquare) - [Hacker News](https://motherduck.com/docs/getting-started/sample-data-queries/hacker-news) - [Nyc 311 Data](https://motherduck.com/docs/getting-started/sample-data-queries/nyc-311-data) - [Pypi](https://motherduck.com/docs/getting-started/sample-data-queries/pypi) - [Stackoverflow](https://motherduck.com/docs/getting-started/sample-data-queries/stackoverflow) - [Stackoverflow Survey](https://motherduck.com/docs/getting-started/sample-data-queries/stackoverflow-survey) - [Home](https://motherduck.com/docs) - [Evidence](https://motherduck.com/docs/integrations/bi-tools/evidence) - [Hex](https://motherduck.com/docs/integrations/bi-tools/hex) - [Bi Tools](https://motherduck.com/docs/integrations/bi-tools) - [Marimo](https://motherduck.com/docs/integrations/bi-tools/marimo) - [Metabase](https://motherduck.com/docs/integrations/bi-tools/metabase) - [Powerbi](https://motherduck.com/docs/integrations/bi-tools/powerbi) - [Superset Preset](https://motherduck.com/docs/integrations/bi-tools/superset-preset) - [Tableau](https://motherduck.com/docs/integrations/bi-tools/tableau) - [Amazon S3](https://motherduck.com/docs/integrations/cloud-storage/amazon-s3) - [Azure Blob Storage](https://motherduck.com/docs/integrations/cloud-storage/azure-blob-storage) - [Cloudflare R2](https://motherduck.com/docs/integrations/cloud-storage/cloudflare-r2) - [Google Cloud Storage](https://motherduck.com/docs/integrations/cloud-storage/google-cloud-storage) - [Cloud Storage](https://motherduck.com/docs/integrations/cloud-storage) - [Data Quality](https://motherduck.com/docs/integrations/data-quality) - [Data Science Ai](https://motherduck.com/docs/integrations/data-science-ai) - [Databases](https://motherduck.com/docs/integrations/databases) - [Postgres](https://motherduck.com/docs/integrations/databases/postgres) - [Dev Tools](https://motherduck.com/docs/integrations/dev-tools) - [Apache Iceberg](https://motherduck.com/docs/integrations/file-formats/apache-iceberg) - [Delta Lake](https://motherduck.com/docs/integrations/file-formats/delta-lake) - [File Formats](https://motherduck.com/docs/integrations/file-formats) - [How To Integrate](https://motherduck.com/docs/integrations/how-to-integrate) - [Integrations](https://motherduck.com/docs/integrations) - [Dlt](https://motherduck.com/docs/integrations/ingestion/dlt) - [Ingestion](https://motherduck.com/docs/integrations/ingestion) - [Go Driver](https://motherduck.com/docs/integrations/language-apis-and-drivers/go-driver) - [Language Apis And Drivers](https://motherduck.com/docs/integrations/language-apis-and-drivers) - [Jdbc Driver](https://motherduck.com/docs/integrations/language-apis-and-drivers/jdbc-driver) - [Python Overview](https://motherduck.com/docs/integrations/language-apis-and-drivers/python/python-overview) - [Sqlalchemy](https://motherduck.com/docs/integrations/language-apis-and-drivers/python/sqlalchemy) - [R](https://motherduck.com/docs/integrations/language-apis-and-drivers/r) - [Orchestration](https://motherduck.com/docs/integrations/orchestration) - [Datagrip](https://motherduck.com/docs/integrations/sql-ides/datagrip) - [Dbeaver](https://motherduck.com/docs/integrations/sql-ides/dbeaver) - [Sql Ides](https://motherduck.com/docs/integrations/sql-ides) - [Dbt](https://motherduck.com/docs/integrations/transformation/dbt) - [Transformation](https://motherduck.com/docs/integrations/transformation) - [Web Development](https://motherduck.com/docs/integrations/web-development) - [Vercel](https://motherduck.com/docs/integrations/web-development/vercel) - [Authenticating To Motherduck](https://motherduck.com/docs/key-tasks/authenticating-and-connecting-to-motherduck/authenticating-to-motherduck) - [Connecting To Motherduck](https://motherduck.com/docs/key-tasks/authenticating-and-connecting-to-motherduck/connecting-to-motherduck) - [Authenticating And Connecting To Motherduck](https://motherduck.com/docs/key-tasks/authenticating-and-connecting-to-motherduck) - [Multithreading And Parallelism](https://motherduck.com/docs/key-tasks/authenticating-and-connecting-to-motherduck/multithreading-and-parallelism) - [Multithreading And Parallelism Jdbc](https://motherduck.com/docs/key-tasks/authenticating-and-connecting-to-motherduck/multithreading-and-parallelism/multithreading-and-parallelism-jdbc) - [Multithreading And Parallelism Nodejs](https://motherduck.com/docs/key-tasks/authenticating-and-connecting-to-motherduck/multithreading-and-parallelism/multithreading-and-parallelism-nodejs) - [Multithreading And Parallelism Python](https://motherduck.com/docs/key-tasks/authenticating-and-connecting-to-motherduck/multithreading-and-parallelism/multithreading-and-parallelism-python) - [Read Scaling](https://motherduck.com/docs/key-tasks/authenticating-and-connecting-to-motherduck/read-scaling) - [Cloud Storage](https://motherduck.com/docs/key-tasks/cloud-storage) - [Querying S3 Files](https://motherduck.com/docs/key-tasks/cloud-storage/querying-s3-files) - [Writing To S3](https://motherduck.com/docs/key-tasks/cloud-storage/writing-to-s3) - [Data Apps](https://motherduck.com/docs/key-tasks/data-apps) - [Wasm Client](https://motherduck.com/docs/key-tasks/data-apps/wasm-client) - [Github Action Cron](https://motherduck.com/docs/key-tasks/data-warehousing/Orchestration/github-action-cron) - [Flat Files](https://motherduck.com/docs/key-tasks/data-warehousing/Replication/flat-files) - [Postgres](https://motherduck.com/docs/key-tasks/data-warehousing/Replication/postgres) - [Spreadsheets](https://motherduck.com/docs/key-tasks/data-warehousing/Replication/spreadsheets) - [Sql Server](https://motherduck.com/docs/key-tasks/data-warehousing/Replication/sql-server) - [Data Warehousing](https://motherduck.com/docs/key-tasks/data-warehousing) - [Basics Operations](https://motherduck.com/docs/key-tasks/database-operations/basics-operations) - [Detach And Reattach Motherduck Database](https://motherduck.com/docs/key-tasks/database-operations/detach-and-reattach-motherduck-database) - [Database Operations](https://motherduck.com/docs/key-tasks/database-operations) - [Specifying Different Databases](https://motherduck.com/docs/key-tasks/database-operations/specifying-different-databases) - [Switching The Current Database](https://motherduck.com/docs/key-tasks/database-operations/switching-the-current-database) - [How To Guides](https://motherduck.com/docs/key-tasks/how-to-guides) - [Loading Data Into Motherduck](https://motherduck.com/docs/key-tasks/loading-data-into-motherduck) - [Loading Data From Cloud Or Https](https://motherduck.com/docs/key-tasks/loading-data-into-motherduck/loading-data-from-cloud-or-https) - [Loading Data From Local Machine](https://motherduck.com/docs/key-tasks/loading-data-into-motherduck/loading-data-from-local-machine) - [Loading Data From Postgres](https://motherduck.com/docs/key-tasks/loading-data-into-motherduck/loading-data-from-postgres) - [Loading Data Md Python](https://motherduck.com/docs/key-tasks/loading-data-into-motherduck/loading-data-md-python) - [Loading Duckdb Database](https://motherduck.com/docs/key-tasks/loading-data-into-motherduck/loading-duckdb-database) - [Managing Organizations](https://motherduck.com/docs/key-tasks/managing-organizations) - [Running Hybrid Queries](https://motherduck.com/docs/key-tasks/running-hybrid-queries) - [Sharing Data](https://motherduck.com/docs/key-tasks/sharing-data) - [Managing Shares](https://motherduck.com/docs/key-tasks/sharing-data/managing-shares) - [Sharing Overview](https://motherduck.com/docs/key-tasks/sharing-data/sharing-overview) - [Sharing With Users](https://motherduck.com/docs/key-tasks/sharing-data/sharing-with-users) - [Sharing Within Org](https://motherduck.com/docs/key-tasks/sharing-data/sharing-within-org) - [Use Md With Ai](https://motherduck.com/docs/key-tasks/use-md-with-ai) - [Writing Sql With Ai](https://motherduck.com/docs/key-tasks/writing-sql-with-ai) - [Markdown Page](https://motherduck.com/docs/markdown-page) - [Search](https://motherduck.com/docs/search) - [Aggregate Functions](https://motherduck.com/docs/sql-reference/duckdb-sql-reference/aggregate-functions) - [Configurations](https://motherduck.com/docs/sql-reference/duckdb-sql-reference/configurations) - [Constraints](https://motherduck.com/docs/sql-reference/duckdb-sql-reference/constraints) - [Data Types](https://motherduck.com/docs/sql-reference/duckdb-sql-reference/data-types) - [Alter Table](https://motherduck.com/docs/sql-reference/duckdb-sql-reference/duckdb-statements/alter-table) - [Attach Detach](https://motherduck.com/docs/sql-reference/duckdb-sql-reference/duckdb-statements/attach-detach) - [Call](https://motherduck.com/docs/sql-reference/duckdb-sql-reference/duckdb-statements/call) - [Copy](https://motherduck.com/docs/sql-reference/duckdb-sql-reference/duckdb-statements/copy) - [Create Index](https://motherduck.com/docs/sql-reference/duckdb-sql-reference/duckdb-statements/create-index) - [Create Macro](https://motherduck.com/docs/sql-reference/duckdb-sql-reference/duckdb-statements/create-macro) - [Create Table](https://motherduck.com/docs/sql-reference/duckdb-sql-reference/duckdb-statements/create-table) - [Delete](https://motherduck.com/docs/sql-reference/duckdb-sql-reference/duckdb-statements/delete) - [Drop](https://motherduck.com/docs/sql-reference/duckdb-sql-reference/duckdb-statements/drop) - [Export](https://motherduck.com/docs/sql-reference/duckdb-sql-reference/duckdb-statements/export) - [Duckdb Statements](https://motherduck.com/docs/sql-reference/duckdb-sql-reference/duckdb-statements) - [Insert](https://motherduck.com/docs/sql-reference/duckdb-sql-reference/duckdb-statements/insert) - [Pivot](https://motherduck.com/docs/sql-reference/duckdb-sql-reference/duckdb-statements/pivot) - [Select](https://motherduck.com/docs/sql-reference/duckdb-sql-reference/duckdb-statements/select) - [Set Reset](https://motherduck.com/docs/sql-reference/duckdb-sql-reference/duckdb-statements/set-reset) - [Unpivot](https://motherduck.com/docs/sql-reference/duckdb-sql-reference/duckdb-statements/unpivot) - [Update](https://motherduck.com/docs/sql-reference/duckdb-sql-reference/duckdb-statements/update) - [Use](https://motherduck.com/docs/sql-reference/duckdb-sql-reference/duckdb-statements/use) - [Vacuum](https://motherduck.com/docs/sql-reference/duckdb-sql-reference/duckdb-statements/vacuum) - [Enum](https://motherduck.com/docs/sql-reference/duckdb-sql-reference/enum) - [Expressions](https://motherduck.com/docs/sql-reference/duckdb-sql-reference/expressions) - [Functions](https://motherduck.com/docs/sql-reference/duckdb-sql-reference/functions) - [Duckdb Sql Reference](https://motherduck.com/docs/sql-reference/duckdb-sql-reference) - [Information Schema](https://motherduck.com/docs/sql-reference/duckdb-sql-reference/information-schema) - [Metadata Functions](https://motherduck.com/docs/sql-reference/duckdb-sql-reference/metadata-functions) - [Pragma Statements](https://motherduck.com/docs/sql-reference/duckdb-sql-reference/pragma-statements) - [Query Syntax](https://motherduck.com/docs/sql-reference/duckdb-sql-reference/query-syntax) - [Sample](https://motherduck.com/docs/sql-reference/duckdb-sql-reference/sample) - [Window Functions](https://motherduck.com/docs/sql-reference/duckdb-sql-reference/window-functions) - [Sql Reference](https://motherduck.com/docs/sql-reference) - [Embedding](https://motherduck.com/docs/sql-reference/motherduck-sql-reference/ai-functions/embedding) - [Prompt](https://motherduck.com/docs/sql-reference/motherduck-sql-reference/ai-functions/prompt) - [Prompt Explain](https://motherduck.com/docs/sql-reference/motherduck-sql-reference/ai-functions/sql-assistant/prompt-explain) - [Prompt Fix Line](https://motherduck.com/docs/sql-reference/motherduck-sql-reference/ai-functions/sql-assistant/prompt-fix-line) - [Prompt Fixup](https://motherduck.com/docs/sql-reference/motherduck-sql-reference/ai-functions/sql-assistant/prompt-fixup) - [Prompt Query](https://motherduck.com/docs/sql-reference/motherduck-sql-reference/ai-functions/sql-assistant/prompt-query) - [Prompt Schema](https://motherduck.com/docs/sql-reference/motherduck-sql-reference/ai-functions/sql-assistant/prompt-schema) - [Prompt Sql](https://motherduck.com/docs/sql-reference/motherduck-sql-reference/ai-functions/sql-assistant/prompt-sql) - [Attach Database](https://motherduck.com/docs/sql-reference/motherduck-sql-reference/attach-database) - [Attach Share](https://motherduck.com/docs/sql-reference/motherduck-sql-reference/attach-share) - [Connection Duckdb Id](https://motherduck.com/docs/sql-reference/motherduck-sql-reference/connection-management/connection-duckdb-id) - [Interrupt Connections](https://motherduck.com/docs/sql-reference/motherduck-sql-reference/connection-management/interrupt-connections) - [Monitor Connections](https://motherduck.com/docs/sql-reference/motherduck-sql-reference/connection-management/monitor-connections) - [Copy Database](https://motherduck.com/docs/sql-reference/motherduck-sql-reference/copy-database) - [Create Database](https://motherduck.com/docs/sql-reference/motherduck-sql-reference/create-database) - [Create Secret](https://motherduck.com/docs/sql-reference/motherduck-sql-reference/create-secret) - [Create Share](https://motherduck.com/docs/sql-reference/motherduck-sql-reference/create-share) - [Create Snapshot](https://motherduck.com/docs/sql-reference/motherduck-sql-reference/create-snapshot) - [Delete Secret](https://motherduck.com/docs/sql-reference/motherduck-sql-reference/delete-secret) - [Describe Share](https://motherduck.com/docs/sql-reference/motherduck-sql-reference/describe-share) - [Detach Database](https://motherduck.com/docs/sql-reference/motherduck-sql-reference/detach-database) - [Detach Share](https://motherduck.com/docs/sql-reference/motherduck-sql-reference/detach-share) - [Drop Database](https://motherduck.com/docs/sql-reference/motherduck-sql-reference/drop-database) - [Drop Share](https://motherduck.com/docs/sql-reference/motherduck-sql-reference/drop-share) - [Grant Access](https://motherduck.com/docs/sql-reference/motherduck-sql-reference/grant-access) - [List Secrets](https://motherduck.com/docs/sql-reference/motherduck-sql-reference/list-secrets) - [List Shares](https://motherduck.com/docs/sql-reference/motherduck-sql-reference/list-shares) - [Md Run Parameter](https://motherduck.com/docs/sql-reference/motherduck-sql-reference/md-run-parameter) - [Databases](https://motherduck.com/docs/sql-reference/motherduck-sql-reference/md_information_schema/databases) - [Introduction](https://motherduck.com/docs/sql-reference/motherduck-sql-reference/md_information_schema/introduction) - [Owned_shares](https://motherduck.com/docs/sql-reference/motherduck-sql-reference/md_information_schema/owned_shares) - [Shared_with_me](https://motherduck.com/docs/sql-reference/motherduck-sql-reference/md_information_schema/shared_with_me) - [Object Name Resolution](https://motherduck.com/docs/sql-reference/motherduck-sql-reference/object-name-resolution) - [Print Md Token](https://motherduck.com/docs/sql-reference/motherduck-sql-reference/print-md-token) - [Refresh Database](https://motherduck.com/docs/sql-reference/motherduck-sql-reference/refresh-database) - [Revoke Access](https://motherduck.com/docs/sql-reference/motherduck-sql-reference/revoke-access) - [Show Databases](https://motherduck.com/docs/sql-reference/motherduck-sql-reference/show-databases) - [Temporary Tables](https://motherduck.com/docs/sql-reference/motherduck-sql-reference/temporary-tables) - [Update Share](https://motherduck.com/docs/sql-reference/motherduck-sql-reference/update-share) - [Ducklings Get Duckling Config For User](https://motherduck.com/docs/sql-reference/rest-api/ducklings-get-duckling-config-for-user) - [Ducklings Set Duckling Config For User](https://motherduck.com/docs/sql-reference/rest-api/ducklings-set-duckling-config-for-user) - [Motherduck Rest Api](https://motherduck.com/docs/sql-reference/rest-api/motherduck-rest-api) - [Users Create Service Account](https://motherduck.com/docs/sql-reference/rest-api/users-create-service-account) - [Users Create Token](https://motherduck.com/docs/sql-reference/rest-api/users-create-token) - [Users Delete](https://motherduck.com/docs/sql-reference/rest-api/users-delete) - [Users Delete Token](https://motherduck.com/docs/sql-reference/rest-api/users-delete-token) - [Users List Tokens](https://motherduck.com/docs/sql-reference/rest-api/users-list-tokens) - [Error_messages](https://motherduck.com/docs/troubleshooting/error_messages) - [Faq](https://motherduck.com/docs/troubleshooting/faq) - [Troubleshooting](https://motherduck.com/docs/troubleshooting) - [Reinstall Md Extension](https://motherduck.com/docs/troubleshooting/reinstall-md-extension) - [Support](https://motherduck.com/docs/troubleshooting/support) - [Troubleshooting Access Policy](https://motherduck.com/docs/troubleshooting/troubleshooting-access-policy) - [Uninstall](https://motherduck.com/docs/troubleshooting/uninstall) - [Windows Certs](https://motherduck.com/docs/troubleshooting/windows-certs)