Most of us have run across the scenario where we have data in one table, but we need the exact same data in another table in another database. In SQL Server, I’d do it this way: INSERT INTO TableB (FirstName, LastName) SELECT FirstName, LastName FROM TableA; Yes, pretty simple. Basically, we’re grabbing all of the…… Continue reading Pushing data into one table from another in Snowflake
Month: November 2024
Now you want to see query results in email from Snowflake
In our last post, we discussed the most basic of all ways how in Snowflake you can send out a basic email. It was pretty simple, straight text – nothing to really grab the attention of our readers – which we know is the way to craft an email, right? To do this, we’re going…… Continue reading Now you want to see query results in email from Snowflake