Business Intelligence (BI)¶

Business intelligence (BI) tools enable analyzing, discovering, and reporting on data to help executives and managers make more informed business decisions. A key component of any BI tool is the ability to deliver data visualization through dashboards, charts, and other graphical output.

Business intelligence also sometimes overlaps with technologies such as data integration/transformation and advanced analytics; however, we’ve chosen to list these technologies separately in their own categories.

Snowflake is known to inter-operate with the following BI tools:

Solution		Version / Installation Requirements
		Adobe Campaign: 20.1 (or higher) Snowflake: ODBC Driver — download from the Snowflake Client Repository	Additional resources: Specific configurations by database type — Configure Access to Snowflake (Adobe Documentation: Help) Big data management on Snowflake (Adobe Documentation: Tutorials)
		AtScale: 7.4 (or higher) Snowflake: No requirements	Additional resources: Snowflake & AtScale, A Perfect Fit (AtScale Blog)
		AWS Quicksight: No requirements Snowflake: No requirements
		Chartio: No requirements Snowflake: No requirements	Available for trial via Snowflake Partner Connect. Additional resources: Connect and Explore Your Data in the Cloud with Snowflake and Chartio Analytics (Chartio website)
		Domo: No requirements Snowflake: No requirements	Available for trial via Snowflake Partner Connect. Additional resources: Snowflake Connector (Domo Knowledge Base)
		IBM Cognos: 11.0.5, 04‘16 (or higher) Snowflake: No requirements	Additional resources: New Data Sources in 11.0.5 (Cognos Analytics Blog)
		Looker: No requirements Snowflake: No requirements	Additional resources: Snowflake (Looker Documentation)
		Metabase: No requirements Snowflake: No requirements	Additional resources: metabase / modules / drivers / snowflake (Github)
		Microsoft Power BI Cloud Service: On-premises Data Gateway July Update (or higher) Snowflake: ODBC Driver — download from the Snowflake Client Repository
		Microsoft Power BI Desktop: Desktop July Update (or higher) Desktop September Update (or higher) Snowflake: ODBC Driver — download from the Snowflake Client Repository	Additional resources: Connect to Snowflake in Power BI Desktop (Power BI Documentation)
		Microstrategy: Secure Enterprise Platform 10.2 or 10.3 (or higher) Snowflake: ODBC Driver — download from the Snowflake Client Repository	Additional resources: How to connect to Snowflake (Microstrategy Community) How to connect to Snowflake in Secure Enterprise Platform 10.2 (Microstrategy Community) Configuring MicroStrategy to use Snowflake (Snowflake Community)
		Mode Analytics: No requirements Snowflake: No requirements	Additional resources: Explore & Visualize Your Snowflake data (Mode website)
		Oracle Analytics Cloud: March 2019 (or higher) Snowflake: No requirements	Additional resources: Visualizing Data and Building Reports in Oracle Analytics Cloud > Create Connections to Snowflake Data Warehouse (Oracle Documentation) How to Use the Oracle Analytics Cloud (OAC) 105.2 Snowflake Connector (Performance Architects website)
		Oracle Analytics Desktop: November 2019 (or higher) Snowflake: No requirements	Additional resources: User’s Guide for Oracle Analytics Desktop > Create Connections to Snowflake Data Warehouse (Oracle Documentation)
		Pentaho Business Analytics: Pentaho 8.3 (or higher): Snowflake plugin — download from the Pentaho Customer Portal (requires login) Pentaho 8.2 (or lower): No Pentaho requirements, but some Snowflake requirements Snowflake: Pentaho 8.3 (or higher): No requirements Pentaho 8.2 (or lower): . JDBC Driver — download from Maven . or . PentahoSnowflakePlugin (3rd-party connector) — download from GitHub	Additional resources: PDI and Snowflake (Pentaho Documentation) PentahoSnowflakePlugin Readme (GitHub) Configuring a JDBC connection to Snowflake Using Pentaho (Snowflake Community)
		Qlikview: No requirements Snowflake: ODBC Driver — download from the Snowflake Client Repository	Additional resources: Qlik Snowflake Integration_How to guide (Qlik Community; requires login) Configuring Qlikview to use Snowflake (Snowflake Community)
		Sigma Computing: No requirements Snowflake: No requirements	Available for trial via Snowflake Partner Connect.
		Salesforce Einstein Analytics: No requirements Snowflake: No requirements	Additional resources: Snowflake Computing Connection (Salesforce Community Help)
		SAP BusinessObjects: 4.2 SP08 (or higher) Snowflake: . ODBC Driver — download from the Snowflake Client Repository . or . JDBC Driver — download from Maven	Additional resources: Snowflake for SAP BusinessObjects 4.2 SP08 (SAP Community Blogs)
		Sisense: No requirements Snowflake: No requirements	Sisense for Cloud Data Teams (formerly Periscope Data) available for trial via Snowflake Partner Connect. Additional resources: Sisense Connector for Snowflake (Sisense website) Connecting to Snowflake (Sisense Documentation)
		Tableau: Desktop/Server/Online 9.3 (or higher) Snowflake: ODBC Driver — download from the Snowflake Client Repository	Additional resources: Introducing the Snowflake connector in Tableau 9.3 (Tableau Blog) Supported Connectors: Snowflake (Tableau Help) Best Practices for Using Tableau with Snowflake (Snowflake Resource Library)
		Thoughtspot: No requirements Snowflake: No requirements	Available for trial via Snowflake Partner Connect. Additional resources: Search and AI-Driven Analytics for Snowflake (Thoughtspot website)
		Tibco Spotfire: 10.3 LTS (or higher) Snowflake: ODBC Driver — download from the Snowflake Client Repository	Additional resources: What’s New in TIBCO Spotfire 10.3 LTS > Native Snowflake support (TIBCO Community) Spotfire Analyst User’s Guide (TIBCO Documentation)