rtempleton

create or replace procedure stage_storage_crawler()
returns string
language javascript
EXECUTE AS CALLER
as     
$$

//create a temp table to hold the results
snowflake.execute( {sqlText:`
    create or replace temp table stage_storage_crawler_results(

rtempleton

#!/usr/bin/env python

# Get all the database objects and permissions.
# Can be used after running snowflake_roles.py to create the required roles
# 2018-10-23  jfrink    added ddl for roles, modified connection parameters
# 2019-01-15  jfrink    added Roles and permissions report by object.
# 2019-03-07  jfrink    added extract script to create a dump of all the tables to a stage
#                       and also the corresponding script to load all the data.
#                       Converted show tables over to using information schema for cases greater then 10k rows.
#                       Converted show views over to using information schema for cases greater then 10k rows.

rtempleton

use role sysadmin;

-- set up dev environment
create database if not exists my_test_db;
create schema if not exists fuzzy_match;
create warehouse if not exists dev_wh warehouse_size = 'small' auto_suspend = 300 initially_suspended=true;
use schema my_test_db.fuzzy_match;
use warehouse dev_wh;

rtempleton

--create a table to hold the metrics you wish to monitor and their threshold values
CREATE TABLE "MY_TEST_DB"."PUBLIC"."THRESHOLDS" ("SERVICE_TYPE" STRING NOT NULL, "CREDITS_BILLED" DOUBLE NOT NULL) COMMENT = 'Used for the Nifi alerting demo';

--insert some sample records into the thresholds table
insert into "MY_TEST_DB"."PUBLIC"."THRESHOLDS" values ('AUTO_CLUSTERING', 10),('PIPE', 10),('MATERIALIZED_VIEW', 10),('WAREHOUSE_METERING', 10);

--query to compare current metrics to threshold values
--This is used for the HOURLY report
select a.*, iff(b.credits_billed is null, 0, b.credits_billed)::string as credits_billed from
"MY_TEST_DB"."PUBLIC"."THRESHOLDS" a left join

rtempleton

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<template encoding-version="1.2">
    <description>Workflow to monitor Snowflake credit consumption and report to Slack. Full article can be found here https://snowflakecomputing.atlassian.net/wiki/spaces/RT/pages/771200336/Creating+a+Snowflake+usage+report+using+Apache+Nifi

Requires existing tables and apps defined in your Snowflake account and your Slack account</description>
    <groupId>be279da7-0167-1000-6a67-4d0cb36decc6</groupId>
    <name>SnowflakeCreditMonitoring</name>
    <snippet>
        <connections>
            <id>1d50d3ac-3446-3e09-0000-000000000000</id>

rtempleton

--set up your environment
create database my_test_db;
create schema my_test_db.witsml;
use schema my_test_db.witsml;

             
--create the staging table where all WITSML files are loaded to by Snowpipe    
create table witsml_temp (col1 variant);

rtempleton

{
  "paragraphs": [
    {
      "text": "%md\n### Run simple queries to check the count of both the iotdata and iotrollup tables.\nClick the play button within each of the paragraphs to rerun/update the content\n",
      "user": "admin",
      "dateUpdated": "2018-10-05T19:03:40-0400",
      "config": {
        "tableHide": false,
        "editorSetting": {
          "language": "markdown",