Is there a way where I can export the Snowflake query results into Google Drive as a Spreadsheet using Python. I need to automate this process using Airflow.
Thanks in Advance!!
Is there a way where I can export the Snowflake query results into Google Drive as a Spreadsheet using Python. I need to automate this process using Airflow.
Thanks in Advance!!
Copyright © 2021 Jogjafile Inc.
You can use the SnowflakeOperator to unload directly into GCS https://docs.snowflake.com/en/user-guide/data-unload-gcs.html https://registry.astronomer.io/providers/snowflake/modules/snowflakeoperator
and then there is a GCSToGoogleSheets operator https://registry.astronomer.io/providers/google/modules/gcstogooglesheetsoperator