ePrivacy and GPDR Cookie Consent by Cookie Consent Skip to main content

Connector Google Cloud Storage Service Account

The Google Cloud Storage Connector allows you to connect the Google Cloud Storage bucket with Meiro Integrations so that it can be used as a data source for the data workflow. 

Google Cloud Storage provides unified object storage for live or archived data. 

This component enables to connect through Service Account.

Requirements

To set up the configuration for the Google Cloud Storage Connector, you will need a Google Cloud Storage account. You can create your account here.

If you have not used Google Cloud Storage before, we recommend you to check the official Google Cloud Storage documentation.

Features

Wildcard

Using * (wildcard) at the end of an expression in a key field allows you to search for the necessary files in the bucket. For example use MyFolder/* to connect to all the files in the directory MyFolder.

Data In/Data Out

Data In 

N/A

Data Out

Your results will be saved in the Data Out bucket data/out/files folder. 

Read more: about the folder structure here.

Learn how: to move files from one folder in configuration to another using Command Line Interface Code processor please refer to this article.

 

Parameters

Google-Cloud-Storage-Parameters.png

Bucket  Name (required)

​Provide a Google Cloud Storage bucket name. As all bucket names reside in a single Cloud Storage namespace. To find the bucket name go to your Google Cloud Storage account, go to the Storage section and the Browser. 

Read more: about Google Cloud storage buckets here.

Search Key (required)

​In order to search for the key prefix for the files from the Google Cloud Storage bucket, it is possible to use a *  wildcard at the end. For example, if you would like to connect only the files from the folder myfolder, please insert myfolder/*.

Include Sub-folders (true/false)

By marking that field you will download the data from the bucket with all subfolders. This option is available only with the wildcard *.

New Files Only (true/false)

Checking the New Files option enables you to load the data in incremental loads. 

After the first run of the configuration in the incremental mode, the file state.json of the Data Out bucket is showing properties like:

  • "last_downloaded_file_timestamp" that is the timestamp of the last change in the Google Cloud Storage connector  (seconds since Jan 01 1970 UTC)
  • "files_modified_in_last_downloaded_file_timestamp" that lists names of the processed files in the last Timestamp

Each time you run the configuration, Meiro Integrations is checking the values of these properties and downloads only the unprocessed files to the Data Out bucket.

Limit (required)

The Limit field describes the maximum number of files to download. If the key matches more files than chosen, only the oldest files will be downloaded.

SERVICE_ACCOUNT_KEY_FILE

In Google Cloud Storage Console, you can create a service account with these parameters.

Private keys can be tricky. Private keys have new lines “\n” in them. When you open them, they look like a ” square" of text. The best way to approach this is to take the Private Key with new line that turned into “\n”, and put it directly into the JSON, not the form. This is so that it will not get replaced. 

 

service-account-key-file.png

client-id.png