Skip to content

Commit ecc0a21

Browse files
localstack-botlocalstack-bot
committed
Updated function coverage docs
1 parent 55d0baa commit ecc0a21

File tree

2 files changed

+48
-40
lines changed

2 files changed

+48
-40
lines changed

‎src/content/docs/snowflake/features/index.md

Lines changed: 34 additions & 29 deletions
Original file line numberDiff line numberDiff line change
@@ -19,27 +19,32 @@ The content will be updated as additional query features and functions are imple
1919
### Applications
2020
| |ALTER|CREATE|DESCRIBE|DROP|SHOW|
2121
|----|----|----|----|----|----|
22-
|**APPLICATION**|❓|❓|❓|❓|❓|
22+
|**APPLICATION**|✅|✅|✅|✅|✅|
2323

2424
### Application Packages
2525
| |ALTER|CREATE|DROP|SHOW|
2626
|----|----|----|----|----|
27-
|**APPLICATION PACKAGE**|❓|❓|❓|❓|
27+
|**APPLICATION PACKAGE**|✅|✅|✅|✅|
2828

2929
### Catalog Integration
3030
| |ALTER|CREATE|DESCRIBE|DROP|SHOW|
3131
|----|----|----|----|----|----|
32-
|**CATALOG INTEGRATION**|❓|❓|❓|❓|❓|
32+
|**CATALOG INTEGRATION**|❓|✅|❓|✅|✅|
3333

3434
### Databases
3535
| |ALTER|CREATE|DESCRIBE|DROP|SHOW|UNDROP|USE|
3636
|----|----|----|----|----|----|----|----|
37-
|**DATABASE**|❓|❓|❓|❓|❓|❓|✅|
37+
|**DATABASE**|✅|✅|✅|✅|✅|❓|✅|
38+
39+
### Data and File Operations
40+
| |COPY INTO|GET|LIST|PUT|REMOVE|
41+
|----|----|----|----|----|----|
42+
|**FILE OPERATIONS**|✅|✅|✅|✅|✅|
3843

3944
### Dynamic Tables
4045
| |ALTER|CREATE|DESCRIBE|DROP|SHOW|UNDROP|
4146
|----|----|----|----|----|----|----|
42-
|**DYNAMIC TABLE**|❓|❓|❓|❓|❓|❓|
47+
|**DYNAMIC TABLE**|❓|✅|✅|✅|✅|❓|
4348

4449
### External Tables
4550
| |ALTER|CREATE|DESCRIBE|DROP|SHOW|
@@ -49,120 +54,120 @@ The content will be updated as additional query features and functions are imple
4954
### External Volumes
5055
| |ALTER|CREATE|DESCRIBE|DROP|SHOW|UNDROP|
5156
|----|----|----|----|----|----|----|
52-
|**EXTERNAL VOLUME**|❓|❓|❓|❓|❓|❓|
57+
|**EXTERNAL VOLUME**|✅|✅|✅|✅|✅|❓|
5358

5459
### File Formats
5560
| |ALTER|CREATE|DESCRIBE|DROP|SHOW|
5661
|----|----|----|----|----|----|
57-
|**FILE FORMAT**|❓|❓|❓|❓|❓|
62+
|**FILE FORMAT**|✅|✅|✅|✅|✅|
5863

5964
### Functions
6065
| |ALTER|CREATE|DESCRIBE|DROP|SHOW|
6166
|----|----|----|----|----|----|
62-
|**FUNCTION**|❓|❓|❓|❓|❓|
67+
|**FUNCTION**|✅|✅|✅|✅|✅|
6368

6469
### Hybrid Tables
6570
| |CREATE|SHOW|
6671
|----|----|----|
67-
|**HYBRID TABLE**|❓|❓|
72+
|**HYBRID TABLE**|✅|✅|
6873

6974
### Iceberg Tables
7075
| |ALTER|CREATE|DESCRIBE|DROP|SHOW|UNDROP|
7176
|----|----|----|----|----|----|----|
72-
|**ICEBERG TABLE**|❓|❓|❓|❓|❓|❓|
77+
|**ICEBERG TABLE**|❓|✅|❓|✅|❓|❓|
7378

7479
### Indexes
7580
| |CREATE|DROP|SHOW|
7681
|----|----|----|----|
77-
|**INDEX**|❓|❓|❓|
82+
|**INDEX**|✅|✅|✅|
7883

