Skip to content

Files

Latest commit

f5aaa7f · Nov 2, 2020

History

History
53 lines (36 loc) · 3.62 KB

onnx-overview.md

File metadata and controls

53 lines (36 loc) · 3.62 KB
title description keywords services ms.service ms.subservice ms.topic author ms.author ms.date
Machine learning and AI with ONNX in Azure SQL Edge
Machine learning in Azure SQL Edge supports models in the Open Neural Network Exchange (ONNX) format. ONNX is an open format you can use to interchange models between various machine learning frameworks and tools.
deploy SQL Edge
sql-edge
sql-edge
machine-learning
conceptual
dphansen
davidph
05/19/2020

Machine learning and AI with ONNX in SQL Edge

Machine learning in Azure SQL Edge supports models in the Open Neural Network Exchange (ONNX) format. ONNX is an open format you can use to interchange models between various machine learning frameworks and tools.

Overview

To infer machine learning models in Azure SQL Edge, you will first need to get a model. This can be a pre-trained model or a custom model trained with your framework of choice. Azure SQL Edge supports the ONNX format and you will need to convert the model to this format. There should be no impact on model accuracy, and once you have the ONNX model, you can deploy the model in Azure SQL Edge and use native scoring with the PREDICT T-SQL function.

Get ONNX models

To obtain a model in the ONNX format:

Limitations

Currently, not all ONNX models are supported by Azure SQL Edge. The support is limited to models with numeric data types:

Other numeric types can be converted to supported types by using CAST and CONVERT.

The model inputs should be structured so that each input to the model corresponds to a single column in a table. For example, if you are using a pandas dataframe to train a model, then each input should be a separate column to the model.

Next steps