How to specify home catalog for table trigger in YAML

Dimitry
Valued Contributor

I have a job that is triggered from changes in a table.

Table is located in the home catalog.

I have multiple environments, that are not predefined (created on the fly)

Some process writes into a table, and then job starts processing this table.

I have a generic target

targets:
  client-workspace:
    workspace:
      root_path: ${var.bundle_path}
    mode: production

I don't specify host, because it is not pre-determined.

      trigger:
        pause_status: UNPAUSED
        table_update:
          table_names:
            - {WORKSPACE_NAME}.schema.table

and here I hit a roadblock, as there is no way to figure WORKSPACE_NAME, unless configured which means I hardcode each dynamically created workspace.

I understand there is a way round using CLI and providing the parameter in the command line.

Is there a better solution that would enable deployment from UI?