Snowflake
What is a window function in SQL?
Here is a nice general description from Snowflake’s documentation that summarizes clearly the answer to the question “What is a
Snowflake cloning rules certification good to know because you will probably be tested on it.
Additional rules taht apply to cloning objects – see the link below directly to Snowflakes documentation on the subject: https://docs.snowflake.com/en/sql-reference/sql/create-clone.html#additional-rules-that-apply-to-cloning-objects
Snowflake – using get with snowsql to copy a file from a user stage + plus unloading to json
1st login using snowsql snowsql -a <accountName> -u <username> now using your personal staging area which is designated by: @~
Using snowsql put a file in your user stage from a Windows client
Login snowsql -a <account> -u <username> List the files/objects in your user stage list @~; Copy a file named junk.txt
Make your DDL from get_ddl look pretty ( formatted ) in Snowflake UI – not Snowsight
Run a select statement with get_ddl in it like in the example below – then click on the result and
How do you know that a table in Snowflake might benefit from a Cluster Key and how to define them
1.) When a table is very large 2.) When querys degrade over time You do NOT have to define Snowflake
Free Snowflake Practice Test For SnowPro Core Certification
snowflake 5 practice tests – 60 questions per test – not bad practice – free https://www.youtube.com/playlist?list=PLba2xJ7yxHB7BLKzxvkMp5dGroiiQycQS
Snowflake Cancel Query by Query ID or Session or All Queries For a User – three ways
Cancel query can be accomplished either way: By session with: SYSTEM$CANCEL_ALL_QUERIES(session_id) By query with: SYSTEM$CANCEL_QUERY(query_id) Additionally you can do the
Snowflake Load Meta Data / Load_History
Yep, you guessed it, in the information_schema there is a load_history view: https://docs.snowflake.com/en/sql-reference/info-schema/load_history.html