Google BigQuery Best Practices  [draft]

Right way to explore tables in BigQuery This LinkedIn Post by Yingjun Wu ( link ) had show cased a ridiculous case of BigQuery pricing model. BigQuery charges based on the amount of data referenced, not by the amount of data processed. This means that even you used a LIMIT keyword to limit the number of rows returned, BigQuery will still charge you the amount of data query referenced. The right way to explore tables in BigQuery is to use TABLESAMPLE clause to sample the data....

March 24, 2025 · 1 min · 115 words · Eric

Strava Authorization Error - Missing activity read_permission

Reference Mark Needham: Fix Strava API issue

October 14, 2023 · 1 min · 7 words · Eric

ChatGPT Tips and Tricks

User Scenario Prompt for Cover Letter Write a conversational cover letter for a job application as a [position] at [company] using my resume below as a reference. Draft a persuasive cover letter in 150 words or less highlighting my qualifications and enthusiasm for the [position] at [company] using my resume achievements below. Create a compelling cover letter that explain why I am the best fit for the [position] at [company]. Write the letter using the StoryBrand Framework....

March 27, 2023 · 1 min · 117 words · Eric

Learn In Public

Reference Learn in Public

December 29, 2022 · 1 min · 4 words · Eric

Convert HEIC Images to JPEG with macOS

The reference post can quickly help you create an Automator workflow to convert HEIC images to JPEG. Reference How to Create a Mac Quick Action to Convert HEIC to JPG

December 21, 2022 · 1 min · 30 words · Eric