Microsoft Fabric, Data Engineering, Data Science, Python.
time.time() # Assuming your file is a CSV file and named 'your_file.csv' file_path = '/lakehouse/default/Files/data/*.parquet' result = con.execute(f""" SELECT COUNT(VendorID) as count, sum(passenger_count) FROM read_parquet(\'{file_path}\') """).fetchdf() display(result) It’s remarkable how