Creating Temp Tables in Azure data connector


I am playing around with the azure data connector and wondering if the ability exists to create temp tables when writing my query for the azure sql data warehouse connector?

I have been succesful in doing it with workbench but would be awesome if the same functionality exists with the Azure connection. I am currently getting this error "Domo is ready, but Azure SQL Data Warehouse returned "111212;Operation cannot be performed within a transaction."


  • user090374
    user090374 Domo Employee

    Hi @LukeLT,


    Unfortunately that connector only allows only the retrieving of files. This unfortunatley would be a feature request, but your CSM may be able to provide more insight on whether this can be implemented as Product Feedback.