stackql-deploy 2.2.0

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
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83

/*+ exists */
SELECT COUNT(*) as count 
FROM snowflake.database.databases
WHERE name = '{{ database_name }}'
AND endpoint = '{{ endpoint }}';

/*+ statecheck, retries=1, retry_delay=2 */
SELECT COUNT(*) as count 
FROM snowflake.database.databases
WHERE name = '{{ database_name }}'
AND endpoint = '{{ endpoint }}'
AND kind = '{{ kind }}'
AND comment = '{{ comment }}'
AND data_retention_time_in_days = {{ data_retention_time_in_days }}
AND log_level = '{{ log_level }}'
AND max_data_extension_time_in_days = {{ max_data_extension_time_in_days }}
AND suspend_task_after_num_failures = {{ suspend_task_after_num_failures }}
AND trace_level = '{{ trace_level }}'
AND user_task_managed_initial_warehouse_size = '{{ user_task_managed_initial_warehouse_size }}'
AND serverless_task_min_statement_size = '{{ serverless_task_min_statement_size }}'
AND serverless_task_max_statement_size = '{{ serverless_task_max_statement_size }}'
AND user_task_timeout_ms = {{ user_task_timeout_ms }}
;

/*+ create */
INSERT INTO snowflake.database.databases (
name,
kind,
comment,
data_retention_time_in_days,
log_level,
max_data_extension_time_in_days,
suspend_task_after_num_failures,
trace_level,
user_task_managed_initial_warehouse_size,
serverless_task_min_statement_size,
serverless_task_max_statement_size,
user_task_timeout_ms,
endpoint
)
SELECT 
'{{ database_name }}',
'{{ kind }}',
'{{ comment }}',
 {{ data_retention_time_in_days }},
'{{ log_level }}',
 {{ max_data_extension_time_in_days }},
 {{ suspend_task_after_num_failures }},
'{{ trace_level }}',
'{{ user_task_managed_initial_warehouse_size }}',
'{{ serverless_task_min_statement_size }}',
'{{ serverless_task_max_statement_size }}',
 {{ user_task_timeout_ms }},
'{{ endpoint }}'
;

/*+ update */
REPLACE snowflake.database.databases
SET 
kind = '{{ kind }}',
comment = '{{ comment }}',
data_retention_time_in_days = '{{ data_retention_time_in_days }}',
default_ddl_collation = '{{ default_ddl_collation }}',
log_level = '{{ log_level }}',
max_data_extension_time_in_days = '{{ max_data_extension_time_in_days }}',
suspend_task_after_num_failures = '{{ suspend_task_after_num_failures }}',
trace_level = '{{ trace_level }}',
user_task_managed_initial_warehouse_size = '{{ user_task_managed_initial_warehouse_size }}',
serverless_task_min_statement_size = '{{ serverless_task_min_statement_size }}',
serverless_task_max_statement_size = '{{ serverless_task_max_statement_size }}',
user_task_timeout_ms = '{{ user_task_timeout_ms }}'
WHERE 
name = '{{ database_name }}'
AND name = '{{ database_name }}'
AND endpoint = '{{ endpoint }}';

/*+ exports */
SELECT '{{ database_name }}' as database_name;

/*+ delete */
DELETE FROM snowflake.database.databases
WHERE name = '{{ database_name }}'
AND endpoint = '{{ endpoint }}';