Is your feature request related to a problem? Please describe.
Antalya swarms are a wonderful feature but sometimes hard for ordinary users to apply in practice. For example:
- Users need to know they are available
- Users need to have rights to system.clusters to get the cluster name
- They need to adapt settings like object_storage_cluster to dispatch to the swarm cluster.
Describe the solution you'd like
It would be great if swarms could automatically advertise the tables that they can access to initiators. Initiators could then have a setting like 'use_swarm_if_available' so the swarm is automatically used if applicable without users having to know the swarm name or where it is locate. It would be addressed during query planning.
Describe alternatives you've considered
Continue with the current approach, which is cumbersome.
Additional context
There will need to be monitoring and information in system.query_log to show that swarm processing has kicked in.
Is your feature request related to a problem? Please describe.
Antalya swarms are a wonderful feature but sometimes hard for ordinary users to apply in practice. For example:
Describe the solution you'd like
It would be great if swarms could automatically advertise the tables that they can access to initiators. Initiators could then have a setting like 'use_swarm_if_available' so the swarm is automatically used if applicable without users having to know the swarm name or where it is locate. It would be addressed during query planning.
Describe alternatives you've considered
Continue with the current approach, which is cumbersome.
Additional context
There will need to be monitoring and information in system.query_log to show that swarm processing has kicked in.