Data Keeps Loading in the Input Step or Error "Tableau Prep Stopped Running Because an Underlying Process Stopped Unexpectedly" Occurs When Connecting to Google BigQuery

Please use the below workarounds to avoid this issue.

Option 1

After adding the Input step, move to the [Data Sample] tab, and select [Use all data] or set a [Fixed number of rows].

If you are using a large table, this method might take a long time to load and process the data. In this situation, please refer to Option 2.

Option 2

After selecting a Project and Dataset, double-click Custom SQL located at the bottom left of the pane.
An input step should be automatically added. In the Custom SQL dialog box, enter a query using the syntax below and then click Run.
* No need to change the option in the [Data Sample] tab in this method.

SELECT * FROM `project-id.dataset_name.table_name`

Note: The Custom SQL option will not be displayed until a dataset is selected.  The Custom SQL option can be displayed by selecting a random project and dataset.