Snowflake has its own CLI tool: SnowSQL. In this level of the Stairway Series learn how to work with this dialect in Snowflake and Visual Studio Code.
2025-06-13 (first published: 2024-11-20)
1,967 reads
In this next level of the Stairway to Snowflake, learn about creating and dropping databases, with some options for cloning from different sources.
2025-06-13 (first published: 2025-01-15)
2,449 reads
How to create a connection for StreamLit and Snowflake to upload data for visualization
2024-12-20
2,550 reads
This next level of the Stairway to Snowflake looks at the Snowsight UI and what you can accomplish with it.
2025-06-13 (first published: 2024-10-23)
1,887 reads
This article shows how to access Snowflake information from Synapse Analytics.
2024-06-03
1,694 reads
Two of the top cloud services right now are Azure Synapse and Snowflake. Whatever your organization is implementing or if you need to transfer data to/from those services, it is important to know how to interconnect them and be able to transfer data between services.
2023-06-09
In this article, we look at how Snowflake handles deadlocks and the process of creating a deadlock and detecting a deadlock.
2023-05-29
Sometimes people say to avoid the snowflake schema and stick to a clean star schema. Why is that? Is something wrong with creating a snowflake schema?
2023-05-15
When working with Snowflake, it is important to understand the different types of tables available and when to use each one. In this tutorial, we will compare Snowflake temporary and transient tables, highlight their similarities and differences, and provide examples of when to use each type of table.
2023-03-31
SQL Server Analysis Services (SSAS) is an analytical data engine used in decision support and business analytics. It provides enterprise-grade semantic data models for business reports and client applications, such as Power BI, Excel, Reporting Services reports, and other data visualization tools. When paired with ADO.NET data providers, you can create cubes from external data […]
2019-04-30
3,621 reads
By James Serra
Microsoft Purview can be the best data governance tool in the world, but it...
I’ve been working on a project that combines two things I spend a lot...
Running AI and data pipelines on the edge instead of the cloud has gone...
Unfortunately I'm using SSMS 22. It didn't come with maintenance plans by default. I...
Comments posted to this topic are about the item Secure Cached Plans
Comments posted to this topic are about the item Complex Data Processing with dbt...
The DMV, sys.dm_exec_cached_plans, contains rows for each cached plan on an instance. In Azure SQL Database, not every used has rights to every database, as there does exist an instance behind each database. How is security handled for this DMV in Azure?
See possible answers