As mentioned in Firebolt documentation,
Dimension tables are replicated in each engine node. Use dimension tables for smaller data sets that are typically more descriptive of a dimension in the fact table, and are frequently joined with fact tables.
In terms of dimension table size, it could be couple of hundred millions.