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.