Get Schema Node

G

Data/Database/Meta

Get Local Database Schema

schema_local_dbdata

Inputs2

Outputs2

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

2

Input

Execution

exec_in

Database

Struct

database

Database Connection Reference

SchemaNodeDBConnectionNodeDBConnectionNodeDBConnection1 fields

cache_keystringrequired

Schema enforced

Output Pins

2

Done

Execution

exec_out

Done Fetching Local Database Schema

Schema

Struct

schema

Local Database Schema

SchemaTableSchemaTableSchemaTableSchema2 fields

fieldsArray<TableField>required

The columns, in storage order.

itemsTableFieldarray item

One column of a table.

namestringrequired

Column name.

data_typevaluerequired

Arrow data type: a bare name such as `"Utf8"` or `"Int64"` for simple types, an object for nested ones such as lists and structs.

nullablebooleanrequired

Whether the column accepts nulls.

dict_idinteger | null

Dictionary id, set only on dictionary-encoded columns.

format int64

dict_is_orderedboolean | null

Whether the dictionary is ordered, set only on dictionary-encoded columns.

+1 more fields

metadatavalue

Table level key/value metadata, defined by whoever wrote the table.

default null

Node Info

Internal name

schema_local_db

Category

Data/Database/Meta