SQLake UI tour
This section helps you to understand and navigate around the SQLake UI.
Main page
1. Worksheets
Workseets provides a powerful and versatile interface for creating and submitting SQL queries, as well as performing most other DML and all DDL operations, and viewing the results as your statements complete.
2. Jobs
Job monitoring UI that provides insights into each job and its progress. This page is helpful in monitoring and troubleshooting existing jobs.
3. Clusters
The clusters UI provides a list of clusters in your SQLake environment
4. All Worksheets
This section displays all of the worksheets a user has access to.
5. Private Worksheets
This sections displays all worksheets that can only be accessed by the user. They're not visible to others.
6. Public Worksheets
This section displays all worksheets that can be accessed and visible to all users in the organization
7. Explore Templates
Pre-built templates that helps you to jump start your SQLake journey. Use the templates with sample data to start quickly.
8. See All Templates
A pop-up will allow you to discover and search for all templates.
9. New
Create a new worksheet to start building your pipeline.
10. A table that allows you to click into each worksheet.
The table also offers the following information:
Worksheet Name
Creator Status
Last Modified
Created Date
11. Filters
Allows users to filter by:
Worksheet Name
Creator Status
Last Modified
Created Date
12. Help
Documentation to help you with building your pipeline. If documentation doesn't offer enough help, you may contact Upsolver or join the community Slack channel.
Worksheet
1. Worksheet Name
Name of the worksheet. By clicking on the drop down, it allows you to rename, duplicate, download, delete and make the worksheet public or private.
2. Tree Objects
This tree allows you navigate and discover the objects that you've used or created in SQLake such as tables, jobs, topics, buckets, etc.
3. Worksheet SQL Editor
Use the editor to develop and test your code. Hover over the plus button for more options.
4. Preview Job
Helps you to understand the result of your SQL before you run the job. This option only works with the CREATE JOB statements.
5. Run
Click on Run when you're ready to run a SQL statement. The statement executes the query based on where the cursor is located. Optionally, you may use command + enter as a shortcut.
6. SQL Snippet
Sample snippets to help you with your SQL syntax while developing your pipeline.
7. Table in the tree
The tables created will show up here. By clicking on the table, you can see the statistics of your data in the table.
8. Job in the tree
The jobs created that either read from or write to the table. By clicking on the job name, you can see the definition and details about the job.
9. Information
Additional information about the object that you've selected.
10. Help
Documentation to help you with building your pipeline. If the documentation doesn't offer enough help, you may contact Upsolver or join the community Slack channel.
Last updated
