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
  • Alteryx: Analytics 11.5 (or higher)
  • Snowflake: ODBC Driver — 32-bit or 64-bit (download from the Snowflake web interface)
Databricks Spark, JDBC
  • Databricks: Runtime 4.2
  • Snowflake: No requirements
dplyr N/A (R extension)
  • dplyr: 0.4.3
  • Snowflake: dplyr extension, v0.1.1 — available via dplyr-snowflakedb (GitHub)
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