Meet industry peers, ask questions, collaborate to find answers, and connect with Googlers who are making the products you use every day.<\/p>", "imageupload.max_uploaded_images_per_upload" : 100, "imageupload.max_uploaded_images_per_user" : 10000, "integratedprofile.connect_mode" : "", "tkb.toc_maximum_heading_level" : "2", "tkb.toc_heading_list_style" : "disc", "sharedprofile.show_hovercard_score" : true, "config.search_before_post_scope" : "community", "tkb.toc_heading_indent" : "15", "p13n.cta.recommendations_feed_dismissal_timestamp" : -1, "imageupload.max_file_size" : 10024, "layout.show_batch_checkboxes" : false, "integratedprofile.cta_connect_slim_dismissal_timestamp" : -1 }, "isAnonymous" : true, "policies" : { "image-upload.process-and-remove-exif-metadata" : true }, "registered" : false, "emailRef" : "", "id" : -1, "login" : "Former Community Member" }, "Server" : { "communityPrefix" : "/qsqph94282", "nodeChangeTimeStamp" : 1732566018996, "tapestryPrefix" : "/gc", "deviceMode" : "DESKTOP", "responsiveDeviceMode" : "DESKTOP", "membershipChangeTimeStamp" : "0", "version" : "24.7", "branch" : "24.7-release", "showTextKeys" : false }, "Config" : { "phase" : "prod", "integratedprofile.cta.reprompt.delay" : 30, "profileplus.tracking" : { "profileplus.tracking.enable" : false, "profileplus.tracking.click.enable" : false, "profileplus.tracking.impression.enable" : false }, "app.revision" : "2409051714-s8dac8f1df8-b80", "navigation.manager.community.structure.limit" : "1000" }, "Activity" : { "Results" : [ ] }, "NodeContainer" : { "viewHref" : "https://www.googlecloudcommunity.com/gc/Cloud-Forums/ct-p/cloud-forums", "description" : "Get answers to your questions and share your knowledge about the Google Cloud.", "id" : "cloud-forums", "shortTitle" : "Cloud Forums", "title" : "Cloud Forums", "nodeType" : "category" }, "Page" : { "skins" : [ "googlecloud", "theme_hermes", "responsive_peak" ], "authUrls" : { "loginUrl" : "https://www.googlecloudcommunity.com/gc/user/userloginpage?dest_url=https%3A%2F%2Fwww.googlecloudcommunity.com%2Fgc%2FData-Analytics%2FActive-Logical-Storage%2Fm-p%2F829290", "loginUrlNotRegistered" : "https://www.googlecloudcommunity.com/gc/user/userloginpage?redirectreason=notregistered&dest_url=https%3A%2F%2Fwww.googlecloudcommunity.com%2Fgc%2FData-Analytics%2FActive-Logical-Storage%2Fm-p%2F829290", "loginUrlNotRegisteredDestTpl" : "https://www.googlecloudcommunity.com/gc/user/userloginpage?redirectreason=notregistered&dest_url=%7B%7BdestUrl%7D%7D" }, "name" : "ForumTopicPage", "rtl" : false, "object" : { "viewHref" : "/gc/Data-Analytics/Active-Logical-Storage/td-p/694813", "subject" : "Active Logical Storage", "id" : 694813, "page" : "ForumTopicPage", "type" : "Thread" } }, "WebTracking" : { "Activities" : { }, "path" : "Community:Google Cloud Community/Category:Google Cloud/Category:Cloud Forums/Board:Data Analytics/Message:Re: Active Logical Storage" }, "Feedback" : { "targeted" : { } }, "Seo" : { "markerEscaping" : { "pathElement" : { "prefix" : "@", "match" : "^[0-9][0-9]$" }, "enabled" : false } }, "TopLevelNode" : { "viewHref" : "https://www.googlecloudcommunity.com/gc/Google-Cloud/ct-p/google-cloud", "description" : "Find answers, ask questions, and connect with our community of experts.", "id" : "google-cloud", "shortTitle" : "Google Cloud", "title" : "Google Cloud", "nodeType" : "category" }, "Community" : { "viewHref" : "https://www.googlecloudcommunity.com/", "integratedprofile.lang_code" : "en", "integratedprofile.country_code" : "US", "id" : "qsqph94282", "shortTitle" : "Google Cloud Community", "title" : "Google Cloud Community" }, "CoreNode" : { "conversationStyle" : "forum", "viewHref" : "https://www.googlecloudcommunity.com/gc/Data-Analytics/bd-p/cloud-data-analytics", "settings" : { }, "description" : "Want more from your data? Have questions about products like BigQuery, Dataflow, or Pub/Sub? Join the conversation here.", "id" : "cloud-data-analytics", "shortTitle" : "Data Analytics", "title" : "Data Analytics", "nodeType" : "Board", "ancestors" : [ { "viewHref" : "https://www.googlecloudcommunity.com/gc/Cloud-Forums/ct-p/cloud-forums", "description" : "Get answers to your questions and share your knowledge about the Google Cloud.", "id" : "cloud-forums", "shortTitle" : "Cloud Forums", "title" : "Cloud Forums", "nodeType" : "category" }, { "viewHref" : "https://www.googlecloudcommunity.com/gc/Google-Cloud/ct-p/google-cloud", "description" : "Find answers, ask questions, and connect with our community of experts.", "id" : "google-cloud", "shortTitle" : "Google Cloud", "title" : "Google Cloud", "nodeType" : "category" }, { "viewHref" : "https://www.googlecloudcommunity.com/", "description" : "The official home of Google Cloud and Workspace community forums, learning hub, and community blogs.", "id" : "qsqph94282", "shortTitle" : "Google Cloud Community", "title" : "Google Cloud Community", "nodeType" : "Community" } ] } }; LITHIUM.Components.RENDER_URL = "/gc/util/componentrenderpage/component-id/#{component-id}?render_behavior=raw"; LITHIUM.Components.ORIGINAL_PAGE_NAME = 'forums/v5/ForumTopicPage'; LITHIUM.Components.ORIGINAL_PAGE_ID = 'ForumTopicPage'; LITHIUM.Components.ORIGINAL_PAGE_CONTEXT = 'VWuJ_AMbfJ27Ssj2XX69HDKjrnkv_NuquGtkFa4UvJtquI9zWhT5KU_Rcg0D-h9Oqa6DEMnwDVeQGZrnRkiuuiYViuM3SWs7SnTK6NTtq8BZFrQedQa5B4XdHCGzAQEePfZJpb2RrZdM1IbMfhA8Gp8XuTKfUAhPXBSVAhqxPXQqZ-EyJRFqSlT9ozAGDZHseQGgS5PhFzULozTRJUqCyOAHiuA1bp-C4GrFzlM_JKfpRKIzPuxcAJ-jOycusgfmEm7zN6QxchpwXFyg40nVjmXGdbrgrCbURlPc-6BxsXITUh73Z2ONn-DKOz0MJcsxb3hznesnE-CHxxZdx66HgvaQZx7O7ns8cGRR0UQSB71JG6E00xkqCqIsdXrkTkxV'; LITHIUM.Css = { "BASE_DEFERRED_IMAGE" : "lia-deferred-image", "BASE_BUTTON" : "lia-button", "BASE_SPOILER_CONTAINER" : "lia-spoiler-container", "BASE_TABS_INACTIVE" : "lia-tabs-inactive", "BASE_TABS_ACTIVE" : "lia-tabs-active", "BASE_AJAX_REMOVE_HIGHLIGHT" : "lia-ajax-remove-highlight", "BASE_FEEDBACK_SCROLL_TO" : "lia-feedback-scroll-to", "BASE_FORM_FIELD_VALIDATING" : "lia-form-field-validating", "BASE_FORM_ERROR_TEXT" : "lia-form-error-text", "BASE_FEEDBACK_INLINE_ALERT" : "lia-panel-feedback-inline-alert", "BASE_BUTTON_OVERLAY" : "lia-button-overlay", "BASE_TABS_STANDARD" : "lia-tabs-standard", "BASE_AJAX_INDETERMINATE_LOADER_BAR" : "lia-ajax-indeterminate-loader-bar", "BASE_AJAX_SUCCESS_HIGHLIGHT" : "lia-ajax-success-highlight", "BASE_CONTENT" : "lia-content", "BASE_JS_HIDDEN" : "lia-js-hidden", "BASE_AJAX_LOADER_CONTENT_OVERLAY" : "lia-ajax-loader-content-overlay", "BASE_FORM_FIELD_SUCCESS" : "lia-form-field-success", "BASE_FORM_WARNING_TEXT" : "lia-form-warning-text", "BASE_FORM_FIELDSET_CONTENT_WRAPPER" : "lia-form-fieldset-content-wrapper", "BASE_AJAX_LOADER_OVERLAY_TYPE" : "lia-ajax-overlay-loader", "BASE_FORM_FIELD_ERROR" : "lia-form-field-error", "BASE_SPOILER_CONTENT" : "lia-spoiler-content", "BASE_FORM_SUBMITTING" : "lia-form-submitting", "BASE_EFFECT_HIGHLIGHT_START" : "lia-effect-highlight-start", "BASE_FORM_FIELD_ERROR_NO_FOCUS" : "lia-form-field-error-no-focus", "BASE_EFFECT_HIGHLIGHT_END" : "lia-effect-highlight-end", "BASE_SPOILER_LINK" : "lia-spoiler-link", "FACEBOOK_LOGOUT" : "lia-component-users-action-logout", "BASE_DISABLED" : "lia-link-disabled", "FACEBOOK_SWITCH_USER" : "lia-component-admin-action-switch-user", "BASE_FORM_FIELD_WARNING" : "lia-form-field-warning", "BASE_AJAX_LOADER_FEEDBACK" : "lia-ajax-loader-feedback", "BASE_AJAX_LOADER_OVERLAY" : "lia-ajax-loader-overlay", "BASE_LAZY_LOAD" : "lia-lazy-load" }; LITHIUM.noConflict = true; LITHIUM.useCheckOnline = false; LITHIUM.RenderedScripts = [ "prism.js", "KeepSessionAlive.js", "jquery.effects.slide.js", "en.js", "MessageBodyDisplay.js", "en.js", "brightcove_uploader.js", "ReCaptchaV3.js", "PolyfillsAll.js", "plugin.js", "TinyMceEditor.js", "DynamicPager.js", "jquery.delayToggle-1.0.js", "plugin.js", "jquery.ui.widget.js", "jquery.ajax-cache-response-1.0.js", "jquery.clone-position-1.0.js", "jquery.function-utils-1.0.js", "plugin.js", "DataHandler.js", "Components.js", "MessageEditor.js", "SearchForm.js", "ProductsField.js", "jquery.blockui.js", "AjaxFeedback.js", "SearchAutoCompleteToggle.js", "plugin.js", "jquery.ui.draggable.js", "DropDownMenu.js", "LiModernizr.js", "jquery.placeholder-2.0.7.js", "jquery.ui.resizable.js", "plugin.js", "en.js", "jquery.tmpl-1.1.1.js", "InlineMessageReplyContainer.js", "Text.js", "Events.js", "ElementQueries.js", "jquery.css-data-1.0.js", "json2.js", "BlockEvents.js", "jquery.viewport-1.0.js", "NoConflict.js", "en.js", "UserListActual.js", "plugin.js", "en.js", "aws-sdk.js", "FieldSet.js", "Tooltip.js", "MessageViewDisplay.js", "ResizeSensor.js", "plugin.js", "LazyLoadComponent.js", "HelpIcon.js", "jquery.effects.core.js", "plugin.js", "Throttle.js", "jquery.tools.tooltip-1.2.6.js", "plugin.js", "plugin.js", "Cache.js", "plugin.js", "TokenInputAutoComplete.js", "plugin.js", "PartialRenderProxy.js", "jquery.scrollTo.js", "jquery.position-toggle-1.0.js", "plugin.js", "jquery.hoverIntent-r6.js", "jquery.ui.position.js", "jquery.ui.dialog.js", "en.js", "en.js", "jquery.ui.mouse.js", "plugin.js", "en.js", "jquery.iframe-transport.js", "plugin.js", "EarlyEventCapture.js", "jquery.js", "jquery.json-2.6.0.js", "jquery.ui.core.js", "Video.js", "Link.js", "DeferredImages.js", "Lithium.js", "tinymce-patched.js", "AutoComplete.js", "CustomEvent.js", "plugin.js", "InputEditForm.js", "ActiveCast3.js", "plugin.js", "Forms.js", "InformationBox.js", "plugin.js", "jquery.autocomplete.js", "plugin.js", "OoyalaPlayer.js", "ForceLithiumJQuery.js", "en.js", "plugin.js", "jquery.fileupload.js", "Globals.js", "ElementMethods.js", "Namespace.js", "plugin.js", "jquery.appear-1.1.1.js", "theme.js", "plugin.js", "Auth.js", "Placeholder.js", "jquery.lithium-toastmessage.js", "ThreadedDetailMessageList.js", "Sandbox.js", "DropDownMenuVisibilityHandler.js", "jquery.lithium-selector-extensions.js", "api.js", "InlineMessageReplyEditor.js", "jquery.tokeninput-1.6.2.js", "jquery.iframe-shim-1.0.js", "AjaxSupport.js", "InlineMessageEditor.js", "Loader.js", "CookieBannerAlert.js", "en.js", "Dialog.js", "SpoilerToggle.js", "plugin.js" ];(function(){LITHIUM.AngularSupport=function(){function g(a,c){a=a||{};for(var b in c)"[object object]"===Object.prototype.toString.call(c[b])?a[b]=g(a[b],c[b]):a[b]=c[b];return a}var d,f,b={coreModule:"li.community",coreModuleDeps:[],noConflict:!0,bootstrapElementSelector:".lia-page .min-width .lia-content",bootstrapApp:!0,debugEnabled:!1,useCsp:!0,useNg2:!1},k=function(){var a;return function(b){a||(a=document.createElement("a"));a.href=b;return a.href}}();LITHIUM.Angular={};return{preventGlobals:LITHIUM.Globals.preventGlobals, restoreGlobals:LITHIUM.Globals.restoreGlobals,init:function(){var a=[],c=document.querySelector(b.bootstrapElementSelector);a.push(b.coreModule);b.customerModules&&0

