Results of 1 - 10 of about 11 for eu (0.002 sec.)
- PostgreSQL Extension and the Secret Manager 13620
- User credentials and other PostgreSQL database connection details can be stored using the DuckDB Secrets Manager . The following syntax can be used to create a secret: CREATE SECRET ( TYPE postgres, HOST '127.0.0.1', PORT 5432, DATABASE pos
...tgres, USER 'postgres', PASSWORD '' ); The information from the secret will be used when ATTACH is called. We can leave the PostgreSQL connection string empty to use all of the information stored in the...eated secrets are temporary. Secrets can be persisted using the CREATE PERSISTENT SECRET command . Persistent secrets can be used across sessions. Managing Multiple Secrets Named secrets can be used to manage connections to multiple PostgreSQL data...base instances. Secrets can be given a name upon creation. CREATE SECRET postgres_secret_one ( TYPE postgres, HOST '127.0.0.1', PORT 5432, DATABASE postgres, USER 'pos... - https://man.mtool.work/duckdb/2.0/core_extensions/postgres/secrets.html
- Quack on WebAssembly 10171
- CloudFormation Stack We provide an example template for initializing a CloudFormation stack, based on pre-baked public AMI, based on Ubuntu, which will: via DuckDB, install and load Quack, create a randomized token, and do quack_serve on th
...zonaws.com/quack.yaml , and is backed by images for (at the moment) eight regions: us-east-1 us-east-2 us-west-1 us-west-2 eu-central-1 eu-west-1 ap-northeast-1 ap-southeast-1 Only inputs are the type of the instance (default t3.micro) and the name...of the stack (needs to be unique on the same org/region). Template is maintained at https://github.com/duckdb/duckdb-quack-infra Deploy via Web UI Vi...sit https://console.aws.amazon.com/cloudformation/home#/stacks/quickcreate?templateURL=https://duckdb-quack-ami.s3.us-east-1.amazonaws.com/quack.yaml&stackName=my-duckdb-quack-demo Log-in, select a name, pos... - https://man.mtool.work/duckdb/2.0/quack/setup/quack_wasm.html
- Deploying Quack 9975
- This page collects deployment recipes for running a public-facing Quack server. Today there is one recipe (AWS EC2), we will introduce more over time. On AWS EC2 The fastest way to get a public-facing Quack server is the one-click AWS Cloud
...s are selectable on the Parameters page when launching. Supported regions: us-east-1 , us-east-2 , us-west-1 , us-west-2 , eu-west-1 , eu-central-1 , ap-northeast-1 , ap-southeast-1 . Connecting from a Local DuckDB Copy QuackURI and Token from the... - https://man.mtool.work/duckdb/2.0/quack/setup/deployment.html
- Fastly Object Storage Import 9015
- Prerequisites For Fastly Object Storage, the S3 Compatibility API allows you to use DuckDB's S3 support to read and write from Fastly buckets. This requires the httpfs extension , which can be installed using the INSTALL SQL command. This o
...storage.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_STYLE needs to use path ....Querying After setting up the Fastly Object Storage credentials, you can query the data there using DuckDB's built-in methods, such as read_csv or read_parquet : SELECT * FROM 's3://⟨fastly-bucket-name⟩/(file).csv'; S... - https://man.mtool.work/duckdb/2.0/guides/network_cloud_storage/fastly_object_sto...
- AWS Extension 8641
- 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
...to use the AWS SDK default provider: CREATE OR REPLACE SECRET secret ( TYPE s3, PROVIDER credential_chain ); To query a file using the above secret, simply query any s3:// prefixed file. DuckDB also allows specifying a specific chain using the CHAI...hen override the region, run: CREATE OR REPLACE SECRET secret ( TYPE s3, PROVIDER credential_chain, CHAIN config, REGION '⟨eu-west-1⟩' ); Selecting a Profile To load credentials based on a named profile which is not the default (from the AWS_PROFIL...requires an explicit CHAIN : CREATE SECRET aws_rds_secret ( TYPE rds, PROVIDER credential_chain, CHAIN 'env;sso', REGION '⟨eu-west-1⟩', RDS_USER '⟨db_user⟩', RDS_HOST '⟨instance⟩.⟨identifier⟩.⟨region⟩.rds.amazonaws.com', RDS_PORT '5432' ); The rds... - https://man.mtool.work/duckdb/2.0/core_extensions/aws.html
- Amazon RDS with IAM Authentication 8641
- 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
...chain to mint the IAM token: CREATE SECRET aws_rds_secret ( TYPE rds, PROVIDER credential_chain, CHAIN 'env;sso', REGION '⟨eu-west-1⟩', RDS_USER '⟨postgres⟩', RDS_HOST '⟨instance⟩.⟨identifier⟩.⟨region⟩.rds.amazonaws.com', RDS_PORT '5432' ); Then cr...gres⟩', DATABASE '⟨postgres⟩', SSLMODE require, AWS_RDS_SECRET aws_rds_secret ); Connecting and Querying Attach the database using the postgres secret, then query it as a regular database: ATTACH '' AS rds_db (TYPE postgres, SECRET pg_rds_secret);... - https://man.mtool.work/duckdb/2.0/guides/database_integration/rds_iam.html
- Partitioned Writes 7877
- Examples Write a table to a Hive partitioned dataset of Parquet files: COPY orders TO 'orders' (FORMAT parquet, PARTITION_BY (year, month)); Write a table to a Hive partitioned dataset of CSV files, allowing overwrites: COPY orders TO 'orde
...ctory for each partition: COPY sales TO 'sales' (FORMAT parquet, PARTITION_BY (region), PARTITION_PATH CASE WHEN region = 'eu' THEN 'europe' ELSE 'region=' || coalesce(region, 'unknown') END); The expression is evaluated once per partition and its...ME_PATTERN '{uuid}' options, but DuckDB performs an extra check for whether the file already exists and then regenerates the UUID in the rare event that it does (to avoid clashes). Handling Slashes in Columns To handle slashes in column names, use...Percent-Encoding implemented by the url_encode function .... - https://man.mtool.work/duckdb/2.0/data/partitioning/partitioned_writes.html
- S3 API Support 7486
- 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)
...e the AWS extension page . Overview of S3 Secret Parameters Below is a complete list of the supported parameters that can be used for both the config and credential_chain providers: Name Description Secret Type Default ENDPOINT Specify a custom S3...S3 , GCS , R2 STRING - URL_COMPATIBILITY_MODE Can help when URLs contain problematic characters S3 , GCS , R2 BOOLEAN false URL_STYLE Either vhost (alias virtual ) or path S3 , GCS , R2 STRING vhost for S3 , path for R2 and GCS USE_SSL Whether to...using the KMS_KEY_ID option: CREATE OR REPLACE 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 Whil... - https://man.mtool.work/duckdb/2.0/core_extensions/httpfs/s3api.html
- Catalogs 7486
- 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
...edential_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 supported . Then, connect to the catalog: ATTACH '⟨account_id⟩' AS g...count(*) FROM glue_catalog.⟨namespace_name⟩.⟨table_name⟩; If you have an S3 Tables federated catalog, you can create a table using the standard CREATE TABLE syntax; CREATE TABLE glue_catalog.⟨namespace_name⟩.⟨table_name⟩ (a INTEGER, b VARCHAR); If...arehouse⟩' AS my_r2_catalog ( TYPE iceberg, URI '⟨catalog-uri⟩' ); The variables for warehouse and catalog-uri are available under the settings of the R2 Object Storage Catalog (R2 Object Store, Catalog name, Settings). Once you attached to the R2... - https://man.mtool.work/duckdb/2.0/core_extensions/iceberg/catalogs.html
- Quack Remote Protocol 7486
- The Quack extension turns a DuckDB instance into a server that other DuckDB instances (clients) can connect to over HTTP. This page covers the protocol at a glance and walks through basic usage on both sides of the wire. For the full list o
...efault port: 9494 . All URIs use the quack: scheme, e.g., quack:hostname:port with the port defaulting to 9494 . Server-Side Usage Starting a Server A server is started from an existing DuckDB session. Everything that the session can see (in-memory...over the remote protocol. To start listening on localhost, run: {:.codebox-server} CALL quack_serve('quack:localhost'); The URI argument is optional: calling quack_serve() without it also listens on quack:localhost . quack_serve returns the listen...quack:0.0.0.0:9494', allow_other_hostname = true); Non-local servers serve HTTPS by default, using a self-signed certificate unless you pass ssl_cert_file and ssl_key_file (see the Reference ). For production deployments, we recommend binding the s... - https://man.mtool.work/duckdb/2.0/quack/overview.html
DuckDB 2.0 Documentation / man.mtool.work