Connecting to Google BigQuery

​

Refer to Google Cloud documentation to learn more.

​​

Step 1: Create a Google Cloud Project

1. Go to the Google Cloud Console.

2. Create a new project or select an existing one.

3. Take note of the Project ID.

 

Step 2: Enable BigQuery API

1. In your project, go to APIs & Services > Library.

2. Search for BigQuery API and click Enable.

​

Step 3: Configure OAuth Consent Screen

1. Go to APIs & Services > OAuth consent screen.

2. Choose Internal (this requires Google Workspace with your domain).

   • If you don't yet have Google Workspace, you’ll need to choose External for now.

3. Fill in:

   • App name

   • User support email

   • Authorized domain(s)

   • Developer contact information

4. Scopes:

   • Add https://www.googleapis.com/auth/bigquery.readonly

   • Optionally also https://www.googleapis.com/auth/cloud-platform

5. Save and Publish.

 

Step 4: Create OAuth 2.0 Client ID for iOS

1. Go to APIs & Services > Credentials.

2. Click Create Credentials > OAuth client ID.

3. Choose Application type: iOS.

4. Enter:

   • Name: e.g., Oneboard BigQuery

   • Bundle ID: ai.sweeft.oneboard

5. Click Create and save the:

   • Client ID

   • Client Secret (not used directly in iOS, but useful for backend exchanges)