SELECT * FROM ..., it's up to you. Once you have created your model, click Save Model.
ORDER BYstatement. When we unload the records, we just use a normal SELECT, so the records can come back in any order. We recommend treating the Google Sheet that is receiving data as the "raw data" and doing any necessary transformations, like ordering, in a separate sheet within the file. The
IMPORTRANGEfunction in Google Sheets can be a great solution for this use case - you can find the documentation and best practices here.
Sheets prohibits updates of over 2.5M cells. Please try modifying your source data to limit the total cell count.