Loading CSV data files from local upload

In this example scenario, we will load three advertising and sales data sources into a dataset in BigQuery for analysis. Each data source CSV file will be loaded manually through a single batch job. Loading CSV files has the advantage of being an easy process, as they can be loaded from local upload or Google Cloud Storage.

This approach has disadvantages as well. First, the data will only be from a snapshot or a moment in time, and second, it is a manual operation – it needs to be done by an individual. Beyond this example, with moment-in-time data, you may consider setting up streaming ingestion when possible for automated data loading. Many common advertising or marketing services support integration with BigQuery to handle data loading and updates for you. For additional information on loading data into BigQuery, review Chapter 4, Loading and Transforming Data.

Google Analytics BigQuery linking

In Google Analytics (GA) you...