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 name | indispensable | Custom Variable Use | Contents |
|---|---|---|---|
| Google Drive Connection Configuration | Yes | not allowed | Select your Google Drive Connection Configuration. Google Drive Connection Configuration can authenticate using OAuth authentication or a service account (JSON key). |
| folder ID | Yes | not allowed | Specify 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 expression | No | available | Files to be transferred can be specified by regular expressions. Example: The ^report_ (transfers a file whose filename starts with report_ ) |
| Input file format | Yes | CSV/TSV | Specify 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.