Skip to main content

Creating Infrastructure Templates

See also:
[exec] [INSERT] [SHOW] [ Using Variables ]

Cloud resources are deployed with StackQL using INSERT statements. INSERT templates for different cloud resources can be generated using the SHOW INSERT command.

Generating an INSERT template using the SHOW INSERT command​

An example of generating a template is shown here:

SHOW INSERT INTO google.compute.addresses;

This can be run through the shell or using an exec command as shown here:

./stackql exec 'show insert into google.compute.addresses' --output text --hideheaders

Returns :

INSERT INTO google.compute.addresses(
project,
region,
data__address,
data__addressType,
data__description,
data__ipVersion,
data__name,
data__network,
data__networkTier,
data__prefixLength,
data__purpose,
data__subnetwork
)
SELECT
'{{ .values.project }}',
'{{ .values.region }}',
'{{ .values.data__address }}',
'{{ .values.data__addressType }}',
'{{ .values.data__description }}',
'{{ .values.data__ipVersion }}',
'{{ .values.data__name }}',
'{{ .values.data__network }}',
'{{ .values.data__networkTier }}',
{{ .values.data__prefixLength }},
'{{ .values.data__purpose }}',
'{{ .values.data__subnetwork }}'

This template can then be used along with a json or jsonnet data file to supply values at run time; for more information see Using Variables.

Generating an INSERT template with only required parameters​

To generate a StackQL INSERT template with only mandatory attributes use the /*+ REQUIRED */ query hint as shown here:

SHOW INSERT /*+ REQUIRED */ INTO google.compute.instances;

This can be run through the shell or using an exec command as shown here:

./stackql exec 'show insert /*+ REQUIRED */ into google.compute.instances' --output text -H

Returns :

INSERT INTO google.compute.instances(
project,
zone,
data__machineType,
data__name
)
SELECT
'{{ .values.project }}',
'{{ .values.zone }}',
'{{ .values.data__machineType }}',
'{{ .values.data__name }}'
;