PYTHON: Opening a CSV File with the DuckDB UI

[xchray]

Dear all,

in documentation: it is possible to call UI for a given csv file in CLI, can I achieve it using python? Even more, can I call memory table for viewing without CSV?

Thanks,

    con = duckdb.connect()
    stat = do_stat_work()
    con.execute(
        "CREATE TABLE if not exists statistics AS  FROM stat WITH NO DATA;"
    )
    con.execute("INSERT INTO statistics SELECT * FROM stat;")
    con.execute("call start_ui()")

[jraymakers]

If you start the UI from Python (as in your first example above), then the tables or views you create in Python will be visible in the UI.