I have a data source which is a custom SQL query- connected to a Redshift DB as extract.
I was wondering if I can create another Redshift connected data source based on that existent data source- since they are both queries.
data source 1: select * from table
data source 2: select * from data source 1 left join table2 ...
That's the database views are for.
CREATE VIEW your_view_name AS SELECT * FROM your_table_1 ;
CREATE VIEW your_view_name AS
SELECT * FROM your_table_1 ;
SELECT your_view_name LEFT JOIN your_table_2 ...
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...