PolyBase allows your SQL Server instance to access data outside of the server/database using T-SQL. In SQL Server 2016, you can run queries on external data in Hadoop or import data from Azure Blob Storage:
Figure 10.8: PolyBase concept (source: https://docs.microsoft.com/en-us/sql/relational-databases/polybase/polybase-guide)
In this section, we'll use a similar dataset as in the previous section, represented as CSV files in Azure Blob Storage. These CSV files represent the EMS incidents, which will be exposed as an external table in SQL Server. The goal for this walk-through is to understand seasonality and the trending of EMS incidents. We will use R in the SQL Server to do this and view the chart in SQL Operations Studio.
The following are the prerequisites to get started:
- The SQL Server instance installed with PolyBase...
