To be used for posts related to Snowflake tasks: https://docs.snowflake.com/en/user-guide/tasks-intro.html
Questions tagged [snowflake-task]
125 questions
0
votes
1 answer
Snowflake Stream data retaining
I created a Stream in Snowflake on a table and created a task to move the data to a table. Even after the task is complete the data in the stream is not purging. Because of that the task is not getting skipped and keep reinserting data from stream…
Kamalakannan Babuji
- 57
- 4
0
votes
2 answers
Is there a way to get the information about cancelled query
In our snowflake, we have multiple users accessing the database. And sometimes when query takes long time people are cancelling the query from UI.
I was wondering if there is a way to get information about who has cancelled the query.
Like we have…
danD
- 666
- 1
- 7
- 29
0
votes
1 answer
How do I retrieve INCREMENT for Sequences in snowflake?
(select INCREMENT from TEST_DB.INFORMATION_SCHEMA.SEQUENCES
Why this is not working but it working in other properties retrieval
0
votes
2 answers
How do you get DDL of a task in Snowflake?
In Snowflake, you can use the get_ddl function like this to get ddl for tables, views and procedures:
select get_ddl('view', 'SOME_VIEW_I_CREATED')
But it doesn't seem you can do this with tasks.
Is there any way to easily get DDL for snowflake…
Trevor
- 4,620
- 2
- 28
- 37
-1
votes
1 answer
How to convert a Julian date into timestamp in Snowflake
I have dates like 54940,55001,54970 etc.
I need to convert these dates into yyyy-MM-dd format in snowflake
Neha Nayal
- 21
- 4