Hi, I think the comparison is wrong, because in snowflake data is organized in fact and dimension tables while solr is search engine.
Solr is optimized for full text search while snowflake like dB are used to run joins, analytic queries. To answer your question - no if you are on snowflake , solr is not right choice at all. On Thu, 21 Apr 2022, 20:34 Balanathagiri Ayyasamypalanivel, < [email protected]> wrote: > Thanks David, for your quick response. From the overall article in the > system, it seems like snowflake little faster than the normal Database > system, so instead of sourcing the data from snowflake to Solr. > > Can we directly query from snowflake via snow sql? > > Regards, > Bala. > > On Thu, Apr 21, 2022, 10:36 AM David Hastings < > [email protected]> > wrote: > > > I dont see how they are comparable. One is a DB, the other is a search > > engine. There is no overlap aside from Solr indexing data fro Snowflake > to > > search it > > > > On Thu, Apr 21, 2022 at 10:21 AM Balanathagiri Ayyasamypalanivel < > > [email protected]> wrote: > > > > > Hi, > > > > > > Any one recently switched from Solr to Snowflake? Or can we have any > > > comparison chart between the snowflake vs Solr. > > > > > > Regards, > > > Bala. > > > > > >
