Connection
Swap url in your DataViz tool
Whatever Dataviz tool you are using, Indexima for Snowflake is a transparent proxy in front of Snowflake. For most tools, to redirect queries sent by your Dataviz Tool to Indexima instead of Snowflake, you only need to change the target URL: Replace .snowflakecomputing.com
in your target url with .sf.indexima.io
Examples:
From | To |
---|---|
https://<account_identifier>.snowflakecomputing.com | https://<account_identifier>.sf.indexima.io |
https://ab12345.eu-west-1.aws.snowflakecomputing.com | https://ab12345.eu-west-1.aws.sf.indexima.io |
https://abcdefg-yz98765.snowflakecomputing.com | https://abcdefg-yz98765.sf.indexima.io |
No other change is needed. The same driver will accept this new URL and you’ll retrieve all your datas exactly as if you were directly connected to Snowflake.
⚠️ In any case, you need to be in direct query, meaning that you cannot import your data in your Dataviz Tool otherwise no queries will be sent to snowflake or Indexima
Tableau
In tableau you just need to change this line :
From | To |
---|---|
And that’s it !
Anything supported by the Tableau / Snowflake connector will be supported out of the box when connecting through Indexima. Please see Tableau documentation for further details.
To deactivate Tableau temporary tables, see also this tip.
🔒 For OAuth authentication, the Tableau default connector enforce snowflakecomputing.com
domain. To use Indexima (as for any advanced OAuth scenario), you need to define a custom OAuth config as described here. Please liaise with Indexima support if you need assistance to build your OAuth config file.
Power-BI
From Power BI Desktop application, to connect to Snowflake through Indexima, use the standard Power BI connector for Snowflake, replacing .snowflakecomputing.com
with .sf.indexima.io
in your server url.
Dont forget to select "DirectQuery", as import mode is not compatible with Indexima acceleration.
For existing dashboards, you can swap the url by clicking 'Transform Data' to open the Power Query editor, then you can edit source settings.
Once your dashboard targets Indexima, you can publish it on Power BI service or on a report server as usual.
🔒 For OAuth authentication, the PowerBI default connector for Snowflake enforce snowflakecomputing.com
domain. And the default ODBC connector doesn't support DirectQuery.
To use Indexima, you need to define a custom connector. Microsoft provides a Snowflake connector here, but which doesn't support OAuth authentication. We provide an enhanced version of this connector supporting Microsoft AAD OAuth: SnowflakeODBC_AAD.mez. Please liaise with Indexima support if you need assistance to build your own connector.
Microstrategy
To connect to Snowflake or Indexima you need to previously define ODBC connections. Then you only need to change the server part, all other fields are unchanged.
From | To |
---|---|
Metabase
In order to redirect your queries to Indexima, fill the field 'Account Name' of the database with <snowflake-account>.sf.indexima.io:443/?account=<snowflake-account>
From | To |
---|---|
Grafana
In order to redirect your queries to Indexima, fill the field 'Account' of the Snowflake plugin with <snowflake-account>.sf.indexima.io:443/?account=<snowflake-account>
From | To |
---|---|
Luzmo
In order to redirect your queries to Indexima, fill the field 'Host' of the Snowflake plugin with https://<snowflake-account>.sf.indexima.io