Practical Predictive Analytics

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