ernestoongaro

package routines;
import java.math.BigInteger;
import java.security.MessageDigest;
import java.security.NoSuchAlgorithmException;

import sun.misc.BASE64Encoder;


public class hashingUtils {

ernestoongaro

#!/bin/bash

# Copyright (c) 2016. TIBCO Software Inc.
# This file is subject to the license terms contained
# in the license file that is distributed with this file.
# version: 6.3.0-v1.0.4

# This script sets up and runs JasperReports Server on container start.
# Default "run" command, set in Dockerfile, executes run_jasperserver.
# If webapps/jasperserver-pro does not exist, run_jasperserver 

ernestoongaro

ernestoongaro

CLIENT_ID='YOURS'
CLIENT_SECRET='YOURS'
END_POINT=https://YOURS:19999/api/3.0
LOOK_ID=12
which jq

if [ $status -gt 0 ]
  then
    echo "This utility requires the jq command line utility to parse JSON data. Find more information here: https://stedolan.github.io/jq/"
    echo "On a mac with the brew utility installed, you should be able to install jq with the command \"brew install jq\"."

ernestoongaro

?dynamic_fields=[{"table_calculation":"rank","label":"rank","expression":"rank(${order_items.count},${order_items.count})","value_format":null,"value_format_name":null,"_kind_hint":"measure","_type_hint":"number"},{"table_calculation":"rank_this_month","label":"rank (this month)","expression":"pivot_index(${rank},1)","value_format":null,"value_format_name":null,"_kind_hint":"supermeasure","_type_hint":"number"},{"table_calculation":"rank_last_month","label":"rank (last month)","expression":"pivot_index(${rank},2)","value_format":null,"value_format_name":null,"_kind_hint":"supermeasure","_type_hint":"number"},{"table_calculation":"rank_last_year","label":"rank (last year)","expression":"pivot_index(${rank},3)","value_format":null,"value_format_name":null,"_kind_hint":"supermeasure","_type_hint":"number"},{"table_calculation":"month_over_month_change","label":"month over month change","expression":"${rank_last_month} - ${rank_this_month}","value_format":null,"value_format_name":null,"_kind_hint":"supermeasure",

ernestoongaro

{"type":"FeatureCollection","features":[{"type":"Feature","properties":{"class":"806"},"geometry":{"type":"GeometryCollection","geometries":[{"type":"Polygon","coordinates":[[[16.997110422869135,60.79457447678141],[16.998269112081275,60.79482533259329],[17.022340000822286,60.80097737392255],[17.11218656779418,60.71680575854287],[17.117422240810846,60.71201853955253],[17.119853361006875,60.710814488418706],[17.12519879659224,60.709434075001965],[17.13510427084147,60.711267313260045],[17.141790181134926,60.71624563470729],[17.145625323768833,60.721325407062345],[17.148571503633683,60.76180782907883],[17.207895702086944,60.728782289223254],[17.220205780029683,60.72341895481281],[17.209495602097046,60.714274587236865],[17.196989983202982,60.70062471735477],[17.18198035586522,60.69474529410215],[17.167925616049565,60.69427358174364],[17.162271867023115,60.691677535802675],[17.16046752988998,60.69198528555882],[17.14530598514857,60.68689702228293],[17.14304828276375,60.68775393009436],[17.13842381974118,60.68486965

ernestoongaro

### This should only run if the session facts table is empty
view: session_facts_full_load {
  derived_table: {
    sql_trigger_value: select case when count(distinct partition_date) < 1 then "full re-build" else "daily incremental load" end from ${session_facts_pdt.SQL_TABLE_NAME} ;;
    explore_source: ga_sessions {
      column: id {}
      column: partition_raw {}
      column: keyword_count { field: trafficSource.keyword_count }
      column: add_to__cart { field: hits_eventInfo.add_to__cart }

ernestoongaro

ernestoongaro

models:
  - name: dim_customers
    description: Customer dimensions table
    columns:
      - name: customer_key
        description: Primary key on the customers table
        tests:
          - unique
          - not_null
      - name: region

ernestoongaro

First run this in snowflake:

(
 src variant
)
AS SELECT parse_json(column1) as src
FROM values
('{ 
 "topleveldate" : "2017-04-28",