Skip to content

Compare Database Views Node

Data/Database/Versioning

Compare two snapshots by a unique, non-null string or integer key. Return counts, schema changes and bounded row previews.

database_comparedataLong running
Inputs5
Outputs3
Security exposureUnrated
Packagedata

Ratings

Scores range from 0 to 10. Higher values mean more impact, exposure, or operational weight.

No score metadata has been set for this node yet.

Input Pins

5

Input

Execution
exec_in

Database

Struct
database

Database connection

NodeDBConnectionNodeDBConnection1 fields
cache_keystringrequired
Schema enforced

Compare With

Struct
other

Target database view

NodeDBConnectionNodeDBConnection1 fields
cache_keystringrequired

Key Column

String
key

Unique, non-null string or integer application key present in both views

Default id

Preview Limit

Integer
limit

Maximum changed rows returned, from 0 to 1000. Counts cover the full comparison.

Default 100

Output Pins

3

Done

Execution
exec_out

Operation completed

Reference

Struct
reference

Resolved table, branch, version and access state. An unopened new table has no reference yet.

DatabaseReferenceDatabaseReference5 fields
tablestringrequired
branchstringrequired
versioninteger:uint64required
format uint64min 0
read_onlybooleanrequired
pinnedbooleanrequired

Difference

Struct
diff

Added, removed, changed and unchanged counts with row previews

DatabaseDiffDatabaseDiff9 fields
sourceDatabaseReferencerequired
tablestringrequired
branchstringrequired
versioninteger:uint64required
format uint64min 0
read_onlybooleanrequired
pinnedbooleanrequired
targetDatabaseReferencerequired
tablestringrequired
branchstringrequired
versioninteger:uint64required
format uint64min 0
read_onlybooleanrequired
pinnedbooleanrequired
addedinteger:uint64required
format uint64min 0
removedinteger:uint64required
format uint64min 0
changedinteger:uint64required
format uint64min 0
unchangedinteger:uint64required
format uint64min 0
schema_changesArray<string>required
itemsstringarray item
rowsArray<DatabaseDiffRow>required
itemsDatabaseDiffRowarray item
kindstringrequired
truncatedbooleanrequired

Node Info

Internal name
database_compare
Category
Data/Database/Versioning
Version
1