Database – Cloud Support

Deploying PostgreSQL using Terraform

Create main.tf file Added providers provider “azurerm” {     features {     } } 2. Added resource group which is already create.data “azurerm_resource_group” “rg”{     name = “jasdemo” } 3. Add random resource to generate random password for PostgreSQLresource “random_password” “postgresql-pass” {   length = 8   min_special = 2 } 4. […]

ETL on Azure using Azure Data Factory

Create data factory Data factory created as below screenshot Create SQL Server Database Database created as below screenshot Need to create Storage account In Storage Account create container input  and upload the csv file Created database in ETLdemo SQL Server Now we need to create pipeline on Databrick. We need click on Author and Monitor […]