How to Store and Access SQL Queries in Databricks 🌱

Last updated on March 13, 2021

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’) `

There are no notes linking to this note.

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