Do you know, how to extract every 100th or nth row in looker?
Considering the fact that 100th row might be different depending on your Looker joins, you would need the n-th to be a column in your source data.. Alternatively, you can try to add a dimension with a window function but I haven’t tested it myself..