If you want to load any data from ActiveCampaign to BigQuery, you have to use one of the following supported data sources.
- Google Cloud Storage
- Sent data directly to BigQuery with a POST request
- Google Cloud Datastore Backup
- Streaming insert
- App Engine log files
- Cloud Storage logs
From the above list of sources, 5 and 6 are not applicable in our case.
For Google Cloud Storage, you first have to load your data into it. There are a few options on how to do this. For example, you can use the console directly as described here and do not forget to follow the best practices.
Another option is to post data through the JSON API. As we see again, APIs play an important role in both the extraction and the loading of data into our data warehouse. It's just a matter of one HTTP POST request using a tool like CURL or Postman in its simplest case.
After you have loaded data into Cloud Storage, you have to create a Load Job for BigQuery to load every data into it. This Job should point to the source data in Cloud Storage that have to be imported. You can do this by providing source URIs that point to the appropriate objects.