Customization ​

You can customize the settings of Indexima for Snowflake in your interface: https://autopilot.indexima.io/settings

Dynamic Tables creation ​

You can enable or disable automatic creation / deletion of Dynamic Tables. By default this option is enabled to make sure you always benefit from the best aggregation layer without any action required.
If you deactivate the DT creation, Indexima will still calculate and suggest the best aggregation layer (see https://autopilot.indexima.io/aggregation) but Dynamic Tables won’t be created automatically. You will have to create them manually in Snowflake if you want to benefit from query acceleration.
Be aware that as your activity increases this can become time and resource consuming as the number of dynamic tables will increase and the best aggregation layer can change at any time.

Query acceleration ​

You can enable or disable query acceleration. By default this option is enabled. This allows Indexima to automatically redirect your SQL Queries towards relevant Dynamic Tables, and therefore improve performance.
If you disable this option, queries won’t be redirected and you won’t benefit from any Dynamic Tables. The only way to use them would be to rewrite your query to force them through Dynamic Tables or to redefine your data model in your BI Tool so it points to Dynamic Tables when needed.
In most cases this is highly time consuming and will force you to duplicate Data sources as some queries can use an aggregation layer but others still need to access the raw data.

Service user ​

You can update the service user and password of this user, to adapt the role and authorisation that Indexima will have when connecting to your Snowflake.
In any case, the queries proxied by Indexima will always be executed with the original Snowflake user defined in your dataviz tool. The Service user is only used for Indexima to requets metadata from your Snowflake and to create Dynamic Tables.

Advanced settings ​

The folowing parameters are available to fine-tune the behaviour of Indexima:

  • DT Target lag: Target lag parameter for Dynamic Tables automatically created. Please refer to Snowflake documentation
  • DT refresh warehouse: Warehouse used to refresh the Dynamic Tables. Please refer to Snowflake documentation
  • Query analysis period: The maximum age of a query to be considered when calculating the best aggregation layer.
  • Query minimum hits: Minimal number of queries seen during the computation period necessary for a candidate materialization to be taken into account.
  • Refresh aggregation layer frequency: The frequency at which to recalculate the best aggregation layer and adapt Snowflake Dynamic Tables.
  • Scope limitation: Limit the scope of DT automatic creation to a specific database or a specific schema. You can define several scopes (comma separated) of database or database.schema. Eg: "DB1, DB2.SC1, DB2.SC2"
  • DT location: Store every DT in a specific schema. If empty (default), DT are stored next to their source table. Format is MYDATABASE.MYSCHEMA.
    This setting is especially usefull if you want to accelerate a Snowflake shared database: as the consumer has read-only access to the shared database, you need to setup this parameter in order to create DT in a specific location outside of the shared database.