<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom" xmlns:dc="http://purl.org/dc/elements/1.1/">
  <channel>
    <title>DEV Community: Saketh Reddy</title>
    <description>The latest articles on DEV Community by Saketh Reddy (@sakethmittu18).</description>
    <link>https://dev.to/sakethmittu18</link>
    <image>
      <url>https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F4246734%2F73de5d8f-d615-480d-ab1a-e3f20dce92bb.jpg</url>
      <title>DEV Community: Saketh Reddy</title>
      <link>https://dev.to/sakethmittu18</link>
    </image>
    <atom:link rel="self" type="application/rss+xml" href="https://dev.to/feed/sakethmittu18"/>
    <language>en</language>
    <item>
      <title>How Can We Build a Self-Refreshing Dashboard on Google Cloud for ~$1</title>
      <dc:creator>Saketh Reddy</dc:creator>
      <pubDate>Mon, 16 Nov 2026 03:00:18 +0000</pubDate>
      <link>https://dev.to/sakethmittu18/how-can-we-build-a-self-refreshing-dashboard-on-google-cloud-for-1-3eh7</link>
      <guid>https://dev.to/sakethmittu18/how-can-we-build-a-self-refreshing-dashboard-on-google-cloud-for-1-3eh7</guid>
      <description>&lt;p&gt;A dashboard is really two things: a query/logic, and somewhere to put the result. The query is the interesting part. “The somewhere is what you &lt;strong&gt;pay&lt;/strong&gt; for”.&lt;/p&gt;

&lt;p&gt;This is how I built the second part for about a dollar a year – “no server, no BI licence, no build” step. One HTML file in a storage bucket, rebuilt on a schedule, by a Python job in Vertex AI.&lt;/p&gt;

&lt;p&gt;&lt;a href="https://storage.googleapis.com/insightspilot-ai/Article_Insights_AI.html" rel="noopener noreferrer"&gt;See the live dashboard&lt;/a&gt; || &lt;a href="https://github.com/Saketh-Labs/InsightPilot-AI" rel="noopener noreferrer"&gt;Code on GitHub&lt;/a&gt;&lt;/p&gt;

&lt;h2&gt;
  
  
  What it costs
&lt;/h2&gt;

&lt;p&gt;Most teams reach for a BI platform here, and per-seat licences at list price generally land somewhere between &lt;strong&gt;$15&lt;/strong&gt; and &lt;strong&gt;$75&lt;/strong&gt; per user per month. For a team of fifty, that is a &lt;strong&gt;five-figure($XX,XXX) annual bill&lt;/strong&gt; before anyone has written a single query. Enterprise tiers are quoted rather than published, which tells you roughly where they sit.&lt;/p&gt;

&lt;p&gt;Here is the whole bill for &lt;strong&gt;InsightPilot-AI&lt;/strong&gt; approach:&lt;/p&gt;

&lt;div class="table-wrapper-paragraph"&gt;&lt;table&gt;
&lt;thead&gt;
&lt;tr&gt;
&lt;th&gt;Line&lt;/th&gt;
&lt;th&gt;What it actually comes to&lt;/th&gt;
&lt;/tr&gt;
&lt;/thead&gt;
&lt;tbody&gt;
&lt;tr&gt;
&lt;td&gt;BigQuery&lt;/td&gt;
&lt;td&gt;~8 MB scanned a week — under 0.1% of the free monthly terabyte (Depends on size of data)&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;Scheduled compute&lt;/td&gt;
&lt;td&gt;a few minutes a week, under 2¢ a run&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;Storage&lt;/td&gt;
&lt;td&gt;one 200 KB file, $0.000005 a month&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;Total&lt;/td&gt;
&lt;td&gt;roughly $1 a year&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;&lt;/div&gt;

&lt;p&gt;Almost all of that dollar is the compute for the scheduled job. Every view ships the whole 200 KB file, but a hundred thousand views is 20 GB, still inside the free allowance.&lt;/p&gt;

&lt;h2&gt;
  
  
  The Architecture
&lt;/h2&gt;



&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight plaintext"&gt;&lt;code&gt; BigQuery                     Scheduled Python job              Cloud Storage
 your dataset     ──SQL──▶    1. run the query      ──HOST──▶  one .html file
                              2. inject the rows                served directly
                              3. upload the page
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;Three moving parts, and only one of them is code we had to write.&lt;/p&gt;

&lt;h2&gt;
  
  
  Security protocols followed
&lt;/h2&gt;

