Results of 1 - 10 of about 15 for Service (0.002 sec.)
- Dutch Railway Datasets 14873
- Examples in this documentation often use datasets based on the Dutch Railway datasets . These high-quality datasets are maintained by the team behind the Rijden de Treinen (Are the trains running?) application . This page contains download
...post on the analysis of these datasets . Loading the Datasets You can load the datasets directly as follows: CREATE TABLE services AS FROM 'https://blobs.duckdb.org/nl-railway/services-2025-03.csv.gz'; DESCRIBE services; column_name column_type null ke...y default extra Service:RDT-ID BIGINT YES NULL NULL NULL Service:Date DATE YES NULL NULL NULL Service:Type VARCHAR YES NULL NULL NULL Service:Comp...any VARCHAR YES NULL NULL NULL Service:Train number BIGINT YES NULL NULL NULL Service:Completely cancelled BOOLEAN YES NULL NULL NULL Service:Partly cancelled BO... - https://man.mtool.work/duckdb/2.0/guides/snippets/dutch_railway_datasets.html
- Secrets Manager 9857
- The Secrets manager provides a unified user interface for secrets across all backends that use them. Secrets can be scoped, so different storage prefixes can have different secrets, allowing for example to join data across organizations in
...e user running the DuckDB process can read and write them. Types of Secrets Secrets are typed, their type identifies which service they are for. Most secrets are not included in DuckDB by default; instead, they are registered by extensions. Currently, t...he following secret types are available: Secret type Service / protocol Extension azure Azure Blob Storage azure ducklake DuckLake ducklake gcs Google Cloud Storage httpfs http HTTP a...sing the DROP SECRET statement , e.g.: DROP PERSISTENT SECRET my_persistent_secret; Creating Multiple Secrets for the Same Service Type If two secrets exist for a service type, the scope can be used to decide which one should be used. For example: CREAT... - https://man.mtool.work/duckdb/2.0/configuration/secrets_manager.html
- Azure Extension 9091
- 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
...er works like credential_chain . With several identities and no ID, the Azure SDK decides which one is used, so set an ID. SERVICE_PRINCIPAL Provider The SERVICE_PRINCIPAL provider allows connecting using an Azure Service Principal (SPN) . With a client...secret: CREATE SECRET azure_spn ( TYPE azure, PROVIDER service_principal, TENANT_ID '⟨tenant_id⟩', CLIENT_ID '⟨client_id⟩', CLIENT_SECRET '⟨client_secret⟩', ACCOUNT_NAME '⟨storage_accou...nt_name⟩' ); Or with a certificate: CREATE SECRET azure_spn_cert ( TYPE azure, PROVIDER service_principal, TENANT_ID '⟨tenant_id⟩', CLIENT_ID '⟨client_id⟩', CLIENT_CERTIFICATE_PATH '⟨client_cert_path⟩', ACCOUNT_NAME '⟨... - https://man.mtool.work/duckdb/2.0/core_extensions/azure.html
- S3 API Support 8742
- The httpfs extension supports reading/writing/ globbing files on object storage servers using the S3 API. S3 offers a standard API to read and write to remote files (while regular http servers, predating S3, do not offer a common write API)
...ndustry storage providers. Platforms The httpfs filesystem is tested with AWS S3 , Minio , Google Cloud and lakeFS . Other services that implement the S3 API (such as Cloudflare R2 , SeaweedFS , and Tigris ) should also work, but not all features may be...AN true ACCOUNT_ID The R2 account ID to use for generating the endpoint URL R2 STRING - KMS_KEY_ID AWS KMS (Key Management Service) key for Server Side Encryption S3 S3 STRING - REQUESTER_PAYS Allows use of "requester pays" S3 buckets S3 BOOLEAN false R...Platform-Specific Secret Types S3 Secrets The httpfs extension supports Server Side Encryption via the AWS Key Management Service (KMS) on S3 using the KMS_KEY_ID option: CREATE OR REPLACE SECRET secret ( TYPE s3, PROVIDER credential_chain, CHAIN confi... - https://man.mtool.work/duckdb/2.0/core_extensions/httpfs/s3api.html
- Advanced Installation Methods 8411
- Downloading Extensions Directly from S3 Downloading an extension directly can be helpful when building a Lambda service or container that uses DuckDB. DuckDB extensions are stored in public S3 buckets, but the directory structure of those b
... - https://man.mtool.work/duckdb/2.0/extensions/advanced_installation_methods.html
- AWS Extension 8324
- 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
...g' ); The possible values for CHAIN are the following: config sts sso env instance process web_identity (for IAM Roles for Service Accounts (IRSA) ; see Web Identity (IRSA) ) The credential_chain provider also allows overriding the automatically fetched...ROLE_ARN value. If the selected profile itself uses STS, use CHAIN 'config' instead. Web Identity (IRSA) For IAM Roles for Service Accounts (IRSA) — commonly used on Amazon EKS — use the web_identity chain together with a role ARN and a token file. A SE...ty', 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 can use credentials obtained through AWS IAM Identity Center (formerly AWS S... - https://man.mtool.work/duckdb/2.0/core_extensions/aws.html
- S3 and AWS Authentication 8150
- This page is the entry point for authenticating to S3 and other AWS services from DuckDB. Authentication is configured using secrets , and the detailed reference material lives on the S3 API Support and AWS Extension pages. The sections bel
...ume an IAM role via STS credential_chain with the sts chain Assuming a Role (STS) You run on Amazon EKS with IAM Roles for Service Accounts (IRSA) credential_chain with the web_identity chain Web Identity (IRSA) You run on an EC2 instance and want to us... - https://man.mtool.work/duckdb/2.0/core_extensions/httpfs/authentication.html
- Iceberg Options 8150
- This page lists the options of the iceberg extension: the parameters accepted by the Iceberg functions , the options of the ATTACH and CREATE SECRET statements used to connect to a catalog , and the global settings. ATTACH Options To make a
...4 are the following. Parameter Type Default Description SECRET VARCHAR NULL The S3 or AWS SECRET to use for signing. SIGV4_SERVICE VARCHAR NULL Override the SERVICE for signing requests, otherwise inferred from the URI parameter. SIGV4_REGION VARCHAR NU... - https://man.mtool.work/duckdb/2.0/core_extensions/iceberg/iceberg_options.html
- Securing Extensions 7976
- DuckDB has a powerful extension mechanism, which has the same privileges as the user running DuckDB's (parent) process. This introduces security considerations. Therefore, we recommend reviewing the configuration options listed on this page
...loper could create and register a harmless-looking DuckDB extension that steals your crypto coins. If you're running a web service that executes untrusted SQL from users with DuckDB, we recommend disabling community extensions. To do so, run: SET allow_... - https://man.mtool.work/duckdb/2.0/operations_manual/securing_duckdb/securing_ext...
- Connect 7889
- Overview Every DuckDB feature reachable from Java starts with a Connection . This page covers the JDBC URL forms the driver accepts, how DuckDB and driver options are passed and which of them win, how connections come to share (or not share
...VMs the driver registers itself with the DriverManager automatically when the JDBC JAR is on the classpath (through Java's service-provider mechanism ), so no setup is needed. If that does not happen for some reason, load the DuckDBDriver class explicit...onn = DriverManager.getConnection("jdbc:duckdb:"); In GraalVM Native Image executables, always use this explicit load: the service-provider discovery is not reliably visible to Native Image's static analysis. To create a DuckDB connection, call DriverMa... - https://man.mtool.work/duckdb/2.0/clients/java/connecting.html
DuckDB 2.0 Documentation / man.mtool.work