7984
### Materialized Views
8085
| |ALTER|CREATE|DESCRIBE|DROP|SHOW|TRUNCATE|
8186
|----|----|----|----|----|----|----|
82-
|**MATERIALIZED VIEW**|❓|❓|❓|❓|❓|❓|
87+
|**MATERIALIZED VIEW**|✅|✅|✅|✅|✅|✅|
8388

8489
### Pipes
8590
| |ALTER|CREATE|DESCRIBE|DROP|SHOW|
8691
|----|----|----|----|----|----|
87-
|**PIPE**|❓|❓|❓|❓|❓|
92+
|**PIPE**|✅|✅|✅|✅|✅|
8893

8994
### Procedures
9095
| |ALTER|CALL|CALL WITH|CREATE|DESCRIBE|DROP|SHOW|
9196
|----|----|----|----|----|----|----|----|
92-
|**PROCEDURE**|❓|❓|❓|❓|❓|❓|❓|
97+
|**PROCEDURE**|❓|✅|❓|✅|✅|✅|✅|
9398

9499
### Roles
95100
| |ALTER|CREATE|DROP|GRANT|REVOKE|SHOW|USE|
96101
|----|----|----|----|----|----|----|----|
97-
|**ROLE**|❓|❓|❓|❓|❓|❓|❓|
102+
|**ROLE**|❓|✅|✅|❓|❓|✅|✅|
98103

99104
### Row Access Policies
100105
| |ALTER|CREATE|DESCRIBE|DROP|SHOW|
101106
|----|----|----|----|----|----|
102-
|**ROW ACCESS POLICY**|❓|❓|❓|❓|❓|
107+
|**ROW ACCESS POLICY**|✅|✅|✅|✅|✅|
103108

104109
### Schemas
105110
| |ALTER|CREATE|DESCRIBE|DROP|SHOW|UNDROP|USE|
106111
|----|----|----|----|----|----|----|----|
107-
|**SCHEMA**|❓|❓|❓|❓|❓|❓|✅|
112+
|**SCHEMA**|✅|✅|✅|✅|✅|❓|✅|
108113

109114
### Sequences
110115
| |ALTER|CREATE|DESCRIBE|DROP|SHOW|
111116
|----|----|----|----|----|----|
112-
|**SEQUENCE**|❓|❓|❓|❓|❓|
117+
|**SEQUENCE**|✅|✅|✅|✅|✅|
113118

114119
### Shares
115120
| |ALTER|CREATE|DESCRIBE|DROP|SHOW|
116121
|----|----|----|----|----|----|
117-
|**SHARE**|❓|❓|❓|❓|❓|
122+
|**SHARE**|❓|✅|❓|✅|❓|
118123

119124
### Stages
120125
| |ALTER|CREATE|DESCRIBE|DROP|SHOW|
121126
|----|----|----|----|----|----|
122-
|**STAGE**|❓|❓|❓|❓|❓|
127+
|**STAGE**|✅|✅|✅|✅|✅|
123128

124129
### Storage Integrations
125130
| |ALTER|CREATE|DESCRIBE|DROP|SHOW|
126131
|----|----|----|----|----|----|
127-
|**STORAGE INTEGRATION**|❓|❓|❓|❓|❓|
132+
|**STORAGE INTEGRATION**|❓|✅|✅|✅|✅|
128133

129134
### Streams
130135
| |ALTER|CREATE|DESCRIBE|DROP|SHOW|
131136
|----|----|----|----|----|----|
132-
|**STREAM**|❓|❓|❓|❓|❓|
137+
|**STREAM**|✅|✅|✅|✅|✅|
133138

134139
### Streamlits
135140
| |ALTER|CREATE|DESCRIBE|DROP|SHOW|
136141
|----|----|----|----|----|----|
137-
|**STREAMLIT**|❓|❓|❓|❓|❓|
142+
|**STREAMLIT**|✅|✅|✅|✅|✅|
138143

139144
### Tables
140145
| |ALTER|CREATE|DESCRIBE|DROP|SHOW|TRUNCATE|UNDROP|
141146
|----|----|----|----|----|----|----|----|
142-
|**TABLE**|❓|✅|✅|✅|❓|❓|❓|
147+
|**TABLE**|✅|✅|✅|✅|✅|❓|❓|
143148

144149
### Tags
145150
| |ALTER|CREATE|DROP|SHOW|UNDROP|
146151
|----|----|----|----|----|----|
147-
|**TAG**|❓|❓|❓|❓|❓|
152+
|**TAG**|✅|✅|✅|✅|❓|
148153

