Machine Learning & Data Science¶

Also referred to as advanced analytics, artificial intelligence (AI), and “Big Data”, machine learning and data science cover a broad category of vendors, tools, and technologies that provide advanced capabilities for statistical and predictive modeling.

These tools and technologies often share some overlapping features and functionality with BI tools; however, they focus less on analyzing/reporting past data. Instead, they focus on examining large data sets to discover patterns and uncover useful business information that can be used to predict future trends.

The following machine learning and data science platforms and technologies are known to provide native connectivity to Snowflake:

Solution		Version / Installation Requirements	Notes
		Alteryx: Analytics 11.5 (or higher) Snowflake: ODBC Driver — download from the ODBC Download page	Available for trial via Snowflake Partner Connect. Validated by the Snowflake Ready Technology Validation Program. Additional resources: Snowflake In-Database Functionality Now Available (Alteryx Community Blog) Supported Data Sources — Snowflake (Alteryx Documentation)
		Amazon SageMaker: No requirements Snowflake: No requirements	Additional resources: Developer Guide > Prepare and Analyze Datasets > Import data from Snowflake (AWS Documentation) Preconfigured Amazon SageMaker Instance with Snowflake Connector (Snowflake Blog)
		Big Squid: No requirements Snowflake: No requirements	Validated by the Snowflake Ready Technology Validation Program. Additional resources: How Do I Create a Snowflake Connection? (Big Squid Support)
		BoostKPI: No requirements Snowflake: No requirements	Additional resources: BoostKPI Integration with Snowflake (BoostKPI website)
		Databricks: Runtime 4.2 Snowflake: No requirements	Integration implemented through the Snowflake Connector for Spark embedded in Databricks Runtime. Additional resources: Data Sources — Snowflake (Databricks Documentation)
		Dataiku: DSS Snowflake: JDBC Driver — download from the JDBC Driver page in the Maven Central Repository	Available for trial via Snowflake Partner Connect. Validated by the Snowflake Ready Technology Validation Program. Additional resources: Connecting to Data > SQL Databases > Snowflake (Dataiku Documentation)
		DataRobot: No requirements Snowflake: No requirements	Available for trial via Snowflake Partner Connect. Validated by the Snowflake Ready Technology Validation Program. Additional resources: The Power of DataRobot + Snowflake (DataRobot Blog)
		Domino: 3.6 (or higher) Snowflake: See the Domino documentation for requirements	Additional resources: Connecting to Snowflake from Domino (Domino Documentation)
		H2O.ai: Driverless AI 1.4.2 (or higher) Snowflake: No requirements	Available for trial via Snowflake Partner Connect. Validated by the Snowflake Ready Technology Validation Program. Additional resources: Using Data Connectors with Native Installs - Snowflake (H2O.ai Documentation)
		Hex: No requirements Snowflake: No requirements	Available for trial via Snowflake Partner Connect. Validated by the Snowflake Ready Technology Validation Program. Additional resources: Query Snowflake data right from a powerful data notebook (Hex website) Connect to Data (Hex Documentation)
		KNIME: Analytics Platform 4.4.0 (or higher) Extension: KNIME Snowflake Integration Snowflake: None (JDBC Driver embedded in the KNIME extension); other Snowflake drivers also supported	Additional resources: Overview: KNIME for Snowflake Users (KNIME website) Collection: KNIME for Snowflake Users (KNIME Community Hub) KNIME Snowflake Extension Guide (KNIME Documentation)
		Qubole: Enterprise Edition Snowflake: No requirements	Integration implemented through the Snowflake Connector for Spark embedded in Qubole Data Service (QDS) Additional resources: Qubole Quickstart Guide (Qubole Documentation) Qubole-Snowflake Integration Guide (Qubole Documentation)
		SAS: Cloud Analytic Services 3.4 (or higher) SAS/ACCESS 9.4 (or higher) for Relational Databases Snowflake: ODBC Driver — download from the ODBC Download page	Additional resources: Snowflake: Data Connector Specifics (SAS Documentation) SAS/ACCESS Interface to Snowflake (SAS Documentation)
		Spark: 3.0 (or higher) Scala: 2.12 or 2.13 Snowflake: JDBC Driver — download from the JDBC Driver page in the Maven Central Repository Connector for Spark — download from the Snowflake Connector for Spark page in the Maven Central Repository	Additional resources: Configuring Snowflake to Communicate with Spark Running on EMR (Snowflake Community)
		Tellius: None Snowflake: None	Additional resources: Tellius + Snowflake for Instant Analytics & AI at Scale (Tellius website) 4 Things That Make Tellius and Snowflake Great Together (Tellius website) Transform Data in Snowflake Data Cloud with Java UDFs in Tellius (Tellius website)
		Zepl: No requirements Snowflake: JDBC Driver — download from the JDBC Driver page in the Maven Central Repository Connector for Spark — download from the Snowflake Connector for Spark page in the Maven Central Repository	Additional resources: Zepl and Snowflake Bring Data Science as a Service to Cloud Data Warehouses (Zepl Blog) Getting Started with Zepl and Snowflake in Minutes (Zepl Blog) Zepl and Snowflake — Data Science as a Service for your Cloud Warehouse (Zepl Solution Brief)