Accessing Databricks: A Comprehensive Guide

Learn how to access Databricks, create queries, and filter by the partition column to achieve the desired results. This guide also covers the use of two-factor authentication for added security.

June 4, 2024 By Andres Alonso

In this guide, we'll learn how to access Databricks and efficiently navigate its features to run queries and analyze data. If you've enabled two-factor authentication, understanding the process of receiving push notifications is crucial for a seamless login experience. Once inside your workspace, creating a query to explore data sets becomes essential. Remember to filter by the partition column for precise results. Running your query will yield the data needed for analysis. Let's get started.

Let's get started.

This is how you access Databricks, using this as an example.

Step #1: Click "Single Sign On" — Click "Single Sign On"

If you have enabled two-factor authentication, you will receive a push notification. After logging in, click on your workspace to create a query. Explore and find the table you need, then add the statement.

Step #8: Click "telemetry_5min_agg_v2" — Click "telemetry_5min_agg_v2"

Please always remember to filter by the partition column, which you can find in the catalog. At the end, run your query to access all the necessary data.

Step #14: Click "( 1000 )" — Click "( 1000 )"

It may take some time, but in the end, you will achieve the results.

Thank you.