There are a selection of public datasets available through the Google Cloud Public Dataset Program that is already loaded into Big Query.
Dataset Example Search
When searching for datasets in the Google Dataset search, one must have datasets as one of the search terms. For example, if you are looking for datasets of the water quality of Canada, your search terms would be: Canada "Water Quality" datasets.