Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Why does bigquery show the number (1) behind some tables

After loading data with batch processing to Google BigQuery i'm expecting tables that are partitioned based on their date (I know, have to rename the column of date as it's reserved).

However, when receiving some new tables they have a different icon and show the number 1 behind the table in this format (1). See the image below.

What is happening here? I would expect them to be normal partitioned tables.
I can't find this anywhere in their documentation or the wider web.

// if you give a -1 at least tell me why? What is wrong with this question?

enter image description here

like image 586
Michel K Avatar asked Sep 02 '25 10:09

Michel K


1 Answers

This number is shown there because it is probably that you used to have more tables with the same schema and the same name prefix, but now those tables are deleted. For example, here I have 6 tables with the same prefix and it shows (6).

enter image description here

When I open this table it appears that the I can select the other tables to show the schema or details as:

enter image description here

like image 53
Jose Gutierrez Paliza Avatar answered Sep 08 '25 12:09

Jose Gutierrez Paliza