Materialised view

[craftzneko]

Type: Bug

Unable to script to create on an existing materialised view. My view should look like this

CREATE MATERIALIZED VIEW ictsignal_lastscanperdevice AS
SELECT main.*
FROM ictsignal_production.ictsignal AS main
INNER JOIN (
    SELECT computername, MAX(datecreated) AS max_datecreated
    FROM ictsignal_production.ictsignal
    GROUP BY computername
) AS subquery ON main.computername = subquery.computername AND main.datecreated = subquery.max_datecreated;

but i get an error

Extension version: 0.6.0
Azure Data Studio version: azuredatastudio 1.48.0 (4970733324ef8254b7c22a5dc55af7f8a1dea93f, 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	11th Gen Intel(R) Core(TM) i7-11800H @ 2.30GHz (16 x 2304)
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)	63.73GB (46.72GB free)
Process Argv
Screen Reader	no
VM	0%

[craftzneko]

any update on this, i cant really use this plugin for my needs as i cant seem to see my views