Contents x
    Data Source - Rtoaster insight+ with Google Account integration
      • Print
      • PDF
      Contents

      Data Source - Rtoaster insight+ with Google Account integration

        • Print
        • PDF
        Article summary

        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 Namerole
        rtoaster-insightIt will be linked when you link your Google account.
        rtoaster-dataThe Rtoaster table on the Rtoaster insight+ screen contains the corresponding data.
        bp-pica-prdThe user-defined table on the Rtoaster insight+ screen contains the corresponding data.

        Setting items

        STEP1 Basic settings

        item nameindispensabledefault valueContents
        Rtoaster insight+ Google Account Connection ConfigurationYesSelect the previously registered Connection Configuration that has the necessary permissions for this ETL Configuration.
        Click here to learn how to set up Connection Configuration .
        Data export destination Google Cloud Storage URIYesData 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.
        SQLYesLegacy SQL is not available.
        Please check the GCP project name, dataset name, and table name below for available tables, etc.
        Temporary data file formatYesCSVPlease specify the file format of the data to be temporarily stored in GCS.
        Temporary Data Deletion PolicyYesDeletePlease 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.
          GCP project selection.png{height= "" width=""}

        project-select.png{height= "" 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= "" 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+.
        Was this article helpful?
        What's Next