0

Im running bigquery command line query with destination table

like bq query --destination_table with some select statements from src table.

Whether this will be considered as loading data or querying data ?

Because, loading data is free and query data is going to cost.

My intention is to move some data from src to destination with some manipulations on src fields . So bq query with destination looks a perfect fit for this .

Mangai
  • 95
  • 2
  • 6
  • 1
    obviously, this is considered as a query! – Mikhail Berlyant Dec 17 '17 at 03:55
  • @Mngx: it's important you accept answers when they are correct. That's how Stack Overflow works ;-) Also, see here! https://stackoverflow.com/questions/47824767/max-number-of-partitions-that-can-be-created-on-bigquery-table – Graham Polley Dec 18 '17 at 09:51

1 Answers1

2

If you are running a query, then you are billed for the cost of the query. It doesn't matter whether you have specified a destination table. If you want to avoid the cost of querying, you need to extract the data, perform whatever transformation you want, and then load it again.

Elliott Brossard
  • 32,095
  • 2
  • 67
  • 99