stackql-deploy 2.0.7

Infrastructure-as-code framework for declarative cloud resource management using StackQL
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53

/*+ exists */
SELECT
count(*) as count
FROM databricks_workspace.catalog.external_locations
WHERE name = '{{ name }}' 
AND deployment_name = '{{ deployment_name }}'
;

/*+ create */
INSERT INTO databricks_workspace.catalog.external_locations (
name,
url,
credential_name,
comment,
read_only,
skip_validation,
deployment_name
)
SELECT 
'{{ name }}',
'{{ url }}',
'{{ credential_name }}',
'{{ comment }}',
{{ read_only }},
{{ skip_validation }},
'{{ deployment_name }}'
RETURNING *
;

/*+ update */
UPDATE databricks_workspace.catalog.external_locations
SET 
comment = '{{ comment }}',
credential_name = '{{ credential_name }}',
read_only = {{ read_only }},
skip_validation = {{ skip_validation }},
url = '{{ url }}'
WHERE name = '{{ name }}'
AND deployment_name = '{{ deployment_name }}'
RETURNING *;

/*+ exports, retries=5, retry_delay=10 */
SELECT name as external_location_name
FROM databricks_workspace.catalog.external_locations
WHERE deployment_name = '{{ deployment_name }}'
AND name = '{{ name }}'
;

/*+ delete */
DELETE FROM databricks_workspace.catalog.external_locations
WHERE name = '{{ name }}' 
AND deployment_name = '{{ deployment_name }}'
RETURNING *;