Cached query limit stuck at 10 rows

[pallavjagoori]

Hi I have connected a mysql data source and written a query which results in 10,000 rows. The Redash query id for the said query is 10 (query_123)

query_123 is lets say:
select * from table_name;

results count is 10,000+

Now I have created a "Query Results as Data Source" and written this SQL query

select * from cached_query_123;

I am only getting first 10 results from query_123 how do I increase the limit from 10? Or how do I return the whole stored data from query_123 i.e. those 10,000+ rows?

What am I missing here? I m following this document:
https://redash.io/help/user-guide/querying/query-results-data-source/