Spark Job Definitions: multiple lakehouses

Hi DennesTorres 

Welcome to Fabric Community and thanks for posting your question here.

As I understand that you are trying to list all the tables present in the Lakehouses. You can achieve this by running the below code in the notebook.

from pyspark.sql import SparkSession

spark = SparkSession \
    .builder \
    .appName("Python Spark SQL basic example") \
    .config("spark.some.config.option", "some-value") \
    .getOrCreate()
print("hello spark job definition")

# Get the list of lakehouses to read tables from.
lakehouses = ["lakehouse1", "lakehouse2"]

# Loop through the lakehouses and read all tables from each lakehouse.
for lakehouse in lakehouses:
    tables = spark.sql(f"SHOW TABLES IN {lakehouse}")
    print(tables)

Hope this helps, please do let us know if you have any queries.