Pitt-Google Broker
troy

Access Data

  • Data Overview
  • Initial Setup
  • BigQuery Databases
  • Cloud File Storage
  • Pub/Sub Streams

Broker Software

  • Software Overview
  • Broker Instance Keywords
  • Components
  • Run a Broker Instance
  • Primers for Developers

API Reference

  • pgb_utils.bigquery
  • pgb_utils.figures
  • pgb_utils.pubsub
  • pgb_utils.utils

Working Notes

  • Project Notes
  • Troy Raen’s Working Notes
    • billing: pitt-google-broker-billing
    • Streaming Stream Looper
    • HEALPix
    • Read The Docs
    • Rubin DPO
    • BigQuery Links
    • Cloud Run info
    • Admin tasks for GCP projects
    • Metadata Tracking System
    • PyPI setup for pgb-utils
    • Cloud Function to load alerts to BigQuery tables
    • AbrilCVs: CV Catalog from Abril 2020
    • AllWISE: Cross match with the AllWISE catalog in BigQuery public datasets
    • SuperNNova: Implementing SuperNNova Classifier
    • alerts-for-testing: Alerts for Testing Purposes
    • billing: pitt-google-broker-billing
    • performance-figures: test figures.py
    • python_fncs: Useful Python functions
    • Streaming Stream Looper
    • v0.3.0
    • v0.3.1:
    • v0.4.0
    • v0.5.0
    • v0.6.0
    • v0.6.2: Issue #68
    • v0.7.0
    • v0.7.1
    • djp-pep8: Summary
Pitt-Google Broker
  • Docs »
  • Troy Raen’s Working Notes »
  • BigQuery Links
  • Edit on GitHub

BigQuery Links¶

  • Python Client for Google BigQuery

  • https://stackoverflow.com/questions/50885946/python-bigquery-api-get-table-schema/50908479

  • https://cloud.google.com/bigquery/docs/information-schema-tables#columns_view

  • https://googleapis.dev/python/bigquery/latest/usage/queries.html

  • https://cloud.google.com/bigquery/docs/bigquery-storage-python-pandas#download_query_results_using_the_client_library

  • https://beam.apache.org/releases/pydoc/2.28.0/apache_beam.io.gcp.bigquery.html

  • https://beam.apache.org/documentation/io/built-in/google-bigquery/#reading-with-a-query-string

  • https://www.tutorialspoint.com/sql/sql-distinct-keyword.htm

  • https://cloud.google.com/bigquery/docs/reference/standard-sql/aggregate_functions#avg

  • https://cloud.google.com/bigquery/docs/best-practices-performance-input

  • https://cloud.google.com/bigquery/docs/reference/standard-sql/data-types?hl=pl

  • .

  • https://alerce-new-python-client.readthedocs.io/en/main/tutorials/ztf_api.html#query-lightcurve

  • https://noao.gitlab.io/antares/client/tutorial/searching.html

  • .

  • https://learn.astropy.org/rst-tutorials/conesearch.html?highlight=filtertutorials

  • https://docs.astropy.org/en/stable/coordinates/

  • Pipelining Generators.-,Create%20Generators%20in%20Python,it%20becomes%20a%20generator%20function.)

Next Previous

© Copyright 2021, The Pitt-Google Broker Team Revision ea106640.

Built with Sphinx using a theme provided by Read the Docs.