This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Get hands-on experience with 20+ free Google Cloud products and $300 in free credit for new customers.
Log in to ask a question

Active Logical Storage

Posted on 01-05-2024 01:46 AM
sharontmathew
Bronze 5
Bronze 5
Reply posted on --/--/---- --:-- AM

I have a gcp account and the active logical storage cost has increased from the last 3 days, even though I don't made much changes from  corresponding to the volume of data.
What is the potential cause for this sudden spike.

Solved Solved
0 2 1,065
Topic Labels
Jump to Solution
0 Likes
1 ACCEPTED SOLUTION

Posted on --/--/---- --:-- AM
kolban
Staff
Reply posted on --/--/---- --:-- AM

Here is a link to an article on BigQuery storage.  If your cost for active logical storage has increased then one must imagine that your utilization of such storage has also increased.  There is a BigQuery table called INFORMATION_SCHEMA.TABLE_STORAGE_USAGE_TIMELINE_BY_ORGANIZATION (ref) that contains data for your historic consumption on a daily basis.  You might want to examine this table and see how your storage has changed day by day. 

View solution in original post

Jump to Solution
2 REPLIES 2

Posted on --/--/---- --:-- AM
kolban
Staff
Reply posted on --/--/---- --:-- AM

Here is a link to an article on BigQuery storage.  If your cost for active logical storage has increased then one must imagine that your utilization of such storage has also increased.  There is a BigQuery table called INFORMATION_SCHEMA.TABLE_STORAGE_USAGE_TIMELINE_BY_ORGANIZATION (ref) that contains data for your historic consumption on a daily basis.  You might want to examine this table and see how your storage has changed day by day. 

Jump to Solution

Posted on --/--/---- --:-- AM
shubham21feb
Bronze 3
Bronze 3
Reply posted on --/--/---- --:-- AM

Hi @kolban ,Thanks for the above answers. It helped a lot in understanding the ways to calculate the storage cost.

I can not get the access on Table_Storage and Table_Storage_usage_Timeline as both of the table are available at region level not available at dataset level. Can you please suggest if there is any other way to get the cost with the help of Information_Schema tables.

Jump to Solution
0 Likes
Top Solution Authors
View all