Materialized View as Input

[jmdeguia]

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 ;

[dataMack]

I think this is similar to your other question.  Yes- in this case you can use the PreSQL option on an input to perform this kind of operation,

[jmdeguia]

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?

[SophiaF]

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

[simonaubert_bd]

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... )