jtroxel

An example scheme to map Looker user attributes, defined by Groups, to a Snowflake Role and WH

Lots of assumptions and assertions:

• For Analytics data, we want to map on multiple dimensions
• Map Compute (WH) by user Organization to track spending
• Map Data Access (Grants) by user "Data Role" and Org, so that we can control access to schemas with sensitive or expensive data, or custom views for a particular org.
• E.g.: Only some users should be able to see FLUENTD_EVENTS or AURORA data directly, and we might end up with Schemas like Revenue with custom stuff
• We have looked at OAuth, but at this time it is untenable because it cant be used with PDTs and would make explore caches useless.
• We are using a Service Account for Looker connections to Snowflake
• The Tram "Information Architecture" is garbage, I wish I had never seen it

jtroxel

An example scheme to map Looker user attributes, defined by Groups, to a Snowflake Role and WH

Lots of assumptions and assertions:

• For Analytics data, we want to map on multiple dimensions
• Map Compute (WH) by user's Organization to track spending
• Map Data Access (Grants) by user's "Data Role" and Org, so that we can control access to schemas with sensitive or expensive data, or custom views for a particular org.
• E.g.: Only some users should be able to see FLUENTD_EVENTS or AURORA data directly, and we might end up with Schemas like Revenue with custom stuff
• We have looked at OAuth, but at this time it is untenable because it can't be used with PDTs and would make explore caches useless.
• We are using a Service Account for Looker connections to Snowflake

So in this setup, we are authorizing as LOOKER_USER, but using the user attributes to construct the Role and WH:

jtroxel

<?php
use Flickr\Config\Config;

// Client example 1:  Simple call to Event subclass (if the type is likely to be used more than once).  Preferred way.
new VespaErrorEvent($type);

// Client example 2:  In-line setup of generic AppEvent using a predefined handler.
new AppEvent("vespa.error{$type}", EventHandlers::metricCounter());

// Client example 3:  In-line setup of generic AppEvent using lambda for act.  Not sure this does anybody any good

jtroxel

const request = require('superagent');

const flickr_endpoint = 'https://backstage-ext.flickr.com/services/rest/';
const flickr_method = 'flickr.identity.registerMigrationToken';
const flickr_api_key = '<api_key>';


const cookie_session = "<cookie_session_value>";
const sa_cookie = "<sa_value>";
request

jtroxel

const request = require('superagent');

const flickr_endpoint = 'https://backstage-ext.flickr.com/services/rest/';
const flickr_method = 'flickr.identity.getUserAttributes';
const flickr_api_key = '<get_the_api_key>';

request
    .get(flickr_endpoint)
    .query({
        method: flickr_method,

jtroxel

Vertx::EventBus.register_handler('manage-restaurants') do |message|
  body = message.body
  puts "Got message body #{body.inspect}"
  case body['action']
    when "create"
      rest = Restaurant.new(body.slice('name'))
      rest.save
      message.reply "OK"
    when "update"
      id = body['id']

jtroxel

        bus.send('manage-restaurants', // Event bus
            // Payload
            {
                action: 'create',
                name: name
            },
            // Reply handler
            function (reply) {
                console.log("Reply " + reply);
            }

jtroxel

// Start a server listening to our routes
server.requestHandler(routeMatcher).listen(8080, 'localhost');

jtroxel

// curl --data-urlencode "name=Thai Green and Sushi" -XPOST localhost:8080/restaurant
routeMatcher.post('/restaurant', function (req) {
    console.log("Params: " + req.params());

    req.expectMultiPart(true);
    req.endHandler(function() {
//        The request has been all ready so now we can look at the form attributes

        var formAttributes = req.formAttributes();
        var name = formAttributes.get('name');

jtroxel

<section data-ng-controller="PostsController" data-ng-init="find()">
    <div class="page-header">
        <h1>Posts</h1>
    </div>
    <div class="list-group">
        <a data-ng-repeat="post in posts" data-ng-href="#!/posts/{{post._id}}" class="list-group-item">
			<small class="list-group-item-text">
				Posted on
				<span data-ng-bind="post.created | date:'medium'"></span>
				by