I'm looking in Business Warehouse and HANA Enterprise Cloud. Which is better, and what is their cost model?
It seems that Snowflake is becoming very popular nowadays. I have done some training and live sessions by Snowflake.
I would like to hear your opinion about the main key parameters we should look for when choosing Snowflake over other cloud-based data lakes, such as costs, ease of use, maintenance, etc?
And what would be success criteria?
I am a solution architect for a global tech company with over ten years of experience.
What are the benefits of having separate layers or a dedicated schema for each layer in ETL?
One dedicated layer for staging, one for type 1 persistent tables, and a dedicated schema/layer for tables at a dimensional model?
Why it is not recommended to have all tables in one schema?
I appreciate your help.