Create a data source

Learn the basic steps for creating a data source.

Want to create a Google Analytics, Sheets, or BigQuery data source?

Try the data source tutorials for step-b-step instructions.

Creating a data source of any type consists of essentially the same steps:

  1. Sign in to Data Studio.
  2. In the top left, click Create, then select Data Source.
  3. Select the type of connector you want from the list.
  4. The connectors page lists both first-party Google connectors, and third-party connectors built by the Data Studio community. Community connectors may cost money to use. If you have issues using a community connector, please contact that connector's developer directly.
  5. Select the data set. Depending on the type of data you're connecting to, this will involve specifying the exact accounts or files you want to use. See related resources for more information on the different connector types.
  6. Click CONNECT. The data source Fields tab will open.
  7. Use the Fields tab to add metrics, change the field types, change the aggregation type , and rename any fields, as needed.
  8. (Optional) Change the data source credentials. This controls who can see the data provided from this data source
  9. (Optional) Click the default data source name to rename it.
  10. Click Create Report.

Data source options

For help finding these options, see Finding your way around the data source editor.

Data source fields

Data sources let you configure the fields you can use in your reports. That configuration includes the following information:

  • The field's name. You can overwrite this by clicking the current name and typing in another.
  • Whether the field is a dimension or a metric.
  • What type of data that fields contains (also known as its semantic type).
  • How numeric fields are summarized (aggregation).
  • (Optional) A description of that field.

Learn more about data modeling.

Calculated fields

In addition to the fields provided by the connector, you can also create new dimensions and metrics in the data source using calculated fields. Calculated fields let you use functions and conditional logic to manipulate and transform your data.

Field editing in reports

The Field Editing in Reports data source option allows report editors to change field definitions at the chart level.

Learn more about field editing in reports.

Control access to your data

The Data credentials option controls who gets to see the data provided by the data source.

  • Owner's credentials allows you to use your credentials to provide the data to other people, even if they don't have their own access to the underlying data set.
  • Viewer's credentials requires anyone wanting to view the data from your data source to possess their own credentials to the underlying data set. Using viewer's credentials ensures that only authorized viewers can see the data.

Learn more about data source credentials.

Data freshness

Data freshness refers to how up-to-date the data in a report is. Data sources that maintain a live connection to the data use a cache to improve report performance. Some data sources let you adjust how often the cache is updated.

Learn more about data freshness.

Community visualizations access

Community visualizations are charts created by third-party developers that work with your data and can be configured just like Data Studio's default charts. This option allows or prevents this data source to provide data to community visualizations. 

 Learn more about Community visualizations access.

Was this helpful?
How can we improve it?

Need more help?

Sign in for additional support options to quickly solve your issue