How to improve a query response time

Hello - I have a 1.5M row data set that I’ve saved as a dataset locally that keeps timing out - any suggestions on how to make the querying more efficient - thought saving it as a dataset instead of a worksheet would do the trick.

Typically, a dataset is just a snowflake view of the underlying table (unless you are working with CSV files).

Materialized dataset commits these views into a table, which is then often faster for reading.

When you edit the dataset, go to materialization tab:

Create a materialization schedule