stackql-deploy 2.0.9

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

/*+ create */
INSERT INTO databricks_workspace.unitycatalog.schemas (
deployment_name,
name,
catalog_name,
comment
)
SELECT 
'{{ databricks_deployment_name }}',
'{{ name }}',
'{{ catalog_name }}',
'{{ comment }}'
;

/*+ statecheck */
SELECT COUNT(*) as count
FROM databricks_workspace.unitycatalog.schemas
WHERE deployment_name = '{{ databricks_deployment_name }}'
AND catalog_name = '{{ catalog_name }}'
AND name = '{{ name }}';

/*+ exports */
SELECT name as schema_name
FROM databricks_workspace.unitycatalog.schemas
WHERE deployment_name = '{{ databricks_deployment_name }}'
AND catalog_name = '{{ catalog_name }}'
AND name = '{{ name }}';