Create and manage data sets

Learn how to uploaded files and manage information sets.

A data ready in the context of file upload is a collection of files with the aforementioned construction. Once a file upload data set exists in Data Studio, you lot can connect to it and create data sources that use that data, but as you would with other types of data.

In this article :

  • Create a information ready
  • Edit a information fix
  • Add data to a data ready
  • Delete an upload file
  • Rename a information gear up
  • Delete a data set
  • Fix upload errors
  • Apply an existing data set in a new data source
  • Change the data fix for an existing data source
  • Access your information in Google Cloud Storage

Create a data gear up

To create a information set, create a new File Upload data source and add a file to information technology:

  1. Sign in to Data Studio.
  2. In the elevation left, click Create and then select Data Source.
  3. Choose File Upload in the Connectors console
  4. Drag one or more files from your computer to the upload target, or click UPLOAD FILES and select the files you desire

Your files will be added to the data set.

Information technology may take some fourth dimension to process your files. During this time, you can still add together more data or create new sets.

Edit a data set

There are 2 ways to edit a data set: by editing the connection of a information source based on the data set, or by going through the connectors panel.

Edit the information source connection

  1. Sign in to Information Studio. After signing in, you'll see the Home page
  2. Click the DATA SOURCES tab
  3. Click a data source that uses the data set y'all want to edit
  4. Click EDIT CONNECTION in the upper left

Use the connectors console

  1. Sign in to Information Studio. After signing in, you'll see the Home page.
  2. Click the DATA SOURCES tab.
  3. Click Create new report or data source.
  4. Choose File Upload in the Connectors panel
  5. Click the data set you desire to edit

Add information to a information prepare

You can add more than files to a data gear up at any time. Edit the data gear up and click ADD FILES. Then, select one or more files to upload. There is no need to click RECONNECT. Whatever data sources that use the data set will automatically be able to admission the new data.

Adding information to a information set appends it to the data set, every bit opposed to merging it. In other words, if you upload duplicate records, both records will announced in your data.

Every file you upload to a given data set must have exactly the same construction, with the same fields in the same club.

Delete an upload file

Deleting an upload file removes its information from the data set. Yous can't undo this (though you tin upload the aforementioned file again, if needed).

  1. Edit the information set
  2. Mouse over the file you want to delete
  3. Click the trash icon appears on the right

Rename a data set

When you start create a information set, it gets named using the name of the first file uploaded. To rename a data set:

  1. Edit the data set you lot want to rename
  2. Click the current name in the files panel and enter a new name

Delete a data set

Deleting a data set permanently removes all the uploaded files.

  1. Edit the data set up y'all want to delete
  2. Click DELETE DATA Prepare at the bottom of the file list

Deleting a information set cannot be undone.

Fix upload errors

If your upload file has errors, Data Studio will display an error in the Status column of the file list. Click Mistake to display the actual problem constitute. Almost all these errors volition exist due to unexpected formatting in the uploaded file.

Larn more about upload file format.

Use an existing data fix in a new information source

You can reuse data sets in any number of information sources.

  1. Create a new information source
  2. Select File Upload in the Connectors panel
  3. Select an existing data set
  4. Click CONNECT in the upper right

Change the data prepare for an existing data source

You can connect an existing information source to a different information gear up.

  1. Edit the data source connection
  2. Select a new data set from the data sets listing or create a new data set
  3. Click RECONNECT

The new data gear up must match the structure of the previous data set, or your charts may break.

Access your information in Google Cloud Storage

All the information you upload via Data Studio is stored in Google Cloud Storage. Y'all can access all your uploaded data there, as well as utilise other deject services with the data. To admission your information in the cloud:

  1. Edit a data ready
  2. Click VIEW FILES IN Cloud on the right, above the list of files.

Was this helpful?

How tin can we improve it?