Kamesh Sampath kameshsampath

/developing-with-streamlit-in-snowflake

GOAL

Build a Customer Churn Risk Dashboard as a Streamlit-in-Snowflake (SiS) app that identifies customers with declining quarter-over-quarter purchase frequency from TPC-DS sample data and visualizes churn risk across dimensions.

REQUIREMENTS

Data Source

Snowflake Cortex Search: Type Casting Fix

The Issue

When using Snowflake Cortex Search with numeric ATTRIBUTES and filter comparisons (@gte, @lte, @eq), queries fail unless columns are explicitly cast to their proper types.

❌ Query That Errors

JSON Flip: Complete Command Reference

A comprehensive collection of all commands and patterns from the "JSON Flip" technique for JSON-to-CSV conversion.

Basic JSON-to-CSV Conversion

Standard JSON Flip Pattern

# Basic pattern for converting JSON arrays to CSV
jq -r '(.[0] | keys_unsorted) as $keys |


	-- Step 1
	CREATE OR REPLACE SECRET alerts_and_notification.slack_channel_aln_webhook_secret
	TYPE = generic_string
	-- https://hooks.slack.com/services/YYYYYYYY/XXXXXXX
	-- Your Slack Webhook Token is /YYYYYYYY/XXXXXXX
	SECRET_STRING = 'YOUR_SLACK_WEBHOOK_TOKEN_HERE'
	COMMENT = 'Webhook for alerts-and-notifications slack channel';

	# assumes miniconda is installed on user home
	# direnv can be installed using brew install direnv or other OS specific methods
	use_conda(){
	local conda_setup="$("$HOME/miniconda3/bin/conda" 'shell.zsh' 'hook' 2> /dev/null)"
	eval "$conda_setup"
	conda activate <name of your conda environment to load>
	}
	strict_env
	use conda

	# https://taskfile.dev
	version: "3"

	tasks:
	default:
	desc: The default task that will be run when task is called without explicit task name
	aliases:
	- all
	cmds:
	- task: install_packages

	#syntax=docker/dockerfile:1.3-labs

	FROM --platform=$TARGETPLATFORM rust:1.67-alpine3.17 AS bins

	ARG TARGETPLATFORM

	RUN --mount=type=cache,target=/usr/local/cargo/registry \
	apk add -U --no-cache alpine-sdk gcompat go-task \
	&& cargo install cargo-zigbuild

	admin:
	access_log_path: /tmp/admin_access.log
	address:
	socket_address: { address: 0.0.0.0, port_value: 9901 }

	static_resources:
	listeners:
	- name: listener_0
	address:
	socket_address: { address: 0.0.0.0, port_value: 10000 }

	# Instructions for fresh install

	$ sh <(curl -L https://nixos.org/nix/install) --darwin-use-unencrypted-nix-store-volume --daemon
	# reboot
	$ source /nix/var/nix/profiles/default/etc/profile.d/nix-daemon.sh
	$ echo 'export NIX_PATH=darwin-config=$HOME/.nixpkgs/darwin-configuration.nix:$HOME/.nix-defexpr/channels${NIX_PATH:+:}$NIX_PATH' \| tee -a ~/.zshrc
	$ echo 'source $HOME/.nix-profile/etc/profile.d/hm-session-vars.sh' \| tee -a ~/.zshrc
	$ nix-channel --add https://nixos.org/channels/nixpkgs-unstable
	$ nix-channel --add https://github.com/LnL7/nix-darwin/archive/master.tar.gz darwin
	$ nix-channel --add https://github.com/nix-community/home-manager/archive/master.tar.gz home-manager

	apiVersion: gateway.solo.io/v1
	kind: VirtualService
	metadata:
	name: fruits-api
	namespace: my-gloo
	spec:
	displayName: FruitsAPI
	virtualHost:
	options:
	cors: