Results of 1 - 5 of about 5 for rds (0.001 sec.)
- Amazon RDS with IAM Authentication 11490
- 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
...on and Loading INSTALL postgres; INSTALL aws; LOAD postgres; LOAD aws; Creating the Secrets First, create a secret of type rds . It uses the AWS credential chain to mint the IAM token: CREATE SECRET aws_rds_secret ( TYPE rds, PROVIDER credential_cha...in, CHAIN 'env;sso', REGION '⟨eu-west-1⟩', RDS_USER '⟨postgres⟩', RDS_HOST '⟨instance⟩.⟨identifier⟩.⟨region⟩.rds.amazonaws.com', RDS_PORT '5432' ); Then create a secret...of type postgres that references it via AWS_RDS_SECRET . Because no password is set, the token generated by the rds secret is used (and refreshed) automatically: CREATE S... - https://man.mtool.work/duckdb/2.0/guides/database_integration/rds_iam.html
- PostgreSQL Extension and the Secret Manager 10773
- 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
...USER_TIMEOUT REPLICATION GSSENCMODE SSLMODE REQUIRESSL SSLNEGOTIATION SSLCOMPRESSION SSLCERT SSLKEY SSLKEYLOGFILE SSLPASSWORD SSLCERTMODE SSLROOTCERT SSLCRL SSLCRLDIR SSLSNI REQUIREPEER SSL_MIN_PROTOCOL_VERSION SSL_MAX_PROTOCOL_VERSION MIN_PROTOCOL_...nnection options, the full connection URI can be specified instead: URI – connection URI Additional option is used for AWS RDS IAM authentication, see details in the next section below: AWS_RDS_SECRET – the name of the secret of type rds AWS RDS IAM...Authentication Managed PostgreSQL databases running on RDS/Aurora services allow to use IAM authentication . In that case the authentication token is generated using AWS SDK and mus... - https://man.mtool.work/duckdb/2.0/core_extensions/postgres/secrets.html
- AWS Extension 9486
- 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
...When CHAIN is sts or web_identity , REFRESH auto is enabled automatically, since these credentials are short-lived. Amazon RDS (IAM Authentication) The aws extension can generate short-lived IAM authentication tokens for connecting to Amazon RDS and...Aurora databases, exposed through a secret of type rds . It accepts the same credential_chain options as an s3 secret, plus the required RDS_USER , RDS_HOST , RDS_PORT , and REG...ION parameters. Unlike an s3 secret, an rds secret also requires an explicit CHAIN : CREATE SECRET aws_rds_secret ( TYPE rds, PROVIDER credential_chain, CHAIN 'env;ss... - https://man.mtool.work/duckdb/2.0/core_extensions/aws.html
- S3 and AWS Authentication 7409
- This page is the entry point for authenticating to S3 and other AWS services from DuckDB. Authentication is configured using secrets , and the detailed reference material lives on the S3 API Support and AWS Extension pages. The sections bel
...want to use its instance profile credential_chain with the instance chain credential_chain provider You connect to Amazon RDS or Aurora with IAM authentication rds secret Amazon RDS (IAM Authentication) The config provider is part of the httpfs ext... - https://man.mtool.work/duckdb/2.0/core_extensions/httpfs/authentication.html
- Guides 6765
- The guides section contains compact how-to guides that are focused on achieving a single goal. For API references and examples, see the rest of the documentation. Note that there are many tools using DuckDB, which are not covered in the off
...ySQL database How to directly query a PostgreSQL database How to directly query a SQLite database How to connect to Amazon RDS / Aurora with IAM authentication Directly Reading Files How to directly read a binary file How to directly read a text fil... - https://man.mtool.work/duckdb/2.0/guides/overview.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work