Edit a data source

This article explains how to edit and configure data sources you, or someone else, has already created. To learn how to create new data sources, see this article.

In this article:

• How to edit a data source
• Find your way around the data source editor
• Who can edit a data source
• What you can edit

How to edit a data source

To edit an embedded data source, edit the report in which it's embedded.

Edit a data sources from within a report

While you're editing a report, you can see all data sources that are used by that report in Resources menu:

1. Edit your report.
2. In the menus, select Resource > Manage added data sources.
3. Locate the data source in the list,;then, to the right, click Edit .

You can also edit the data source for a specific component by following these steps:

1. Edit your report.
2. Select a component.
3. On the right, in the properties panel, select the SETUP tab.
4. In the Data Source section, edit the data source by clicking .

These methods work for both embedded and reusable data sources.

Edit a data source from the home page

You can find and edit all your reusable data sources in the Data sources list on the home page by following these steps:

1. Sign in to Looker Studio.
2. At the top of the Looker Studio home page, click Data Sources.
3. Browse or search for the data source that you want to edit.
4. Click that data source in the list.

Only reusable data sources appear in this list. To edit an embedded data source, follow the steps shown previously.

Find your way around the data source editor

The Data source editor includes several elements and options:

 

1. Data source name. Click to change the name.
2. Version history. View and restore previous versions of the data source .
   1. Next to version history is Share this data source with other people  .
3. Data source options:
   1. Data credentials. Determines who can view the data that is provided by this data source.
   2. Data freshness. Balances data updates with report performance.
   3. Community visualizations access. Allows this data source to provide data to community visualizations.
   4. Field editing in reports. Lets report editors change field names and aggregations, apply analytical functions, and set field display options without needing to edit the data source.
4. Make a copy of this data source.
5. Create report. Create a new report from this data source.
6. Explore. Create a new exploration from this data source.
7. Add a field. Create a calculated field or add a custom group.
8. Edit connection. The data source owner can reconnect the data source.
   
   Filter by email address. Add row level security to your data.
9. Fields. Dimensions appear in green chips, metrics in blue chips, and parameters in purple chips. Click a field to give it a new name. To perform other field actions, click More .
10. Field type. Determines the kind of data that is contained in the field. Click the drop-down menu to change the type.
    Changing field types can have a big impact on your reports.
11. Aggregation. Determines how the field is summarized. Click the drop-down menu to change the aggregation. Fields with AUTO aggregation can't be changed.
12. Description. Add a description to any field. For Looker and Search Ads 360 connections, the description is automatically populated from the data source.
    
    When the Show field descriptions style option is enabled for table charts, users can view the field description in a tooltip.  Show field descriptions is automatically enabled for charts that are connected to a Looker or Search Ads 360 data source.  
13. Calculated fields and custom groups. Click fx to edit the field formula.
14. Refresh fields. Click to update the data source with any structural changes that were made to the underlying data set.
15. Field count. Displays the number of fields in the data source.

Who can edit a data source

To edit a reusable data source, you must either be the owner of the data source or have Can Edit access permission to the data source.

To edit an embedded data source, you must either be the owner of the report or have Can Edit access permission to the report.

What you can edit

Data source editors can do the following:

• Share the data source
• Rename the data source
• Rename and duplicate fields
• Create calculated fields and custom groups
• Create parameters
• Change field aggregations
• Add field descriptions
• Change field data types
• Refresh data source fields
• Edit the data source connection
• Change the data credentials
• Enable native functions

If you are the owner of the data source, you can also perform the following tasks:

• Remove and restore the data source
• Make someone else the owner of that data source

If you are the owner of the data credentials that are used by the data source, you can also revoke the data credentials.