Open navigation

About shared and private connections

In Supermetrics, a connection is a login you use to connect a data source account. Once you've logged in, you can pull data from that platform into your Supermetrics reports.

Connections can be:

  • Shared: All members of your team can use the same data source login
  • Private: Only the person who logged in to the data source can use the connection

This article gives more details on both connection types. Learn how to enable or disable them when you're ready.

A connection's owner is the Supermetrics user who created the connection to the data source.

You can share connections with the other members of your Supermetrics team. Note that to use the shared connection, the team members must be assigned to a license. If you're a single user, you're the only member of your team. Learn how to manage teams and add members to your team.

Shared connections

Shared connections allow you to connect to a data source once and make that connection accessible to anyone on your team who needs access. This means that members of your team won't have to log in using their own credentials. This'll help you improve your team's efficiency and collaboration! 

With a shared connection, your teammates can use that same connection to bring data to any destination. For example, if you have created a query in a Google Sheets report and shared your connection, your teammate can use the same connection for a report in Looker Studio, as the same shared connection is available in all destinations your team has a license for.

Shared connections won't give other team members access to the account anywhere outside Supermetrics — it'll just let them use the account to create and edit queries without logging in.

Shared connection ownership

When you create a query, your data source connection and license are used to fetch data. Whenever anyone else refreshes the query you created, your login credentials will be used to refresh the query. 

If you're a connection owner, you can disconnect the connection or change the connection from shared to private at any time. Learn how to change a connection's sharing settings.

Shared connections in our destinations

All Supermetrics destinations use shared connections to connect to data sources. You can make a connection private in Google Sheets, Looker Studio, and Excel, but connections used in our data warehouse destinations are shared by default.

Learn how to manage shared and private connections in our destinations:

Private connections

A private connection is a data source login that only its owner can use. If anyone else wants to connect data to Supermetrics with this connection, they'll need to log in separately.

Private connections can't be turned to shared by anyone but the connection owner. If a connection is private, a query created using the private connection can't be refreshed by other members of the team.

Making shared connections private

Note that if you have previously shared a connection but make it private later, the queries and data transfers other users have created using that connection will fail. Pay attention to this, especially if you're using our data warehouse destinations  — even though data warehouse connections are shared by default, the connections can be made private in Google Sheets, Excel, and Looker Studio, which will stop the data transfers working in data warehouse destinations as well.

Team roles 

All team members can refresh and disconnect their own connections.

  • Team members with the Owner or Admin role can turn any shared connection back to private, and share their own connection. If they encounter a connection that no longer works and need to replace it, there won't be any interruption in the connection's queries.
  • Team members with the Editor role can share their own connections with the team and make them private.

See the tables for more information.

Manage one's own connections

Team Admin/Owner
Team Editor

View my own connections (private or shared) 


View all shared connections in the team


Share my own connection


Make my own connections private


Reauthenticate my own connections


Replace my own connection


Disconnect my own connection


Restore my own connection


Permanently delete my own connection


Managing team members' connections

Team Admin/Owner
Team Editor

View other team members' shared connections


View other team members' private connections


Share other team members' private connections


Make other team members shared connections private


Reauthenticate other team members' connections


Replace other team members' connections


Disconnect other team members' connections


Restore other team members' connections


Permanently delete other team members' connections


Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.