A company is looking to optimize the management of its Cloud Logging platform and select the appropriate options for logging export in Google Cloud Platform. They want to export logs to BigQuery for long-term analysis, while ensuring the right balance between cost and log retention. What is the best approach to achieve this?