Do hybrid tables store data in new row based format + uPartitions as well? or do hybrid tables only store data in new row based format, meaning Analytics need to be done with downstream etl into classic tables or dynamic tables, or when warehouse caches results in local disk by transforming row based into columnar i suppose ?
Thanks guys thats what i was looking for.. this will make our migration easy from Oracle to Snowflake. Please make it public for virginia us-east-1. There are many projects which are moving out from oracle
What is roughtly the performance difference between hybrid tables and for example tables in transactional databases like snowflake. Will it be possible to run heavy transactional workloads on snowflake. Like 1 million transactions a day?
You can run 1 million transactions in a day. As of now Hybrid table has a throttling limit of 1000 requests per second but you can increase it to 5000 requests per second.
Do hybrid tables store data in new row based format + uPartitions as well? or do hybrid tables only store data in new row based format, meaning Analytics need to be done with downstream etl into classic tables or dynamic tables, or when warehouse caches results in local disk by transforming row based into columnar i suppose ?
It stores the data in row storage as well as in a columnar format for analytical load.
Thanks guys thats what i was looking for.. this will make our migration easy from Oracle to Snowflake. Please make it public for virginia us-east-1. There are many projects which are moving out from oracle
What is roughtly the performance difference between hybrid tables and for example tables in transactional databases like snowflake. Will it be possible to run heavy transactional workloads on snowflake. Like 1 million transactions a day?
You can run 1 million transactions in a day. As of now Hybrid table has a throttling limit of 1000 requests per second but you can increase it to 5000 requests per second.