Synapse vs snowflake

Question

Hello.
I am unable to find an answer or document about my question.
We are planning to move on prem data to azure.
We are debating between (azure synapse, databricks, ADF) and snowflake
Any thoughts please?

Thankyou

Answer 1

Hello arkiboys,
Thanks for the ask and using the forum .

I think the it will be better if you have try to evaluate the product as per what feature you are using and not how are they are different . There may some features
which are different but you end up not using it at all.Both the product are great but if you go with security I think Synapse will fare better , as it
is connected to active directory whick makes the integration confortably easy .Snowflake is avilable for all the leading cloud provider ,
so depending on the fact where does most of the data resides you can make a decision where do you want to host the Snowflake instance . Synapse is only on Azure ,
but then you can always use Azure data factory to ingest data . We do have somethingcalled 'SnowPipe" which offered by Snowflake , I do not think its as powerful as ADF . Also I should point to the fact that Synapse has many simialrity with the TSQL and that does cut down the devlopment time considerably . Again some features like time travel is still not avaliable in Synapse .

One more import part is the reporting piece , data by itself does not mean a lot , on Azure you can use Power BI which is very powerful and integrate failrly well with others services .

Hope this helps helps .

Thanks
Himanshu