Results of 1 - 10 of about 11 for /⟨ (0.002 sec.)
- Azure Extension 12962
- The azure extension lets DuckDB read and write files in Azure Blob Storage and Azure Data Lake Storage (ADLS) Gen2. Installing and Loading The azure extension will be transparently autoloaded on first use from the official extension reposit
...Then you can query Azure storage as follows: Azure Blob Storage Allowed URI schemes: az or azure SELECT count(*) FROM 'az://⟨my_container⟩/⟨path⟩/⟨my_file⟩.⟨parquet_or_csv⟩'; Globs are also supported: SELECT * FROM 'az://⟨my_container⟩/⟨path⟩/*.csv...'; SELECT * FROM 'az://⟨my_container⟩/⟨path⟩/**'; Or with a fully qualified path syntax: SELECT count(*) FROM 'az://⟨my_storage_account⟩.blob.core....windows.net/⟨my_container⟩/⟨path⟩/⟨my_file⟩.⟨parquet_or_csv⟩'; SELECT * FROM 'az://⟨my_storage_account⟩.blob.core.windows.net/⟨my_contai... - https://man.mtool.work/duckdb/2.0/core_extensions/azure.html
- ODBC Extension 11220
- 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
...to the DuckDB nightly repository, can be installed the following way: INSTALL 'http://nightly-extensions.duckdb.org/v1.2.0/⟨platform⟩/odbc_scanner.duckdb_extension.gz'; The URL with the version 1.2.0 in it should be used even if you are running la...To update installed extension to the latest nightly version run: FORCE INSTALL 'http://nightly-extensions.duckdb.org/v1.2.0/⟨platform⟩/odbc_scanner.duckdb_extension.gz'; Installed version (commit ID) can be checked using the following query: FROM d...r'; To install a version built from a specific commit run: FORCE INSTALL 'http://nightly-extensions.duckdb.org/odbc_scanner/⟨7_character_commit_id⟩/v1.2.0/⟨platform⟩/odbc_scanner.duckdb_extension.gz'; Support Status of DBMS-Specific Types Tier 1: O... - https://man.mtool.work/duckdb/2.0/core_extensions/odbc/overview.html
- Hugging Face Support 10242
- The httpfs extension introduces support for the hf:// protocol to access datasets hosted in Hugging Face repositories. See the announcement blog post for details. Usage Hugging Face repositories can be queried using the following URL patter
...n: hf://datasets/⟨my_username⟩/⟨my_dataset⟩/⟨path_to_file⟩ For example, to read a CSV file, you can use the following query: SELECT * FROM 'h...s a branch or specific commit. You can query different dataset versions/revisions by using the following URL: hf://datasets/⟨my_username⟩/⟨my_dataset⟩@⟨my_branch⟩/⟨path_to_file⟩ For example: SELECT * FROM 'hf://datasets/datasets-examples/doc-format... - https://man.mtool.work/duckdb/2.0/core_extensions/httpfs/hugging_face.html
- AWS Extension 8748
- The aws extension adds functionality, e.g., authentication, on top of the httpfs extension's S3 capabilities , using the AWS SDK. Installing and Loading The aws extension will be transparently autoloaded on first use from the official exten
...OR REPLACE SECRET secret ( TYPE s3, PROVIDER credential_chain, CHAIN 'sts', ASSUME_ROLE_ARN 'arn:aws:iam::⟨account_id⟩:role/⟨role⟩', EXTERNAL_ID '⟨external_id⟩', REGION '⟨us-east-1⟩' ); The sts chain value requires an ASSUME_ROLE_ARN value. If the...E SECRET secret ( TYPE s3, PROVIDER credential_chain, CHAIN 'web_identity', ASSUME_ROLE_ARN 'arn:aws:iam::⟨account_id⟩:role/⟨role⟩', WEB_IDENTITY_TOKEN_FILE '⟨/var/run/secrets/eks.amazonaws.com/serviceaccount/token⟩' ); Single Sign-On (SSO) DuckDB... - https://man.mtool.work/duckdb/2.0/core_extensions/aws.html
- S3 Iceberg Import 8748
- Prerequisites Loading an Iceberg file from S3 requires both the httpfs and iceberg extensions. Install them using the INSTALL SQL command. You only need to install extensions once. INSTALL httpfs; INSTALL iceberg; To load the extensions, us
...are correctly configured, Iceberg tables can be read from S3 using the following command: SELECT * FROM iceberg_scan('s3://⟨bucket⟩/⟨iceberg_table_folder⟩/metadata/⟨id⟩.metadata.json'); If you pass the table folder instead of the metadata file, Du... - https://man.mtool.work/duckdb/2.0/guides/network_cloud_storage/s3_iceberg_import...
- ODBC API on Linux 8250
- Driver Manager A driver manager is required to manage communication between applications and the ODBC driver. We tested and support unixODBC that is a complete ODBC driver manager for Linux. Users can install it from the command line: On De
...etup on Linux is based on the .odbc.ini and .odbcinst.ini files. These files can be placed to the user home directory /home/⟨username⟩ or in the system /etc directory. The Driver Manager prioritizes the user configuration files over the system file... - https://man.mtool.work/duckdb/2.0/clients/odbc/linux.html
- Install Script 8250
- You can install the DuckDB CLI client using an install script. Linux and macOS To use the DuckDB install script on Linux and macOS, run: curl https://install.duckdb.org | bash Click to see the output of the install script. % Total % Receive
...: curl https://install.duckdb.org | DUCKDB_INSTALL=static,cli bash The libraries and headers are installed to ~/.duckdb/lib/⟨version⟩/release_⟨platform⟩ , e.g., ~/.duckdb/lib/2.0.0/release_osx_arm64 . For more details, see Linking Extensions . Wind... - https://man.mtool.work/duckdb/2.0/operations_manual/installing_duckdb/install_sc...
- Statically Linking Extensions 7503
- This page is for client and binding authors, and for anyone who embeds libduckdb in their own application. It describes how statically linking extensions changed in DuckDB 2.0 and what builders on top of DuckDB need to do. This change is in
...s tooling ( duckdb-install-scripts#5 ). Setting DUCKDB_INSTALL=static installs the archives and headers under ~/.duckdb/lib/⟨version⟩/⟨build_type⟩_⟨platform⟩ (e.g., ~/.duckdb/lib/2.0.0/release_osx_arm64 ): curl https://install.duckdb.org | DUCKDB_I... - https://man.mtool.work/duckdb/2.0/dev/building/linking_extensions.html
- Installing Extensions 7503
- To install core DuckDB extensions, use the INSTALL command. For example: INSTALL httpfs; This installs the extension from the default repository ( core ). Extension Repositories By default, DuckDB extensions are installed from a single repo
...umentation Installation Location By default, extensions are installed under the user's home directory: ~/.duckdb/extensions/⟨duckdb_version⟩/⟨platform_name⟩/ For stable DuckDB releases, the ⟨duckdb_version⟩ will be equal to the version tag of that... - https://man.mtool.work/duckdb/2.0/extensions/installing_extensions.html
- Catalogs 7254
- The iceberg extension supports attaching Iceberg REST Catalogs. Attaching a catalog is required for writing to Iceberg . Before attaching an Iceberg REST Catalog, you must install the iceberg extension by following the instructions located
...ts Manager : CREATE SECRET ( TYPE s3, PROVIDER credential_chain, CHAIN sts, ASSUME_ROLE_ARN 'arn:aws:iam::⟨account_id⟩:role/⟨role⟩', REGION 'us-east-2' ); In this example we use an STS token, but other authentication methods are supported . Then, c...r's account. ⟨account_id⟩ A 12-digit AWS account ID. ⟨account_id⟩:⟨catalog⟩ A named catalog in the given account. ⟨catalog⟩/⟨sub_catalog⟩ A nested (federated) catalog. ⟨account_id⟩:⟨catalog⟩/⟨sub_catalog⟩ A nested catalog in the given account. To c...E SECRET seaweedfs_secret ( TYPE iceberg, CLIENT_ID '⟨access_key⟩', CLIENT_SECRET '⟨secret_key⟩', OAUTH2_SERVER_URI 'http://⟨seaweedfs_host⟩:8181/v1/oauth/tokens' ); CREATE SECRET seaweedfs_storage ( TYPE s3, KEY_ID '⟨access_key⟩', SECRET '⟨secret_... - https://man.mtool.work/duckdb/2.0/core_extensions/iceberg/catalogs.html
DuckDB 2.0 Documentation / man.mtool.work