HB Read Tabular Data (SQL) component not working?

[edpmay]

Given the following model:

the HB Read Tabular Data component outputs nothing (no values, no col_names, no row_names)?

If I look at the SQL file in something like SQLViewer, there is plenty of the data in the file though:

but the GH Component does not show it? It doesn’t give any errors or warnings either though?

If anyone has any ideas why that may be, I’d appreciate it?

thanks!
@edpmay

Environment:

• MacOS Sequoia 15.1.1
• Rhino v8 (8.15.24352.13002, 2024-12-17)
• Ladybug Tools v 1.8.61

Example File:

• example.gh (29.5 KB)

[TrevorFedyna]

Hi @edpmay, I don’t have any ideas but wanted to share that I dont think this is OS specific, I think I’m getting the same results on my windows machine:

for whatever that’s worth!
Best
-trevor

[behnammmohseni]

Hi @TrevorFedyna @edpmay

this is an open issue on the EP Dev team

Add Date and Time Format Options in `Output:SQLite`

maybe write on this page, to accelerate solving the issue

[edpmay]

I see now… for some reason I was thinking this component allowed me to access any arbitrary table from the SQL file - but it actually only reads data from the HTML output.

so not like… ‘database table’… but just ‘table table’… from the HTML

I get it now…

thanks!!
@edpmay