If you are curious about Nile's internal architecture, here's a deep dive into how DDL like

CREATE TABLE

get transparently and reliably distributed to all tenants and postgres instances: https://www.thenile.dev/blog/distributed-ddl