Dynamic Database

Expanding upon dynamic queries, it's also possible to dynamically select the database itself, guided by user attributes. This approach allows for a more personalized and efficient data handling strategy, tailored to the specific needs and contexts of individual users.

How to Implement:

  1. Create a new dataset

  2. Select "Several databases through variables" option

  3. Integrate the user attribute condition by substituting the placeholder with your desired attribute.

Consider the example below for incorporating a database attribute directly into your query:

{{ (user or {}).get('attributes', {}).get('database', 'rdb') }}

The example demonstrates how to dynamically select appropriate database. This method leverages conditional logic to either use the database attribute or default to rdb if the attribute doesn't exist.

Last updated