Could we use “Creating a new BigQuery table as an event to trigger running a predefined BigQuery query”?2019 Community Moderator ElectionHow to create temporary table in Google BigQueryBigQuery : Job is done but table not created yetBigquery event streaming and table creationBigQuery Java client - how to query external ( federated ) table?Bigquery create table (native or external) link to Google cloud storageUse bigquery php client library to create an external table link to cloud storageIs there a way to create custom day partition on BigQuery Tables?BigQuery: How to autoreload table with new storage JSON files?Can query tables from different datasets in BigQueryFinding the query that created a table in BigQuery
What is the plural TO / OF something
Does the attack bonus from a Masterwork weapon stack with the attack bonus from Masterwork ammunition?
Bash - pair each line of file
Writing in a Christian voice
What (if any) is the reason to buy in small local stores?
What favor did Moody owe Dumbledore?
In Aliens, how many people were on LV-426 before the Marines arrived?
Generic TVP tradeoffs?
Why is indicated airspeed rather than ground speed used during the takeoff roll?
Probably overheated black color SMD pads
Existence of a celestial body big enough for early civilization to be thought of as a second moon
When to use snap-off blade knife and when to use trapezoid blade knife?
Unfrosted light bulb
Do I need to be arrogant to get ahead?
Wrapping homogeneous Python objects
How to define limit operations in general topological spaces? Are nets able to do this?
PTIJ What is the inyan of the Konami code in Uncle Moishy's song?
Is it insecure to send a password in a `curl` command?
Is a party consisting of only a bard, a cleric, and a warlock functional long-term?
What is the significance behind "40 days" that often appears in the Bible?
How does one measure the Fourier components of a signal?
How can an organ that provides biological immortality be unable to regenerate?
Variable completely messes up echoed string
What exactly term 'companion plants' means?
Could we use “Creating a new BigQuery table as an event to trigger running a predefined BigQuery query”?
2019 Community Moderator ElectionHow to create temporary table in Google BigQueryBigQuery : Job is done but table not created yetBigquery event streaming and table creationBigQuery Java client - how to query external ( federated ) table?Bigquery create table (native or external) link to Google cloud storageUse bigquery php client library to create an external table link to cloud storageIs there a way to create custom day partition on BigQuery Tables?BigQuery: How to autoreload table with new storage JSON files?Can query tables from different datasets in BigQueryFinding the query that created a table in BigQuery
Pub/Sub can use "a new storage file in Google Cloud Storage" as a trigger.
Could we use "Creating a new BigQuery table in a dataset, as an event to trigger running a predefined BigQuery query"?
Thanks!
google-bigquery
asked Mar 6 at 21:38
searainsearain
8841018
add a comment |
Pub/Sub can use "a new storage file in Google Cloud Storage" as a trigger.
Could we use "Creating a new BigQuery table in a dataset, as an event to trigger running a predefined BigQuery query"?
Thanks!
google-bigquery
asked Mar 6 at 21:38
searainsearain
8841018
add a comment |
Pub/Sub can use "a new storage file in Google Cloud Storage" as a trigger.
Could we use "Creating a new BigQuery table in a dataset, as an event to trigger running a predefined BigQuery query"?
Thanks!
google-bigquery
asked Mar 6 at 21:38
searainsearain
8841018
Pub/Sub can use "a new storage file in Google Cloud Storage" as a trigger.
Could we use "Creating a new BigQuery table in a dataset, as an event to trigger running a predefined BigQuery query"?
Thanks!
google-bigquery
google-bigquery
asked Mar 6 at 21:38
searainsearain
8841018
asked Mar 6 at 21:38
searainsearain
8841018
edited Mar 6 at 21:45
searain
asked Mar 6 at 21:38
searainsearain
8841018
asked Mar 6 at 21:38
searainsearain
8841018
asked Mar 6 at 21:38
searainsearain
8841018
8841018
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
BigQuery doesn't have trigger support. But you could implement something using Google Cloud Scheduler + Cloud Function.
answered Mar 7 at 0:00
hkanjihhkanjih
526517
add a comment |
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55032571%2fcould-we-use-creating-a-new-bigquery-table-as-an-event-to-trigger-running-a-pre%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
BigQuery doesn't have trigger support. But you could implement something using Google Cloud Scheduler + Cloud Function.
answered Mar 7 at 0:00
hkanjihhkanjih
526517
add a comment |
BigQuery doesn't have trigger support. But you could implement something using Google Cloud Scheduler + Cloud Function.
answered Mar 7 at 0:00
hkanjihhkanjih
526517
add a comment |
BigQuery doesn't have trigger support. But you could implement something using Google Cloud Scheduler + Cloud Function.
answered Mar 7 at 0:00
hkanjihhkanjih
526517
BigQuery doesn't have trigger support. But you could implement something using Google Cloud Scheduler + Cloud Function.
answered Mar 7 at 0:00
hkanjihhkanjih
526517
answered Mar 7 at 0:00
hkanjihhkanjih
526517
answered Mar 7 at 0:00
hkanjihhkanjih
526517
answered Mar 7 at 0:00
hkanjihhkanjih
526517
526517
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55032571%2fcould-we-use-creating-a-new-bigquery-table-as-an-event-to-trigger-running-a-pre%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
