Results of 1 - 10 of about 22 for sources (0.002 sec.)
- ODBC Extension Functions 12003
- odbc_begin_transaction odbc_bind_params odbc_close odbc_commit odbc_connect odbc_copy odbc_create_params odbc_list_data_sources odbc_list_drivers odbc_query odbc_rollback odbc_begin_transaction odbc_begin_transaction(conn_handle BIGINT) ->
...is closed automatically when the statement is closed. Example: SET VARIABLE params1 = odbc_create_params() odbc_list_data_sources odbc_list_data_sources() -> TABLE(name VARCHAR, description VARCHAR, type VARCHAR) Returns the list of ODBC data sources r...egistered in the OS. Uses driver manager call SQLDataSources . Parameters: None. Returns: A table with the following columns: name ( VARCHAR ): data source name description ( VARCHAR...): data source description type ( VARCHAR ): data source type, USER or SYSTEM Example: FROM odbc_list_data_sources() odbc_list_drivers odbc_list_drivers() -> TABLE(description VARCHAR, attributes MAP(VARCHAR, VARCHAR)) Returns the list o... - https://man.mtool.work/duckdb/2.0/core_extensions/odbc/functions.html
- Securing DuckDB 12003
- DuckDB is a powerful analytical database engine. It can read and write files, access the network, load extensions, and use system resources. Like any powerful tool, these capabilities require appropriate configuration when working with sens
...usted Input Untrusted SQL Input Warning Treat SQL in DuckDB like code in Bash or Python. Do not execute SQL from untrusted sources without proper sandboxing. DuckDB executes SQL with the full privileges of the user running it, much like a shell or scrip...n program without sandboxing, apply the same caution to SQL in DuckDB. If your application must execute SQL from untrusted sources, use additional safeguards when running untrusted code such as: Use duckdb-wasm for sandboxing Run DuckDB in an isolated c..., but also for preventing denial of service (DoS) attacks: malicious inputs can easily cause DuckDB to consume excessive resources such as memory, disk, CPU, or network. Untrusted Non-SQL Input Warning Even non-SQL input into DuckDB can easily have unin... - https://man.mtool.work/duckdb/2.0/operations_manual/securing_duckdb/overview.htm...
- Data Sources 11380
- DuckDB supports several data sources, including file formats, network protocols, and database systems: AWS S3 buckets and storage with S3-compatible API Azure Blob Storage Blob files Cloudflare R2 CSV Delta Lake DuckLake Excel httpfs Iceber
... - https://man.mtool.work/duckdb/2.0/data/data_sources.html
- marimo Notebooks 10454
- marimo is an open-source reactive notebook for Python and SQL that's tightly integrated with DuckDB's Python client, letting you mix and match Python and SQL in a single git-versionable notebook. Unlike traditional notebooks, when you run a
...and Table Auto-Discovery marimo introspects connections and displays the database, schemas, tables and columns in the Data Sources panel. This panel lets you quickly navigate your schemas to pull tables and columns into your SQL queries. Data Sources Pa... - https://man.mtool.work/duckdb/2.0/guides/python/marimo.html
- Building Configuration 10151
- Build Types DuckDB can be built in many different settings, most of these correspond directly to CMake but not all of them. release This build has been stripped of all the assertions and debug symbols and code, optimized for performance. de
...version when building from source using the OVERRIDE_GIT_DESCRIBE environment variable. This is useful when building from sources that are not part of a complete Git repository (e.g., an archive file with no information on commit hashes and tags). For...kDB normally derives its version and commit hash from Git, so OVERRIDE_GIT_DESCRIBE is primarily useful when building from sources that are not a complete Git checkout. The version and commit hash are resolved as follows: If OVERRIDE_GIT_DESCRIBE is set... - https://man.mtool.work/duckdb/2.0/dev/building/build_configuration.html
- Glossary of Terms 9225
- This page contains a glossary of a few common terms used in DuckDB. Terms In-Process Database Management System The DBMS runs in the client application's process instead of running as a separate process, which is common in the traditional c
...he table. Using replacement scans allows DuckDB to, e.g., seamlessly read Pandas DataFrames or read input data from remote sources without explicitly invoking the functions that perform this (e.g., reading Parquet files from https ). For details, see th... - https://man.mtool.work/duckdb/2.0/guides/glossary.html
- ODBC Extension 8602
- Please note that DuckDB also offers an ODBC client , which allows you to connect to DuckDB via ODBC from other applications. The odbc_scanner extension allows connecting to other databases (using their ODBC drivers ) and run queries with th
...hout a configured data source in a form Driver={Driver name};parameter1=values1;... . odbc_list_drivers and odbc_list_data_sources functions can be used to find out available drivers and data sources. Example of connection strings without a configured d... - https://man.mtool.work/duckdb/2.0/core_extensions/odbc/overview.html
- Share a DuckDB Database That Only Stores Views 8602
- 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
...log (READ_ONLY); SELECT count(*) AS num_stations FROM catalog.stations; Consumers need the httpfs extension and, for s3:// sources, credentials that grant access to the underlying data. Limitations Consumers must be able to access both the catalog file... - https://man.mtool.work/duckdb/2.0/guides/network_cloud_storage/duckdb_views_only...
- Non-Deterministic Behavior 8299
- Several operators in DuckDB exhibit non-deterministic behavior. Most notably, SQL uses set semantics, which allows results to be returned in a different order. DuckDB exploits this to improve performance, particularly when performing multi-
...o make your queries deterministic, see the “Working Around Non-Determinism” section . Set Semantics One of the most common sources of non-determinism is the set semantics used by SQL. E.g., if you run the following query repeatedly, you may get two diff... - https://man.mtool.work/duckdb/2.0/operations_manual/non-deterministic_behavior.h...
- Avro Extension 7996
- 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
...ction is integrated into DuckDB's file system abstraction, meaning you can read Avro files directly from, e.g., HTTP or S3 sources. For example: FROM read_avro('https://blobs.duckdb.org/data/userdata1.avro'); FROM read_avro('s3://⟨your-bucket⟩/⟨some_fil... - https://man.mtool.work/duckdb/2.0/core_extensions/avro.html
DuckDB 2.0 Documentation / man.mtool.work