# Find your BigQuery Credentials

To connect Humanic with your BigQuery data warehouse, you'll need to provide three pieces of information: the Project ID, Dataset ID, and a Service Account JSON key. Follow these steps to locate these credentials:

### Finding Project ID

* Sign in to the [Google Cloud management console](https://console.cloud.google.com/).
* Navigate to the Dashboard of your project.
* In the "Project info" section of the Dashboard, you'll find the **Project ID** displayed.

<figure><img src="https://2273820434-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrbIhacVcyuUret5XcsVA%2Fuploads%2FevT56feIdeRDH0GbbnFV%2Fimage.png?alt=media&#x26;token=0c52c999-5b27-448d-92c2-34a1e55e98c0" alt=""><figcaption></figcaption></figure>

### Finding Dataset ID

To find the Dataset ID, follow these steps in the BigQuery Studio:

*   In the "Explorer" panel, expand your project to view the list of datasets.

    <figure><img src="https://2273820434-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrbIhacVcyuUret5XcsVA%2Fuploads%2Fk1Bd2ch5azGAhrsTDXpI%2Fimage.png?alt=media&#x26;token=17d00531-6bb1-4bb6-9a75-84ffc6c6d6bc" alt=""><figcaption></figcaption></figure>
* Locate the dataset you want to connect to Humanic.
*   You can find the Dataset ID in two ways:\
    **Option 1: Copy Dataset ID**

    * Click on the three dots next to the dataset name.
    * Select "Copy ID" from the dropdown menu.
    * The Dataset ID will be copied to your clipboard.

    <figure><img src="https://2273820434-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrbIhacVcyuUret5XcsVA%2Fuploads%2FkhHNV0iqcBllE215FgO4%2Fimage.png?alt=media&#x26;token=53b4d308-453a-456e-930c-5c5e2a4cd159" alt=""><figcaption></figcaption></figure>

    **Option 2: View Dataset Info**

    * Click on the dataset name to open the "Dataset info" panel on the right.
    * The Dataset ID will be displayed in the "Dataset info" section.

    <figure><img src="https://2273820434-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrbIhacVcyuUret5XcsVA%2Fuploads%2F3qPmu8IWppfXNP1KC7eW%2Fimage.png?alt=media&#x26;token=300880cb-973a-4953-b851-edb63a0ecceb" alt=""><figcaption></figcaption></figure>

### Generating a Service Account JSON Key

**To create a BigQuery service account key**

* Make sure that you have API enabled on your [BigQuery API](https://console.cloud.google.com/apis/library/bigquery.googleapis.com) page. If you don’t see **API Enabled**, choose **Enable**.
* On the [Service accounts](https://console.cloud.google.com/iam-admin/serviceaccounts) page, choose your BigQuery project, and then choose **Create service account**.
*   On the **Service account details** page, enter a descriptive value for **Service account name**. Choose **Create and continue**. The **Grant this service account access to the project** page opens.

    <figure><img src="https://2273820434-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrbIhacVcyuUret5XcsVA%2Fuploads%2FrkNmXL9cpW5QBVFJsUr3%2Fimage.png?alt=media&#x26;token=4a0a9aaa-edcd-481f-bd12-f74435551e53" alt=""><figcaption></figcaption></figure>
* Choose **Continue**, and then choose **Done**.
* On the [Service accounts](https://console.cloud.google.com/iam-admin/serviceaccounts) page, choose the service account that you created.
*   On the Service Accounts page, click on the three dots next to the service account you just created and select "Manage Keys".

    <figure><img src="https://2273820434-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrbIhacVcyuUret5XcsVA%2Fuploads%2FUP0hN8Nb1UsPx4ynAt9X%2Fimage.png?alt=media&#x26;token=7caab3d2-8e1d-4982-aede-d5e000233c7c" alt=""><figcaption></figcaption></figure>
*   Click "Add Key" > "Create New Key".

    <figure><img src="https://2273820434-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrbIhacVcyuUret5XcsVA%2Fuploads%2FZKvqcCFfkQH92VUytU3h%2Fimage.png?alt=media&#x26;token=17fa4cde-6bf6-439e-978c-baec9ab6c2e6" alt=""><figcaption></figcaption></figure>
*   Select "JSON" as the key type and click "Create". The JSON key file will be downloaded to your machine.

    <figure><img src="https://2273820434-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FrbIhacVcyuUret5XcsVA%2Fuploads%2FzC6EAFzwKXcqKcveGlr6%2Fimage.png?alt=media&#x26;token=8a045fd4-0fd7-4022-aae0-7e2412266429" alt=""><figcaption></figcaption></figure>

