Skip to content

Instantly share code, notes, and snippets.

View bilus's full-sized avatar

Marcin Bilski bilus

View GitHub Profile
<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" lang="en" xml:lang="en">
<head>
<!-- 2020-03-10 Tue 19:33 -->
<meta http-equiv="Content-Type" content="text/html;charset=utf-8" />
<meta name="viewport" content="width=device-width, initial-scale=1" />
<title>stitchingdata</title>
<meta name="generator" content="Org mode" />
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.

Create `dbt` service account in GCP

Needs “Bigquery User” and “Bigquery Connection User” roles.

Needs them in both conrad-production-api and conrad-analytics-staging

Install dbt

https://docs.getdbt.com/docs/installation

brew update
brew tap fishtown-analytics/dbt
brew install dbt

DTS Embedded CONRAD Broadcasts API

  1. Initialize environment variables

    export CLOUD_STORAGE_BUCKET="mbilski-badger"
    export DB_PATH="./"
    export CDN_BASE_URL="http://35.244.156.33/badger_gz/"
    export LOGOS_BASE_DIR="./logos"
    
  2. Go to the app’s directory:

Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.

A server that can communicate via slack, email in response to events.

(map! :leader
(:prefix "g"
:desc "gist-region-or-buffer" "c g" #'gist-region-or-buffer))