How do I get the newest table name created in a DB (in Databricks), that has tables created once a week (names like output_20240530) show tables in “output_” does not give me a date when the tables were created Thanks, Lou

I can use the following and look through the results, but I need to pass the name to other queries and not have the person running the notebook have to do this
%sql
show tables in like “output_“