Advanced Analytics

Also referred to as data science, machine learning (ML), artificial intelligence (AI), and “Big Data”, advanced analytics covers 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 are less focused on analyzing/reporting on 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.

Snowflake is known to inter-operate with the following advanced analytics platforms and technologies:

Solution Connection Type Version / Installation Requirements Additional Information
Alteryx ODBC
Databricks Spark, JDBC
  • Databricks: Runtime 4.2
  • Snowflake: No requirements
Dataiku JDBC
  • Dataiku: DSS
  • Snowflake: No requirements
DataRobot JDBC
  • DataRobot: No requirements
  • Snowflake: No requirements
dplyr N/A (R extension)
  • dplyr: 0.4.3
  • Snowflake: dplyr extension, v0.1.1 — available via dplyr-snowflakedb (GitHub)
H2O.ai JDBC
  • H2O.ai: Driverless AI 1.4.2 (or higher)
  • Snowflake: No requirements
Pyramid Analytics JDBC
  • Pyramid: 2018
  • Snowflake: No requirements
Qubole Spark, JDBC
  • Qubole: Enterprise Edition
  • Snowflake: No requirements
R Language JDBC or ODBC
Apache Spark JDBC