First run this in snowflake:
(
src variant
)
AS SELECT parse_json(column1) as src
FROM values
('{
"topleveldate" : "2017-04-28",
package routines; | |
import java.math.BigInteger; | |
import java.security.MessageDigest; | |
import java.security.NoSuchAlgorithmException; | |
import sun.misc.BASE64Encoder; | |
public class hashingUtils { |
#!/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 |
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\"." |
?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", |
{"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 |
### 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 } |
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 |
First run this in snowflake:
(
src variant
)
AS SELECT parse_json(column1) as src
FROM values
('{
"topleveldate" : "2017-04-28",