Google BigQuery scripting

Constructing SQL Queries Using Google BigQuery Scripting

Let’s start with a simple question: for each tool in my product what fraction of daily active users per day visits the tool? Maybe not so simple so let me add some assumptions to simplify the solution. Daily active user is the one who visits at least one tool per day. You have a lot of tools in the product and you add some new tools from time to time....

March 15, 2021 · 8 min · Alex Danilin

Vagrant - a quick how to

I must confess - I’m a Windows user :) Maybe it is not as cool as Linux or other operating systems, but it solves all the tasks I need so who cares. But there are some rare cases when it is easier for me to use Ubuntu. Like when I took an online Docker course and had some issues with setting up Docker on Windows. I didn’t want to use raw VirtualBox or similar virtualization software because it is a good exercise to practice command line skills from time to time....

November 6, 2020 · 2 min · Alex Danilin

How to Grant an Access for R googlesheets4 package Using Google Cloud Platform Service Account

One of my weekly tasks brought me to Google Cloud Platform instance to deploy a tiny R script as a cron job. This script makes some data transformations and writes the results to Google Sheets. I use googlesheets4 package to communicate with Google Sheets and it works frictionless on my local machine. But Ubuntu cloud instance is not a local Windows machine. I do not use interactive mode on instances and browser as well so the common OAuth authorization is not the case here....

January 29, 2020 · 2 min · Alex Danilin