Results of 1 - 8 of about 8 for analytics (0.002 sec.)
- Command Line Arguments 13085
- The table below summarizes DuckDB's command line options. To list all command line options, use the command: duckdb -help For a list of dot commands available in the CLI shell, see the Dot Commands page . Argument Description -agent Render
...-memory database on localhost:9494 : duckdb -serve To serve a persistent database, provide its path before -serve : duckdb analytics.duckdb -serve The -connect argument connects the CLI to a remote database. Without arguments, it connects to the Quack ser...t in the form TYPE:SECRET . Only the quack type can be served. For example, after creating a persistent Quack secret named analytics , serve or connect with: duckdb analytics.duckdb -serve quack:analytics duckdb -connect quack:analytics The -connect argum... - https://man.mtool.work/duckdb/2.0/clients/cli/arguments.html
- Security 10284
- 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
...to read-only queries. CREATE TABLE quack_tokens (auth_token VARCHAR, user_name VARCHAR); INSERT INTO quack_tokens VALUES ('analytics-team-token', 'analytics'); CREATE MACRO check_token(sid, client_token, server_token) AS ( EXISTS (SELECT 1 FROM quack_toke...) AS ( regexp_matches(upper(trim(query)), '^(SELECT|FROM|WITH|EXPLAIN)\b') ); CALL quack_serve('quack:localhost', token = 'analytics-team-token'); SET GLOBAL quack_authentication_function = 'check_token'; SET GLOBAL quack_authorization_function = 'read_on...ly'; A client with the right token now connects (e.g., with ATTACH 'quack:localhost' AS remote_db (TOKEN 'analytics-team-token') ) and can run SELECT s, but INSERT INTO remote_db.t ... issued through the standard SQL path will fail at aut... - https://man.mtool.work/duckdb/2.0/quack/security.html
- Timestamp Issues 9416
- Timestamp with Time Zone Promotion Casts Working with time zones in SQL can be quite confusing at times. For example, when filtering to a date range, one might try the following query: SET timezone = 'America/Los_Angeles'; CREATE TABLE time
...us section to bound the calendar to the model domain. Half-Open Intervals Another subtle problem in using SQL for temporal analytics is the BETWEEN operator. Temporal analytics almost always uses half-open binning intervals to avoid overlaps at the ends.... - https://man.mtool.work/duckdb/2.0/guides/sql_features/timestamps.html
- Profile and Monitor 8729
- Overview The JDBC driver exposes several ways to observe a running or completed query: cancelling and timing out queries, polling query progress, retrieving profiling output, and emitting memory-usage events through Java Flight Recorder . T
...empty value leaves monitoring disabled. Properties props = new Properties(); props.setProperty("jdbc_jfr_memory_monitor", "analytics-db"); try (Connection conn = DriverManager.getConnection("jdbc:duckdb:/tmp/my_database", props)) { // work with the connec...le a JFR recording is active } The same option can be set in the URL: jdbc:duckdb:/tmp/my_database;jdbc_jfr_memory_monitor=analytics-db Property value Effect absent No events emitted for this connection. empty string No events emitted, the same as absent.... - https://man.mtool.work/duckdb/2.0/clients/java/profiling.html
- Iceberg Functions 8025
- The iceberg extension provides the following functions: Function Description iceberg_scan(source) Reads an Iceberg table from a path. iceberg_metadata(source) Returns the manifest entries of an Iceberg table. iceberg_snapshots(source) Retur
...rom the specified schema. -- Set schema properties CALL set_iceberg_schema_properties(iceberg_catalog.default, { 'owner': 'analytics-team', 'description': 'Default analytics schema' }); -- Read schema properties SELECT * FROM iceberg_schema_properties(ice... - https://man.mtool.work/duckdb/2.0/core_extensions/iceberg/iceberg_functions.html
- marimo Notebooks 8025
- marimo is an open-source reactive notebook for Python and SQL that's tightly integrated with DuckDB's Python client, letting you mix and match Python and SQL in a single git-versionable notebook. Unlike traditional notebooks, when you run a
...SELECT * FROM random_data; Interacting with UI elements, like a slider, makes your data more tangible. DuckDB-Powered OLAP Analytics in marimo marimo provides several features that work well with DuckDB for analytical workflows: Seamless integration betwe... - https://man.mtool.work/duckdb/2.0/guides/python/marimo.html
- Quack Remote Protocol 7500
- 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
...setting whoami_* options directly or by calling 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_versio... - https://man.mtool.work/duckdb/2.0/quack/overview.html
- Connect 7157
- Overview Every DuckDB feature reachable from Java starts with a Connection . This page covers the JDBC URL forms the driver accepts, how DuckDB and driver options are passed and which of them win, how connections come to share (or not share
...E ts > now() - INTERVAL 7 DAYS; /* DUCKDB_CONNECTION_INIT_BELOW_MARKER */ -- Runs for every connection. SET search_path = 'analytics'; Everything above the marker runs the first time the database is opened in the JVM process, and everything below it runs... - https://man.mtool.work/duckdb/2.0/clients/java/connecting.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work