We have a very huge dataset on Google big query which we require for the ad-hoc reporting in Tableau.
keeping the connection live is also not possible since Tableau Query a lot and big query charges on the amount of data process per query. I tried to create an extract but it failed.
Do you need every record in the extract ?
I'd suggest building a summary extract so you can look at the data at a high level before drilling down to 100 million records.