Snowflake Procedure Working Session | SQL Procedure

CREATE OR REPLACE PROCEDURE TABLE_COUNT_PROC() RETURNS NUMBER LANGUAGE SQL AS $$ BEGIN SELECT ROW_COUNT FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME ='EMP_T' ; END ; $$;