Re: Not Able to Get Code to Work for BigQuery using DataFlow

2022-06-14 Thread Sofia’s World
Juan FYI i am using this, hth cutoff_date_str = (date.today() - BDay(60)).date().strftime('%Y-%m-%d') logging.info('Cutoff is:{}'.format(cutoff_date_str)) bq_sql = """SELECT TICKER, LABEL, COUNT(*) as COUNTER FROM `datascience-projects.gcp_shareloader.stock_selection` WHERE AS_OF_DATE

Not Able to Get Code to Work for BigQuery using DataFlow

2022-06-12 Thread Vega, Juan
I'm trying to read data from a simple query in BigQuery and cannot get it to work. I'm following the steps from this URL: https://beam.apache.org/documentation/io/built-in/google-bigquery/ The process is trying to query a very small table with one column and five records. I have this code from