#snowflaketips search results
You can acces the CREATE statement and data types of any object by executing the get_ddl function in @SnowflakeDB #snowflakeTips #sqlhelp #sql #sqlTips
@SnowflakeDB no tiene cursores ni DO WHILE. Logre hacer un acumulador anidando SELECTs y creando una columna que utilizaba para guardar el valor acumulado en vez de una variable. #SnowflakeTips #Data #SQL #SQLtips
@SnowflakeDB has neither cursor or DO WHILE. I managed to build an accumulator by nesting SELECTs and creating a new column to store the accumulated value instead of a variable. #SnowflakeTips #Data #SQL #SQLtips
There is no SELECT * INTO #sessionTable FROM MyPersistentTable statement in @SnowflakeDB. If you need to create a session temporary tables do it like this ⬇️ #SnowflakeTips #sqlhelp #SQLTips #data #SQL
Para generar un ID único en un SELECT como si fuera el IDENTITY de una tabla se puede usar la función ROW_NUMBER ordenadopor toda la clave de la tabla. #SQLtip recien aprendido. #sqlhelp @SnowflakeDB #SnowflakeTips
In order to limit the amount of rows you want to select from a table in @SnowflakeDB you can use de LIMIT statement. #SnowflakeTips #SQL #SQLTips #data
#snowflaketips 8: Ever wonder how to tell if query hit the result cache? The WAREHOUSE_SIZE will be null for the query. One caveat is that there are some queries that don't use a warehouse that also don't use result cache. #snowflakedb #bigdata #analytics #sql
Create your tables as TRANSIENT if you don't want to give your DBA a heart attack, but beware, there is no Fail-safe period for TRANSIENT tables. For more info in temporary and transient tables you can check the @SnowflakeDB docs: docs.snowflake.net/manuals/user-g… #SnowflakeTips #sqlhelp
Boost your Snowflake speed & save money ✔️ Parallel query processing ✔️ Independent warehouses ✔️ Pay-as-you-use model #SnowflakeTips #CloudComputing 👉 snowflakemasters.in
You can convert rows into columns using the PIVOT statement in @SnowflakeDB. More info in docs.snowflake.net/manuals/sql-re… #SnowflakeTips #SQL #sqlhelp #data #sqlTips
#snowflaketips 7: Did you know that Snowflake provides the last year worth of query_history via the SNOWFLAKE data share in the ACCOUNT_USAGE schema? Check out more info here: docs.snowflake.net/manuals/sql-re… #snowflakedb #bigdata #analytics #sql #datasharing
snowflakemasters.in/snowflake-clon… Master Snowflake Clone Database techniques! Learn how to efficiently replicate databases and save storage costs. #DataEngineering #SnowflakeTips
Get query history without using snowflake history tab tech-findings.com/2021/08/How-to… #snowflake #snowflaketips
Started collecting all my #snowflaketips here: gcdatagroup.com/2019/10/10/sno… #bigdata #snowflakedb #data #sql
#snowflaketips 6: Snowflake has a suite of Data Generation functions. Very handy for generating data at scale. There are functions for Normal, Zipf, uniform and random. Read more here at the link below #snowflakedb #bigdata #data #analytics #sql docs.snowflake.net/manuals/sql-re…
Boost your Snowflake speed & save money ✔️ Parallel query processing ✔️ Independent warehouses ✔️ Pay-as-you-use model #SnowflakeTips #CloudComputing 👉 snowflakemasters.in
Get query history without using snowflake history tab tech-findings.com/2021/08/How-to… #snowflake #snowflaketips
Started collecting all my #snowflaketips here: gcdatagroup.com/2019/10/10/sno… #bigdata #snowflakedb #data #sql
#snowflaketips 8: Ever wonder how to tell if query hit the result cache? The WAREHOUSE_SIZE will be null for the query. One caveat is that there are some queries that don't use a warehouse that also don't use result cache. #snowflakedb #bigdata #analytics #sql
#snowflaketips 7: Did you know that Snowflake provides the last year worth of query_history via the SNOWFLAKE data share in the ACCOUNT_USAGE schema? Check out more info here: docs.snowflake.net/manuals/sql-re… #snowflakedb #bigdata #analytics #sql #datasharing
#snowflaketips 6: Snowflake has a suite of Data Generation functions. Very handy for generating data at scale. There are functions for Normal, Zipf, uniform and random. Read more here at the link below #snowflakedb #bigdata #data #analytics #sql docs.snowflake.net/manuals/sql-re…
You can acces the CREATE statement and data types of any object by executing the get_ddl function in @SnowflakeDB #snowflakeTips #sqlhelp #sql #sqlTips
In order to limit the amount of rows you want to select from a table in @SnowflakeDB you can use de LIMIT statement. #SnowflakeTips #SQL #SQLTips #data
Create your tables as TRANSIENT if you don't want to give your DBA a heart attack, but beware, there is no Fail-safe period for TRANSIENT tables. For more info in temporary and transient tables you can check the @SnowflakeDB docs: docs.snowflake.net/manuals/user-g… #SnowflakeTips #sqlhelp
There is no SELECT * INTO #sessionTable FROM MyPersistentTable statement in @SnowflakeDB. If you need to create a session temporary tables do it like this ⬇️ #SnowflakeTips #sqlhelp #SQLTips #data #SQL
You can convert rows into columns using the PIVOT statement in @SnowflakeDB. More info in docs.snowflake.net/manuals/sql-re… #SnowflakeTips #SQL #sqlhelp #data #sqlTips
@SnowflakeDB has neither cursor or DO WHILE. I managed to build an accumulator by nesting SELECTs and creating a new column to store the accumulated value instead of a variable. #SnowflakeTips #Data #SQL #SQLtips
@SnowflakeDB no tiene cursores ni DO WHILE. Logre hacer un acumulador anidando SELECTs y creando una columna que utilizaba para guardar el valor acumulado en vez de una variable. #SnowflakeTips #Data #SQL #SQLtips
@SnowflakeDB no tiene cursores ni DO WHILE. Logre hacer un acumulador anidando SELECTs y creando una columna que utilizaba para guardar el valor acumulado en vez de una variable. #SnowflakeTips #Data #SQL #SQLtips
You can acces the CREATE statement and data types of any object by executing the get_ddl function in @SnowflakeDB #snowflakeTips #sqlhelp #sql #sqlTips
@SnowflakeDB has neither cursor or DO WHILE. I managed to build an accumulator by nesting SELECTs and creating a new column to store the accumulated value instead of a variable. #SnowflakeTips #Data #SQL #SQLtips
#snowflaketips 8: Ever wonder how to tell if query hit the result cache? The WAREHOUSE_SIZE will be null for the query. One caveat is that there are some queries that don't use a warehouse that also don't use result cache. #snowflakedb #bigdata #analytics #sql
There is no SELECT * INTO #sessionTable FROM MyPersistentTable statement in @SnowflakeDB. If you need to create a session temporary tables do it like this ⬇️ #SnowflakeTips #sqlhelp #SQLTips #data #SQL
Para generar un ID único en un SELECT como si fuera el IDENTITY de una tabla se puede usar la función ROW_NUMBER ordenadopor toda la clave de la tabla. #SQLtip recien aprendido. #sqlhelp @SnowflakeDB #SnowflakeTips
In order to limit the amount of rows you want to select from a table in @SnowflakeDB you can use de LIMIT statement. #SnowflakeTips #SQL #SQLTips #data
Create your tables as TRANSIENT if you don't want to give your DBA a heart attack, but beware, there is no Fail-safe period for TRANSIENT tables. For more info in temporary and transient tables you can check the @SnowflakeDB docs: docs.snowflake.net/manuals/user-g… #SnowflakeTips #sqlhelp
Boost your Snowflake speed & save money ✔️ Parallel query processing ✔️ Independent warehouses ✔️ Pay-as-you-use model #SnowflakeTips #CloudComputing 👉 snowflakemasters.in
You can convert rows into columns using the PIVOT statement in @SnowflakeDB. More info in docs.snowflake.net/manuals/sql-re… #SnowflakeTips #SQL #sqlhelp #data #sqlTips
#snowflaketips 7: Did you know that Snowflake provides the last year worth of query_history via the SNOWFLAKE data share in the ACCOUNT_USAGE schema? Check out more info here: docs.snowflake.net/manuals/sql-re… #snowflakedb #bigdata #analytics #sql #datasharing
Something went wrong.
Something went wrong.
United States Trends
- 1. Steelers 50.9K posts
- 2. Tomlin 17.9K posts
- 3. Vikings 31.5K posts
- 4. Bills 85K posts
- 5. Josh Allen 12.1K posts
- 6. Rodgers 13.2K posts
- 7. Brock Bowers 3,794 posts
- 8. Ole Miss 110K posts
- 9. Howard 12.3K posts
- 10. Justin Jefferson 4,979 posts
- 11. #HereWeGo 4,434 posts
- 12. Panthers 55.6K posts
- 13. Seahawks 25.1K posts
- 14. Brosmer 11.5K posts
- 15. Rodney Harrison N/A
- 16. Herbert 11K posts
- 17. #Skol 3,102 posts
- 18. Mason Rudolph 1,812 posts
- 19. Arthur Smith 1,441 posts
- 20. Chargers 23.5K posts