Skip to content

Instantly share code, notes, and snippets.

@vvgsrk

vvgsrk/show_snowflake_procedure.sql

Last active June 28, 2020 18:06
Show Gist options
  • Save vvgsrk/8accfbe44030f37fe892490746874fcb to your computer and use it in GitHub Desktop.
Save vvgsrk/8accfbe44030f37fe892490746874fcb to your computer and use it in GitHub Desktop.
Download ZIP
Raw
show_snowflake_procedure.sql
SHOW PROCEDURES LIKE 'fa_unload_sp' IN db_dev.revenue;
DESCRIBE PROCEDURE db_dev.revenue.fa_unload_sp();
SELECT *
FROM information_schema.procedures
WHERE procedure_catalog = 'AYDP_DEV'
AND procedure_schema = 'PUBLIC'
AND procedure_name = 'FA_UNLOAD_SP';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment