---
title: "Data Source - Rtoaster insight+ with Google Account integration"
slug: "data-source-rtoaster-insight-plus"
updated: 2024-10-07T05:28:01Z
published: 2024-10-07T05:28:01Z
canonical: "documents.trocco.io/data-source-rtoaster-insight-plus"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://documents.trocco.io/llms.txt
> Use this file to discover all available pages before exploring further.

# Data Source - Rtoaster insight+ with Google Account integration

## summary

Help page for ETL Configuration of Data Setting from Rtoaster insight+.

## Prerequisite.

Rtoaster insight+ manages data with Google BigQuery, which is built on the Tokyo region (asia-northeast1) of the Google Cloud Platform (hereinafter referred to as GCP).

BigQuery for Rtoaster insight+ uses only the following GCP projects.

| Project Name | role |
| --- | --- |
| rtoaster-insight | It will be linked when you link your Google account. |
| rtoaster-data | The Rtoaster table on the Rtoaster insight+ screen contains the corresponding data. |
| bp-pica-prd | The user-defined table on the Rtoaster insight+ screen contains the corresponding data. |

## Setting items

### STEP1 Basic settings

| item name | indispensable | default value | Contents |
| --- | --- | --- | --- |
| Rtoaster insight+ Google Account Connection Configuration | Yes |  | Select the previously registered Connection Configuration that has the necessary permissions for this ETL Configuration. [Click here to](/docs/connection-configuration-rtoaster-insight-plus-with-google-account-authentification) learn how to set up Connection Configuration [.](/docs/connection-configuration-rtoaster-insight-plus-with-google-account-authentification) |
| Data export destination Google Cloud Storage URI | Yes |  | Data Source Rtoaster insight+ with Google Account integration requires a temporary export of data to a GCS bucket created on your end. Therefore, please specify the customer's GCS bucket path for the linked Google account. |
| SQL | Yes |  | Legacy SQL is not available. Please check the **GCP project name, dataset name, and table name** below for available tables, etc. |
| Temporary data file format | Yes | CSV | Please specify the file format of the data to be temporarily stored in GCS. |
| Temporary Data Deletion Policy | Yes | Delete | Please specify whether you wish to delete temporary data stored in the GCS. Since temporary data is created with each data transfer, we recommend that you specify **to delete it**. |

## How to check GCP project name, dataset name, and table name

1. Please check the GCP project by transitioning to the BigQuery console [here.](https://console.cloud.google.com/bigquery?project=rtoaster-insight)  

![GCP project selection.png{height=](https://cdn.document360.io/3a3bae1e-f157-487f-8798-01e9d820e760/Images/Documentation/data-source-rtoaster-insight-plus-2024-08-29-1-0-0.png) "" width=""}

![project-select.png{height=](https://cdn.document360.io/3a3bae1e-f157-487f-8798-01e9d820e760/Images/Documentation/data-source-rtoaster-insight-plus-2024-08-29-1-0-1.png) "" width=""}

The GCP project that contains the Rtoaster insight+ data is the `rtoaster-data project` or the `bp-pica-prd project`, so please specify which one.

The permission to execute data in Rtoaster insight+ is granted to `the rtoaster-insight project`, so if you want to execute SQL, please do so with the `rtoaster-insight project` specified.

1. Please check the data set and table names as follows

![How to check datasets and tables.png{height=](https://cdn.document360.io/3a3bae1e-f157-487f-8798-01e9d820e760/Images/Documentation/data-source-rtoaster-insight-plus-2024-08-29-1-0-2.png) "" width=""}

The hierarchy is as follows: **GCP project name** → **dataset name** → **table name**.

## supplement

### precautions

- The cost of the running jobs is included in the cost of Rtoaster insight+.