![]() ![]() Saved worksheets are not accessible outside of the classic web interface. Opening a worksheet from your library of saved worksheets. Opening multiple, concurrent worksheets, each with its own separate session, allowing you to run queries in different worksheets with different contexts without any degradation in UI performance. Running ad hoc queries and performing other SQL operations. Worksheets are designed to meet all your business and workflow needs, including: Resume/suspend or resize your current warehouse. Trash Bin: Removes the query from the history log.Manage worksheets (search for, open or delete, rename).Ĭhange the current database, schema, or warehouse for the current worksheet without losing your work.New Tab (plus icon): Runs the query in a new tab.Edit (pencil icon): Overwrite text in the editor with a query on the selected table.Of particular note is the Actions column, which enables you to do the following: The Query History tab, as the name implies, shows a history of all previously run queries and conveys basic information, such as success/failure, start time, duration, progress (if still running), and so on. The CTAS button is used to materialize a query to a singular table in order to avoid complex joins or aggregations that can affect performance. In the SQL Lab section, select the Allow CREATE TABLE AS field.In order to use this feature, it must be enabled: The Create Table As (CTAS) feature enables you to create a new table based on a SQL query. If you wish to transfer it back to the chart Explore page, just select Explore as described above. From here, you can further refine or change the SQL code. The underlying SQL code of the chart will now appear in the SQL Editor. ![]() To do this, from the chart's Explore page, select the triple bar icon and, in the sub-menu, select Run in SQL Lab. You may also wish to view the underlying SQL code of a current chart in the SQL Editor. If you wish to overvwrite an existing dataset, then select the Overwrite existing field, select the drop-down to view and select a dataset or enter a name to search. The chart Explore page appears featuring the newly-saved virtual dataset. In the Save as new field, enter a new name for the virtual dataset, if needed, and then select Save & Explore. ![]() The Save or Overwrite Dataset window appears. To use this tool, from the SQL Editor, run a query and view in the Results tab. Alternatively, you can overwrite an existing dataset. The Explore tool enables you to save your query as a virtual dataset and then continue exploring in the chart Explore page. You should define all the parameters referenced in the query in a valid JSON document.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |