Thank you so much for the reply. I had an idea that fact tables should be loaded last, I didn't know how to proceed with the dimension tables in snowflake...