Snowflake allows calling of some specialized stored procedures to turn on and off certain features. These procedures have specialized naming conventions which separate the specific method from the grouped set, or refer to a named object such as a defined budget. The grammar does not currently support this, and in fact the CALL, while parsed, is not converted into IR.
Proposed Solution
It seems unlikely that Databricks SQL will have equivalents for most - if any - of these system specific calls, but we should support the syntax and be able to report that it is unsupported.
Is there an existing issue for this?
Category of feature request
Transpile
Problem statement
Snowflake allows calling of some specialized stored procedures to turn on and off certain features. These procedures have specialized naming conventions which separate the specific method from the grouped set, or refer to a named object such as a defined budget. The grammar does not currently support this, and in fact the
CALL
, while parsed, is not converted into IR.Proposed Solution
It seems unlikely that Databricks SQL will have equivalents for most - if any - of these system specific calls, but we should support the syntax and be able to report that it is unsupported.
Additional Context
Example:
https://docs.snowflake.com/en/sql-reference/classes/budget/methods/activate