Stairway to Snowflake Level 1 - An Introduction to Snowflake
Get an overview of Snowflake in this level, one of the fastest growing data warehouse platforms in the world.
2024-10-31 (first published: 2021-02-17)
10,238 reads
Get an overview of Snowflake in this level, one of the fastest growing data warehouse platforms in the world.
2024-10-31 (first published: 2021-02-17)
10,238 reads
In this next level of the Stairway to Snowflake, we look at the considerations for creating an account and how to set one up.
2024-10-31 (first published: 2021-05-24)
3,461 reads
Learn how you can configure a Snowflake account in your cloud database and load data.
2024-10-31 (first published: 2021-12-01)
2,090 reads
This next level of the Stairway to Snowflake looks at the Snowsight UI and what you can accomplish with it.
2024-10-31 (first published: 2024-10-23)
1,089 reads
In this next level of the Stairway to Biml, learn how metadata makes your Biml code more efficient and helpful in generating packages.
2024-02-14 (first published: 2016-11-09)
4,571 reads
In the next level of the Stairway to Biml, we breakdown the various elements in a Biml file to help you understand what parts of the files are used to control the package generation.
2014-07-02
10,254 reads
By Steve Jones
One of the things that I’ve been asked in every operations situation is what...
By Brian Kelley
If you are an introvert like me, events like the PASS Summit can call...
By kleegeek
On October 2nd and 3rd, I took part in an amazing event called AI...
The setup: 3 tables: core_users, core_roles, and core_user_roles. core users is the "base" table,...
I’m working with a SQL Server database that supports a multi-tenant application. We have...
Good Morning, I have built an SSIS package which produces Excel File Output. In...
I am building an ETL process between these tables in SQL Server 2022 set to 160 compatibility level:
CREATE TABLE Image_Staging ( imageid INT NOT NULL CONSTRAINT Image_StagingPK PRIMARY KEY , imagestatus TINYINT , imagebinary IMAGE); GO CREATE TABLE Images ( imageid INT NOT NULL CONSTRAINT ImagesPK PRIMARY KEY , imagestatus TINYINT , imagemodified DATETIME , imagebinary IMAGE); GOI want to run this query to check if the images already loaded exist. This will help me decide if I need to insert or update an image. What happens with this query?
SELECT i.imageid FROM dbo.Image_Staging AS ist INNER JOIN dbo.Images AS i ON ist.imagebinary = i.imagebinary;See possible answers