How to query bigQuery view definition?
Is there a way to query/search all of my bigQuery views definition?
Not via API but on the BigQuery query UI?
Thanks
sql google-bigquery
add a comment |
Is there a way to query/search all of my bigQuery views definition?
Not via API but on the BigQuery query UI?
Thanks
sql google-bigquery
2
I don't think so. BigQuery doesn't expose metadata through views, which is how most other databases handle this.
– Gordon Linoff
Nov 11 at 13:04
1
Submit the form linked in issuetracker.google.com/issues/35906063#comment9 to get (alpha) access to INFORMATION_SCHEMA views.
– Elliott Brossard
Nov 11 at 13:59
add a comment |
Is there a way to query/search all of my bigQuery views definition?
Not via API but on the BigQuery query UI?
Thanks
sql google-bigquery
Is there a way to query/search all of my bigQuery views definition?
Not via API but on the BigQuery query UI?
Thanks
sql google-bigquery
sql google-bigquery
edited Nov 11 at 13:03
Gordon Linoff
756k35291399
756k35291399
asked Nov 11 at 12:51
Oded Bet Av
61
61
2
I don't think so. BigQuery doesn't expose metadata through views, which is how most other databases handle this.
– Gordon Linoff
Nov 11 at 13:04
1
Submit the form linked in issuetracker.google.com/issues/35906063#comment9 to get (alpha) access to INFORMATION_SCHEMA views.
– Elliott Brossard
Nov 11 at 13:59
add a comment |
2
I don't think so. BigQuery doesn't expose metadata through views, which is how most other databases handle this.
– Gordon Linoff
Nov 11 at 13:04
1
Submit the form linked in issuetracker.google.com/issues/35906063#comment9 to get (alpha) access to INFORMATION_SCHEMA views.
– Elliott Brossard
Nov 11 at 13:59
2
2
I don't think so. BigQuery doesn't expose metadata through views, which is how most other databases handle this.
– Gordon Linoff
Nov 11 at 13:04
I don't think so. BigQuery doesn't expose metadata through views, which is how most other databases handle this.
– Gordon Linoff
Nov 11 at 13:04
1
1
Submit the form linked in issuetracker.google.com/issues/35906063#comment9 to get (alpha) access to INFORMATION_SCHEMA views.
– Elliott Brossard
Nov 11 at 13:59
Submit the form linked in issuetracker.google.com/issues/35906063#comment9 to get (alpha) access to INFORMATION_SCHEMA views.
– Elliott Brossard
Nov 11 at 13:59
add a comment |
active
oldest
votes
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%2f53248928%2fhow-to-query-bigquery-view-definition%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
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.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- 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%2f53248928%2fhow-to-query-bigquery-view-definition%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
2
I don't think so. BigQuery doesn't expose metadata through views, which is how most other databases handle this.
– Gordon Linoff
Nov 11 at 13:04
1
Submit the form linked in issuetracker.google.com/issues/35906063#comment9 to get (alpha) access to INFORMATION_SCHEMA views.
– Elliott Brossard
Nov 11 at 13:59