Overview: Snowflake aces Python machine studying

Final yr I wrote about eight databases that assist in-database machine studying. In-database machine studying is essential as a result of it brings the machine studying processing to the info, which is far more environment friendly for giant information, moderately than forcing information scientists to extract subsets of the info to the place the machine studying coaching and inference run.

These databases every work otherwise:

• Amazon Redshift ML makes use of SageMaker Autopilot to robotically create prediction fashions from the info you specify by way of a SQL assertion, which is extracted to an Amazon S3 bucket. The most effective prediction operate discovered is registered within the Redshift cluster.
• BlazingSQL can run GPU-accelerated queries on information lakes in Amazon S3, move the ensuing DataFrames to RAPIDS cuDF for information manipulation, and at last carry out machine studying with RAPIDS XGBoost and cuML, and deep studying with PyTorch and TensorFlow.
• BigQuery ML brings a lot of the facility of Google Cloud Machine Studying into the BigQuery information warehouse with SQL syntax, with out extracting the info from the info warehouse.
• IBM Db2 Warehouse features a large set of in-database SQL analytics that features some fundamental machine studying performance, plus in-database assist for R and Python.
• Kinetica gives a full in-database lifecycle answer for machine studying accelerated by GPUs, and may calculate options from streaming information.
• Microsoft SQL Server can prepare and infer machine studying fashions in a number of programming languages.
• Oracle Cloud Infrastructure can host information science sources built-in with its information warehouse, object retailer, and features, permitting for a full mannequin improvement lifecycle.
• Vertica has a pleasant set of machine studying algorithms built-in, and may import TensorFlow and PMML fashions. It could do prediction from imported fashions in addition to its personal fashions.

Now there’s one other database that may run machine studying internally: Snowflake.

Snowflake overview