创建的 Snowflake DDL 是错误的执行立即创建视图'

发布于 2025-01-11 15:51:41 字数 466 浏览 3 评论 0原文

查询：

execute immediate '<--create view query-->';

结果 DDL： 创建或替换视图 view_name( <--专栏--> ) asexecute立即 '<--创建视图查询-->';

示例： 查询：

execute immediate 'create or replace view a as select * from b';

DDL： 创建或替换视图 a(b1,b2,b3) asexecute立即'创建或替换视图 a as select * from b';

原文

Query:

execute immediate '<--create view query-->';

Resultant DDL:
create or replace view view_name(
<--columnlist-->
) asexecute immediate '<--create view query-->';

Example:
Query:

execute immediate 'create or replace view a as select * from b';

DDL:
create or replace view a(b1,b2,b3) asexecute immediate 'create or replace view a as select * from b';

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

万人眼中万个我 2025-01-18 15:51:41

很好发现。要使用 Snowsight 重现此案例：

EXECUTE IMMEDIATE 'create or replace view a as select 1 AS c';
-- View A successfully created.

SELECT * FROM a;
-- C
-- 1

SELECT GET_DDL('VIEW', 'PUBLIC.A');

创建或替换视图 A( C ) asEXECUTE IMMEDIATE '创建或替换视图 a as select 1 AS c';

解决方法。使用匿名块来包装视图定义：

EXECUTE IMMEDIATE $
BEGIN
  create or replace view a as select 1 AS c;
END;
$;
-- null

SELECT * FROM a;
-- C
-- 1

SELECT GET_DDL('VIEW', 'PUBLIC.A');

创建或替换视图 A( C ) 作为选择 1 AS c；

Well spotted. To reproduce this case using Snowsight:

EXECUTE IMMEDIATE 'create or replace view a as select 1 AS c';
-- View A successfully created.

SELECT * FROM a;
-- C
-- 1

SELECT GET_DDL('VIEW', 'PUBLIC.A');

create or replace view A( C ) asEXECUTE IMMEDIATE 'create or replace view a as select 1 AS c';

Workaround. Using anonymous block to wrap view definition:

EXECUTE IMMEDIATE $
BEGIN
  create or replace view a as select 1 AS c;
END;
$;
-- null

SELECT * FROM a;
-- C
-- 1

SELECT GET_DDL('VIEW', 'PUBLIC.A');