Common patterns and functions to other SQL syntaxes
SELECT ... FROM ... syntaxes
Built-in and custom functions
Query data tables in Unity Catalog or in other database systems
SELECT
id,
name,
product,
store_id,
sales,
unit_price,
FROM
sales_data
WHERE
sales > 10 AND
product IN ('widget', 'thingy')
Common functions
Databricks SQL functions mirror some of the most common operations in SQL, Python, and Spark
ROUND() and FORMAT_NUMBER()
CONCAT(), LEFT(), and RIGHT()
DATE(), DATE_ADD(), and DATE_DIFF()
CASE, IF(), and ISNULL()
FROM_CSV() and FROM_JSON()
Create a custom User Defined Function (UDF)
SELECT
id,
initcap(name) as name,
right(product, 10) as productSKU,
store_id,
int(sales) as numSales,
round(unit_price, 2) as unit_price
FROM
sales_data
WHERE
sales > 10 AND
product IN ('widget', 'thingy')
Preparing Video For Download...
