Contents x
    Data Source - Google Drive
      • Print
      • PDF
      Contents

      Data Source - Google Drive

        • Print
        • PDF
        Article summary

        summary

        • Help Page for ETL Configuration of Data Setting from Google Drive.
        • Various files in a folder can be transferred.

        Target file format

        • CSV/TSV
        • JSON Lines
        • JSONPath
        • LTSV
        • Microsoft Excel (xlsx or xls file)

        Setting items

        STEP1 Basic settings

        item nameindispensableCustom Variable UseContents
        Google Drive Connection ConfigurationYesnot allowedSelect your Google Drive Connection Configuration.
        Google Drive Connection Configuration can authenticate using OAuth authentication or a service account (JSON key).
        folder IDYesnot allowedSpecify the ID of the folder. Files directly under the folder specified here will be transferred. Files in subfolders are not transferred.

        How to get the folder ID:.
        If the URL of the Google Drive folder is as follows, 0B68XXXXXXXX is the folder ID.
        https://drive.google.com/drive/u/0/folders/0B68XXXXXX
        filename regular expressionNoavailableFiles to be transferred can be specified by regular expressions.
        Example: The ^report_ (transfers a file whose filename starts with report_ )
        Input file formatYesCSV/TSVSpecify the format of the input file.
        For more information, see About input file format settings.

        Restrictions

        • Files that exist in the top hierarchy (no folders) cannot be transferred. Be sure to place the files you wish to transfer under the folder.
        • Incremental Data Transfer, which transfers files excluding those already transferred, is not supported.
        Was this article helpful?
        What's Next