- Download a Printable PDF of this Cheat Sheet. This PySpark SQL cheat sheet has included almost all important concepts. In case you are looking to learn PySpark SQL in-depth, you should check out the Spark, Scala, and Python training certification provided by Intellipaat.
- Azure Databricks SQL notebooks supports various types of visualizations using the display function. Visualizations in SQL; Interoperability. This section describes features that support interoperability between SQL and other languages supported in Azure Databricks. Databricks Runtime 7.x and above. User-defined scalar functions (UDFs).
Data munging cheat sheet November 3, 2015. Basic data munging operations: structured data. This page is developing. Python pandas PySpark RDD PySpark DF R dplyr Revo.
-->APPLIES TO: SQL API
The Azure Cosmos DB query cheat sheets help you quickly write queries for your data by displaying common database queries, operations, functions, and operators in easy-to-print PDF reference sheets. The cheat sheets include reference information for the SQL, MongoDB, Table, and Gremlin APIs.
Choose from a letter-sized or A3-sized download.
Letter-sized cheat sheets
Download the Azure Cosmos DB letter-sized query cheat sheets if you're going to print to letter-sized paper (8.5' x 11').
Oversized cheat sheets
Download the Azure Cosmos DB A3-sized query cheat sheets if you're going to print using a plotter or large-scale printer on A3-sized paper (11.7' x 16.5').
Next steps
For more help writing queries, see the following articles:
- For SQL API queries, see Query using the SQL API, SQL queries for Azure Cosmos DB, and SQL syntax reference
- For MongoDB queries, see Query using Azure Cosmos DB's API for MongoDB and Azure Cosmos DB's API for MongoDB feature support and syntax
- For Gremlin API queries, see Query using the Gremlin API and Azure Cosmos DB Gremlin graph support
- For Table API queries, see Query using the Table API
This section provides a guide to developing notebooks in Azure Databricks Workspace using the SQL language.
To learn how to develop SQL queries using Azure Databricks SQL Analytics, see Queries in SQL Analytics and SQL reference for SQL Analytics.
SQL language
This section provides an Azure Databricks SQL reference and information about compatibility with Apache Hive SQL.
Databricks Command Cheat Sheet
Spark SQL
Use cases
Databricks Markdown Cheat Sheet
Visualizations
Azure Databricks SQL notebooks supports various types of visualizations using the display function.
Interoperability
Pyspark Dataframe Documentation
This section describes features that support interoperability between SQL and other languages supported in Azure Databricks.
Databricks Runtime 7.x and above
Databricks Runtime 5.5 LTS and 6.x
Tools
In addition to Azure Databricks notebooks, you can also use the following business intelligence tools:
Access control
This article describes how to use SQL constructs to control access to database objects:
Databricks Cheat Sheet
Resources