Skip to content
English
Request Article Update Go to Customer portal
  • There are no suggestions because the search field is empty.

Dashboard and Look Usage Policies

This article describes Data Analysis usage policies.

In order to provide an efficient data analysis tool and balance the operational needs of Clarity Communities, Bitfocus implemented Looker standard practices. These policies and procedures went into effect by 8/1/2021. 

  • Looks - Must be used at least once every two years
    • Consequence: Unused Looks will be deleted
  • Custom published Clarity fields - Must be included in Looker content within 30 days of being published to Looker
    • Consequence: Unused fields will be unpublished
  • Legacy Dashboard Content Limit - Must have <= 25 queries/tiles per dashboard
  • Tabbed Dashboard Content Limit - Must have <= 10 tabs and <= 20 queries/tiles per tab 
    • Consequence: Scheduling will be removed
    • Consequence: Auto-refresh will be removed
    • Consequence: In extreme cases where this dashboard is causing degraded Looker performance, we will quarantine the dashboard
    • Alternative: Consider converting a legacy dashboard to a tabbed dashboard or consider creating multiple, linked, dashboards to avoid query limits
  • Dashboard Auto-refresh - Auto-refresh rate must be less than once per hour
    • Consequence: Auto-refresh will be set to once per hour
  • Dashboard Scheduling - Scheduling must be for less than once per hour
    • Consequence: Any dashboards scheduled more than once per hour will be changed to once per hour
    • More frequent scheduling cannot be supported due to Looker caching functionality
  • SFTP Scheduling - Failed SFTP transfers will be retried 3 times
    • Consequence: The recurrence will be ended
    • SFTP addresses must be static to be reliable
      • Dynamic IPs are not supported by Looker 
  • Field Exposure Requests
    • In Looker, exposing HUD-specified fields to all instances at data collection points that do not align with HUD guidance can negatively impact shared resources over time. Our Looker Usage Policies are designed to prioritize HUD-specified and documented collection methods.
  • Merge Queries
    • More than 3 merged queries may result in unexpected results and will not be supported. 
  • Number of Fields in Looks
    • More than 30 fields in a look may result in unexpected results and will not be supported. 
  • Query Performance
    • Query performance is monitored for long-running queries. If queries exceed execution times of 60-90+ minutes, it may have an adverse effect on shared resources, resulting in the cancellation of the query to prevent replica lag and query build-up.

 

Updated: 08/14/2026