Create and manage data sets

Learn how to uploaded files and manage data sets.

A information set in the context of file upload is a collection of files with the same structure. In one case a file upload data set exists in Information Studio, you can connect to it and create data sources that use that data, just as y'all would with other types of data.

In this article :

  • Create a data fix
  • Edit a data set
  • Add together data to a data fix
  • Delete an upload file
  • Rename a data set
  • Delete a data set
  • Fix upload errors
  • Use an existing data set in a new data source
  • Alter the data fix for an existing data source
  • Admission your information in Google Deject Storage

Create a data prepare

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

  1. Sign in to Data Studio.
  2. In the acme left, click Create so select Information Source.
  3. Choose File Upload in the Connectors panel
  4. Elevate one or more files from your figurer to the upload target, or click UPLOAD FILES and select the files you desire

Your files will be added to the data set.

It may take some time to process your files. During this time, you can still add more information or create new sets.

Edit a data set up

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

Edit the information source connection

  1. Sign in to Data Studio. After signing in, you lot'll see the Domicile folio
  2. Click the Data SOURCES tab
  3. Click a information source that uses the data set you desire to edit
  4. Click EDIT Connection in the upper left

Use the connectors console

  1. Sign in to Data Studio. Subsequently signing in, you lot'll encounter the Dwelling house page.
  2. Click the DATA SOURCES tab.
  3. Click Create new report or data source.
  4. Choose File Upload in the Connectors console
  5. Click the data set you lot want to edit

Add information to a information ready

You lot can add together more than files to a data ready at any time. Edit the information set and click Add FILES. And so, select one or more files to upload. There is no demand to click RECONNECT. Whatever data sources that use the data gear up will automatically be able to admission the new data.

Calculation data to a data set appends information technology to the data set, as opposed to merging information technology. In other words, if you upload duplicate records, both records will appear in your data.

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

Delete an upload file

Deleting an upload file removes its data from the information set. You can't undo this (though you lot can upload the aforementioned file once more, if needed).

  1. Edit the data fix
  2. Mouse over the file y'all want to delete
  3. Click the trash icon appears on the right

Rename a data prepare

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

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

Delete a data set

Deleting a data set permanently removes all the uploaded files.

  1. Edit the data ready you lot desire to delete
  2. Click DELETE Information Prepare at the bottom of the file list

Deleting a data fix cannot be undone.

Set upload errors

If your upload file has errors, Information Studio will display an error in the Status cavalcade of the file list. Click Fault to display the actual problem plant. Virtually all these errors volition exist due to unexpected formatting in the uploaded file.

Learn more about upload file format.

Use an existing information ready in a new information source

Y'all tin can reuse data sets in any number of data sources.

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

Change the data set for an existing information source

You tin can connect an existing data source to a unlike data ready.

  1. Edit the data source connection
  2. Select a new data prepare from the data sets list or create a new data ready
  3. Click RECONNECT

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

Access your information in Google Cloud Storage

All the data you upload via Data Studio is stored in Google Cloud Storage. You can access all your uploaded data there, too as use other cloud services with the data. To admission your data in the deject:

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

Was this helpful?

How tin we improve it?