@azbake/ingredient-sql-dwh

Ingredient for deploying an instance of SQL Data Warehouse.

Usage no npm install needed!

<script type="module">
  import azbakeIngredientSqlDwh from 'https://cdn.skypack.dev/@azbake/ingredient-sql-dwh';
</script>

README

Changelogs

Overview

The SQL Data Warehouse ingredient is a plugin for bake. When included in a recipe, this will create a SQL Data Warehouse.

Usage

name: sqlserver-sql-dwh
shortName: sqldwh
version: 1.0.0
ingredients:
  - "@azbake/ingredient-sql-dwh@0~"
resourceGroup: true
rgOverride: HCHB_DataAdmins_DataWarehouse_Dev
parallelRegions: false
variables:
  databaseName : "testsqldwh"
  skuName : "DW100c"
  serverName : "testsqlserverlogical"
  serverLocation : "centralus"
  collation : "SQL_Latin1_General_CP1_CI_AS"
  databaseTags : {}
recipe:
  namespace:
    properties:
      type: "@azbake/ingredient-sql-dwh"
      parameters:
        databaseName : "[coreutils.variable('databaseName')]"
        skuName : "[coreutils.variable('skuName')]"
        serverName : "[coreutils.variable('serverName')]"
        serverLocation : "[coreutils.variable('serverLocation')]"
        collation : "[coreutils.variable('collation')]"
        databaseTags : "[coreutils.variable('databaseTags')]"
property required description
databaseName yes The name of the SQL Data Warehouse.
requestedServiceObjectiveId Yes Service tier of the SQL Data Warehouse. Use the Capabilities_ListByLocation REST API
serverName Yes Logical SQL Server Name.
serverLocation Yes Azure data center location.
collation Yes Database collation
databaseTags no (default:Default) Resource tags

Utilities

Utility classes can be used inside of the bake.yaml file for parameter and source values.

SqlServerLogicalUtils class

| function | description | | create_resource_name() | Returns the name created for the Service Bus Namespace when deployed |

Function Details

create_resource_name()

Gets the name created for the App Service Plan when deployed.

...
parameters:
    planName: "[SqlServerLogicalUtils.create_resource_name()]"
...
Returns

string