When should dimensional tables be used in terms of the size of the data?

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.