update scheduled query about bigrquery HOT 8 OPEN

I assume you also want to be able to create a new scheduled query, not just update an existing?

from bigrquery.

Yes, that would be very helpful. In our process, we often set them up manually in BigQuery and then update them automatically in R/Python scripts thereafter. But, if it were easy to create and update them from bigrquery, this would be much cleaner.

from bigrquery.

Note to self: look at discovery doc wrappers in googlesheets4.

from bigrquery.

Do you have any sense of how you get a data source setup so I could test it myself?

from bigrquery.

@hadley Yes, I think I can help with that...

I'm not sure what detail you need. Happy to chat if you need more info..

• Go to this link and click console to create a project.
• Navigate to BigQuery and click create dataset.
• Once you have a dataset, you can enter this query to load some data into your project from a public dataset:

CREATE OR REPLACE TABLE `your_project_name.your_dataset_name.baby_names` AS 
SELECT * 
FROM `bigquery-public-data.usa_names.usa_1910_2013` 
LIMIT 1000;

This example has the following schema:

fullname type
state STRING
gender STRING
year INTEGER
name STRING
number INTEGER

Here is some info about the dataset itself: https://console.cloud.google.com/marketplace/product/social-security-administration/us-names?project=long-base-314819

Hope this helps! Let me know if you need anything else.

from bigrquery.

How does that connect with a schedule query?

from bigrquery.

I need a bit more help to get this to a place where I can test it, so I'm going to put off until the next release of bigrquery which I'll aim to do early next year.

from bigrquery.

I need a bit more help to get this to a place where I can test it, so I'm going to put off until the next release of bigrquery which I'll aim to do early next year.

Ok! Sorry I missed your previous question. Thanks for the update. I'm happy to help with your testing when you are ready to resume.

from bigrquery.