Скачать или смотреть What are the interesting DuckDB metadata functions ?

➡️ Follow Us
LinkedIn:   / motherduck  
X/Twitter :   / motherduck  
Blog: https://motherduck.com/blog/

#dataengineering #duckdb

--------------------------------------

In this DuckDB tutorial, we explore three powerful yet often overlooked metadata tables that can supercharge your workflow with the popular in-process analytical database. If you've ever wondered how to check or modify DuckDB configurations, the `duckdb_settings` function table is your starting point. It provides a queryable list of all system settings and their default values for parameters like `memory_limit` and `threads`. This makes DuckDB performance tuning more transparent, showing you exactly how to change a DuckDB setting with a simple SQL command.

Next, we dive into `duckdb_extensions`, a system table essential for managing the rich ecosystem of DuckDB extensions. Here, you can quickly see all available core extensions and check which ones are installed and loaded in your environment. This is invaluable for debugging or when you need to manually load or install a specific extension. While most extensions auto-load, this table gives you a clear view of what’s happening behind the scenes, ensuring you have the right tools active for your data analysis tasks.

Finally, we cover a personal favorite for database introspection: the `duckdb_tables` and `duckdb_views` system tables. These metadata tables allow you to query information about all the tables and views in your database. The standout feature is the `sql` column, which contains the complete DDL (Data Definition Language) used to create each object. This is a game-changer for anyone asking "how to view all tables in DuckDB" or needing to reuse complex table creation SQL without digging through old scripts.