Database Node Catalog

Database category

Generated from 42 catalog nodes in Data/Database.

Data/Database/DeleteData/Database/GraphData/Database/Graph/MetaData/Database/Graph/QueryData/Database/Graph/WriteData/Database/InsertData/Database/MetaData/Database/OptimizationData/Database/SchemaData/Database/Search

Nodes in this category

Showing 42 of 42 generated node docs.

Open Database

Data/Database

Open a local database

4 in2 outSecurity unrated

Open Remote Database

Data/Database

Open a shared database of a connected project. The project must have granted this app access with a role that allows reading (and for writes, writing) files or databases. The run reuses the connection and refreshes its scoped credentials automatically.

5 in2 outSecurity unrated

Delete

Data/Database/Delete

Delete rows from a database table and return the removed rows

3 in2 outSecurity unrated

Drop Table

Data/Database/Delete

Permanently deletes the entire table, both its rows and its schema, so it can be recreated later with a different schema. This is irreversible and cannot be undone. Buffered writes that have not been flushed yet are discarded instead of written back. Graph overlays referencing the table are pruned and reported on References; saved queries are never modified. Known limitation: a DataFusion table provider registered from this table earlier in the same run keeps pointing at the deleted dataset, because mounts are only refreshed when the credential generation changes.

2 in3 outSecurity 4/10

Purge

Data/Database/Delete

Purge Database

2 in1 outSecurity unrated

Create Graph Overlay

Data/Database/Graph

Creates a new graph overlay definition over existing database tables

3 in4 outSecurity unrated

Drop Graph Overlay

Data/Database/Graph

Deletes a graph overlay definition (does not drop underlying tables)

3 in3 outSecurity unrated

Open Graph Overlay

Data/Database/Graph

Opens an existing graph overlay and returns a connection for querying

3 in4 outSecurity unrated

Graph Schema

Data/Database/Graph/Meta

Retrieves the schema (labels and properties) of a graph overlay

2 in2 outSecurity unrated

List Graph Overlays

Data/Database/Graph/Meta

Lists all graph overlay definitions in the database

2 in3 outSecurity unrated

Cypher Query

Data/Database/Graph/Query

Executes a Cypher query against the graph overlay

5 in4 outSecurity unrated

Find Paths

Data/Database/Graph/Query

Finds the shortest connections between two objects, including alternative routes

8 in5 outSecurity unrated

Graph Analytics

Data/Database/Graph/Query

Computes degree, PageRank, and connected components over a graph overlay

3 in4 outSecurity unrated

Graph Neighbors

Data/Database/Graph/Query

Finds neighbor nodes by traversing edges from a seed node

7 in5 outSecurity unrated

Graph Sample

Data/Database/Graph/Query

Samples objects of a given label from a graph overlay for previewing

4 in4 outSecurity unrated

Graph Search

Data/Database/Graph/Query

Searches objects by caption or identifier across the whole graph overlay

4 in4 outSecurity unrated

Graph Subgraph

Data/Database/Graph/Query

Extracts a subgraph around seed nodes for visualization

6 in5 outSecurity unrated

SQL Query (Graph)

Data/Database/Graph/Query

Executes a read-only SQL query against graph overlay tables via DataFusion. Write any value that comes from outside the flow as a $placeholder and wire it into the pin that appears — never build the SQL string around it.

5 in4 outSecurity unrated

Upsert Graph Edge

Data/Database/Graph/Write

Inserts or updates an edge in the graph overlay's underlying edge table

4 in3 outSecurity unrated

Upsert Graph Node

Data/Database/Graph/Write

Inserts or updates a node in the graph overlay's underlying table

4 in3 outSecurity unrated

Batch Insert

Data/Database/Insert

Inserts multiple items at once. Faster than Upsert but might produce duplicates.

3 in3 outSecurity unrated

Batch Insert (CSV)

Data/Database/Insert

Inserts multiple items at once. Faster than Upsert but might produce duplicates.

5 in3 outSecurity unrated

Batch Insert (TDMS)

Data/Database/Insert

Reads a LabVIEW TDMS file and batch-inserts its channel data as rows into a vector database.

4 in1 outSecurity unrated

Batch Upsert

Data/Database/Insert

Inserts if the Item does not exist, Updates if it does

4 in3 outSecurity unrated

Insert

Data/Database/Insert

Faster than Upsert, but might write duplicate items.

3 in3 outSecurity unrated

Upsert

Data/Database/Insert

Inserts if the Item does not exist, Updates if it does

4 in3 outSecurity unrated

Count

Data/Database/Meta

Count Items

3 in2 outSecurity unrated

Get Schema

Data/Database/Meta

Get Local Database Schema

2 in2 outSecurity unrated

List

Data/Database/Meta

List Content

4 in2 outSecurity unrated

List Indices

Data/Database/Meta

Lists all indices on a database table

2 in2 outSecurity unrated

List Tables

Data/Database/Meta

Lists all available table names in the database location

2 in2 outSecurity unrated

Build Index

Data/Database/Optimization

Build Index

4 in1 outSecurity unrated

Drop Index

Data/Database/Optimization

Remove an index from a database table

3 in1 outSecurity unrated

Flush Database

Data/Database/Optimization

Flush any buffered writes to storage immediately

2 in3 outSecurity unrated

Optimize and Update

Data/Database/Optimization

Optimize and Update the Database

3 in1 outSecurity unrated

Add Column

Data/Database/Schema

Adds a column using a typed SQL expression (e.g. 0, '', CAST(NULL AS STRING)). LanceDB rejects bare NULL — wrap it in CAST(... AS <type>). Supported types: int, bigint, float, double, string, binary, boolean, date, timestamp.

4 in2 outSecurity unrated