Append a CSV file to a Google bigQuery table. Create a "Service credentials" at the https://console.cloud.google.com/, copy & paste the JSON file into the variable value for 'CREDENTIALS' and set it as a secret.
- Modified
- Used by3 users
- Used149 times
- API
- Source code
- Recommended actors
To run the code examples, you need to have an Apify account. Replace <YOUR_API_TOKEN> in the code with your API token.
const Apify = require('apify');
// Set API token
Apify.client.setOptions({ token: '<YOUR_API_TOKEN>' });
// Prepare actor input
const input = {};
// Run the actor
const run = await Apify.call('juansgaitan/big-query', input);
// Print actor output (if any)
console.log('Output');
console.dir(run.output);
// Fetch and print actor results from the run's dataset (if any)
console.log('Results from dataset');
const dataset = await Apify.openDataset(run.defaultDatasetId, { forceCloud: true });
await dataset.forEach(async (item, index) => {
console.log(JSON.stringify(item));
});
