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.