Project Management

Question 1

What are the key components of a project

Answer 1

Connections
Model
Explore 
Views
Other Files

Question 2

What are the key components of a connection

Answer 2

• contact details for your database [host name, database or schema name, username, and password]
• secure access to DB [ipwhitelist, SSH tunnel etc.]
• configure looker to work with db dialect
• read_write access and schema for PDTs

Question 3

Who can set up a connection and how do they do that?

Answer 3

Admins, navigate to admin nav, select connections setting

Question 4

What is the default way to manage explores in a project?

How does the BizTech team do it? Why are we doing it differently?

Answer 4

The default organization of files in a project is explores live in the model.lkml file. This is an easy way to ensure that explores are only visible in one section in the explore dropdown in Looker UI

The BizTech team manages separate explore files, to be more specific about how explores work. Because of this in each model you should have one “include:” parameter link for the explore and ensure that other models with different connections do not include this explore unless desired.

Question 5

Can I use multiple connections in an explore?

Answer 5

Currently you can only use one connection per explore.

In practice you can use merge queries to combine data from different databases. These are often slow and a bit cumbersome to update.

you can have the full explore linked to multiple connections by creating a file with that explore and in each model including the explore file. This can be VERY confusing for end users though…