149154
### Tasks
150155
| |ALTER|CREATE|DESCRIBE|DROP|EXECUTE|SHOW|
151156
|----|----|----|----|----|----|----|
152-
|**TASK**|❓|❓|❓|❓|❓|❓|
157+
|**TASK**|✅|✅|✅|✅|✅|✅|
153158

154159
### Users
155160
| |ALTER|CREATE|DESCRIBE|DROP|SHOW|
156161
|----|----|----|----|----|----|
157-
|**USER**|❓|❓|❓|❓|❓|
162+
|**USER**|✅|✅|❓|✅|✅|
158163

159164
### Views
160165
| |ALTER|CREATE|DESCRIBE|DROP|SHOW|
161166
|----|----|----|----|----|----|
162-
|**VIEW**|❓|❓|❓|❓|❓|
167+
|**VIEW**|✅|✅|✅|✅|✅|
163168

164169
### Warehouses
165170
| |ALTER|CREATE|DESCRIBE|DROP|SHOW|USE|
166171
|----|----|----|----|----|----|----|
167-
|**WAREHOUSE**|❓|❓|❓|❓|❓|❓|
172+
|**WAREHOUSE**|✅|✅|✅|✅|✅|✅|
168173

‎src/content/docs/snowflake/sql-functions.md

Lines changed: 14 additions & 11 deletions
Original file line numberDiff line numberDiff line change
@@ -176,7 +176,7 @@ The content will be updated as additional query features and functions are imple
176176
|CURRENT_SECONDARY_ROLES|✅|
177177
|CURRENT_SESSION|✅|
178178
|CURRENT_STATEMENT|✅|
179-
|CURRENT_TASK_GRAPHS|❓|
179+
|CURRENT_TASK_GRAPHS|✅|
180180
|CURRENT_TIME|✅|
181181
|CURRENT_TIMESTAMP|✅|
182182
|CURRENT_TRANSACTION|✅|
@@ -252,7 +252,7 @@ The content will be updated as additional query features and functions are imple
252252
|FINETUNE ('DESCRIBE') (SNOWFLAKE.CORTEX)|❓|
253253
|FINETUNE ('SHOW') (SNOWFLAKE.CORTEX)|❓|
254254
|FINETUNE (SNOWFLAKE.CORTEX)|❓|
255-
|FIRST_VALUE|❓|
255+
|FIRST_VALUE|✅|
256256
|FL_GET_CONTENT_TYPE|❓|
257257
|FL_GET_ETAG|❓|
258258
|FL_GET_FILE_TYPE|❓|
@@ -336,7 +336,7 @@ The content will be updated as additional query features and functions are imple
336336
|HLL_ESTIMATE|❓|
337337
|HLL_EXPORT|❓|
338338
|HLL_IMPORT|❓|
339-
|HOUR / MINUTE / SECOND|❓|
339+
|HOUR, MINUTE, SECOND|✅|
340340
|ICEBERG_TABLE_FILES|❓|
341341
|ICEBERG_TABLE_SNAPSHOT_REFRESH_HISTORY|❓|
342342
|IFF|✅|
@@ -376,13 +376,13 @@ The content will be updated as additional query features and functions are imple
376376
|JAROWINKLER_SIMILARITY|❓|
377377
|JSON_EXTRACT_PATH_TEXT|❓|
378378
|KURTOSIS|❓|
379-
|LAG|❓|
379+
|LAG|✅|
380380
|LAST_DAY|✅|
381381
|LAST_QUERY_ID|✅|
382382
|LAST_SUCCESSFUL_SCHEDULED_TIME|❓|
383383
|LAST_TRANSACTION|❓|
384384
|LAST_VALUE|❓|
385-
|LEAD|❓|
385+
|LEAD|✅|
386386
|LEAST|✅|
387387
|LEAST_IGNORE_NULLS|✅|
388388
|LEFT|❓|
@@ -450,7 +450,7 @@ The content will be updated as additional query features and functions are imple
450450
|PARSE_JSON|✅|
451451
|PARSE_URL|❓|
452452
|PARSE_XML|❓|
453-
|PERCENT_RANK|❓|
453+
|PERCENT_RANK|✅|
454454
|PERCENTILE_CONT|❓|
455455
|PERCENTILE_DISC|❓|
456456
|PI|✅|
@@ -510,7 +510,7 @@ The content will be updated as additional query features and functions are imple
510510
|SEARCH_OPTIMIZATION_HISTORY|❓|
511511
|SEARCH_PREVIEW (SNOWFLAKE.CORTEX)|❓|
512512
|SENTIMENT (SNOWFLAKE.CORTEX)|❓|
513-
|SEQ1 / SEQ2 / SEQ4 / SEQ8|❓|
513+
|SEQ1, SEQ2, SEQ4, SEQ8|✅|
514514
|SERVERLESS_ALERT_HISTORY|❓|
515515
|SERVERLESS_TASK_HISTORY|❓|
516516
|SHA1, SHA1_HEX|❓|
@@ -609,6 +609,7 @@ The content will be updated as additional query features and functions are imple
609609
|SYSTEM$ADD_REFERENCE|❓|
610610
|SYSTEM$ALLOWLIST|❓|
611611
|SYSTEM$ALLOWLIST_PRIVATELINK|❓|
612+
|SYSTEM$APP_COMPATIBILITY_CHECK|❓|
612613
|SYSTEM$APPLICATION_GET_LOG_LEVEL|❓|
613614
|SYSTEM$APPLICATION_GET_METRIC_LEVEL|❓|
614615
|SYSTEM$APPLICATION_GET_TRACE_LEVEL|❓|
@@ -688,6 +689,8 @@ The content will be updated as additional query features and functions are imple
688689
|SYSTEM$HOLD_PRIVILEGE_ON_ACCOUNT|❓|
689690
|SYSTEM$INITIATE_MOVE_ORGANIZATION_ACCOUNT|❓|
690691
|SYSTEM$INTERNAL_STAGES_PUBLIC_ACCESS_STATUS|❓|
692+
|SYSTEM$IS_APPLICATION_ALL_MANDATORY_TELEMETRY_EVENT_DEFINITIONS_ENABLED|❓|
693+
|SYSTEM$IS_APPLICATION_AUTHORIZED_FOR_TELEMETRY_EVENT_SHARING|❓|
691694
|SYSTEM$IS_APPLICATION_INSTALLED_FROM_SAME_ACCOUNT|❓|
692695
|SYSTEM$IS_APPLICATION_SHARING_EVENTS_WITH_PROVIDER|❓|
693696
|SYSTEM$IS_GLOBAL_DATA_SHARING_ENABLED_FOR_ACCOUNT|❓|
@@ -755,7 +758,7 @@ The content will be updated as additional query features and functions are imple
755758
|SYSTEM$WHITELIST — Deprecated|❓|
756759
|SYSTEM$WHITELIST_PRIVATELINK — Deprecated|❓|
757760
|SYSTIMESTAMP|❓|
758-
|TAG_REFERENCES|❓|
761+
|TAG_REFERENCES|✅|
759762
|TAG_REFERENCES_ALL_COLUMNS|❓|
760763
|TAG_REFERENCES_WITH_LINEAGE|❓|
761764
|TAN|✅|
@@ -785,7 +788,7 @@ The content will be updated as additional query features and functions are imple
785788
|TO_OBJECT|✅|
786789
|TO_QUERY|❓|
787790
|TO_TIME, TIME|✅|
788-
|TO_TIMESTAMP / TO_TIMESTAMP_*|❓|
791+
|TO_TIMESTAMP, TO_TIMESTAMP_*|✅|
789792
|TO_VARIANT|✅|
790793
|TO_XML|❓|
791794
|TRANSFORM|❓|
@@ -812,7 +815,7 @@ The content will be updated as additional query features and functions are imple
812815
|TRY_TO_GEOGRAPHY|❓|
813816
|TRY_TO_GEOMETRY|❓|
814817
|TRY_TO_TIME|❓|
815-
|TRY_TO_TIMESTAMP / TRY_TO_TIMESTAMP_*|❓|
818+
|TRY_TO_TIMESTAMP, TRY_TO_TIMESTAMP_*|✅|
816819
|TYPEOF|❓|
817820
|UNICODE|❓|
818821
|UNIFORM|❓|
@@ -832,7 +835,7 @@ The content will be updated as additional query features and functions are imple
832835
|WAREHOUSE_METERING_HISTORY|❓|
833836
|WIDTH_BUCKET|❓|
834837
|XMLGET|❓|
835-
|YEAR* / DAY* / WEEK* / MONTH / QUARTER|❓|
838+
|YEAR*, DAY*, WEEK*, MONTH, QUARTER|✅|
836839
|ZEROIFNULL|✅|
837840
|ZIPF|❓|
838841

0 commit comments

Comments
 (0)