SQL Connector Returning No Rows

Alan@SMTN
Alan@SMTN Member
in Connectors

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?

Tagged:

Answers

  • ArborRose
    ArborRose Coach

    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
    
)

    ** Was this post helpful? Click Agree or Like below. **
    ** Did this solve your problem? Accept it as a solution! **

  • Alan@SMTN
    Alan@SMTN Member

    Got it. I'll make those adjustments. Thanks.

Categories