Results of 1 - 10 of about 14 for authenticate (0.002 sec.)
- Amazon RDS with IAM Authentication 12341
- Managed PostgreSQL databases on Amazon RDS and Aurora can authenticate with short-lived IAM tokens instead of a static password. DuckDB supports this through the postgres and aws extensions: the aws extension generates the token from an AWS
... - https://man.mtool.work/duckdb/2.0/guides/database_integration/rds_iam.html
- S3 API Support 11500
- 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)
...lable methods and guidance on which one to use, see the S3 and AWS Authentication page. The preferred way to configure and authenticate to S3 endpoints is to use secrets . Multiple secret providers are available. To migrate from the deprecated S3 API , use a...R2 STRING s3.amazonaws.com for S3 , KEY_ID The ID of the key to use S3 , GCS , R2 STRING - REGION The region for which to authenticate (should match the region of the bucket to query) S3 , GCS , R2 STRING us-east-1 SECRET The secret of the key to use S3 , G... - https://man.mtool.work/duckdb/2.0/core_extensions/httpfs/s3api.html
- Delta Extension 9820
- The delta extension adds support for the Delta Lake open-source storage format . It is built using the Delta Kernel . The extension reads Delta tables, local and remote, and writes them: it can create tables and append to them. For implemen
...ing from an S3 Bucket To scan a Delta table in an S3 bucket , run: SELECT * FROM delta_scan('s3://⟨my_bucket⟩/⟨path⟩'); To authenticate, create a secret : CREATE SECRET ( TYPE s3, PROVIDER credential_chain ); SELECT * FROM delta_scan('s3://⟨my_bucket⟩/⟨path⟩...To scan a Delta table in an Azure Blob Storage container , run: SELECT * FROM delta_scan('az://⟨my_container⟩/⟨path⟩'); To authenticate, create a secret : CREATE SECRET ( TYPE azure, PROVIDER credential_chain, ACCOUNT_NAME '⟨storage_account_name⟩' ); SELECT... - https://man.mtool.work/duckdb/2.0/core_extensions/delta.html
- HTTP(S) Support 9820
- With the httpfs extension, it is possible to directly query files over the HTTP(S) protocol. This works for all files supported by DuckDB or its various extensions, and provides read-only access. SELECT * FROM 'https://domain.tld/file.exten
...SELECT * FROM read_parquet([ 'https://domain.tld/file1.parquet', 'https://domain.tld/file2.parquet' ]); Authenticating To authenticate for an HTTP(S) endpoint, create an HTTP secret using the Secrets Manager : CREATE SECRET http_auth ( TYPE http, BEARER_TOK... - https://man.mtool.work/duckdb/2.0/core_extensions/httpfs/https.html
- Legacy Authentication Scheme for S3 API 9820
- Prior to version 0.10.0, DuckDB did not have a Secrets manager . Hence, the configuration of and authentication to S3 endpoints was handled via variables. This page documents the legacy authentication scheme for the S3 API. Warning This pag
...by printing their values). Therefore, avoid using these methods for storing secrets. The recommended way to configure and authenticate of S3 endpoints is to use secrets . Legacy Authentication Scheme To be able to read or write from S3, the correct region s... - https://man.mtool.work/duckdb/2.0/core_extensions/httpfs/s3api_legacy_authentica...
- Guides 9820
- The guides section contains compact how-to guides that are focused on achieving a single goal. For API references and examples, see the rest of the documentation. Note that there are many tools using DuckDB, which are not covered in the off
...a Parquet file How to run a query directly on a Parquet file HTTP(S), S3 and GCP Network and cloud storage overview How to authenticate to S3 / AWS How to load a Parquet file directly from HTTP(S) How to load a CSV file directly from HTTP(S) How to load a Pa... - https://man.mtool.work/duckdb/2.0/guides/overview.html
- Iceberg Extension 8980
- The iceberg extension implements support for the Apache Iceberg open table format . There are two ways to work with Iceberg in DuckDB: Individual tables are read directly from storage, by pointing at a table's metadata. This requires no cat
...les For full read and write access — and to use Iceberg's catalog features — attach an Iceberg REST catalog. Most catalogs authenticate with OAuth2; store the credentials in a secret and attach the catalog with ATTACH ... (TYPE iceberg, ...) : CREATE SECRET... - https://man.mtool.work/duckdb/2.0/core_extensions/iceberg/overview.html
- AWS Extension 7299
- 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
...lable methods and guidance on which one to use, see the S3 and AWS Authentication page. The preferred way to configure and authenticate to AWS S3 endpoints is to use secrets . There are two S3 secret providers: The config provider, where you supply the acces... - https://man.mtool.work/duckdb/2.0/core_extensions/aws.html
- Catalogs 7299
- 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
...e Polaris , Lakekeeper , SeaweedFS and Google Cloud BigLake . Attaching an Iceberg REST Catalog Most Iceberg REST Catalogs authenticate via OAuth2. You can use the existing DuckDB secret workflow to store login credentials for the OAuth2 service. CREATE SECR... - https://man.mtool.work/duckdb/2.0/core_extensions/iceberg/catalogs.html
- Securing DuckDB 7299
- 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
...from a client. Queries can access the secrets defined in the Secrets Manager. For example, if there is a secret defined to authenticate with a user, who has write privileges to a given AWS S3 bucket, queries may write to that bucket. This is applicable for b... - https://man.mtool.work/duckdb/2.0/operations_manual/securing_duckdb/overview.htm...
DuckDB 2.0 Documentation / man.mtool.work