#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
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
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
#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
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
Boost your Snowflake speed & save money ✔️ Parallel query processing ✔️ Independent warehouses ✔️ Pay-as-you-use model #SnowflakeTips #CloudComputing 👉 snowflakemasters.in
#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
snowflakemasters.in
Why Snowflake Clone Database is Key to Scalable Analytics
Snowflake Clone Database are a powerful feature that enables scalable analytics in Snowflake. With clone databases, users can create fully functional copies of databases
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
@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
You can acces the CREATE statement and data types of any object by executing the get_ddl function in @SnowflakeDB #snowflakeTips #sqlhelp #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
#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
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
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
Boost your Snowflake speed & save money ✔️ Parallel query processing ✔️ Independent warehouses ✔️ Pay-as-you-use model #SnowflakeTips #CloudComputing 👉 snowflakemasters.in
#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. Sonny Gray 5,662 posts
- 2. Dick Fitts N/A
- 3. #yummymeets N/A
- 4. Red Sox 6,135 posts
- 5. Clarke 5,965 posts
- 6. #GMMTV2026 4.28M posts
- 7. National Treasure 4,546 posts
- 8. Giolito N/A
- 9. Thankful 51.2K posts
- 10. Gone in 60 1,574 posts
- 11. Happy Thanksgiving 20.3K posts
- 12. Breslow N/A
- 13. Joe Ryan N/A
- 14. Chaim 1,079 posts
- 15. #csm221 4,802 posts
- 16. Chuck and Nancy 1,796 posts
- 17. Mark Kelly 253K posts
- 18. Academic All-District N/A
- 19. Raising Arizona N/A
- 20. #OurCosmicClue_Wooyoung 27.9K posts