One of the main disadvantages of snowflake schema is that it increases the query complexity and the number of joins required to retrieve data from multiple dimension tables.