You are overseeing a critical project for your company's Business Intelligence (BI) department. This project involves a data pipeline that continuously ingests real-time data into BigQuery through streaming processes. To ensure that the BI department can effectively analyze and leverage this data, it is essential that users have the capability to execute custom SQL queries on the most current data available in BigQuery. What actions should you take to achieve this objective?