Results of 1 - 10 of about 16 for definitions (0.003 sec.)
- Share a DuckDB Database That Only Stores Views 13932
- A DuckDB database file does not have to contain any data: it can store only view definitions that point at remote data such as Parquet files on object storage. The resulting file is only a few hundred kilobytes, yet it behaves like a shared
...ts original location and format. This is useful for publishing a curated “semantic layer” over a data lake, where the view definitions encode the joins, filters, and column names that consumers should use, without copying or moving the data itself. Prerequi...ATE VIEW stations AS SELECT * FROM read_parquet('s3://my-bucket/rail/stations.parquet'); Because the file stores only view definitions, it stays small no matter how large the referenced datasets are. Hosting the Catalog Upload the catalog.duckdb file to any... - https://man.mtool.work/duckdb/2.0/guides/network_cloud_storage/duckdb_views_only...
- Troubleshooting Quack 11038
- DuckDB 2.0 ships a polished version of Quack (first released in DuckDB 1.5.3) with substantial performance and stability improvements. If you experience any issues with Quack, try upgrading all your DuckDB clients to the latest version of t
...TTACH Fails to Bind a Remote Table Definition When a Quack client runs ATTACH 'quack:⟨host⟩' , it loads the server's table definitions up front and binds them locally. A single definition that cannot be bound fails the entire attachment, even when you only...with TABLE_RESOLUTION 'eager' so that schemas are resolved while tables are enumerated, which lets Quack import their real definitions: {:.codebox-server} -- Server: substitute your own warehouse, URI, and secret. LOAD iceberg; LOAD quack; ATTACH 'warehouse... - https://man.mtool.work/duckdb/2.0/quack/troubleshooting.html
- Avro Extension 10587
- The avro extension enables DuckDB to read Apache Avro files. The avro extension was released as a community extension in late 2024 and became a core extension in early 2025. The read_avro Function The extension adds a single DuckDB function
...automatically translates the Avro Schema to the DuckDB schema. All Avro types can be translated, except for recursive type definitions , which DuckDB does not support. The type mapping is very straightforward except for Avro's "unique" way of handling NULL...library dependency (sigh again). We plan to fix this eventually. As mentioned above, DuckDB cannot express recursive type definitions that Avro has, this is unlikely to ever change. There is no support to allow users to provide a separate Avro schema file.... - https://man.mtool.work/duckdb/2.0/core_extensions/avro.html
- Files Created by DuckDB 9253
- DuckDB creates several files and directories on disk. This page lists both the global and the local ones. Global Files and Directories DuckDB creates the following global files and directories in the user's home directory (denoted with ~ ):
...Yes ~/.duckdb/stored_secrets Persistent secrets created by the Secrets manager . Yes Yes ~/.duckdb/extension_repositories Definitions of custom extension repositories , including their pinned public keys, stored as one JSON file per repository. Created by... - https://man.mtool.work/duckdb/2.0/operations_manual/footprint_of_duckdb/files_cr...
- PEG Parser 8577
- New Starting with DuckDB 2.0, the PEG parser is the default parser. In earlier versions it was an experimental, opt-in feature enabled with enable_peg_parser() , which is no longer required or available. DuckDB uses a parser based on PEG (
...), whereas DuckDB 2.0 returns 12 . Rendered SQL qualifies built-in functions, for example main.struct_pack(x := 1) in view definitions. ORDER BY true is accepted, whereas DuckDB 2.0 rejects a non-integer literal. Column constraints on ALTER TABLE ... ADD CO... - https://man.mtool.work/duckdb/2.0/sql/peg_parser.html
- Geometry Data Type 8369
- Name Description GEOMETRY Geospatial entity The GEOMETRY data type is used to store and manipulate geometric objects, such as points, lines, and polygons. The GEOMETRY type was part of the spatial extension but became a built-in data type i
...CRS definition in WKT or PROJJSON format instead of a shorthand identifier as the CRS parameter. However, as complete CRS definitions are usually very large, this gets unwieldy very quickly and is not recommended for interactive use. It is currently not po...ssible to define a custom CRS from within SQL, or to persist custom CRS definitions in a database such that DuckDB can use them to resolve CRS identifiers for geometry columns, but this is something we are... - https://man.mtool.work/duckdb/2.0/sql/data_types/geometry.html
- CSV Auto Detection 7919
- When using read_csv , the system tries to automatically infer how to read the CSV file using the CSV sniffer . This step is necessary because CSV files are not self-describing and come in many different dialects. The auto-detection works ro
...ected types can be individually overridden using the types option. This option takes either of two options: A list of type definitions (e.g., types = ['INTEGER', 'VARCHAR', 'DATE'] ). This overrides the types of the columns in-order of occurrence in the CSV... - https://man.mtool.work/duckdb/2.0/data/csv/auto_detection.html
- Quack Remote Protocol 7919
- The Quack extension turns a DuckDB instance into a server that other DuckDB instances (clients) can connect to over HTTP. This page covers the protocol at a glance and walks through basic usage on both sides of the wire. For the full list o
...d-hoc SQL scoped to that attachment: {:.codebox-client} FROM remote_db.query('SELECT 42'); ATTACH binds the remote's table definitions on the client, so a single table definition that cannot be bound fails the whole attachment. If this happens (for example,... - https://man.mtool.work/duckdb/2.0/quack/overview.html
- GROUPING SETS 7919
- GROUPING SETS , ROLLUP and CUBE can be used in the GROUP BY clause to perform a grouping over multiple dimensions within the same query. Note that this syntax is not compatible with GROUP BY ALL . Examples Compute the average income along t
...number of expressions passed to GROUPING_ID() , or the order in which they are passed is independent from the actual group definitions appearing in the GROUPING SETS -clause (or the groups implied by ROLLUP and CUBE ). As long as the expressions passed to G... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/grouping_sets.html
- Query 7693
- The duckdb_query method allows SQL queries to be run in DuckDB from C. This method takes two parameters, a (null-terminated) SQL query string and a duckdb_result result pointer. The result pointer may be NULL if the application is not inter
...fied column. duckdb_result_get_arrow_options Returns the arrow options associated with the given result. These options are definitions of how the arrow arrays/schema should be produced. Syntax duckdb_arrow_options duckdb_result_get_arrow_options ( duckdb_re... - https://man.mtool.work/duckdb/2.0/clients/c/query.html
DuckDB 2.0 Documentation / man.mtool.work