Hi there, we can use an Azure Function to move data from Snowflake S3 to Azure Blob Storage. This function would be started by a daily timer. We can transfer data effectively by using an Azure Function and Snowflake's COPY INTO command.
Have you set up the S3 integration for Snowflake yet? Which particular data formats and volumes are we working with? Would you require any data transformations or additional processing during the transfer?
My skills and expertise include:
- MS Azure Services.
- Developing, Deploying and configuring Azure Web Apps, Azure App Services using Visual Studio, experience in cloud migration and integration.
- Azure Active Directory, ADFS, OAuth, SAML for authentication/Authorization.
- Building solutions using Event Hub, Service Bus, Blob Storage, Azure Files, Table Storage.
- Developing and Hosting REST API using Azure API Management, Swagger and integration with Azure web apps.
- Designing, hosting, and managing data in SQL Azure, Document DB, Mongo DB, Table Storage, Azure Data Lake, and blob storage.
Looking forward to potentially teaming up on this exciting project!
Best regards,
Imtiyaz JN