This script shows the ancestors for each node in a dbt graph

show_ancestors.py

import sys
import networkx as nx

if len(sys.argv) != 2:
    print("Usage: {} [path/to/graph.gpickle]".format(sys.argv[0]))
    sys.exit(1)


filename = sys.argv[1]
graph = nx.read_gpickle(sys.argv[1])

for node in graph.node:
    print("{}".format(node))
    for anc in nx.ancestors(graph, node):
        print("  {}".format(anc))
    print()