bryanmtl

staging:
  before_rails:
    - source: /.cloud66/files/ruby_inline.sh
      destination: /tmp/ruby_inline.sh
      target: rails
      halt_on_error: false
      execute: true
      run_on: all_servers
      apply_during: all
      sudo: true

bryanmtl

staging:
  first_thing:
    - command: apt-get install awscli -y
      target: any
      execute: true
      sudo: true
    - source: /.cloud66/node
      destination: /tmp/install.sh
      target: rails
      execute: true

bryanmtl

These are the Glossier Engineering and Data role definitions for both teams.

Technical	Data	People
Junior Engineer (2)	Junior Data Analyst (2)	Tech Lead (5)
Engineer (3)	Data Analyst (3)	Tech Director (6-7)
Senior Engineer (4)	Data Scientist (3)	Head of Data (7)
Staff Engineer (5)	Senior Data Analyst (4-6)	VP Engineering (8)
Senior Staff Engineer (6-7)	Senior Data Scientist (4-6)	CTO

bryanmtl

#!/bin/bash
# install the plugins and build the static site
gitbook install && gitbook build

# checkout to the gh-pages branch
git checkout gh-pages

# pull the latest updates
git pull origin gh-pages --rebase

bryanmtl

SELECT
	customers.first_name  AS "customers.first_name",
	(COALESCE(CAST( ( SUM(DISTINCT (CAST(FLOOR(COALESCE(customers.total_spent ,0)*(1000000*1.0)) AS DECIMAL(65,0))) + ('x' || MD5(customers.id ::varchar))::bit(64)::bigint::DECIMAL(65,0)  *18446744073709551616 + ('x' || SUBSTR(MD5(customers.id ::varchar),17))::bit(64)::bigint::DECIMAL(65,0) ) - SUM(DISTINCT ('x' || MD5(customers.id ::varchar))::bit(64)::bigint::DECIMAL(65,0)  *18446744073709551616 + ('x' || SUBSTR(MD5(customers.id ::varchar),17))::bit(64)::bigint::DECIMAL(65,0)) )  AS DOUBLE PRECISION) / CAST((1000000*1.0) AS DOUBLE PRECISION), 0) / NULLIF(COUNT(DISTINCT CASE WHEN  customers.total_spent  IS NOT NULL THEN customers.id  ELSE NULL END), 0)) AS "customers.avg_spent"
FROM shopify.orders  AS orders
LEFT JOIN shopify.customers  AS customers ON customers.id = orders.customer__id

GROUP BY 1
ORDER BY 2 DESC
LIMIT 500