Import-related Procedures

You are looking at an older version of the documentation. The latest version is found here.

SYSADMIN.importView

This procedure imports a view. Import will not fail even if the data source the view is based on is not present.

SQL

SYSADMIN.importView(IN text string)

SQL

CALL importView('CREATE VIEW test_views.v1 AS SELECT 1')

This procedure imports a virtual procedure.

SQL

SYSADMIN.importProcedure(IN text string)

SQL

CALL SYSADMIN.importProcedure('CREATE PROCEDURE test_views.proc1() AS BEGIN SELECT * FROM test_tables.test_a; END')