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.

The following BI tools and technologies are known to provide native connectivity to Snowflake:

Solution		Version / Installation Requirements	Notes
		Adobe Campaign: 20.1 (or higher) Snowflake: ODBC Driver — download from the ODBC Download page	Additional resources: Specific configurations by database type — Configure Access to Snowflake (Adobe Documentation: Help) Big data management on Snowflake (Adobe Documentation: Tutorials)
		Astrato: No requirements Snowflake: No requirements	Additional resources: Create your Astrato account — free for 5 users (Astrato website) Connect to Snowflake (Astrato Help Center)
		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	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)
		Google Data Studio: No requirements Snowflake: No requirements	Additional resources: Snowflake Connector for Google Data Studio
		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	Validated by the Snowflake Ready Technology Validation Program. 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 ODBC Download page
		Microsoft Power BI Desktop: Desktop July Update (or higher) Desktop September Update (or higher) Snowflake: ODBC Driver — download from the ODBC Download page	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 ODBC Download page	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: 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 > Connect to Snowflake Data Warehouse (Oracle Documentation) Oracle Analytics Desktop Doesn’t Connect To Snowflake (Red Pill Analytics Blog)
		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 . 3rd-party connector (PentahoSnowflakePlugin) — download from GitHub	Additional resources: PDI and Snowflake (Pentaho Documentation) PentahoSnowflakePlugin Readme (GitHub) Configuring a JDBC connection to Snowflake Using Pentaho (Snowflake Community)
		Pyramid: 2018 (or higher) Snowflake: No requirements	Additional resources: Snowflake + Pyramid (Pyramid Analytics website)
		Qlik Sense: No requirements Snowflake: No requirements	Validated by the Snowflake Ready Technology Validation Program. Additional resources: Qlik Connectors > ODBC Connector Package > Snowflake (Qlik Documentation)
		Sigma Computing: No requirements Snowflake: No requirements	Available for trial via Snowflake Partner Connect. Validated by the Snowflake Ready Technology Validation Program.
		SAP BusinessObjects: 4.2 SP08 (or higher) Snowflake: . ODBC Driver — download from the ODBC Download page . 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. Validated by the Snowflake Ready Technology Validation Program. 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 ODBC Download page	Validated by the Snowflake Ready Technology Validation Program. 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)
		Tableau CRM: No requirements Snowflake: No requirements	Formerly Salesforce Einstein Analytics Additional resources: Snowflake Computing Connection (Salesforce Community Help)
		ThoughtSpot: No requirements Snowflake: No requirements	Available for trial via Snowflake Partner Connect. Validated by the Snowflake Ready Technology Validation Program. Additional resources: Search and AI-Driven Analytics for Snowflake (ThoughtSpot website)
		TIBCO Spotfire: 10.3 LTS (or higher) Snowflake: ODBC Driver — download from the ODBC Download page	Additional resources: Connector for Snowflake (TIBCO Documentation) Accessing Data from Snowflake (TIBCO Documentation)