How to Store and Access SQL Queries in Databricks 🌱

  1. Create the SQL query and define table_name as the name where you store the queried table. ``` %sql CREATE OR REPLACE TEMPORARY VIEW AS

’'’SQL query here’’’ SELECT * FROM 


2. Create a spark dataframe for the queried table

spark_dataframe_of_table = spark.table(β€˜table_name’) ```

Notes mentioning this note

There are no notes linking to this note.

Here are all the notes in this garden, along with their links, visualized as a graph.