CREATE VIEW
Creates a view
within a session which can be used to represent a long or complex stackql
query.
See also:
[ SELECT ]
Syntax
creatViewStatement::=
CREATE VIEW AS
<selectStatement> [ UNION | JOIN <selectStatement> ];
info
Available in version 0.3.x
and above.
Examples
Cross cloud UNION
between aws
and google
CREATE VIEW dual_cloud_block_storage AS
SELECT
'google' AS vendor,
name,
split_part(split_part(type, '/', 11), '-', 2) AS type,
status,
sizeGb AS size
FROM google.compute.disks
WHERE project = '<YOUR_GCP_PROJECT>'
AND zone = 'australia-southeast1-a'
UNION
SELECT
'aws' AS vendor,
volumeId AS name,
volumeType AS type,
status,
size
FROM aws.ec2.volumes
WHERE region = 'ap-southeast-2';