Developer forum

Forum » Feature requests » Export functionality in SQL FireHose

Export functionality in SQL FireHose

E-mail notifications
Hans Ravnsfjall
Reply
Posted on 25/09/2015 16:53:29

It would be really nice, if it was possible to export the output you get when selecting/outputting somthing in SQL FIreHose

Regards Hans


Replies

 
Nuno Aguiar
Posted on 28/09/2015 12:03:32
Reply

+1

(for administrators only)

 
Jens Mouritzen
Jens Mouritzen
Posted on 13/02/2018 22:28:23
Reply

Has this improved since ?  Is it something we can do in DW 9  ?
I got a query that i would like to export from the SQL firehose

select o.OrderId, o.OrderCustomerName, o.OrderCustomerEmail,o.OrderDate, ol.OrderLineProductName, ol.OrderLineQuantity, ol.OrderLineOrderId
from EcomOrders o
left join EcomOrderLines ol on o.OrderId=ol.OrderLineOrderId

where OrderComplete = 1
and OrderDeleted = 'false'
and OrderDate like '%2018%'
and OrderComplete = 'true'
and OrderTransactionStatus = 'Succeeded'

and OrderLineType = 'product'