I am writing some queries in our Data Access Redshift db. I have an internal dataset I'd like to join to the Tealium data. What are my options for doing this ? To my knowledge: I can copy down my Tealium Redshift (Data Access) data to an internal database This would be very large and therefore infeasible I have experimented with a Tableau extract - which is a variation of the above idea . However, trying to do a local join of the extract with my internal data is still very expensive and each query run takes >1hr Can I however, upload my table to redshift so the data is co-located with the Tealium Redshift data. ? I can understand anyspace, privileges and performance concerns. However, is there a way to do this in a limited fashion ? (Such as temp-schema only, < 100 Mb , process priority down-revved) What other options exist?
... View more
Expand/CollapseMenu
