Yes, you can use standard SQL constructs such as INSERT statements and COPY to load data into DuckLake.
(diclaimer: I work at DuckDB Labs)
(diclaimer: I work at DuckDB Labs)
> About the COPY statement, it means we can drop Parquet files ourselves in the blob storage ?
Dropping the Parquet files on the blob storage will not work – you have to COPY them through DuckLake so that the catalog databases is updated with the required catalog and metadata information.