Google Cloud Storage Integration
In this article, we’ll integrate a Google Cloud Storage data source with Y42.
Google Cloud Storage is Google's cloud storage system. Y42 enables syncing files from your Cloud Storage bucket to your Y42 instance.
OAuth doesn’t share password data but instead uses authorization tokens to prove an identity between you and the service provider. OAuth is an authentication protocol that allows you to approve one application interacting with another on your behalf without giving away your password. For instance, when you tell tell Google that it’s OK for another application or website to access your profile. To sum up, you only need to have an existing Google account, connected to your Google Cloud, to authorize the access.
This integration requires no import settings.
There is no predefined schema for this integration. The integration will dynamically load the tables & columns which are defined within your specific system.
Note: If you are importing a spreadsheet and none of your rows have numeric values, the column names from the spreadsheet will not be imported as heading onto the Google BigQuery. However, if there's a number in any of the columns data, then the import will successfully take the first row as column headers. Therefore, we recommend creating an index column to avoid the issue.
Updating your data
For this source only a full import is possible. You have the option of scheduling updates by the month, weeks, days, and even by the hour.
Google Cloud Storage Setup Guide:
- On Integrate, click on "Add..." to search for Google Cloud Storage and select it.
- Name your integration.
- Authorize access to Google Cloud Storage by following the instructions.
- After authentication, you are good to go and start importing your tables.
- Select the files you need and click import. You can start accessing the tables once the status is “Ready”.