dltm-markwan

Setup dbt dev containers in 10 minutes

This gist will contain two options - dbt Core or dbt Cloud CLI The following steps are required by both:


	CREATE OR REPLACE PROCEDURE ANALYTICS.dbt_markwan_sprocs.CalculateMonthlySalesByNation()
	RETURNS VARCHAR
	LANGUAGE SQL
	AS
	$$
	BEGIN
	-- Create the temporary table for months
	CREATE OR REPLACE TEMPORARY TABLE temp_months AS (
	WITH RECURSIVE cte_months AS (

	{{
	config(
	materialized='view'
	)
	}}

	with final as (
	select
	store_id \|\| "-" \|\| cast(id as string) as unique_id,
	pk,