Contents x
    Data Source - Rtoaster insight+ Google Account Integration
    • 07 Dec 2022
    • Print
    • Dark
      Light
    • PDF
    Contents

    Data Source - Rtoaster insight+ Google Account Integration

    • Updated on 07 Dec 2022
    • Print
    • Dark
      Light
    • PDF
    Article Summary

    Note

    This is a machine-translated version of the original Japanese article.
    Please understand that some of the information contained on this page may be inaccurate.

    summary

    This is a help page for setting up data transfer from Rtoaster insight+.

    Supported Protocols

    • Data Transfer (Embulk)
    • File aggregation

    precondition

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

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

    Project NameRole
    rtoaster-insightIt will be linked when linking your Google account.
    rtoaster-dataContains the corresponding data in the Rtoaster table on the Rtoaster insight+ screen.
    bp-pica-prdContains data corresponding to a user-defined table on the Rtoaster insight+ screen.

    Setting items

    STEP1 Basic settings

    Itemnamerequireddefault
    		valuecontent
    Rtoaster insight+ Google Account Connection InformationYes
    		From the connection information registered in advance, select the one that has the necessary permissions for this transfer setting.
    Please refer to here for how to set the connection information.
    Data export destination Google Cloud Storage URIYes
    		Source Rtoaster insight+ Google account integration requires you to temporarily export data to the GCS bucket you created.
    Therefore, please specify the GCS bucket path for customers with linked Google accounts.
    .SQLYes
    		Legacy SQL is not available.
    For tables that can be used, please check the GCP project name, dataset name, and table name below.
    File format for temporary dataYes.CSVPlease specify the file format of the data to be temporarily stored in GCS.
    Temporary data deletion policyYesdeleteSpecify whether you want to delete temporary data stored in GCS.
    Temporary data is created each time you transfer data, so we recommend that you specify that you delete it.

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

    1. Check the GCP project by moving to the BigQuery console from here.
      GCPプロジェクトの選択.png

    プロジェクト選択.png

    Please specify either GCP projectrtoaster-dataプロジェクト orbp-pica-prdプロジェクト that contains Rtoaster insight+ data.

    * Since the permission to execute data in Rtoaster insight+ isrtoaster-insightプロジェクト granted to , if you want tortoaster-insightプロジェクト execute SQL, please execute it with the specified state.

    1. Check the dataset name and table name as follows.

    データセットとテーブルの確認方法.png

    GCP project name → dataset name → It is hierarchical like table name.

    supplement

    Precautions

    • The cost of the execution job is included in the cost of Rtoaster insight+.
    Was this article helpful?
    What's Next