Hey all,
I’m a new bigquery user confused about what might be invoking the bigquery reservation API and generating associated costs. I’m using a bigquery notebook to convert a Dataframe into a GBQ table using to_gbq method from Pandas (which might not be the best way to do this as I understand). I’ve used this method to load 3 5mb tables. Aside from this, there’s no other parts of my notebook that modify or query the table in any way. I’ve checked the tables once by querying then directly (no more than 2-3times, running a fairly simple SELECT * FROM table LIMIT 100 query.
What might be causing about 30slot-hours of Bigquery reservation API usage? I’m using the default settings (I’m still on the free 90 day trial period), so I’ve not created any reservations and I should have on-demand pricing. I’ve checked the capacity manager and I don’t see any reservation there either. The only thing I can think of is to disable the Reservation API (which also turns removes access to capacity management) - which allows my code to still run smoothly, but I’d like to know what I’m doing wrong here. I’m confused as if there’s something I’m missing, or if I’m fundamentally misunderstanding something about bigquery.