inner_join (view)

1 row where NODES = 6 and STATE = "idle"

✎ View and edit SQL

This data as json, CSV (advanced)

PARTITION AVAIL TIMELIMIT NODES STATE NODELIST name VRAM
rtx2060 up 1-00:00:00 6 idle c[29,51-52,60-62] rtx2060 6

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW inner_join AS SELECT *
FROM nodes
INNER JOIN [nvidia-gpus] ON nodes.PARTITION = [nvidia-gpus].name;