Is it possible to use python to create parquet files from SQL table and store to Azure Storage Account?

Question

Python for parquet file creation

Answer 1

Yes. You can ingest data from a database via pandas.read_sql() https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.read_sql.html

You can write via DataFrame.to_parquet()
https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.to_parquet.html

I am not into azure but either there is a Python library for it our you can use the requests library for calling an API