Results of 1 - 10 of about 12 for tokens (0.002 sec.)
- Security 14291
- This page covers Quack's security posture end to end: what the server exposes, what stays local, the role of a TLS-terminating reverse proxy, and the authentication / authorization callbacks the server runs on every connection and every que
...custom authentication is through using a MACRO . Example: Multi-Token Table Authenticate against a small table of allowed tokens (e.g., one per user): CREATE TABLE quack_tokens (auth_token VARCHAR, user_name VARCHAR); INSERT INTO quack_tokens VALUES (...lice'), ('bob-key-456', 'bob'); CREATE MACRO check_token(sid, client_token, server_token) AS ( EXISTS (SELECT 1 FROM quack_tokens WHERE auth_token = client_token) ); SET GLOBAL quack_authentication_function = 'check_token'; Now any client whose token i...s in quack_tokens is admitted, everyone else is rejected. Adding / removing users is a regular INSERT / DELETE operation. Example: Developer... - https://man.mtool.work/duckdb/2.0/quack/security.html
- Overview of DuckDB Internals 9675
- Tip For a detailed explanation of DuckDB internals, see the Design and Implementation of DuckDB Internals ("DiDi") library entry. On this page is a brief description of the internals of the DuckDB engine. Parser The parser converts a query
...string into the following tokens: SQLStatement QueryNode TableRef ParsedExpression The parser is not aware of the catalog or any other aspect of the databa...ors if tables do not exist, and will not resolve any types of columns yet. It only transforms a query string into a set of tokens as specified. ParsedExpression The ParsedExpression represents an expression within a SQL statement. This can be e.g., a r... - https://man.mtool.work/duckdb/2.0/internals/overview.html
- Catalogs 9215
- 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
...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 can pass it directly to your CREATE SECRET statement CREATE SECRET iceberg_se...below. CREATE SECRET r2_secret ( TYPE iceberg, TOKEN '⟨r2_token⟩' ); You can create a token by following the create an API token steps in getting started. Then, attach the catalog with the following commands. ATTACH '⟨warehouse⟩' AS my_r2_catalog ( TYP...iceberg, CLIENT_ID '⟨access_key⟩', CLIENT_SECRET '⟨secret_key⟩', OAUTH2_SERVER_URI 'http://⟨seaweedfs_host⟩:8181/v1/oauth/tokens' ); CREATE SECRET seaweedfs_storage ( TYPE s3, KEY_ID '⟨access_key⟩', SECRET '⟨secret_key⟩', ENDPOINT '⟨seaweedfs_host⟩:83... - https://man.mtool.work/duckdb/2.0/core_extensions/iceberg/catalogs.html
- Troubleshooting 8914
- Curl Request Fails Problem When trying to attach to an Iceberg REST Catalog endpoint, DuckDB returns the following error: IO Error: Curl Request to '/v1/oauth/tokens' failed with error: 'URL using bad/illegal format or missing URL' Solution
... - https://man.mtool.work/duckdb/2.0/core_extensions/iceberg/troubleshooting.html
- Amazon RDS with IAM Authentication 8596
- 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
... - https://man.mtool.work/duckdb/2.0/guides/database_integration/rds_iam.html
- Regular Expressions 8454
- DuckDB offers pattern matching operators ( LIKE , SIMILAR TO , GLOB ), as well as support for regular expressions via functions. Regular Expression Syntax DuckDB uses the RE2 library as its regular expression engine. For the regular express
...entire string to match. Instead, regexp_matches returns true if the string merely contains the pattern (unless the special tokens ^ and $ are used to anchor the regular expression to the start and end of the string). Below are some examples: SELECT reg...ion Description 'c' Case-sensitive matching 'i' Case-insensitive matching 'l' Match literals instead of regular expression tokens 'm' , 'n' , 'p' Newline sensitive matching 'g' Global replace, only available for regexp_replace 's' Non-newline sensitive... - https://man.mtool.work/duckdb/2.0/sql/functions/regular_expressions.html
- Hugging Face Support 8136
- 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
...Hugging Face Token in the DuckDB Secrets Manager to access private or gated datasets. First, visit Hugging Face Settings – Tokens to obtain your access token. Second, set it in your DuckDB session using DuckDB's Secrets Manager . DuckDB supports two pr... - https://man.mtool.work/duckdb/2.0/core_extensions/httpfs/hugging_face.html
- Iceberg Extension 7994
- The iceberg extension implements support for the Apache Iceberg open table format . There are two ways to work with Iceberg in DuckDB: Individual tables are read directly from storage, by pointing at a table's metadata. This requires no cat
...( TYPE iceberg, CLIENT_ID '⟨admin⟩', CLIENT_SECRET '⟨password⟩', OAUTH2_SERVER_URI '⟨https://catalog.example.com/v1/oauth/tokens⟩' ); ATTACH '⟨warehouse⟩' AS my_catalog ( TYPE iceberg, SECRET iceberg_secret, URI '⟨https://catalog.example.com⟩' ); Once... - https://man.mtool.work/duckdb/2.0/core_extensions/iceberg/overview.html
- Utility Functions 7994
- Scalar Utility Functions The functions below are difficult to categorize into specific function types and are broadly useful. Name Description alias(column) Return the name of the column. can_cast_implicitly(source_value, target_value) Whet
...s a table with num_rows rows, each containing the fields defined in varargs . sql_tokenize(sql) Splits the sql string into tokens. Returns a table with the columns start (the byte offset of the token), token_type (e.g., KEYWORD , IDENTIFIER , NUMBER_LI...2, 'foo', num_rows = 3) | | Result | 3 rows of 1, 2, 'foo' | sql_tokenize(sql) | Description | Splits the sql string into tokens. Returns a table with the columns start (the byte offset of the token), token_type (e.g., KEYWORD , IDENTIFIER , NUMBER_LI... - https://man.mtool.work/duckdb/2.0/sql/functions/utility.html
- AWS Extension 7676
- 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
...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_c... - https://man.mtool.work/duckdb/2.0/core_extensions/aws.html
DuckDB 2.0 Documentation / man.mtool.work