Hi @IM_01,

Unfortunately, no. The order by function in the definition of a Lakeflow SDP materialized view, does not guarantee the stored rows will be ordered when you later query the MV. Materialized views are stored like regular Unity Catalog tables... as in they cache the result set of your query, but the engine is free to physically store and return rows in any order unless you ORDER BY in the select that reads from the MV. So, you'll have to use order by when querying the MV.

If this answer resolves your question, could you mark it as “Accept as Solution”? That helps other users quickly find the correct fix.