Scripting languages support
Brief summary of how the scripting languages are being handled.
The procedure body is treated as an extension of the source file, this is to get information over objects inside it. For example, when the analyzer found occurrences of dependencies inside the body they are registered from the procedure to the object.
Procedure language support:
CREATE OR REPLACE PROCEDURE PROC1()
UPDATE DB.SCH.T1 SET value1 = newValue
The analyzer will not get references from SQL statements created dynamically. Even if the variable is filled in the same code.
create or replace procedure get_row_count(TABLE_NAME VARCHAR)
// Dynamically compose the SQL statement to execute.
var sql_command = "select count(*) from " + TABLE_NAME;
// Run the statement.
var stmt = snowflake.createStatement(
//... more code