Data Storage + Warehousing

Using Google’s Cloud solution BigQuery, we offer an enterprise-level data warehousing solution that can store data from all the tools and platforms used by mission-driven organizations, all in one centralized place.

Spend less time focused on how to store data and more time on using that data to optimize your programs. Space, security, and query performance – we’ll handle that.

Easy-to-Use
Data Platform

We’ve made our platform accessible for low or no-code users. Through PAD UI, our web app for our data warehouse, users can quickly find and engage with their BigQuery projects.

Through PAD UI you can:

  • Access datasets

  • Run matching jobs

  • Create beautiful reports

  • and much more

Enterprise-Level Data Management

Our warehouse — PAD — offers large-scale storage for large amounts of frequently changing data, at very little cost and latency.

Storing and querying data is easier and cheaper than in other data warehouses through the features of BigQuery. Through PAD, our members have access to:

  • Google Cloud

  • Connected Sheets

  • BigQuery

  • Scheduled Queries

  • Cloud Run

  • Google Workflows

  • Matching to Catalist and TargetSmart

Peace-of-Mind
Data Management

Feel confident knowing your data is secure and up-to-date. Stop worry about tool sprawl, data degradation, and needed updates to keep up with the latest security releases.

As a PAD user, we help you free up your time by taking care of:

  • Admin duties

  • User management

  • Security management and updates

  • Ongoing maintenance and updates

  • Billing management and optimization

  • Data Monitoring

  • Templates specified to your needs

Learn More About PAD

  • So, What Exactly is PAD?

    Think of PAD as the jumping-off point for all things data.

    Read More

  • 5 Things You Can Do in PAD

    Functionalities in our data warehouse that extend beyond just writing queries.

    Read More

  • Automating Tasks in PAD

    Is there an easy way to connect and automate common data tasks in PAD?

    Read More

Mack, Data Director, SEIU Healthcare PA

"By managing the setup, daily data transfers, and hosting of our database, CTA made it possible for our union to have a data warehouse and increased our capacity to leverage data to advocate for our union members."

Frequently Asked Questions

  • PAD stands for Progressive Action Database, our data warehouse and integrations platform. We leverage enterprise tools (GCP, Airbyte, dbt) and customize them for the organization’s most important data needs. PAD allows you to store, move, analyze, visualize, share, and report on your data

  • By leveraging Google’s BigQuery engine, we’ve built PAD to be as customizable, scalable, and secure as possible. This allows our partners to fine-tune their data processes to suit their needs specifically without needing piecemeal workarounds.

  • At CTA, we believe we’re only as strong as our least-technical users. We’ve built PAD with all skill sets in mind, and our partners can leverage point-and-click user interfaces to build reports and workflows, or they can build and deploy complex SQL queries or Python code.

  • PAD is designed to provide one-to-one syncs to the most popular platforms and tools. Better yet, PAD can also send data from your warehouse to other external tools you are using. You can read more about our extensive list of integrations here.