fabric/script

Run T-SQL inside a warehouse. Batches are split on GO lines and must not contain ${{ }}.

The step takes no nested steps:. It takes timeout: (HH:MM:SS or D.HH:MM:SS) and retry: { count, interval }; the default is the portal policy.

with.warehouse

The token name of the warehouse; gld_datawarehouse emits {{ .gld_datawarehouse_id }}.

with.sql

The T-SQL, GO-separated.

with.timeout

Per-block execution timeout, HH:MM:SS. Default 02:00:00.

Example

- id: merge_gold
  uses: fabric/script
  with:
    warehouse: gld_datawarehouse
    sql: |-
      CREATE SCHEMA IF NOT EXISTS History
      GO
      MERGE History.Period ...