Materialized View as Input

Question

Good Day,

Can we use a Materialized View as Input, here is an example query.

create materialized view mv
as
select *
from t ;

select * from MV ;

simonaubert_bd · Answer

Hello @jmdeguia

As input, a materialized view is just like a table.

However, you can't create it (but you can vote for this idea to support it https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Ideas/in-Database-support-for-Materialized-Views/idi-p/1117726 )

SophiaF · Answer

@jmdeguia - a little late, but you will want a query compatible with the database you are using

jmdeguia · Answer

Thank you for the answer, a follow-up to that is that the query should be the same as above? or should it be based on what server the database is connected. The query above is for oracle, so if I'm using MS SQL Server it should be a query compatible for SQL Server?