Using hdbvirtualtableconfig with schema.configure

[former_member610674]

Dear Community,

I want the schema dynamically assigned in the the virtualschemaconfig, so that I can define it in the .yaml-file once. For a similar use case we are using schema.configure in the synonymconfig files. Is it possible to apply the same in the virtualtableconfig-files?

The .hdbvirtualtableconfig:

{  "vt_IACCOUNT": 

  {"target": 

    {"remote": "SDA_HANA_BWZENTRAL", 

    "database": "<NULL>", 

    "schema.configure" : "aquisition-service/logicalschema", 

    "object": "/BI0/IACCOUNT"}}}

The corresponding .hdbvirtualtable:

VIRTUAL TABLE "vt_IACCOUNT" AT "<NULL>"."<NULL>"."<NULL>"."/BI0/IACCOUNT"    

The relevant hdi container in the yaml is:

modules: 

- name: Aquisition   

  type: hdb   

  path: UDWH_AL   

  requires:    

    - name: CrossSchemaService    

    - name: hdi_AL      

  properties:          

  TARGET_CONTAINER: '~{hdi-aquisition}'

and the corresponding service:

resources: 

- name: hdi_AL   

  parameters:      

    config:         

      schema: UDWH_AL         

      logicalschema: SAPBZK   

  properties:      

    hdi-aquisition: ${service-name}   

    type: com.sap.xs.hdi-container

So far I have tried a lot of options to define the logicalschema without success.

How can I define the logicalschema in the yaml-file to use it properly in a virtualtableconfig?

Thank you in advance!!