How to manually enroll an early access or custom data source in BigQuery (marketplace)

With the Google APIs Explorer, you can enroll any Supermetrics early access or custom-built connector in BigQuery even if it's not available in the BigQuery marketplace.

Before you begin

Before you can enroll a connector in BigQuery, you’ll need permission to update your project. Ask your admin to grant you the Project Mover role — or add it yourself — for the project you want to enroll the connector in.

Learn about predefined roles in Google’s documentation.

Instructions

Step 1: Find your project number

You’ll need your project number to enroll the connector.

To find it:

1. Log in to Google Cloud Platform.
2. In the left-side menu, click BigQuery → SQL workspace.
3. Select the project you’d like to enroll the connector in.
4. Click Cloud overview → Dashboard.
5. In the Dashboard tab’s Project info pane, you’ll find your project number.

Step 2: Get the connector ID

This is the identifier that you’ll add to your project in the Google APIs Explorer. If the connector ID for your data source isn't publicly available, we'll send it to you. 

Step 3: Enroll the connector in your project

When you’re ready, use the Google APIs Explorer to enroll the connector.

1. Open the BigQuery Data Transfer Service.
2. A dialog titled “Try this method” will open at the right-hand side of the screen.
3. Fill in the “name” field with projects/yourProjectNumber.
4. In the “Request body” field, click the plus icon and select dataSourceIds. 
5. This will add a section where you’ll add the connector ID. Make sure to add double quotation marks around the ID.
   With your connector ID in the highlighted row, an example would read:
   
   {
       "dataSourceIds": [
           "yourconnectorID"
       ]
   }
   
   
6. Double-check your work, and click Execute when you’re ready.
7. Authenticate your connection.

If everything’s working as it should, you’ll see a green response message reading 200.

Step 4: Verify enrollment

To make sure that your connector is properly enrolled:

1. Open the Google Cloud Platform.
2. In the left-side menu, click BigQuery → Data transfers.
3. Click + CREATE TRANSFER.
4. Under Source type, search for the connector you enrolled in the project. If the connector’s ready to use, it should appear there.