Results of 1 - 10 of about 12 for username (0.002 sec.)
- HTTP(S) Support 14044
- 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
...an HTTP proxy using the Secrets Manager : 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. CR...( TYPE HTTP, SCOPE ['⟨https://duckdb.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_proxy_username = '⟨username⟩'; SET http_proxy_password = '⟨password⟩'; Note: You cannot set a proxy scope using the configurations option... - https://man.mtool.work/duckdb/2.0/core_extensions/httpfs/https.html
- PostgreSQL Extension and the Secret Manager 10135
- 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
...UTH_SCOPE The following options are renamed to the corresponding keys: DATABASE – alias to DBNAME HOSTNAME – alias to HOST USERNAME – alias to USER Instead of separate connection options, the full connection URI can be specified instead: URI – connection...dbname=postgres user=postgres sslmode=require password=$(aws rds generate-db-auth-token --hostname $RDSHOST --port 5432 --username postgres --region eu-west-1)" Configuring Secrets for IAM Authentication Authentication from the postgres extension uses t...specified to the duckdb command (other DuckDB clients may require slightly different syntax): duckdb postgres:postgresql://username:password@127.0.0.1:5432/db1 This method can also be used with DuckLake (with PostgreSQL catalog), when an S3/object storag... - https://man.mtool.work/duckdb/2.0/core_extensions/postgres/secrets.html
- Hugging Face Support 8967
- The httpfs extension introduces support for the hf:// protocol to access datasets hosted in Hugging Face repositories. See the announcement blog post for details. Usage Hugging Face repositories can be queried using the following URL patter
...n: hf://datasets/⟨my_username⟩/⟨my_dataset⟩/⟨path_to_file⟩ For example, to read a CSV file, you can use the following query: SELECT * FROM 'hf://dataset...ranch or specific commit. You can query different dataset versions/revisions by using the following URL: hf://datasets/⟨my_username⟩/⟨my_dataset⟩@⟨my_branch⟩/⟨path_to_file⟩ For example: SELECT * FROM 'hf://datasets/datasets-examples/doc-formats-csv-1@~pa... - https://man.mtool.work/duckdb/2.0/core_extensions/httpfs/hugging_face.html
- ODBC Extension Functions 8967
- odbc_begin_transaction odbc_bind_params odbc_close odbc_commit odbc_connect odbc_copy odbc_create_params odbc_list_data_sources odbc_list_drivers odbc_query odbc_rollback odbc_begin_transaction odbc_begin_transaction(conn_handle BIGINT) ->
...dbc_commit(getvariable('conn')) odbc_connect odbc_connect(conn_string VARCHAR) -> BIGINT odbc_connect(conn_string VARCHAR, username VARCHAR, password VARCHAR) -> BIGINT Opens an ODBC connection to a remote DB. If username and password (positional) parame...string ( VARCHAR , default: :memory: ): DuckDB connection string to the source DB, example: ducklake:postgres:postgresql://username:pwd@127.0.0.1:5432/lake1 source_file ( VARCHAR ): path to a Parquet, CSV or JSON file (remote or local) to be read with Du...TRAIN_STATIONS', create_table=TRUE) FROM odbc_copy(getvariable('conn'), source_conn_string='ducklake:postgres:postgresql://username:pwd@127.0.0.1:5432/lake1', source_queries=[ 'CREATE SECRET s (TYPE s3 [...])', 'FROM nl_train_stations' ], dest_table='NL_... - https://man.mtool.work/duckdb/2.0/core_extensions/odbc/functions.html
- ODBC Extension 8826
- 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
....0.0.1;Port=50000;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;US...8; Snowflake: Driver={SnowflakeDSIIDriver};Server=foobar-ab12345.snowflakecomputing.com;Database=SNOWFLAKE_SAMPLE_DATA;UID=username;PWD=pwd; ClickHouse: Driver={ClickHouse ODBC Driver (Unicode)};Server=127.0.0.1;Port=8123; Spark: Driver={Simba Spark ODBC...; Arrow Flight SQL (Dremio 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 poss... - https://man.mtool.work/duckdb/2.0/core_extensions/odbc/overview.html
- Tableau – A Data Visualization Tool 8684
- Tableau is a popular commercial data visualization tool. In addition to a large number of built-in connectors, it also provides generic database connectivity via ODBC and JDBC connectors. Tableau has two main versions: Desktop and Online (S
...te a view of the h2oai Parquet test file in the current DuckDB code base: CREATE VIEW h2oai AS ( FROM read_parquet('/Users/username/duckdb/data/parquet-testing/h2oai/h2oai_group_small.parquet') ); Note that you should use full path names to local files s...> More…, click on "Other Databases (JDBC)". This brings up the connection dialog box. For the URL, enter jdbc:duckdb:/User/username/path/to/database.db . For the Dialect, choose PostgreSQL. The rest of the fields can be ignored: However, functionality wi... - https://man.mtool.work/duckdb/2.0/guides/data_viewers/tableau.html
- Configuration 8242
- DuckDB has a number of configuration options that can be used to change the behavior of the system. The configuration options can be set using either the SET statement or the PRAGMA statement . They can be reset to their original values usi
...when running into connection failures BOOLEAN true http_proxy_password The password for the HTTP proxy. VARCHAR http_proxy_username The username for the HTTP proxy. VARCHAR http_proxy The HTTP proxy host. Defaults to the HTTP_PROXY environment variable....OOLEAN false threads , worker_threads The number of total background threads used by the system. BIGINT # CPU cores user , username The username to use. Kept for legacy compatibility. VARCHAR validate_external_file_cache The cache validation mode. VALIDA... - https://man.mtool.work/duckdb/2.0/configuration/overview.html
- AWS Extension 8101
- 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
...t: CREATE OR REPLACE SECRET secret ( 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 i... - https://man.mtool.work/duckdb/2.0/core_extensions/aws.html
- CREATE VIEW Statement 8101
- The CREATE VIEW statement defines a new view in the catalog. Examples Create a simple view: CREATE VIEW view1 AS SELECT * FROM tbl; Create a view or replace it if a view with that name already exists: CREATE OR REPLACE VIEW view1 AS SELECT
...te a secure view (hides internals from functions such as stats() and EXPLAIN ANALYZE ): CREATE SECURE VIEW users AS SELECT username FROM all_users WHERE access_level = 'standard'; The SQL query behind an existing view can be read using the duckdb_views()... - https://man.mtool.work/duckdb/2.0/sql/statements/create_view.html
- ODBC API on Linux 7800
- Driver Manager A driver manager is required to manage communication between applications and the ODBC driver. We tested and support unixODBC that is a complete ODBC driver manager for Linux. Users can install it from the command line: On De
...up on Linux is based on the .odbc.ini and .odbcinst.ini files. These files can be placed to the user home directory /home/⟨username⟩ or in the system /etc directory. The Driver Manager prioritizes the user configuration files over the system files. For t... - https://man.mtool.work/duckdb/2.0/clients/odbc/linux.html
DuckDB 2.0 Documentation / man.mtool.work