change data capture objects references

[arkdvd]

Type: Bug

Hello,
My setup:
I tried to setup additional project (secondary) for all change data capture tables and referenced them using cmd variable concept in main project in all code using them (example store proc in main project is using couple of cdc tables in joins).
Error message:
I could build my project successfully but when I tried deploying, script errored out complaining " '<$varibaleDBname>..' is not supported in this version of SQL Server." using Azure SQL DacpacTask in CI/CD devops.

Target Sql server : Azure Sql database

Question :
Is there any work around to fix this in Database sql project ?, looks like my set up isn't going to work. Any thouhgts and direction will help.

Thank you

Extension version: 1.4.2
Azure Data Studio version: azuredatastudio 1.48.0 (4970733, 2024-02-27T00:05:08.293Z)
OS version: Windows_NT x64 10.0.19045
Restricted Mode: No
Preview Features: Enabled
Modes:

System Info

Item	Value
CPUs	12th Gen Intel(R) Core(TM) i5-1250P (16 x 2112)
GPU Status	2d_canvas: enabled canvas_oop_rasterization: enabled_on direct_rendering_display_compositor: disabled_off_ok gpu_compositing: enabled multiple_raster_threads: enabled_on opengl: enabled_on rasterization: enabled raw_draw: disabled_off_ok video_decode: enabled video_encode: enabled vulkan: disabled_off webgl: enabled webgl2: enabled webgpu: enabled
Load (avg)	undefined
Memory (System)	15.67GB (1.28GB free)
Process Argv
Screen Reader	no
VM	0%