community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE

Materialized View as Input

Meteoroid

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 ;

Quasar
Quasar

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,

Meteoroid

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?

Moderator
Moderator

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

Sophia Fraticelli
Customer Support Engineer
Labels