jackross

DECLARE @forecast_snapshot_id uniqueidentifier = '54266D12-8B13-4C23-9BDF-A740580ECFB2';

WITH _sources AS
(
  SELECT
     CASE
       WHEN source LIKE 'MB[QL]%'
       THEN LEFT(source, 7)
       ELSE LEFT(source, 9)
     END                               AS label

jackross

USE usga_apps;
GO

TRUNCATE TABLE seer.forecasts;
GO

INSERT INTO seer.forecasts
SELECT *
FROM USGAPROD2.usga_apps.seer.forecasts f
WHERE EXISTS

jackross

sort -uf \
  <(cut -d'|' -f2 growers_20150608.txt) \
  <(cut -d'|' -f3 growers_20150608.txt) \
  >! names.txt

jackross

name: Example Strategy

strategy: base_acre

geography: &geography
  include:
    states:
      AR: all_counties
      LA: all_counties
      MS: all_counties

jackross

WITH _data AS
(
  SELECT
     *
    ,EXTRACT(YEAR FROM invoice_date + INTERVAL '3 MONTHS') AS season
  FROM public.dcp_sales_log
)
,_new AS
(
  SELECT

jackross

--# :down

DROP FUNCTION IF EXISTS jsonb_object_to_property_bag(jsonb, text, text)
;

--#

--# :up

CREATE FUNCTION jsonb_object_to_property_bag(jsonb, text = 'key', text = 'value')