Bigquery Storage Write API Connection Management

[yusuff]

I'm testing using the Bigquery Storage Write API via the Python client.

I want to compare

client.append_rows(iter([request])) 
# and
append_rows_stream.send(request)
append_rows_stream.close()

Does append_rows create one connection and close it immediately? Does it create multiple connections if there are multiple requests in the iterator?

I tried using append_rows and checked the quota for `Concurrent connections per project for us region` but it's showing 100 concurrent connections when I had just sent 5 requests in total.