Results of 1 - 9 of about 9 for west (0.002 sec.)
- PostgreSQL Extension and the Secret Manager 12384
- 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
...on token using aws CLI. Pass this token as a password connection option: bash export RDSHOST="database-1-instance-1.xxx.eu-west-1.rds.amazonaws.com" psql "host=$RDSHOST port=5432 dbname=postgres user=postgres sslmode=require password=$(aws rds genera...te-db-auth-token --hostname $RDSHOST --port 5432 --username postgres --region eu-west-1)" Configuring Secrets for IAM Authentication Authentication from the postgres extension uses the same logic as with psql...n the example above: sql CREATE SECRET aws_rds_secret1 ( TYPE rds, PROVIDER credential_chain, CHAIN 'env;sso;', REGION 'eu-west-1', RDS_USER 'postgres', RDS_HOST 'database-1-instance-1.xxxxxxxxxxxx.eu-west-1.rds.amazonaws.com', RDS_PORT '5432' ); The... - https://man.mtool.work/duckdb/2.0/core_extensions/postgres/secrets.html
- Quack on WebAssembly 10892
- 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
....s3.us-east-1.amazonaws.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.micr... - https://man.mtool.work/duckdb/2.0/quack/setup/quack_wasm.html
- Deploying Quack 10731
- 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
...instance; other sizes 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... - https://man.mtool.work/duckdb/2.0/quack/setup/deployment.html
- Time Zone Reference List 8897
- An up-to-date version of this list can be pulled from the pg_timezone_names() table function: SELECT name, abbrev FROM pg_timezone_names() ORDER BY name; name abbrev ACT ACT AET AET AGT AGT ART ART AST AST Africa/Abidjan Iceland Africa/Accr
...Australia/South Australia/Sydney AET Australia/Tasmania Australia/Tasmania Australia/Victoria Australia/Victoria Australia/West Australia/West Australia/Yancowinna Australia/Yancowinna BET BET BST BST Brazil/Acre Brazil/Acre Brazil/DeNoronha Brazil/D...eNoronha Brazil/East BET Brazil/West Brazil/West CAT CAT CET CET CNT CNT CST CST CST6CDT CST6CDT CTT CTT Canada/Atlantic Canada/Atlantic Canada/Central Canada/... - https://man.mtool.work/duckdb/2.0/sql/data_types/timezones.html
- AWS Extension 8070
- 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
...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_PROFILE env...uires 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 secre... - https://man.mtool.work/duckdb/2.0/core_extensions/aws.html
- Amazon RDS with IAM Authentication 8070
- 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
...in 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 create... - https://man.mtool.work/duckdb/2.0/guides/database_integration/rds_iam.html
- FROM and JOIN Clauses 7585
- The FROM clause specifies the source of the data on which the remainder of the query should operate. Logically, the FROM clause is where the query starts execution. The FROM clause can contain a single table, a combination of multiple table
...ies – any predicate can be used: Return the pairs of jobs where one ran longer but cost less: SELECT s1.t_id, s2.t_id FROM west s1, west s2 WHERE s1.time > s2.time AND s1.cost < s2.cost; Natural Joins Natural joins join two tables based on attributes... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/from.html
- S3 API Support 7082
- 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)
...ing 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 While Clo... - https://man.mtool.work/duckdb/2.0/core_extensions/httpfs/s3api.html
- Quack Remote Protocol 7082
- 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
...ng the quack_identify helper: {:.codebox-client} CALL quack_identify( name = 'analytics-1', provider = 'ec2', region = 'eu-west-1', meta = '{"role": "worker"}' ); meta is merged with auto-computed duckdb_version and platform keys; user-supplied keys... - https://man.mtool.work/duckdb/2.0/quack/overview.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work