Minimum IAM roles
To use table loading
To use query loading
To use "Import Large Dataset"
When you load a large dataset (more than 500MB as a benchmark), we recommend that you use this "Import Large Dataset" option. This option exports the data as GCS (Google Cloud Storage) objects then and loads the data in multiple tasks. Hence, loading is faster.
To enable this option, check Import Large Dataset then specify "Temp dataset", "Temp table", "GCS bucket" and "GCS path prefix". And please make sure that The "Temp dataset" must be created manually in advance.