Hi All, my team wants to create a new connection f...
# help-connector-development
n
Hi All, my team wants to create a new connection for reporting needs in the dashboard from Google Bigquery to Mixpanel. Can anyone help with a guide or steps to build the process? thank you.
k
A message from kapa.ai
Sure, I can guide you through the process of setting up a connection from Google BigQuery to Mixpanel using Airbyte. Firstly, you need to set up the BigQuery destination connector: 1. Log into your [Airbyte Cloud](https://cloud.airbyte.com/workspaces) or Airbyte Open Source account. 2. Click Destinations and then click + New destination. 3. On the Set up the destination page, select BigQuery or BigQuery (denormalized typed struct) from the Destination type dropdown. 4. Enter the name for the BigQuery connector. 5. For Project ID, enter your [Google Cloud project ID](https://cloud.google.com/resource-manager/docs/creating-managing-projects#identifying_projects). 6. For Dataset Location, select the location of your BigQuery dataset. Note: You cannot change the location later. 7. For Default Dataset ID, enter the BigQuery [Dataset ID](https://cloud.google.com/bigquery/docs/datasets#create-dataset). 8. For Loading Method, select [Standard Inserts](https://docs.airbyte.com/integrations/destinations/bigquery#using-insert) or [GCS Staging](https://docs.airbyte.com/integrations/destinations/bigquery#recommended-using-a-google-cloud-storage-bucket). (Source: [Airbyte Documentation](https://docs.airbyte.com/integrations/destinations/bigquery)) Next, you need to set up the Mixpanel source connector: 1. [Log into your Airbyte Cloud](https://cloud.airbyte.com/workspaces) or navigate to the Airbyte Open Source dashboard. 2. Click Sources and then click + New source. 3. On the Set up the source page, select Mixpanel from the Source type dropdown. 4. Enter the name for the Mixpanel connector. 5. For Authentication, select Service Account from the dropdown and enter the [Mixpanel Service Account secret](https://developer.mixpanel.com/reference/service-accounts). 6. For Project ID, enter the [Mixpanel Project ID](https://help.mixpanel.com/hc/en-us/articles/115004490503-Project-Settings#project-id). 7. For Attribution Window, enter the number of days for the length of the attribution window. 8. For Project Timezone, enter the [timezone](https://help.mixpanel.com/hc/en-us/articles/115004547203-Manage-Timezones-for-Projects-in-Mixpanel) for your Mixpanel project. 9. For Start Date, enter the date in YYYY-MM-DD format. The data added on and after this date will be replicated. If left blank, the connector will replicate data from up to one year ago by default. 10. For End Date, enter the date in YYYY-MM-DD format. 11. For Region, enter the [region](https://help.mixpanel.com/hc/en-us/articles/360039135652-Data-Residency-in-EU) for your Mixpanel project. 12. For Date slicing window, enter the number of days to slice through data. If you encounter RAM usage issues due to a huge amount of data in each window, try using a lower value for this parameter. 13. Click Set up source. (Source: [Airbyte Documentation](https://docs.airbyte.com/integrations/sources/mixpanel))
New message text here