Data connector for Google Cloud Storage
The connector for Google Cloud Storage enables you to directly import a Google Cloud Storage dataset to InfoSum Platform.
Before starting, you will need the following information to hand:
- JSON key
To configure a connection, login to the Platform if you haven't already and either create a dataset or access the Bunker of an existing dataset. Once you're in the Bunker, select Import a dataset or use the Import tab, and locate the Google Cloud Storage connector as shown below.
Click Connect and import the JSON key.
You will then be taken to the Connect stage. When you specify the Bucket, a table will appear on the right-hand side showing the available file names and sizes.
Copy the file name into the Object box and select Download, then Connect.
A subset of the data will then appear as a preview. You can perform some minor manipulations as this point, such as selecting which columns to import, renaming columns and excluding rows.
When you're happy with the preview, accept the settings and select an import configuration, then you'll be taken to the Import Wizard. This will show how our Platform has understood your dataset and mapped columns into our Global Schema.
If this looks correct, accept the Wizard Settings, otherwise untick the boxes so they can be correctly mapped during the later normalisation phase.
Learn how to normalise the dataset into our Global Schema using data mappings and transformations.