execute multiple create view statements in snowflake

Is there a way to create multiple views in one query in Snowflake?

I keep getting error when I try this –

create or replace view forecast_view as
select * from forecast
where variable = 'Name'
    
go

create or replace view demand_view as
select * from demand
where variable = 'Name'

​x
 
create or replace view forecast_view asselect * from forecastwhere variable = 'Name'    go​create or replace view demand_view asselect * from demandwhere variable = 'Name'​

Error:

SQL compilation error: syntax error line 5 at position 0 unexpected 'go'.

 
SQL compilation error: syntax error line 5 at position 0 unexpected 'go'.​

I also tried this –

create or replace view forecast_view as
select * from forecast
where variable = 'Name';

create or replace view demand_view as
select * from demand
where variable = 'Name';

 
create or replace view forecast_view asselect * from forecastwhere variable = 'Name';​create or replace view demand_view asselect * from demandwhere variable = 'Name';​

but it only executes the first create view statement.

Answer

There is no “go” command in SnowFlake:

SnowFlake Commands

Executing Multiple SQL Statements in a Stored Procedure

Advertisement

Answer