How to enable sqlite introspection in datasource pane

[sumau]

I followed the sqlite example which as I understand executes the queries using duckDB. I wanted to execute the queries using sqlite so I created a sqlalchemy sqlite engine:

import sqlalchemy

sqlite_engine = sqlalchemy.create_engine("sqlite:///Chinook_Sqlite.sqlite")

This creates an additional SQLite Datasource but doesn't list all the tables:

Am I missing any steps?

[akshayka]

Thanks for using marimo :)

Does this help? https://docs.marimo.io/guides/working_with_data/sql/#database-schema-and-table-auto-discovery

[sumau]

It seems the auto discovery works on the DuckDB database but not the SQLite database

[Light2Dark]

Hey @sumau, this should be improved in marimo 0.11.18. Are you using an older version?

[sumau]

Yes I was using 0.11.14 but all fixed now thanks!