Can we use SQL Views and Indexed Views as sources

[jmdeguia]

Hi,

I would like to know if it is possible to use SQL Views and Indexed Views as sources and/outputs and how it is done if it is possible.

Thank You.

[dataMack · Accepted solution]

A View or Table can be used in the input (standard or In-DB) tools.  No sure what you mean as far as using a view for an output- maybe you could provide more detail there?

[jmdeguia]

For input, If we can query Views and Index Views, and the same idea for output if we can query those.

[bjmcgovern]

Jason,

Can you supply the exact steps to connect to the SQL view as I can only see the SQL tables?

Regards,

BJ

[jroot]

I tried this with Snowflake and while I wasn't able to see Views in the visual query builder at first, I could find Views in the "Tables" tab to the left of the Visual Query Builder. Once I select a View from the "Tables" section, it would then populate in the Visual Query Builder. I also was able to use the SQL Editor to query from existing views.