SQL Connector Returning No Rows

Alan@SMTN

I'm sure this has been answered but I can't find it, so I'm hoping this is a simple answer. I have a SQL dataset that was returning rows but currently returns no rows. This is expected and should continue to switch between returning rows and returning no rows. The issue is that when it returns no rows the dataset in DOMO is not being updated. I'm using the SQL Connector in DOMO. How do I set this up so that the DOMO dataset updates to match what's coming from SQL?

ArborRose

Domo generally updates when there is data. If it doesn't see data it won't update. You could maybe do a UNION with something to indicate no rows exist.

SELECT *

FROM your_table

WHERE some_condition


UNION ALL


SELECT 'No Data' AS column1, NULL AS column2, NULL AS column3

WHERE NOT EXISTS (

    SELECT 1

    FROM your_table

    WHERE some_condition

)