Is GSC bulk export is partitioned by default? It says the partition expiry is 60 days. But this way it kinda fails the purpose of using BQ to hold the data for long time.
You can also set it to NULL - but as John said, storage can incur costs. I'd recommend setting up budget alerts so you're not taken by surprise when a bill comes your way
@Noah built to help you get a sense how how costs will grow over time. And scroll up to the top of the page and check out the free tool and Looker Studio template he built - it's pretty sweet.
The 60 day partition expiry is ONLY the default for . i.e. when you have not set up Billing in GCP. This is not specific to the GSC export and it is just the way Google limits costs when you are not paying.
The most recent project I did, billing was definitely on and I still had the partition expiration. Though I think it was for longer than 90, but still not as long as I want.
the billing was added as Google prompted to add billing when I turned on the bulk export. So, yes even when the billing is added, I still see the 60 days expiry date
That sounds like the link to BigQuery was created before billing was active, which means that adding the billing after the table was created won't have any effect. I would expect that if you canceled the export and started it again you wont have the 60 day limitation.