Use persistent derived tables in your Looker project for ad-hoc and one-timed projects that involve complex or big amount of data.