Gilbert Quevauvilliers continues a series on Python notebooks and DuckDB:
In this blog post I am going to explain how to loop through a data frame to query data and write once to a Lakehouse table.
The example I will use is to loop through a list of dates which I get from my date table, then query an API, append to an existing data frame and finally write once to a Lakehouse table.
Click through for the code, as well as a sample notebook you can use.