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:
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.
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?
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?
Notes from BenDesk: Visualizations in PAD
What kind of visualization does PAD offer? What is “Looker Studio” and where did Data Studio go?
Notes from BenDesk: Accessing Stored Data without SQL
Is there an easy way to access stored data for someone who doesn’t know SQL?