Results of 1 - 10 of about 13 for account (0.003 sec.)
- Azure Extension 14234
- 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
...it manually, run: INSTALL AND LOAD azure; Usage Queries need a secret ; for a public container, a secret with the storage account name is enough (see the CONFIG provider ). Then you can query Azure storage as follows: Azure Blob Storage Allowed URI sch...LECT * 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.co...FROM 'abfss://⟨my_filesystem⟩/⟨path⟩/**'; Or with a fully qualified path syntax: SELECT count(*) FROM 'abfss://⟨my_storage_account⟩.dfs.core.windows.net/⟨my_filesystem⟩/⟨path⟩/⟨my_file⟩.⟨parquet_or_csv⟩'; SELECT * FROM 'abfss://⟨my_storage_account⟩.dfs.... - https://man.mtool.work/duckdb/2.0/core_extensions/azure.html
- Catalogs 10258
- 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
...using the Secrets 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 supporte...d . Then, connect to the catalog: ATTACH '⟨account_id⟩' AS glue_catalog ( TYPE iceberg, URI 'glue.⟨region⟩.amazonaws.com/iceberg', AUTHORIZATION_TYPE 'sigv4' ); Or alternati...vely: ATTACH '⟨account_id⟩' AS glue_catalog ( TYPE iceberg, ENDPOINT_TYPE 'glue' ); Warning As with Amazon S3 Tables , ENDPOINT_TYPE glue always... - https://man.mtool.work/duckdb/2.0/core_extensions/iceberg/catalogs.html
- S3 API Support 9396
- 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)
...HTTP S3 , GCS , R2 BOOLEAN true VERIFY_SSL Whether to verify the SSL certificate of the server S3 , GCS , R2 BOOLEAN 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 fo...SECRET secret ( TYPE s3, PROVIDER credential_chain, CHAIN config, REGION '⟨eu-west-1⟩', KMS_KEY_ID 'arn:aws:kms:⟨region⟩:⟨account_id⟩:⟨key⟩/⟨key_id⟩', SCOPE 's3://⟨bucket-sub-path⟩' ); R2 Secrets While Cloudflare R2 uses the regular S3 API, DuckDB has...OR REPLACE SECRET secret ( TYPE r2, KEY_ID '⟨AKIAIOSFODNN7EXAMPLE⟩', SECRET '⟨wJalrXUtnFEMI/K7MDENG/bPxRfiCYEXAMPLEKEY⟩', ACCOUNT_ID '⟨my_account_id⟩' ); Note the addition of the ACCOUNT_ID which is used to generate the correct endpoint URL for you. Al... - https://man.mtool.work/duckdb/2.0/core_extensions/httpfs/s3api.html
- Cloudflare R2 Import 8991
- Prerequisites For Cloudflare R2, the S3 Compatibility API allows you to use DuckDB's S3 support to read and write from R2 buckets. This requires the httpfs extension , which can be installed using the INSTALL SQL command. This only needs to
...in DuckDB: CREATE SECRET ( TYPE r2, KEY_ID '⟨AKIAIOSFODNN7EXAMPLE⟩', SECRET '⟨wJalrXUtnFEMI/K7MDENG/bPxRfiCYEXAMPLEKEY⟩', ACCOUNT_ID '⟨your-32-character-hexadecimal-account-ID⟩' ); Querying After setting up the R2 credentials, you can query the R2 data... - https://man.mtool.work/duckdb/2.0/guides/network_cloud_storage/cloudflare_r2_imp...
- ATTACH and DETACH Statements 8815
- DuckDB allows attaching to and detaching from database files. Examples Attach the database file.db with the alias inferred from the name ( file ): ATTACH 'file.db'; Attach the database file.db with an explicit alias ( file_db ): ATTACH 'fil
...bles , environment variables or string concatenation. This keeps credentials and environment-specific identifiers, such as account numbers, out of your SQL scripts. Read the database path from a variable: SET VARIABLE db_path = 'file.db'; ATTACH getvari...able('db_path') AS file_db; Build the path by concatenating a variable, for example an account number read from the environment: SET VARIABLE account_id = '123456789012'; ATTACH 'account_' || getvariable('account_id')...|| '.db' AS account_db; Read the path from an environment variable using getenv() , which is available in the CLI client only: ATTACH getenv('... - https://man.mtool.work/duckdb/2.0/sql/statements/attach.html
- AWS Extension 8234
- 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
...e 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 config....policy: CREATE 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 val...ue. 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 SESSION_NA... - https://man.mtool.work/duckdb/2.0/core_extensions/aws.html
- Spatial Functions 8181
- Function Index Scalar Functions Function Summary DuckDB_PROJ_Compiled_Version Returns a text description of the PROJ library version that this instance of DuckDB was compiled against. DuckDB_Proj_Version Returns a text description of the PR
...action of the total 2D length of the line. ST_LineMerge "Merges" the input line geometry, optionally taking direction into account. ST_LineString2DFromWKB Deserialize a LINESTRING_2D from a WKB encoded blob ST_LineSubstring Returns a substring of a line...f the earth. This is a highly accurate method for calculating the area of a polygon taking the curvature of the earth into account, but is also the slowest. Returns 0.0 for any geometry that is not a POLYGON , MULTIPOLYGON or GEOMETRYCOLLECTION containi...orner to the mitre point to the corner radius. The default value is 1.0. This is a planar operation and will not take into account the curvature of the earth. ST_BuildArea Signature GEOMETRY ST_BuildArea (geom GEOMETRY) Description Creates a polygonal g... - https://man.mtool.work/duckdb/2.0/core_extensions/spatial/functions.html
- Data Import 8005
- Recommended Import Methods When importing data from other systems to DuckDB, there are several considerations to take into account. We recommend importing using the following order: For systems which are supported by a DuckDB scanner extens
... - https://man.mtool.work/duckdb/2.0/guides/performance/import.html
- ODBC API on Windows 7724
- Setup Using the DuckDB ODBC API on Windows requires the following steps: Microsoft Windows requires an ODBC Driver Manager to manage communication between applications and the ODBC drivers. The Driver Manager on Windows is provided in a DLL
...uble-click on the odbc_install.exe . Windows administrator privileges are required. In case of a non-administrator, a User Account Control prompt will occur. odbc_install.exe adds a default DSN configuration into the ODBC registries with a default datab... - https://man.mtool.work/duckdb/2.0/clients/odbc/windows.html
- Delta Extension 7724
- 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
...n('az://⟨my_container⟩/⟨path⟩'); To authenticate, create a secret : CREATE SECRET ( TYPE azure, PROVIDER credential_chain, ACCOUNT_NAME '⟨storage_account_name⟩' ); SELECT * FROM delta_scan('az://⟨my_container⟩/⟨path⟩'); Reading from Google Cloud Storage... - https://man.mtool.work/duckdb/2.0/core_extensions/delta.html
DuckDB 2.0 Documentation / man.mtool.work