Data Source - Google Cloud Spanner
    • PDF

    Data Source - Google Cloud Spanner

    • PDF

    Article summary

    summary

    Help Page for ETL Configuration of Data Settings from Google Cloud Spanner.

    constraints

    • BYTES type is not supported.

    Setting items

    STEP1 Basic settings

    item nameindispensabledefault valueContents
    Google Cloud Spanner Connection ConfigurationYes-Select the previously registered Connection Configuration that has the necessary permissions for this ETL Configuration.
    instance IDYes-Specify the instance ID to be transferred.
    Database IDYes-Specify the name of the database to be transferred.
    queryYes-Enter a query to retrieve transfer data from Snowflake.
    Custom Variables can also be used to dynamically determine the value of a setting during ETL Configuration of TROCCO's data.
    Number of records that the cursor reasoned at a timeYes10000You can specify the number of rows to be retrieved at a time by the cursor.
    Query execution timeoutYes86400Query execution timeout can be specified in seconds.

    Was this article helpful?