How Redash Loads queries with large data points (around 100k)?

The same way it loads any query result: all values are loaded to the front end application. Redash expects you to aggregate data on your database server, then use Redash to visualize the result. 100k results in many cases will crash the application. Although this depends how many fields are on each row.

I think it’s pretty unlikely you need 100k data points to render a visualisation, so filter or aggregate the data in your query first and then return only the rows needed to create the visualisation to Redash.

Also consider adding parameters to the query to make this more dynamic.