Providing BigQuery credentials to the BoardSync app:

Here is an instruction how to obtain all needed credentials from BigQuery:

    • Go to the Google Cloud Console.
    • Create or select the project you want to use with BigQuery.
    • In the navigation menu, click on “APIs & Services” > “Credentials.”
    • Click on the “Create credentials” button and select “Service account key” from the dropdown menu.
    • Choose the service account you want to use or create a new one.
    • Select the key type as “JSON” and click on the “Create” button.
    • The JSON file containing the API key will be downloaded to your computer, and should look like this:
    • Copy the information from the JSON to the form. After you do it – this is how your credentials should look like:

Once you’ve filled in all of the information, hit save and you should be redirected to selecting the syncronization time periods in monday. At this time we support Daily, Weekly and Monthly intervals only.

After choosing, hit add to board
It should look like this:
Meaning, now every day the BoardSync bigquery integration app would sync the board information to bigquery, at the selected time you specified(according to your local timezone).
No further action is needed after this, and you may close the form. About 5 minutes from the selected synchronization time, simply check your bigquery console. you should see a relevant table has been created for your board.