LookML Development Practices

This document outlines the best practices for developing LookML models in the Data Team. #TODO review the practices with team

Naming Conventions

Measures:

• Use number_ prefix for count measures
  • Example: number_of_users, number_of_transactions

• Use total_ prefix for sum measures
  • Example: total_amount, total_revenue

Template Code for Common Links

User ID Link

link: {
  label: "Open in Hydra"
  url: "https://hydra.majority.com/user/{{ value }}"
}

Attempt ID Link

link: {
  label: "Open in Hydra - KYC Attempt"
  url: "https://hydra.majority.com/kyc/{{ view_name.user_id._value | url_encode }}/{{ value | url_encode }}"
}

Entity Token - Documents Tab Link

link: {
  label: "Open in Alloy - Document"
  url: "https://app.alloy.co/entities/{{ value }}/?tab=documents"
}

---

Adding a New Model

When adding a new model to Looker, complete these two configuration steps:

1. Configure Project Connection

1. Go to Develop > Projects
2. You'll see the new project is not configured
3. Click Configure
4. Save the bq_majority connection

2. Update User Roles

1. Go to Admin > Users > Roles
2. Add the new model to the appropriate roles
3. Typically add to majority_user role for standard users
4. Admins automatically have access to all models