Transparent Utah Super User Resource Center

What is a Super User?

A Super User has the ability to access the raw data stored in our database. This allows the Super User to access any data included in the Transparent Utah database. Super Users are expected to have the basic technical skills and expertise to access and analyze this evolving data resource.

Pricing?

The Transparent Utah database is housed in Google's Big Query data warehouse. Super Users, or their organizations, are billed by Google for the queries that they perform in their Google Cloud Project. The Super User is given access through the Google Cloud Platform (see below for details). At the time of writing, Google Cloud platform does offer a "Free Tier"" of services which covers up to 1TB of queries per month. Depending on the size and complexity of the query, this usually covers 10-200 complex queries. However any queries beyond that limit will be charged to the super user directly by Google.

The Office of the State Auditor does not bill Super Users. The Office is not responsible for charges generated by a Super User and rates and service tier information is provided for your convenience only. The data is provided to super users without warranty and for user convenience, although the Office invites comments and suggestions to further improve the Transaparent Utah data.

Tutorial

How to Become a Super User

March 21st 2024

Learn how to become a super user of the Transparent Utah database.

Continue reading
Become a Superuse image
Documentation

What fields are available?

March 22nd, 2024

View the Database Schema and fields available to researchers

Continue reading
Fields Available Image
Tutorial

How to Query the Database using R or Python?

March 22nd, 2024

Learn step by step to run your first queries directly from R or Python with Google Big Query to access Transparent Utah data.

Continue reading
Become a Superuse image
Scripts

Common Research SQL Scripts

March 22nd, 2024

We have compiled helpful SQL scripts for your convenience based on years of supporting researchers. We also include scripts used internally by our team.

Continue reading
Become a Superuse image