PROGnostications
Welcome to the CTA Blog, featuring how-to’s, tool insights, partner spotlights, and more (including from PROG, our mascot).
Scroll through our latests posts below or search for a topic here:

Using Partitions and Clusters to Improve Query Performance
How can I improve query performance on large datasets and help reduce usage costs in PAD?

Sharing Datasets Based on User Profiles
Is there an easy way to share datasets with others based on their user profile levels?

Monitoring Compute in BigQuery
Is it possible to access and query historical data in BigQuery?

Accessing and Querying Historical Data in BigQuery
Is it possible to access and query historical data in BigQuery?

How to Load a Large CSV file into BigQuery
BigQuery can handle the process of loading large CSV files as tables

Notes from BenDesk: Checking CTA’s Operational Status
The best way to check on the operational status of CTA services.

Notes From BenDesk: Transferring Ownership in PAD
PAD makes it easy to transfer ownership of either a Scheduled Query or a Connected Sheet.

Notes From BenDesk: Visualizing Geographic Data in PAD
While you can use many great options to visualize geographic data in PAD, we recommend using Looker Studio or BigQuery Geo Viz.

*New* Clarity Campaign Labs - Model Samples
Announcing our new partnership with Clarity Campaign Labs, offering PAD users access to their extensive national model suite.

Notes From BenDesk: Automate and Schedule Queries
Is there a way for me to automate and schedule my queries in PAD?

Notes from BenDesk: Accessing public or CTA-shared datasets
Is there an easy way to securely access public or CTA-shared datasets directly within my PAD project?

Notes from BenDesk: User Permissions
As a PAD admin, is there a simple way for me to review or double-check users and their permissions on a dataset or table?

Notes from BenDesk: Connecting PAD to Python
Is it possible to connect PAD to Python? If so, how do I set this up and authenticate access?

Notes from BenDesk: Incorporating Programming Elements
Is it possible to incorporate programming elements like variable settings, IF statements, or loops into my SQL queries in BigQuery?

Notes from BenDesk: User Acces
Is it possible to give a user access to specific data in PAD without granting them access to everything in my project? If so, how can I do it?

Notes from BenDesk: Granting PAD Access
Can I give access to data from another PAD BigQuery project without allowing users to access the source project itself?

Notes from BenDesk: Finding Metadata
Is there an easy way to find metadata about my projects in PAD?

BenDesk: Automating Tasks in PAD
Is there an easy way to connect and automate common data tasks in PAD?

How to Create Dashboards in Looker Studio
Integrations with Looker Studio can help anyone create dashboards to analyze, understand, and present your data.

Notes from BenDesk: Copying Tables in BigQuery
What happens when I click “Copy” when viewing a table in BigQuery, and why does that button disappear sometimes?