O'Reilly logo

Practical Predictive Analytics by Ralph Winters

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Creating some global views

Creating global views will also allow us to pass data between different databricks notebooks. These views will be referenced in the next section. Use the %sql magic command as the first line in the databricks notebook to signify that these are SQL statements:

%sql CREATE GLOBAL TEMPORARY VIEW df_view AS SELECT * FROM df  %sql CREATE GLOBAL TEMPORARY VIEW test_view AS SELECT * FROM test  %sql CREATE GLOBAL TEMPORARY VIEW out_sd_view AS SELECT * FROM out_sd  %sql CREATE GLOBAL TEMPORARY VIEW sumdf_view AS SELECT * FROM sumdf 

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required