Admin settings - Self-service Explores

With the Self-service Exploresfeature, your Looker users can upload CSV, XLS, and XLSX files to Looker and then query and visualize the data in a Looker Explore without needing to configure a LookML model or set up Git version control.

Looker admins can select the Self-service Explores option from the Looker Adminmenu to configure the Self-service Exploresfeature and view data uploads on the instance.

Before you begin

To use self-service Explores, your Looker instance must meet the following requirements:

• Running Looker 25.18 or later.
• Has a connection to a BigQuery database (see the Google BigQuery documentation page for information about setting up a BigQuery connection on your Looker instance), and the connection must be configured in the following ways:
  • The connection must be configured with the All projectsscope. To verify the connection's scope, see the Scopecolumn in the Databasestab of the Connectionspage in the Looker admin menu. The connection's Project Scopevalue cannot be edited once the connection is created.
  • The connection must be enabled for persistent derived tables (PDTs). To verify that PDTs are enabled on the BigQuery connection, open the Looker Connections page, click the Editbutton for the BigQuery connection, click to open the Optional Settingstab, and then verify that the Enable PDTs toggle is turned on.
• For any user who will be creating self-service Explores, their Looker user account must have the upload_data permission, which allows a user to upload CSV files to your instance.

Enabling self-service Explores

• If you disable the Data file uploads toggle, your users will no longer be able to access existing self-service Explores from the Explore menu, and any Looks or dashboards that rely on the data may be affected.
• If you change the BigQuery connection, any existing self-service Explores on your instance can be affected, along with any Looks or dashboards that rely on their data.

Before your users can create self-service Explores, a Looker admin must configure the feature by performing the following steps:

1. From the Generalsection of the Looker Adminmenu, select the Self-service Explores admin page.
2. On the Self-service Explores admin page, enable the Allow data uploadstoggle if it isn't already enabled.
3. From the Default BigQuery connectiondrop-down menu, select the BigQuery connection to use for storing the data for self-service Explores. Looker will save the data to this BigQuery database for the self-service Explores on your instance.
4. Click Save.

Viewing the data uploads on your Looker instance

If self-service Explores are enabled on your instance, a Looker admin can use the Data uploadstable on the Self-service Explores admin page to view the data that your users have uploaded on the instance.

The Data uploadstable shows the following information about the data uploads on your instance:

• The name of the self-service Explore
• The owner of the data upload
• The date that the data was uploaded
• A Deletebutton that allows Looker admins to delete the file upload and its associated self-service Explore

Removing a data upload

The owner of a data upload can remove their upload from the Edit Self-service Explore page . In addition, a Looker admin can remove a data upload from the Self-service Explores admin page by following these steps:

1. From the Generalsection of the Looker Adminmenu, select the Self-service Explores admin page.
2. In the Data uploadstable, click the Deletebutton for the data upload that you want to remove.
3. Click Deletein the confirmation dialog.