Skip to content

Lesson 1 of 6

Create and navigate your workspace

Create a workspace, explore the sidebar, and locate the SQL editor and compute section.

4 minDatabricks

After this lesson, you will be able to create a Databricks workspace, sign in, and find the main areas you will use in later lessons: the SQL editor and the compute section.

Create a workspace

A Databricks workspace is your private area in the Databricks cloud platform. It holds your notebooks, queries, compute resources, and access controls. You create a workspace from your cloud provider's Databricks service page.

If you do not have a Databricks account, ask your administrator to create one for you. The steps below assume you can sign in to your cloud provider's console, such as AWS, Azure, or Google Cloud.

  • In your cloud provider's console, search for Databricks and open the Databricks service.
  • Choose Create workspace.
  • Enter a name for your workspace, for example my-lakehouse-workspace.
  • Select the region closest to your data. This reduces network delay and cost.
  • Choose the pricing tier. For this course, the standard or premium tier is enough.
  • Accept the defaults for the remaining settings and choose Create.

The workspace takes a few minutes to deploy. When it is ready, you see a link to open it.

Sign in and explore the sidebar

Open the workspace URL from your cloud provider's console. Sign in with your Databricks account email and password.

After you sign in, you see the Databricks home page. On the left is the sidebar, a vertical menu with icons and labels. The sidebar is your main way to move around the workspace.

  • Workspace: a folder area for notebooks, files, and experiments.
  • Recents: items you opened recently.
  • Catalog: data objects registered in Unity Catalog, such as tables and schemas.
  • Workflows: scheduled jobs and pipelines.
  • Compute: clusters and SQL warehouses that run your code.
  • SQL Editor: a place to write and run SQL queries.
  • Data Science & Engineering: tools for notebooks, jobs, and models.
  • Marketplace: ready-to-use datasets and solutions.

The sidebar may look slightly different depending on your workspace settings, but the main items are the same.

Locate the SQL editor

The SQL editor is where you write and run SQL queries against your data. In later lessons, you will use it to create tables and query them.

To open the SQL editor:

  • In the sidebar, click SQL Editor.

The SQL editor opens in a new page. At the top is a query name, such as Untitled Query. Below that is a text area where you type SQL. On the right is a panel for results and query details.

You do not need to write a query now. Just notice where the editor is and how to get back to it.

Locate the compute section

Compute resources run your code. In Databricks, there are two main types:

  • All-purpose clusters: used for interactive work, such as running notebooks and developing code.
  • SQL warehouses: used for SQL queries from the SQL editor or BI tools.

In this course, you will start an all-purpose cluster in the next lesson. For now, find where compute resources are listed.

To open the compute section:

  • In the sidebar, click Compute.

You see a list of clusters and SQL warehouses. If this is a new workspace, the list may be empty. That is fine.

Notice the buttons to create a cluster or a SQL warehouse. In the next lesson, you will create a small all-purpose cluster.

Switch between areas

You can move between the SQL editor and compute section using the sidebar. The sidebar stays visible on the left as you navigate.

Try this:

  • Click SQL Editor in the sidebar.
  • Then click Compute.
  • Then click SQL Editor again.

You return to the same query you had open. Databricks keeps your work in the SQL editor until you close it.

You have now created a workspace and know where the main tools are. In the next lesson, you will start a cluster and learn how it runs your code.

Key takeaways

  • A Databricks workspace is your private area for notebooks, queries, compute, and access control.
  • The sidebar is the main navigation menu, with links to Workspace, Catalog, Compute, SQL Editor, and more.
  • The SQL editor is where you write and run SQL queries.
  • The compute section lists clusters and SQL warehouses that run your code.
  • You can switch between areas using the sidebar without losing your work.

Try it

Create a Databricks workspace if you have not already done so. Sign in and open the SQL editor. Type the query SELECT 1 in the editor, but do not run it because you have no compute resource yet. Open the compute section and confirm you can see the list of compute resources. Return to the SQL editor and check that your query text is still there. A good result is that you can navigate between the SQL editor and compute section using the sidebar, and your unrun query remains in the editor when you return.

Official documentation

Ready to use this in a job?

Rolebound applies to matching roles for you.

Start now

Written with AI and checked automatically. Tools change, so a command may behave differently in the version you install. Spotted a mistake? Tell us.

    Cookies on Rolebound

    We use necessary cookies to sign you in and keep the site working — those cannot be turned off. We would also like to set analytics and advertising cookies so we can see which pages help people get interviews and which adverts brought them here. Nothing optional is set unless you say yes, and you can change your mind at any time from “Cookie settings” in the footer. Read our Privacy Policy.