{"id":8641,"date":"2022-01-05T11:17:29","date_gmt":"2022-01-05T10:17:29","guid":{"rendered":"https:\/\/via-internet.de\/blog\/?p=8641"},"modified":"2022-05-16T16:52:35","modified_gmt":"2022-05-16T14:52:35","slug":"google-cloud-platform-tipps-und-tricks","status":"publish","type":"post","link":"https:\/\/via-internet.de\/blog\/2022\/01\/05\/google-cloud-platform-tipps-und-tricks\/","title":{"rendered":"Google Cloud Platform | Tipps und Tricks"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\" id=\"tipps-und-tricks-im-internet\">Tipps und Tricks im Internet<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><a href=\"https:\/\/cloud.google.com\/sdk\/docs\/cheatsheet\">https:\/\/cloud.google.com\/sdk\/docs\/cheatsheet<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><a href=\"https:\/\/medium.com\/google-cloud\/7-gcloud-tricks-you-probably-didnt-know-7f64a16869e7\">https:\/\/medium.com\/google-cloud\/7-gcloud-tricks-you-probably-didnt-know-7f64a16869e7<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><a href=\"https:\/\/github.com\/dennyzhang\/cheatsheet-gcp-A4\">https:\/\/github.com\/dennyzhang\/cheatsheet-gcp-A4<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><a href=\"https:\/\/gist.github.com\/pydevops\/cffbd3c694d599c6ca18342d3625af97\">https:\/\/gist.github.com\/pydevops\/cffbd3c694d599c6ca18342d3625af97<\/a><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"big-query-sql\">Big Query &#8211; SQL<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"select-exclude-special-fields\">SELECT &#8211; exclude special fields<\/h3>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">select * except(title, comment) from publicdata.samples.wikipedia limit 10<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">You could use <a rel=\"noreferrer noopener\" href=\"https:\/\/cloud.google.com\/bigquery\/docs\/reference\/standard-sql\/query-syntax#select-except\" target=\"_blank\">select-except<\/a> or <a rel=\"noreferrer noopener\" href=\"https:\/\/cloud.google.com\/bigquery\/docs\/reference\/standard-sql\/query-syntax#select-replace\" target=\"_blank\">select-replace<\/a>. Maybe you have to change the <a href=\"https:\/\/cloud.google.com\/bigquery\/docs\/reference\/standard-sql\/enabling-standard-sql\" target=\"_blank\" rel=\"noreferrer noopener\">sql dialect<\/a>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Authentication<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">JWT Token<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Try <a rel=\"noreferrer noopener\" href=\"https:\/\/jwt.io\/\" target=\"_blank\">https:\/\/jwt.io<\/a> to decode\/check the token<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Tipps und Tricks im Internet https:\/\/cloud.google.com\/sdk\/docs\/cheatsheet https:\/\/medium.com\/google-cloud\/7-gcloud-tricks-you-probably-didnt-know-7f64a16869e7 https:\/\/github.com\/dennyzhang\/cheatsheet-gcp-A4 https:\/\/gist.github.com\/pydevops\/cffbd3c694d599c6ca18342d3625af97 Big Query &#8211; SQL SELECT &#8211; exclude special fields You could use select-except or select-replace. Maybe you have to change the sql dialect. Authentication JWT Token Try https:\/\/jwt.io to decode\/check the token<\/p>\n","protected":false},"author":1,"featured_media":8642,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_crdt_document":"","_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[1],"tags":[],"class_list":["post-8641","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-allgemein"],"jetpack_featured_media_url":"https:\/\/via-internet.de\/blog\/wp-content\/uploads\/2022\/01\/cloud_cloud.png","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/via-internet.de\/blog\/wp-json\/wp\/v2\/posts\/8641","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/via-internet.de\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/via-internet.de\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/via-internet.de\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/via-internet.de\/blog\/wp-json\/wp\/v2\/comments?post=8641"}],"version-history":[{"count":4,"href":"https:\/\/via-internet.de\/blog\/wp-json\/wp\/v2\/posts\/8641\/revisions"}],"predecessor-version":[{"id":8867,"href":"https:\/\/via-internet.de\/blog\/wp-json\/wp\/v2\/posts\/8641\/revisions\/8867"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/via-internet.de\/blog\/wp-json\/wp\/v2\/media\/8642"}],"wp:attachment":[{"href":"https:\/\/via-internet.de\/blog\/wp-json\/wp\/v2\/media?parent=8641"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/via-internet.de\/blog\/wp-json\/wp\/v2\/categories?post=8641"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/via-internet.de\/blog\/wp-json\/wp\/v2\/tags?post=8641"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}