⌘K ctrl+k
Search Shortcut cmd + k | ctrl + k
DuckDB 1.3 ドキュメント 全文検索
per page, with , order by , clip by
Results of 1 - 10 of about 19 for endpoint (0.003 sec.)
Iceberg REST Catalogs – DuckDB 13404
This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview ... arehouse ' AS iceberg_catalog ( TYPE iceberg , SECRET iceberg_secret , -- pass a specific secret name to prevent ambiguity ENDPOINT https://rest_endpoint.com ); To see the available tables run SHOW ALL TABLES ; ATTACH OPTIONS A REST Catalog with OAuth2 a ... an ATTACH statement. See the complete list of ATTACH options for a REST catalog below. Parameter Type Default Description ENDPOINT_TYPE VARCHAR NULL Used for attaching S3Tables or Glue catalogs. Allowed values are 'GLUE' and 'S3_TABLES' ENDPOINT VARCHAR ... NULL URL endpoint to communicate with the REST Catalog. Cannot be used in conjunction with ENDPOINT_TYPE SECRET VARCHAR NULL Name of secret ...
https://man.mtool.work/duckdb/1.3/core_extensions/iceberg/iceberg_rest_catalogs....
Legacy Authentication Scheme for S3 API – DuckDB 12243
This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview ... API 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 page describ ... ). Therefore, avoid using these methods for storing secrets. The recommended way to configuration and authentication of S3 endpoints is to use secrets . Legacy Authentication Scheme To be able to read or write from S3, the correct region should be set: S ... ET s3_region = 'us-east-1' ; Optionally, the endpoint can be configured in case a non-AWS object storage server is used: SET s3_endpoint = ' domain . tld : port ' ; If the endp ...
https://man.mtool.work/duckdb/1.3/core_extensions/httpfs/s3api_legacy_authentica...
S3 API Support – DuckDB 10228
This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview ... ectsV2 File writes Multipart upload Configuration and Authentication 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 defined secret ... PxRfiCYEXAMPLEKEY ' , REGION ' us-east-1 ' ); Tip If you get an IO Error ( Connection error for HTTP HEAD ), configure the endpoint explicitly via ENDPOINT 's3. your_region .amazonaws.com' . Now, to query using the above secret, simply query any s3:// pr ... orted parameters that can be used for both the config and credential_chain providers: Name Description Secret Type Default ENDPOINT Specify a custom S3 endpoint S3 , GCS , R2 STRING s3.amazonaws.com for S3 , KEY_ID The ID of the key to use S3 , GCS , R2 ...
https://man.mtool.work/duckdb/1.3/core_extensions/httpfs/s3api.html
Fastly Object Storage Import – DuckDB 9391
This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview ... D ' AKIAIOSFODNN7EXAMPLE ' , SECRET ' wJalrXUtnFEMI/K7MDENG/bPxRfiCYEXAMPLEKEY ' , URL_STYLE 'path' , REGION ' us-east ' , ENDPOINT ' us-east .object.fastlystorage.app' -- see note below ); The ENDPOINT needs to point to the Fastly endpoint for the regio ... n you want to use (e.g eu-central.object.fastlystorage.app ). REGION must use the same region mentioned in ENDPOINT . URL_STYLE needs to use path . Querying After setting up the Fastly Object Storage credentials, you can query the data th ...
https://man.mtool.work/duckdb/1.3/guides/network_cloud_storage/fastly_object_sto...
Sharing Macros – DuckDB 9066
This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview ... ──────┘ As one would expect, the macro gets persisted in the database. But this also means that we can host it on an HTTPS endpoint and share it with anyone! We have published this macro on blobs.duckdb.org . You can try it from DuckDB: duckdb Make sure ... that the httpfs extension is installed: INSTALL httpfs ; You can now attach to the remote endpoint and use the macro: ATTACH 'https://blobs.duckdb.org/data/pretty_print_integer_macro.duckdb' AS pretty_print_macro_db ; SEL ... ( table_name ); To use it, make sure that the httpfs extension is installed: INSTALL httpfs ; You can attach to the remote endpoint and use the macro: ATTACH 'https://blobs.duckdb.org/data/compute_table_checksum.duckdb' AS compute_table_checksum_db ; CRE ...
https://man.mtool.work/duckdb/1.3/guides/snippets/sharing_macros.html
Azure Extension – DuckDB 8964
This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview ... he extension will attempt to automatically detect credentials (not used if you pass the connection string). STRING - azure_endpoint Override the Azure endpoint for when the Azure credential providers are used. STRING blob.core.windows.net azure_credentia ... ADLS implements similar functionality as the Blob storage, there are some important performance benefits to using the ADLS endpoints for globbing, especially when using (complex) glob patterns. To demonstrate, let's look at an example of how a glob is pe ... rformed internally using the Blob and ADLS endpoints, respectively. Using the following filesystem: root ├── l_receipmonth=1997-10 │ ├── l_shipmode=AIR │ │ └── data_0.csv │ ├ ...
https://man.mtool.work/duckdb/1.3/core_extensions/azure.html
Deploying DuckDB-Wasm – DuckDB 8332
This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview ... kDB Extensions DuckDB extensions for DuckDB-Wasm, similar for the native cases, are served signed at the default extension endpoint: https://extensions.duckdb.org . If you are deploying duckdb-wasm you can consider mirroring relevant extensions at a diff ... erent endpoint, possibly allowing for air-tight deployments on internal networks. SET custom_extension_repository = ' https://some.endpoi ... as access to SQL can access the data that DuckDB-Wasm can access. Also DuckDB-Wasm in default setting can access to remote endpoints, so have visible effect on external word even from within the sandbox. 関連キーワード duckdb Wasm DuckDB extensions https ...
https://man.mtool.work/duckdb/1.3/clients/wasm/deploying_duckdb_wasm.html
Configuration – DuckDB 8008
This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview ... d use ListView as the physical layout for LIST columns BOOLEAN false autoinstall_extension_repository Overrides the custom endpoint for extension installation on autoloading VARCHAR autoinstall_known_extensions Whether known extensions are allowed to be ... which to automatically trigger a checkpoint (e.g., 1GB) VARCHAR 16.0 MiB custom_extension_repository Overrides the custom endpoint for remote extension installation VARCHAR custom_user_agent Metadata from DuckDB callers VARCHAR default_block_size The de ... should be produced by DuckDB in Utf8View format instead of Utf8 BOOLEAN false s3_access_key_id S3 Access Key ID VARCHAR s3_endpoint S3 Endpoint VARCHAR s3_kms_key_id S3 KMS Key ID VARCHAR s3_region S3 Region VARCHAR us-east-1 s3_secret_access_key S3 Acce ...
https://man.mtool.work/duckdb/1.3/configuration/overview.html
Amazon S3 Tables – DuckDB 7905
This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview ... ON ' us-east-1 ' ); Then, connect to the catalog using you S3 Tables ARN (available in the AWS Management Console) and the ENDPOINT_TYPE s3_tables option: ATTACH ' s3_tables_arn ' AS s3_tables ( TYPE iceberg , ENDPOINT_TYPE s3_tables ); To check whether ...
https://man.mtool.work/duckdb/1.3/core_extensions/iceberg/amazon_s3_tables.html
Amazon SageMaker Lakehouse (AWS Glue) – DuckDB 7905
This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview ... s , ASSUME_ROLE_ARN 'arn:aws:iam:: account_id :role/ role ' , REGION 'us-east-2' ); Then, connect to the catalog using the ENDPOINT_TYPE glue option: ATTACH ' account_id :s3tablescatalog/ namespace_name ' AS glue_catalog ( TYPE iceberg , ENDPOINT_TYPE gl ...
https://man.mtool.work/duckdb/1.3/core_extensions/iceberg/amazon_sagemaker_lakeh...
PREV 1 2 NEXT
DuckDB 1.3 Documentation / man.mtool.work