Results of 1 - 5 of about 5 for audit (0.001 sec.)
- CREATE TRIGGER Statement 12832
- New The CREATE TRIGGER feature was introduced in DuckDB 2.0. The CREATE TRIGGER statement registers a trigger: a set of SQL statements that run automatically in response to INSERT , UPDATE , or DELETE events on a table. Examples Record ever
...y statement that modifies a table in an audit table using a statement-level AFTER trigger. The REFERENCING OLD TABLE and NEW TABLE clauses expose the rows before and af...ter the change as transition tables: CREATE TABLE target (id INTEGER, val INTEGER); CREATE TABLE audit (id INTEGER, old_val INTEGER, new_val INTEGER); CREATE TRIGGER trg_audit AFTER UPDATE ON target REFERENCING OLD TABLE AS o...NEW TABLE AS n FOR EACH STATEMENT INSERT INTO audit SELECT n.id, o.val, n.val FROM o JOIN n ON o.id = n.id; INSERT INTO target VALUES (1, 10), (2, 20); UPDATE target SET val... - https://man.mtool.work/duckdb/2.0/sql/statements/create_trigger.html
- Delta Extension 8732
- The delta extension adds support for the Delta Lake open-source storage format . It is built using the Delta Kernel . The extension reads Delta tables, local and remote, and writes them: it can create tables and append to them. For implemen
...as Delta table properties, except location , which must match the attached path: ATTACH 's3://⟨my_bucket⟩/⟨other_path⟩' AS audit (TYPE delta); CREATE TABLE audit.audit (id BIGINT, name VARCHAR) WITH ('delta.enableDeletionVectors' = 'true', 'delta.appe... - https://man.mtool.work/duckdb/2.0/core_extensions/delta.html
- What's New in the Docs for 2.0 8273
- This page tracks the documentation for the features introduced in DuckDB 2.0, organized around the themes of the DuckDB 2.0.0 release announcement . Each section links to the relevant documentation. DuckDB as a Server: Quack and CONNECT Sin
...2.0 added trigger support, so you can run actions automatically in response to table changes. This is useful for building audit tables and enforcing invariants. CREATE TRIGGER statement SQL Dialect Additions DuckDB 2.0 extended the SQL dialect in sev... - https://man.mtool.work/duckdb/2.0/whats_new_in_the_docs.html
- Merge Statement for SCD Type 2 8126
- This is a practical, step-by-step guide to using DuckDB's MERGE statement (introduced in v1.4.0) to perform upserts and build Slowly Changing Dimension Type 2 (SCD Type 2) tables . Type 2 SCDs let you keep full historical versions of record
...s while clearly identifying the current version, perfect for audit trails, data warehousing, and analytical workloads. Type 2 SCDs are practical when you want to know previous values of you... - https://man.mtool.work/duckdb/2.0/guides/sql_features/merge.html
- Connect 7960
- 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
...ed after deployment. DuckDBConnection.getSessionInitSQL() returns the text that was executed, so an application can log or audit it. Warning The SQL in the file runs with the full privileges of the connection. Treat the connection string and the file... - https://man.mtool.work/duckdb/2.0/clients/java/connecting.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work