Where the modeling work goes
The most useful way to compare them is to ask when each one makes you do the modeling. ThoughtSpot asks for it upfront: worksheets and models in ThoughtSpot Modeling Language, often built on dbt, have to be in good shape before search returns reliable answers. Sigma lets users start almost immediately on warehouse tables, and the modeling happens gradually, in many workbooks, by many authors. One front-loads the cost; the other spreads it out and risks inconsistency.