You are using the Snowflake web interface to execute SQL queries. You want to save a specific query for future use. Which of the following methods allows you to effectively save and organize your…

Question

Options

• ADownload the query as a text file using the 'Download' option from the worksheet menu. Re-
• BUse the 'Create View' command in SQL to save the query's result set as a view.
• CSave the query directly within a Worksheet. Worksheets in Snowflake are designed to store and
• DExport the query as a JSON file using the 'Export' feature. Best to use when needed to store the
• EStore the query as a Stored Procedure. Useful when the query is part of a larger process and

• C
  89% (16)
• D
  6% (1)
• E
  6% (1)

Explanation

Worksheets in Snowflake's web UI (Snowsight) are specifically designed to be persistent editors where you write, save, and organize SQL queries. They persist across sessions and can be named, organized into folders, and shared with teammates-making them the native, purpose-built tool for saving and managing SQL queries within Snowflake. Option A (downloading as a text file) saves the query externally, outside the Snowflake UI, requiring manual re-upload each time. Option B (CREATE VIEW) saves the query's logic as a database object but is intended for reuse in other queries, not for ad-hoc query organization. Option D (export as JSON) is not a standard Snowflake web UI feature for saving queries. Option E (Stored Procedure) is appropriate for executable procedural logic in a workflow, not for simply saving a query for personal reference.

No community discussion yet for this question.