BYOBI - Data Analytics Toolkit
This article is a Bring Your Own Business Intelligence (BYOBI) Data Analytics toolkit.
Table of Contents
Overview
BYOBI - Data Analytics is the modern replacement for the legacy direct SQL access offering, designed to provide you with more robust data accessibility and advanced reporting capabilities.
Bring Your Own Business Intelligence (BYOBI)
The Bring Your Own Business Intelligence (BYOBI) tool gives your organization read-only access to your Clarity Human Services data. You can query it directly using SQL or Python, or connect the business intelligence (BI) tool of your choice — such as Tableau or Power BI.
Why BYOBI - Data Analytics?
BYOBI - Data Analytics replaces the legacy direct SQL access offering. Previously, connecting external BI tools required a cumbersome workaround: exporting data from Clarity and re-importing it into another data warehouse, or connecting to a separate, replicated database (the Customer SQL Model). The legacy offering only supported Looker.
What's Different?
BYOBI - Data Analytics provides standard database connection options so you can query your Clarity data directly — no complex exports or replicated databases needed. This means you can use your preferred commercial BI tools to analyze your data and get faster, more accurate insights.
This new feature gives customers more control over their data analysis.
- Increased Flexibility: Customers can now use their preferred BI tools like Tableau and Power BI to create custom reports, rather than being limited to Looker.
- Improved Efficiency: The need for complex data exports or managing a separate database is eliminated. This saves time and reduces the risk of errors.
- Better Data Accuracy: Direct access ensures customers are always working with the most current and accurate data.
- Simplified Experience: Customers can easily integrate their data with their BI tools, avoiding technical complexities and manual workarounds.
Release
This feature will initially be available to current Customer SQL model customers. Before release, these customers will be prompted to identify 1 user to be set up as the dedicated System Admin via direct customer communication [the deadline for providing the System Admin contact will be 2 weeks after initial contact].
BYOBI - Data Analytics is scheduled to be released on July 30, 2026, to Current SQL customers, when the Auth0 feature will be available for these instances and necessary for usage.
BYOBI - Data Analytics vs. Legacy Direct SQL Access
| Feature | Legacy Direct SQL | BYOBI - Data Analytics |
|
Read-only raw data access |
Yes |
Yes |
|
VPN required |
Yes |
No |
|
Authentication |
No |
Yes, using Auth0. |
|
Python Support |
No |
Yes |
|
SQL Dialect |
MariaDB SQL |
BYOBI - Data Analytics SQL |
|
Connect BI tools without VPN |
No |
Yes |
|
Self-service user management |
No |
Yes, the identified system admin for BYOBI - Data Analytics will be able to create new users without submitting a support ticket. |
|
Custom roles & access controls |
No |
Yes, the identified system admin can define their own roles directly in BYOBI - Data Analytics. |
|
Custom SQL views on raw tables |
No |
Yes, use custom views in conjunction with roles for more granular access controls. |
|
Query, login and copy usage visibility |
No |
Yes, via a new Looker model for the identified BYOBI - Data Analytics system admin. |
|
Data latency |
Sub-second, as this is a direct replica of the production data. |
< 3 minutes |
|
Need to request certain fields to be added to direct SQL access |
Yes |
No |
|
Historical Data |
No, only shows current data. |
Yes, BYOBI - Data Analytics retains the history of changes of a record from when the instance was set up. When translating the query, the user should filter for the current data. |
Action Items for Switching from Direct SQL to BYOBI - Data Analytics
Before BYOBI - Data Analytics Release
- Provide one system administrator who will administer the BYOBI - Data Analytics account. This person will have access to all data in the instance, so they should also be a system administrator in Clarity Human Services.
- Gather a list of users who have access to direct SQL data models now.
- Inventory any existing queries and processes that are being used in the direct SQL access (using MariaDB SQL), including exports to upload data to a Business Intelligence (BI) tool.
- Research how to translate MariaDB SQL to BYOBI - Data Analytics SQL syntax/dialect and create a validation plan.
During/Shortly After Release
- Confirm that the identified system administrator has access to BYOBI - Data Analytics via Auth0.
- Set up Multi-Factor Authentication (MFA) on mobile or desktop per guidance regarding Auth0.
- Confirm that the BYOBI - Data Analytics environment has your data.
- Create user accounts for all other users who have access to direct SQL data models. See documentation on creating user accounts.
- Translate existing queries from the identified inventory and validate results against MariaDB and BYOBI - Data Analytics.
Post Release
- Connect any business intelligence tools directly. See the Connecting Your BI Tool to Clarity Data article.
- Consider:
- Explore access controls needed across your community and map out whether existing SQL access users still need full access.
- Map out custom roles to specific data sets or columns for the various access needs in your community.
- Create custom views and roles and provision them to users.
- Create a Business Intelligence (BI) tool-specific user account.
- Continually monitor usage using the BYOBI - Data Analytics Usage Model in Data Analysis.
FAQ and other considerations
Is there a difference between how you query data in the legacy direct SQL vs. BYOBI - Data Analytics?
Direct SQL access uses MariaDB SQL, and BYOBI - Data Analytics uses Snowflake SQL dialects. Snowflake SQL is generally more modern/standard. See the above comparison of BYOBI - Data Analytics vs. Legacy Direct SQL.
Does BYOBI - Data Analytics include historical data?
BYOBI- Data Analytics retains historical data (changes to an existing record) from when the instance was set up. Any queries should filter for current data (unless specifically looking for changes over time).
Data Sharing/Security/Access, and having more than one system admin for BYOBI - Data Analytics.
Customers should be advised to consider their existing data sharing, consent, and user access policies when adding new users and custom roles in BYOBI - Data Analytics. As with direct SQL access, the sysadmin of BYOBI - Data Analytics can access all data in a given instance.
A community can identify more than one system admin for BYOBI - Data Analytics. However, we ask that only one initially be identified for the rollout (the identified system admin can create their own users).
How to create custom roles
Create new views; refer to the Customer SQL Data Model article for some important tables in the direct SQL access. Create a custom role with access to those views, and provision that role to the user. This could be done for users who need to access only certain agencies or counties in a given instance, or to restrict certain CREATE or other features to non-system-admin users (e.g., Data Analysts vs. a System Administrator with more access).
Can you use API with BYOBI - Data Analytics?
Yes, please see the following documentation on the API. The BYOBI - Data Analytics account can be used for programmatic access to query their data. Auth0 and Key-Pair authentication are used for APIs.
Why am I being asked to register an MFA device when I log in?
Multi-factor Authentication (MFA) is now required for all users authenticating to Clarity Human Services, BYOBI - Analytics, and approved third-party applications. On first sign-in after migration, users will be prompted to enroll, even if you’ve already set up MFA with a phone number when logging into Clarity Human Services.
Updated: 07/20/2026