community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

BigQuery Tool Slow to stream data

Meteor

I've been working with BigQuery using the Google BigQuery input tool, and I've noticed that any time I have to execute a query that has a sizable data return, it takes a very long time to stream that data from Google to BQ.  I'm assuming it's because it is a stream, but wanted to see if anyone else happened to see this behavior or if anyone knew of a way to speed it up.

Alteryx
Alteryx

Using the Insert Batch size parameter may help.

 

I'd recommend doubling it and then halving it from your current setting and then going from there as to which is best. AKA half again or double again, until you find the optimum for your data/network.

Meteor

I'm pretty new to the Google BigQuery connector, doubling what exactly?

Alteryx
Alteryx

Sorry, I got confused and thought you were using the output tool.

 

 

Labels