Results of 1 - 10 of about 24 for region (0.003 sec.)
- Legacy Authentication Scheme for S3 API – DuckDB 12376
- 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
...tication 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: SET s3_region = 'us-east-1' ; Optionally, the endpoint can be configured in case a non-AWS object storage s...ote that this may also require updating the endpoint. For example for AWS S3 it is required to change the endpoint to s3 . region .amazonaws.com . After configuring the correct endpoint and region, public files can be read. To also read private files,...ve, specific configuration values can be used on a per-request basis. This allows for use of multiple sets of credentials, regions, etc. These are used by including them on the S3 URI as query parameters. All the individual configuration values listed... - https://man.mtool.work/duckdb/1.3/core_extensions/httpfs/s3api_legacy_authentica...
- AWS Extension – DuckDB 11559
- 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
...cret ( TYPE s3 , PROVIDER config , KEY_ID ' AKIAIOSFODNN7EXAMPLE ' , SECRET ' wJalrXUtnFEMI/K7MDENG/bPxRfiCYEXAMPLEKEY ' , REGION ' us-east-1 ' ); Tip If you get an IO Error ( Connection error for HTTP HEAD ), configure the endpoint explicitly via ENDP...OINT 's3. your_region .amazonaws.com' . Now, to query using the above secret, simply query any s3:// prefixed file: SELECT * FROM 's3:// your-bu...allows overriding the automatically fetched config. For example, to automatically load credentials, and then override the region, run: CREATE OR REPLACE SECRET secret ( TYPE s3 , PROVIDER credential_chain , CHAIN config , REGION ' eu-west-1 ' ); Auto-... - https://man.mtool.work/duckdb/1.3/core_extensions/aws.html
- S3 API Support – DuckDB 10742
- 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
...cret ( TYPE s3 , PROVIDER config , KEY_ID ' AKIAIOSFODNN7EXAMPLE ' , SECRET ' wJalrXUtnFEMI/K7MDENG/bPxRfiCYEXAMPLEKEY ' , REGION ' us-east-1 ' ); Tip If you get an IO Error ( Connection error for HTTP HEAD ), configure the endpoint explicitly via ENDP...OINT 's3. your_region .amazonaws.com' . Now, to query using the above secret, simply query any s3:// prefixed file: SELECT * FROM 's3:// your-bu...allows overriding the automatically fetched config. For example, to automatically load credentials, and then override the region, run: CREATE OR REPLACE SECRET secret ( TYPE s3 , PROVIDER credential_chain , CHAIN config , REGION ' eu-west-1 ' ); Loadi... - https://man.mtool.work/duckdb/1.3/core_extensions/httpfs/s3api.html
- Delta Extension – DuckDB 10024
- 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
...CT * FROM delta_scan ( 's3://some/delta/table/with/auth' ); To scan public buckets on S3, you may need to pass the correct region by creating a secret containing the region of your public S3 bucket: CREATE SECRET ( TYPE s3 , REGION 'my-region' ); SELEC...T * FROM delta_scan ( 's3://some/public/table/in/my-region' ); Reading from Azure Blob Storage To scan a Delta table in an Azure Blob Storage bucket , run: SELECT * FROM delta_scan...pport for the other DuckDB platforms is work-in-progress. 関連キーワード delta scan Delta extension table DuckDB supported region support local platforms bucket Azure Blob Storage skipping tables currently experimental Reading authenticating buckets Se... - https://man.mtool.work/duckdb/1.3/core_extensions/delta.html
- Fastly Object Storage Import – DuckDB 9724
- 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
...ret ( TYPE s3 , KEY_ID ' 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 region you want to use (e.g eu-central.object.fastlystorage.app ). REGION must use the same region mentioned in ENDPOINT . URL_ST...cket-name / file .parquet' ); 関連キーワード Fastly Storage read DuckDB needs parquet using secret path east fastlystorage region fastly bucket Documentation Guides Network Cloud Copy Markdown Import Prerequisites Compatibility allows support 関連するペ... - https://man.mtool.work/duckdb/1.3/guides/network_cloud_storage/fastly_object_sto...
- S3 Parquet Export – DuckDB 9624
- 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 LOAD SQL command: LOAD httpfs ; After loading the httpfs extension, set up the credentials to write data. Note that the region parameter should match the region of the bucket you want to access. CREATE SECRET ( TYPE s3 , KEY_ID ' AKIAIOSFODNN7EXAMPL...E ' , SECRET ' wJalrXUtnFEMI/K7MDENG/bPxRfiCYEXAMPLEKEY ' , REGION ' us-east-1 ' ); Tip If you get an IO Error ( Connection error for HTTP HEAD ), configure the endpoint explicitly via ENDP...OINT 's3. your_region .amazonaws.com' . Alternatively, use the aws extension to retrieve the credentials automatically: CREATE SECRET ( TYPE s3... - https://man.mtool.work/duckdb/1.3/guides/network_cloud_storage/s3_export.html
- S3 Express One – DuckDB 9407
- 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
...ts with one exception: we have to specify the endpoint according to the following pattern: s3express - availability_zone . region .amazonaws.com where the availability_zone (e.g., use-az5 ) can be obtained from the S3 Express One bucket's configuration...page and the region is the AWS region (e.g., us-east-1 ). For example, to allow DuckDB to use an S3 Express One bucket, configure the Secrets...follows: CREATE SECRET ( TYPE s3 , KEY_ID ' AKIAIOSFODNN7EXAMPLE ' , SECRET ' wJalrXUtnFEMI/K7MDENG/bPxRfiCYEXAMPLEKEY ' , REGION ' us-east-1 ' , ENDPOINT 's3express- use1-az5 . us-east-1 .amazonaws.com' ); Instance Location For best performance, make... - https://man.mtool.work/duckdb/1.3/guides/network_cloud_storage/s3_express_one.ht...
- Aggregate Functions – DuckDB 9407
- 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
...roduce a single row containing the sum of the amount column: SELECT sum ( amount ) FROM sales ; Produce one row per unique region, containing the sum of amount for each group: SELECT region , sum ( amount ) FROM sales GROUP BY region ; Return only the...regions that have a sum of amount higher than 100: SELECT region FROM sales GROUP BY region HAVING sum ( amount ) > 100 ; Return the number of unique values in the region column: SELECT c...ount ( DISTINCT region ) FROM sales ; Return two values, the total sum of amount and the sum of amount minus columns where the region is north us... - https://man.mtool.work/duckdb/1.3/sql/functions/aggregates.html
- S3 Parquet Import – DuckDB 9007
- 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
...SQL command: LOAD httpfs ; Credentials and Configuration After loading the httpfs extension, set up the credentials and S3 region to read data: CREATE SECRET ( TYPE s3 , KEY_ID ' AKIAIOSFODNN7EXAMPLE ' , SECRET ' wJalrXUtnFEMI/K7MDENG/bPxRfiCYEXAMPLEKE...Y ' , REGION ' us-east-1 ' ); Tip If you get an IO Error ( Connection error for HTTP HEAD ), configure the endpoint explicitly via ENDP...OINT 's3. your_region .amazonaws.com' . Alternatively, use the aws extension to retrieve the credentials automatically: CREATE SECRET ( TYPE s3... - https://man.mtool.work/duckdb/1.3/guides/network_cloud_storage/s3_import.html
- R-Tree Indexes – DuckDB 8707
- 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
...th geospatial datasets, it is very common that you want to filter rows based on their spatial relationship with a specific region of interest. Unfortunately, even though DuckDB's vectorized execution engine is pretty fast, this sort of operation does n...e to very quickly search a R-tree-indexed table for only those rows where the indexed geometry column intersect a specific region of interest, as you can skip searching entire sub-trees if the bounding rectangles of their parent nodes don't intersect t...he query region at all. Once the leaf nodes are reached, only the specific rows whose geometries intersect the query region have to be fet... - https://man.mtool.work/duckdb/1.3/core_extensions/spatial/r-tree_indexes.html
DuckDB 1.3 Documentation / man.mtool.work