Back to all posts

Azure Databricks command

Here are some common commands used in Databricks: %fs : Allows you to interact with the filesystem. For example, %fs ls lists the files in the current dire…

Here are some common commands used in Databricks:

%fs: Allows you to interact with the filesystem. For example, %fs ls lists the files in the current directory.

%python, %scala, %sql: Switches the language of the current cell to Python, Scala, or SQL, respectively.

display(): Displays a DataFrame in a visual format.

dbutils.fs.ls(): Lists files in a directory using the Databricks file system API.

spark.read.format().load(): Reads data from a file into a DataFrame.

spark.sql(): Executes a SQL query.

displayHTML(): Displays HTML content in a cell output.

dbutils.notebook.exit(): Exits the current notebook with a specified result.

    Keep building your data skillset

    Explore more SQL, Python, analytics, and engineering tutorials.