- Create a new blank LookML Project within your Looker instance
- Project Name: sql_explorer
- Download the manifest.lkml file drag it into the new project
- Enter a value for the constant
CONNECTION_NAME - This value should be the name of one of your connections in Admin > Connections.
- Enter a value for the constant
- Download the extension-sql-explorer.model.lkml file and drag it into the project
- Click the Configure Git button
- You can either setup a git repository, or click the link at the bottom to
Set up a bare repository - If you choose bare repository, you can come back later and an external repository
- Go back to the project and validate the LookML, Commit and Deploy
- You can either setup a git repository, or click the link at the bottom to
- Configure the model on the
/projectspage. Navigate there by opening the Looker menu and clicking on Develop > Projects- Search the page for
extension-sql-explorerand click the Configure button - The connection setting should match the value above or use all connections
- Search the page for
- Follow the guidelines for extension permissions
- You will need to give users access to the
extension-sql-explorermodel that is installed when creating the project
- You will need to give users access to the
- Refresh the page and open the Looker sidebar. Navigate to Applications > SQL Explorer 🎉
The manifest.lkml file contains entitlements and a URL that may need to be changed to do an upgrade. This repository has the most up-to-date information. An upgrade will follow these steps
- Turn on development mode and navigate to the project and
manifest.lkmlfile - Open up
manifest.lkmlin the repository - Copy the contents of the file and paste it into your open
manifest.lkmlfile in looker - Commit and deploy the project