Azure Data Factory: Autoscale Azure SQL Database From A Pipeline

preview_player
Показать описание
In this video Austin explains how to autoscale an Azure SQL Database from a pipeline for your ETL process. Follow along as he walks through the process of creating stored procedures to scale up and down the Azure SQL database and configures the pipeline to recognize when the database has been scaled up to run ETL processes.

-- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - -
Next step on your journey:

Let's connect:


Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: (904) 638-5743
#PragmaticWorks #AustinLibal #Azure #AzureDataFactory

-~-~~-~~~-~~-~-
Please watch: "(275) Free Pragmatic Works Power Apps Component Library "
-~-~~-~~~-~~-~-
Рекомендации по теме
Комментарии
Автор

Hi,
How to improve the complexity or increase in data volume?

Kindly lead or advise me below mention queries(Link, Documents, website).

1- Develops and maintains scale able data pipelines and builds out new API integrations to support continuing increases in data volume and complexity.

2- Collaborates with analytics and business teams to improve data models that feed business intelligence tools, increasing data accessibility and fostering data-driven decision making across the organisation.

3- Implements processes and systems to monitor data quality, ensuring production data is always accurate and available for key stakeholders and business processes that depend on it.

4- Writes unit/integration tests, contributes to engineering wiki, and documents work.

5- Performs data analysis required to troubleshoot data related issues and assist in the resolution of data issues.

6- Works closely with a team of front end and back end engineers, product managers, and analysts.

7- Designs data integrations and data quality framework.

8- Designs and evaluates open source and vendor tools for data lineage.

9- Works closely with all business units and engineering teams to develop strategy for long term data platform architecture.



Best Regards,

muhammadazam