Materialized View as Input
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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 ;
- Labels:
- In Database
- Input
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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,
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@jmdeguia - a little late, but you will want a query compatible with the database you are using
Senior Solutions Architect
Alteryx, Inc.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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... )