Connect to Google Cloud Storage

Google Deject Storage (GCS) offers earth-wide storage and retrieval of any amount of data. GCS combines the performance and scalability of Google's cloud with advanced security and sharing capabilities. The Google Cloud Storage connector lets yous create and share reports and dashboards based on your GCS data.

In this article :

  • How to connect to Google Cloud Storage
  • Configure the data source
  • Control who sees the data
  • Create a new report from the data source
  • Update the information
  • File format
  • Limits of the GCS connector
  • Related resource

How to connect to Google Cloud Storage

A GCS data source can connect to a single text file, in CSV format, or to a folder stored in your Google Deject Storage saucepan. If you lot connect to a folder, Data Studio volition try to connect to all the CSV files information technology finds to populate the data source.

When connecting to a binder, be sure that all the text files in that folder share the same structure (schema). Trying to connect a data source to files with different structures will cause an mistake.

To connect

  1. Sign in to Information Studio.
  2. In the superlative left, click Create and so select Data Source.
  3. Select the Google Cloud Storage connector from the list
  4. If prompted, AUTHORIZE access to your data.
  5. Enter the path to your information:
    1. Include the saucepan proper name and any parent folders
    2. To select a single file, enter the file name
    3. To select multiple files, enter the concluding binder proper name and select Use all files in path choice
  6. In the upper right, click CONNECT.
    1. The data source fields console appears.
    2. The information source is now connected to your information gear up.

Configure the data source

The data source fields console is where you configure the data source by renaming fields and adding descriptions, adding calculated fields, and changing data types and aggregations. Larn more most working with data source fields.

Control who sees the data

At the acme of the fields panel, you can alter the data credentials. Credentials control who tin meet the data provided past this data source.

OWNER'S CREDENTIALS lets other people view or create reports that utilise this data without requiring them to have their own admission to the data prepare.

VIEWER'S CREDENTIALS, on the other hand, requires each user of the information source to provide their own credentials to access the data prepare.

Acquire more nearly information credentials.

Create a new study from the data source

  1. In the upper right, click CREATE Study.
    1. The study editor appears.
  2. Click Add together TO Report.
    1. This adds the information source to report.
    2. You can at present create charts and controls that get their data from this data source.

New to Information Studio?

Have the Create a report tutorial. Or acquire more about the written report editor.

Update the data

If y'all add new data to the files, or add new files to the folder, that information is automatically available in the data source. This ensures that your reports are always up to date, field of study to normal caching rules.

File format

Yous should be certain that the files you connect to are correctly formatted. Otherwise, errors might occur, or your data may non look correct in your reports.

Probably the near mutual crusade of content errors is improper use of separators, quote marks and line break characters in the data. Understanding how Data Studio handles these can save yous problem down the road.

Only tabular information

The GCS connector tin can only handle files of tabular data in CSV format. This means your files must take a regular structure of properly separated rows and columns. Each row must accept the aforementioned number of columns, even if data is missing for a particular cell in the table. Trying to connect to a file with merged cells, or an inconsistent construction will neglect with an error.

Every file you connect to for a given information source must have exactly the same structure, with the aforementioned fields in the aforementioned order.

If yous need to add or delete fields in an existing data source, you must delete all the previously uploaded files before connecting to files with the new structure. (Or create a new data source using the new file construction.)

Separators

All the fields in your data must be separated from each other by commas.

If there are commas inside the actual data in a field, that field must be surrounded by quotes. If your data includes double quotes, you tin can use a single quote character to surroundings the field.

Header row

The first line in your file must be a header row. This row will tell Data Studio how to proper name your fields. Field names must be unique, so you can't take duplicate values in your header row.

Column names must:

  • Incorporate but letters, numbers, or underscores. Other punctuation or special characters are not allowed.
  • Showtime with a letter or underscore
  • Be at most 128 characters long

The header row must also follow the rules for separators mentioned above.

Line breaks

Each line in the file must end with a line break. The GCS connector does not support line breaks in your data even if these are escaped past quotes.

Limits of the GCS connector

The Google Cloud Storage connector is bailiwick to the following limits:

  • 100MB file size limit per information source
  • Data Studio can't connect to Cloud Storage buckets protected past VPC Service Control perimeters.

Google Deject Storage

Nigh data sources

Was this helpful?

How tin can we ameliorate it?