[BigQuery] - Table excluded

[vorges]

Hi everyone, I created a table from a Python script that collects data from an API and stores it in BigQuery. I also built some views on August 17, 2024. However, they are no longer available. Are tables automatically removed? If so, can I recover them?

[mars124]

Tables are automatically removed upon reaching the expiration datetime. From my experience, tables are created without an expiration by default, so it could be:
a. You somehow accidentally created it with an expiration datetime;
b. Someone updated the table with an expiration datetime;
c. Someone deleted the table;
d. It was created in a different location than you intended, hence you might be looking for it in the wrong place.

[vorges]

I only use this BigQuery account for a personal project and to study BigQuery. I created the tables and views free of charge, but since I didn't insert a credit card, is that why the tables were automatically removed?

[mars124]

Are you using the BigQuery Studio interface? It should not be hard looking for your table there. How did you create the table?

[vorges]

I created the project within BigQuery, I created a dataset to host the API tables and another dataset for the views, but my datasets are empty without the tables and views. I think they were removed automatically.