Google BigQuery: tabel name not found?

DocMusher

Hi dear RM friends,
I got RM connected to Google BigQuery as described earlier in this forum(https://community.rapidminer.com/discussion/comment/62988#Comment_62988).

However, finding the schema name is not a problem in a drop down list. For the tables, no suggestions are delivered. I also attempted just to enter a tabel name manually but without further success. 
I attached the screenshots I received while attempting to use the MIMIC-III database (on Google BigQuery) from inside RM. 

Anyone able to send me some feedback? 
Thanks
Sven

DocMusher

FIXED, copy dataset on BigQuery, new connection and this is the result

DocMusher

.... and its working 

sgenzer

ooh @DocMusher you figured out how to connect with MIMIC-III? That's great news!

Let me see if @phellinger has any ideas...

Scott

DocMusher

And this only the beginning because MIMIC-IV is almost ready: https://mimic-iv.mit.edu/
Hopefully, we can restart using RM for this type of datasets as they represent very good how multivariable time series are recorded in healthcare. For whom the bell tolls: an interesting paper: https://www.hindawi.com/journals/cmmm/2019/8152713/
Cheers Sven

sgenzer

@DocMusher can you share your RM process you're using now? You can send it via PM if you want. I'd like to take a look.

Scott

phellinger

Hi Sven,

thank you for the great screenshots!
Does the dropdown list not refresh after clicking the button next to it? What happens if you enter a valid name and run the process?

Can you see relevant log lines maybe when you open the Log panel via View->Show Panel (it can also be accessed by reading the file ~/.RapidMiner/rapidminer-studio.log).

Best,
Peter

DocMusher

Hi Peter, it gives message refreshing but with nothing appearing. I also tried to enter a table name myself but it did not accept or capture it. Logfiles I send 2morrow. Thanks