MicroStrategy ONE

SnowflakeDSII ODBC Driver for Snowflake Database for Windows and Linux

The following information is required for setting up the driver connection for Snowflake ODBC Driver when running against Snowflake:

  • Data Source Name: A name to identify the Snowflake data source configuration in MicroStrategy. For example, Finance or Snowflake which can serve to identify the connection.
  • Server Name: Specifies the hostname for your account.
  • Database Name: Specifies the default database to use for sessions initiated by the driver.
  • Schema: Specifies the default schema to use for sessions initiated by the driver.
  • Warehouse: Specifies the default warehouse to use for sessions initiated by the driver.
  • Role: Specifies the default role to use for sessions initiated by the driver. The specified role should be a role that has been assigned to the specified user for the driver.
  • Enable SSL: Data is encrypted while transmitting. Snowflake only allows HTTPS to connect, and so it always uses TLS/SSL.