Results of 1 - 10 of about 17 for password (0.002 sec.)
- PostgreSQL Extension and the Secret Manager 13656
- 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 em...ation. CREATE SECRET postgres_secret_one ( TYPE postgres, HOST '127.0.0.1', PORT 5432, DATABASE postgres, USER 'postgres', PASSWORD '' ); The secret can then be explicitly referenced using the SECRET parameter in the ATTACH . ATTACH '' AS postgres_db_one...(TYPE postgres, SECRET postgres_secret_one); Warning Avoid including credentials, such as a password, directly in the connection string. If a connection error occurs, the full connection string, including your credentials,... - https://man.mtool.work/duckdb/2.0/core_extensions/postgres/secrets.html
- HTTP(S) Support 11949
- With the httpfs extension, it is possible to directly query files over the HTTP(S) protocol. This works for all files supported by DuckDB or its various extensions, and provides read-only access. SELECT * FROM 'https://domain.tld/file.exten
...anager : CREATE SECRET http_proxy ( TYPE http, HTTP_PROXY '⟨http_proxy_url⟩', HTTP_PROXY_USERNAME '⟨username⟩', HTTP_PROXY_PASSWORD '⟨password⟩' ); You can also set the scope for an HTTP proxy using the SCOPE keyword. CREATE SECRET http_proxy ( TYPE HTTP...db.org⟩', '⟨https://some-other-website.org⟩'], HTTP_PROXY '⟨http_proxy_url⟩', HTTP_PROXY_USERNAME '⟨username⟩', HTTP_PROXY_PASSWORD '⟨password⟩' ); Alternatively, you can add it via configuration options : SET http_proxy = '⟨http_proxy_url⟩'; SET http_pr...oxy_username = '⟨username⟩'; SET http_proxy_password = '⟨password⟩'; Note: You cannot set a proxy scope using the configurations options. Using a Custom Certificate File To us... - https://man.mtool.work/duckdb/2.0/core_extensions/httpfs/https.html
- Amazon RDS with IAM Authentication 10138
- 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
...credential chain, and the postgres extension uses it as the connection password, refreshing it automatically. Installation and Loading INSTALL postgres; INSTALL aws; LOAD postgres; LOAD aws; Creating th...mazonaws.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 SECRET pg_rds_secret ( TYPE po... - https://man.mtool.work/duckdb/2.0/guides/database_integration/rds_iam.html
- PostgreSQL Import 9069
- To run a query directly on a running PostgreSQL database, the postgres extension is required. Installation and Loading The extension can be installed using the INSTALL SQL command. This only needs to be run once. INSTALL postgres; To load t
...to connect to localhost hostaddr Host IP address localhost port Port number 5432 user PostgreSQL user name [OS user name] password PostgreSQL password dbname Database name [user] passfile Name of file passwords are stored in ~/.pgpass -- Attach the Post... - https://man.mtool.work/duckdb/2.0/guides/database_integration/postgres.html
- MySQL Extension 8638
- The mysql extension allows DuckDB to directly read and write data from/to a running MySQL instance. The data can be queried directly from the underlying MySQL database. Data can be loaded from MySQL tables into DuckDB tables, or vice versa.
...host user=root port=0 database=mysql' AS mysqldb (TYPE mysql); USE mysqldb; Warning Avoid including credentials, such as a password, directly in the connection string. If a connection error occurs, the full connection string, including your credentials,...from an environment variable. Setting Default Environment variable database NULL MYSQL_DATABASE host localhost MYSQL_HOST password MYSQL_PWD port 0 MYSQL_TCP_PORT socket NULL MYSQL_UNIX_PORT user current user MYSQL_USER ssl_mode preferred ssl_ca ssl_cap...syntax can be used to create a secret. CREATE SECRET ( TYPE mysql, HOST '127.0.0.1', PORT 0, DATABASE mysql, USER 'mysql', PASSWORD '' ); The information from the secret will be used when ATTACH is called. We can leave the connection string empty to use... - https://man.mtool.work/duckdb/2.0/core_extensions/mysql.html
- Azure Extension 8535
- The azure extension lets DuckDB read and write files in Azure Blob Storage and Azure Data Lake Storage (ADLS) Gen2. Installing and Loading The azure extension will be transparently autoloaded on first use from the official extension reposit
...Configuring a Proxy To configure proxy information when using secrets, you can add HTTP_PROXY , PROXY_USER_NAME and PROXY_PASSWORD in the secret definition. For example: CREATE SECRET secret5 ( TYPE azure, CONNECTION_STRING '⟨connection_string⟩', HTTP_P...ROXY 'http://localhost:3128', PROXY_USER_NAME '⟨proxy_user_name⟩', PROXY_PASSWORD '⟨proxy_password⟩' ); Note When you use secrets: The HTTP_PROXY environment variable is still honored, unless the secret s...RCHAR HTTP_PROXY environment variable (if set). azure_proxy_user_name HTTP proxy username if needed. VARCHAR - azure_proxy_password HTTP proxy password if needed. VARCHAR - Additional Information Logging Since v1.5.2, the Azure extension writes its HTTP... - https://man.mtool.work/duckdb/2.0/core_extensions/azure.html
- AWS Extension 8207
- 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
...( TYPE s3, PROVIDER credential_chain, HTTP_PROXY '⟨proxy.example.com:8080⟩', HTTP_PROXY_USERNAME '⟨username⟩', HTTP_PROXY_PASSWORD '⟨password⟩' ); Region Resolution If no region is provided explicitly, DuckDB resolves it from the following sources, in o...e); loaded_access_key_id loaded_secret_access_key loaded_session_token loaded_region minio_duckdb_user_2 minio_duckdb_user_password_2 NULL NULL... - https://man.mtool.work/duckdb/2.0/core_extensions/aws.html
- ODBC Extension 8104
- Please note that DuckDB also offers an ODBC client , which allows you to connect to DuckDB via ODBC from other applications. The odbc_scanner extension allows connecting to other databases (using their ODBC drivers ) and run queries with th
...Database=testdb;UID=db2inst1;PWD=pwd; PostgreSQL: Driver={PostgreSQL Unicode};Server=127.0.0.1;Port=5432;Username=postgres;Password=postgres;Database=test_db; MySQL/MariaDB: Driver={MariaDB ODBC 3.1 Driver};SERVER=127.0.0.1;PORT=3306;USER=root;PASSWORD=r...emio ODBC + GizmoSQL): Driver={Dremio Flight SQL ODBC Driver};Host=127.0.0.1;Port=31337;UID=gizmosql_username;PWD=gizmosql_password;useEncryption=true; Query Parameters When a DuckDB query is run using prepared statement, it is possible to pass input par... - https://man.mtool.work/duckdb/2.0/core_extensions/odbc/overview.html
- Catalogs 8000
- 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
...ogin credentials for the OAuth2 service. CREATE SECRET iceberg_secret ( TYPE iceberg, CLIENT_ID '⟨admin⟩', CLIENT_SECRET '⟨password⟩', OAUTH2_SERVER_URI '⟨http://iceberg_rest_catalog_url.com/v1/oauth/tokens⟩' ); If you already have a Bearer token, you ca...ris catalog, use the following commands: CREATE SECRET polaris_secret ( TYPE iceberg, CLIENT_ID '⟨admin⟩', CLIENT_SECRET '⟨password⟩' ); ATTACH 'quickstart_catalog' AS polaris_catalog ( TYPE iceberg, URI '⟨polaris_rest_catalog_endpoint⟩', ACCESS_DELEGATI...log the following commands will work. CREATE SECRET lakekeeper_secret ( TYPE iceberg, CLIENT_ID '⟨admin⟩', CLIENT_SECRET '⟨password⟩', OAUTH2_SCOPE '⟨scope⟩', OAUTH2_SERVER_URI '⟨lakekeeper_oauth_url⟩' ); ATTACH '⟨warehouse⟩' AS lakekeeper_catalog ( TYPE... - https://man.mtool.work/duckdb/2.0/core_extensions/iceberg/catalogs.html
- PostgreSQL Extension 7897
- The postgres extension allows DuckDB to directly read and write data from a running PostgreSQL database instance. The data can be queried directly from the underlying PostgreSQL database. Data can be loaded from PostgreSQL tables into DuckD
...es host=127.0.0.1' AS db (TYPE postgres, ISOLATION_LEVEL 'READ COMMITTED'); Warning Avoid including credentials, such as a password, directly in the connection string. If a connection error occurs, the full connection string, including your credentials,...me Database name [user] host Name of host to connect to localhost hostaddr Host IP address localhost passfile Name of file passwords are stored in ~/.pgpass password PostgreSQL password (empty) port Port number 5432 user PostgreSQL user name current user...a production environment where the connection information is managed externally and passed in to the environment. export PGPASSWORD="secret" export PGHOST=localhost export PGUSER=owner export PGDATABASE=mydatabase Then, to connect, start the duckdb proce... - https://man.mtool.work/duckdb/2.0/core_extensions/postgres/overview.html
DuckDB 2.0 Documentation / man.mtool.work