&lt;p&gt;"A static file in a bucket" sounds like it means "public," and that is the part people get wrong. Access here is controlled by &lt;strong&gt;IAM&lt;/strong&gt;, exactly as it would be on any other Google Cloud resource. The demo above is public because the data is public; nothing about the pattern requires that.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;Private by construction, not by remembering.&lt;/strong&gt; The bucket is created with uniform bucket-level access on and public access prevention &lt;strong&gt;enforced&lt;/strong&gt;. Until you deliberately grant something, nothing is reachable, and with prevention enforced, the server refuses a static public grant rather than quietly allowing it.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;Then grant access to principals, not to the internet.&lt;/strong&gt; Any of these work on the bucket, and they are what makes this viable for company data:&lt;/p&gt;

&lt;div class="table-wrapper-paragraph"&gt;&lt;table&gt;
&lt;thead&gt;
&lt;tr&gt;
&lt;th&gt;Principal&lt;/th&gt;
&lt;th&gt;Who that is&lt;/th&gt;
&lt;/tr&gt;
&lt;/thead&gt;
&lt;tbody&gt;
&lt;tr&gt;
&lt;td&gt;user:&lt;a href="mailto:alex@company.com"&gt;alex@company.com&lt;/a&gt;
&lt;/td&gt;
&lt;td&gt;one named person&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;group:&lt;a href="mailto:analytics-team@company.com"&gt;analytics-team@company.com&lt;/a&gt;
&lt;/td&gt;
&lt;td&gt;a Google Group — membership managed in Workspace, not in GCP&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;domain:company.com&lt;/td&gt;
&lt;td&gt;every account in your Workspace / Cloud Identity domain, and nobody else&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;allUsers&lt;/td&gt;
&lt;td&gt;anyone on the internet — only for genuinely public data&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;&lt;/div&gt;

&lt;p&gt;&lt;code&gt;Domain:&lt;/code&gt; is the one that makes this work internally: everyone with a company account can open the dashboard, and nobody outside it can. A group is better still, because access follows the group membership your identity team already maintains, and revoking someone is removing them from the group.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;One trap worth naming.&lt;/strong&gt; &lt;code&gt;allAuthenticatedUsers&lt;/code&gt; sounds like “signed-in people at my company.” It isn't; it means anyone with any Google account, including personal Gmail. It is effectively public. Use &lt;code&gt;domain&lt;/code&gt; or a group. Google now blocks &lt;code&gt;allUsers&lt;/code&gt; and &lt;code&gt;allAuthenticatedUsers&lt;/code&gt; grants by default in organizations created since May 2024, which tells you how often that one bites.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;Least privilege for the job itself.&lt;/strong&gt; The refresh runs as a service account with exactly two roles - &lt;code&gt;BigQuery Job User&lt;/code&gt; on the project and &lt;code&gt;Storage Object User&lt;/code&gt; on the bucket. It can run queries and write one object. It cannot change IAM, delete the bucket, or touch anything else in the project.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;One real limitation.&lt;/strong&gt; A public grant cannot be narrowed to a single object: IAM conditions are rejected on public resources, and per-object ACLs are disabled by the uniform bucket-level access you want switched on. So, if some objects must stay private while others are world-readable, use two buckets. For the internal case, this never comes up, because nothing is public to begin with.&lt;/p&gt;

&lt;h2&gt;
  
  
  Run it yourself
&lt;/h2&gt;

&lt;p&gt;Everything is on GitHub, set up as a template. You can see the page with generated sample data before touching Google Cloud at all:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight shell"&gt;&lt;code&gt;git clone https://github.com/Saketh-Labs/InsightPilot-AI.git
&lt;span class="nb"&gt;cd&lt;/span&gt; InsightPilot-AI
python refresh_dashboard.py --data dashboard/data.json --no-upload --out page.html
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;&lt;a href="https://github.com/Saketh-Labs/InsightPilot-AI" rel="noopener noreferrer"&gt;github.com/Saketh-Labs/InsightPilot-AI&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;The README covers creating the bucket, and every gotcha above in more detail.&lt;/p&gt;

&lt;h2&gt;
  
  
  References
&lt;/h2&gt;

&lt;ul&gt;
&lt;li&gt;&lt;a href="https://cloud.google.com/bigquery/pricing" rel="noopener noreferrer"&gt;BigQuery on-demand pricing&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://cloud.google.com/storage/docs/uniform-bucket-level-access" rel="noopener noreferrer"&gt;Uniform bucket-level access&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://cloud.google.com/storage/docs/uploading-objects" rel="noopener noreferrer"&gt;Cloud Storage: uploading objects&lt;/a&gt;&lt;/li&gt;
&lt;/ul&gt;

</description>
      <category>googlecloud</category>
      <category>bigquery</category>
      <category>dataengineering</category>
      <category>python</category>
    </item>
  </channel>
</rss>
