Yahia M.

Ah thanks for clarifying! Will update you here as soon as I hear back on its availability!

Hi Koen, We don't have that yet but I've added your feature request! In the meantime, would using the MotherDuck CLI be a feasible alternative? You can then run motherduck flight run --flight <id-or-url>

Also, do you have a ~/.duckdbrc file? If so, can you share its contents or any commands used there?

Could you run these and paste back what you get, this will help figure out the any access issues to the schema:

SELECT schemata.schema_name, tables.table_name
FROM system.information_schema.schemata AS schemata
LEFT JOIN system.information_schema.tables AS tables
  ON tables.table_catalog = schemata.catalog_name
  AND tables.table_schema = schemata.schema_name
WHERE schemata.catalog_name = 'lhr';

and

SELECT extension_name, extension_version FROM duckdb_extensions() WHERE loaded;

will tell us the loaded extensions. Thanks!

Thanks for sharing the screenshots, taking a look!

Thanks for testing it! Looking at your new screenshot, MotherDuck looks like it is no longer connected in that session: my_db and sample_data have dropped out of the list, can you confirm if that is the case? Could you try this: In the editor, run ATTACH 'md:'; and then reload the page. Do my_db and sample_data come back, and does lhr list its tables?

Thanks for the screenshots and description! Two things if you don't mind:

If the tables come back after that, let me know which databases you had attached when it froze. The sidebar loads all of them together, so one that is slow to respond may slow down the whole list.

Docs are updated here! Let me know if you have any further questions!

Glad it worked! Absolutely, I'll follow up with the team to update the docs, apologies for the friction here! 😅

Thanks for sharing the screenshots! You're right that the Looker docs (here) don't cover Looker Studio, as they're different connectors. Two things worth changing:

SELECT * FROM remote_flowers.main.<your_table>

Out of interest, do you need the table picker for browsing, or is one query per data source workable? If browsing matters there's a way to get that populated too, happy to share it.