Icon

02_​SQLServer_​BlobStorage_​andKNIMEModels

Mix and Match Predictive Approach. From BlobStorage and SQL Server through In-Database Processing till KNIMEAnalytics Model Training.

This workflow reads CENSUS data from a SQL Server database; it then performs some In-Database Processing on SQL Server; it trains a KNIME decision tree model to predict COW values based on all other attributes; and it finally joins the results with data from BlobStorage on the Azure Cloud. Data for this example come from the new CENSUS dataset which is publicly available and can be downloaded from: http://www.census.gov/programs-surveys/acs/data/pums.html A full explanation of all attributes can be found in: http://www2.census.gov/programs-surveys/acs/tech_docs/pums/data_dict/PUMSDataDict15.pdf

In-Database Processing KNIME Machine Learning BlobStorage Data Lake Mix and Match Predictive Approach. From BlobStorage and SQL Server through In-Database Processing till KNIMEAnalytics Model Training.Goal: Predicting COW values.This workflow reads CENSUS data from a SQL Server database; it then performs some In-Database Processing on SQL Server; it trains a KNIME decision tree model to predict COW values based on allother attributes; and it finally joins the results with data from BlobStorage on the Azure Cloud.Data for this example come from the new CENSUS dataset which is publicly available and can be downloaded from: http://www.census.gov/programs-surveys/acs/data/pums.html A full explanation of all attributes can be found in: http://www2.census.gov/programs-surveys/acs/tech_docs/pums/data_dict/PUMSDataDict15.pdf Datasets used inthis example areavailable here. COW is NULLconnect toSQL ServerInsert <hostname> and <Credentials> here.Use of Credentials is recommended over simpleusername and password.Credentials are defined at the workflow levelRight-click the workflow in KNIME Explorer panel andselect "Workflow Credentials".Parameter field might need customization.InsertStorage Accountand Access Key.Also here Credentialsare recommendedUsing the pathwe create a url from which the csv reader canread directlyCOW is not NULLimport all rows where COW is NOT NULLimport all rows whereCOW is NULLappend predictedCOW columnpredict COWselect * from ss13pmeNode 180Node 181remove COWss13hme.csvjoin on SERIAL NOfile ss13hme.csvfile ss13pme.csvDatabase Row Filter SQL ServerConnector Azure Blob StoreConnection Azure Blob StoreFile Picker Database Row Filter Database ConnectionTable Reader Database ConnectionTable Reader Decision TreePredictor DecisionTree Learner Database TableSelector DatabaseColumn Filter Number To String DatabaseColumn Filter File Reader Joiner File Reader File Reader In-Database Processing KNIME Machine Learning BlobStorage Data Lake Mix and Match Predictive Approach. From BlobStorage and SQL Server through In-Database Processing till KNIMEAnalytics Model Training.Goal: Predicting COW values.This workflow reads CENSUS data from a SQL Server database; it then performs some In-Database Processing on SQL Server; it trains a KNIME decision tree model to predict COW values based on allother attributes; and it finally joins the results with data from BlobStorage on the Azure Cloud.Data for this example come from the new CENSUS dataset which is publicly available and can be downloaded from: http://www.census.gov/programs-surveys/acs/data/pums.html A full explanation of all attributes can be found in: http://www2.census.gov/programs-surveys/acs/tech_docs/pums/data_dict/PUMSDataDict15.pdf Datasets used inthis example areavailable here. COW is NULLconnect toSQL ServerInsert <hostname> and <Credentials> here.Use of Credentials is recommended over simpleusername and password.Credentials are defined at the workflow levelRight-click the workflow in KNIME Explorer panel andselect "Workflow Credentials".Parameter field might need customization.InsertStorage Accountand Access Key.Also here Credentialsare recommendedUsing the pathwe create a url from which the csv reader canread directlyCOW is not NULLimport all rows where COW is NOT NULLimport all rows whereCOW is NULLappend predictedCOW columnpredict COWselect * from ss13pmeNode 180Node 181remove COWss13hme.csvjoin on SERIAL NOfile ss13hme.csvfile ss13pme.csvDatabase Row Filter SQL ServerConnector Azure Blob StoreConnection Azure Blob StoreFile Picker Database Row Filter Database ConnectionTable Reader Database ConnectionTable Reader Decision TreePredictor DecisionTree Learner Database TableSelector DatabaseColumn Filter Number To String DatabaseColumn Filter File Reader Joiner File Reader File Reader

Nodes

Extensions

Links