Shiao Shyan Yap

  • @mryap
  • Organising Committee, Dublin Measurecamp
Enjoy work that are at the intersection of digital marketing, web analytics, data science, UX (A/B te...  
Read more

What Shiao Shyan's working on

What Shiao Shyan's working on


Sep 14, 2021
Sep 14, 2021
Data Collection
Setup database
Google BigQuery
+ 1
Generate BigQuery credentials  To let dbt connect to your warehouse, you'll need generate a keyfile. This is like using a database user name and password with most other data warehouses. (but without filling up manually)

  1. Go to the BigQuery credential wizard. Ensure that your new project is selected in the header bar.
  2. Generate credentials with the following options:
    • Which API are you using? BigQuery API
    • What data will you be accessing? Application data (you'll be creating a service account)
    • Are you planning to use this API with App Engine or Compute Engine? No
    • Service account name: dbt-user
    • Role: BigQuery Job User & BigQuery User
    • Key type: JSON
  3. Download the JSON file and save it in an easy-to-remember spot, with a clear filename (e.g. dbt-user-creds.json)

Aug 29, 2021
Aug 29, 2021
Assigning your own labels to a column in SQL 

An example for mysql

mysql> SELECT emp_id,
    ->   'ACTIVE' AS status,
    ->   emp_id * 3.14159 AS empid_x_pi,
    ->   UPPER(lname) AS last_name_upper
    -> FROM employee;
Aug 18, 2021
Aug 18, 2021
You can set the default region and zones that gcloud uses if you are always working within one region/zone and you don't want to append the --zone flag every time. 

To do this, run these commands: 
gcloud config set compute/zone ...

gcloud config set compute/region ...

Aug 18, 2021
Aug 18, 2021
Create a new instance with gcloud
Instead of using the Cloud Console to create a virtual machine instance, you can use the command line tool gcloud, which is pre-installed in Google Cloud Shell. Cloud Shell is a Debian-based virtual machine loaded with all the development tools you'll need (gcloud, git, and others) and offers a persistent 5-GB home directory.

Note: If you want to try this on your own machine, read the gcloud command line tool guide

Aug 18, 2021
Aug 18, 2021
Installed an NGINX web server
 Confirm that NGINX is running

ps auwx | grep nginx

 To see the web page, return to the Cloud Console and click the External IP link in the row for your machine, or add the External IP value to http://EXTERNAL_IP/ in a new browser window or tab. 

Aug 14, 2021
Aug 14, 2021
Edited CSS
Learnt Flask
Cloud computing
+ 1
Changed background colour by editing CSS file, commit and stage changes via Git completely in-browser  thanks to cloud computing. (with nothing to install locally) 
Get your own page like this