MicroStrategy ONE

Connect to Snowflake on Windows

MicroStrategy ships the Snowflake driver by default. You can set up the connectivity from MicroStrategy Developer and Web.

  • ODBC
  • JDBC

Starting in MicroStrategy 2021, the Snowflake ODBC driver is shipped out-of-the-box to simplify the connectivity workflow.

Explore the following topics to configure Snowflake ODBC connectivity on Windows.

Add the Database Instance to MicroStrategy Developer

  1. Open MicroStrategy Developer.

  2. Go to the Data Instance configuration.

  3. Right-click in the Database Instance dialog and select New > Database Instance.
  4. Enter a database instance name.

  5. From the Database connection type drop-down, choose Snowflake.

  6. Click New.
  7. In the Database Connections dialog, enter a database connection name.

  8. Select the DSN.

  9. Click New.

  10. In the Database Logins dialog, enter your login credentials.

  11. Click OK in all three dialogs (Login, Connection, and Database Instance).

    The database instance is created and can be used to query the database.

Add the Database Instance to MicroStrategy Web

  1. Open MicroStrategy Web (https://<servername>/MicroStrategy/servlet/mstrWeb).

  2. Click Create > Add External Data.

  3. Choose Snowflake.

  4. In the Data Source dialog, create a new database instance by completing the required fields.

  5. Click Save.

  6. Fetch data.

Starting in MicroStrategy 2021, the Snowflake JDBC driver is shipped out-of-the-box to simplify the connectivity workflow.

Explore the following topics to configure Snowflake JDBC connectivity on Windows.

Add the Database Instance to MicroStrategy Developer

  1. Open MicroStrategy Developer.

  2. Go to the Data Instance configuration.

  3. Right-click in the Database Instance dialog and select New > Database Instance.
  4. Enter a database instance name.

  5. From the Database connection type drop-down, choose Snowflake.

  6. Click New.
  7. In the Database Connections dialog, enter a database connection name.

  8. Go to the Advanced tab.

  9. Build a connection string.

    1. In a text editor, use the connection string template to build a connection string for your Snowflake instance:

      JDBC;DRIVER={com.snowflake.client.jdbc.SnowflakeDriver};URL={jdbc:snowflake://HOST/?warehouse=WAREHOUSE&db=DATABASE&schema=SCHEMA};
    2. Replace HOST with the appropriate value. For example, acme.snowflakecomputing.com.

    3. Replace WAREHOUSE, DATABASE, and SCHEMA.

      Your resulting string should look similar to

      JDBC;DRIVER={com.snowflake.client.jdbc.SnowflakeDriver};URL={jdbc:snowflake://microstrategy.snowflakecomputing.com/?warehouse=testwarehouse&db=ABC&schema=PUBLIC};

  10. In the Additional connection string parameters field, paste the connection string.

  11. Return to the General tab.
  12. Click New.

  13. In the Database Logins dialog, enter your login credentials.

  14. Click OK in all three dialogs (Login, Connection, and Database Instance).

    The database instance is created and can be used to query the database.

    Add the Database Instance to MicroStrategy Web

    MicroStrategy does not support the creation of connections using a JDBC driver. However, MicroStrategy Web supports the creation of connections using the ODBC driver, as explained in the ODBC tab of this page.