How to Restore Deleted Rows in Snowflake

Quick Answer. For recovering deleted rows in Snowflake you can run the following query. Then verify the information that you want to restore is on that table. after that drop the target table and rename the clone table to replace the target table. If you … “How to Restore Deleted Rows in Snowflake”

Read More

How to compare two tables in Snowflake

Quick answer. For comparing two tables, run the following Script. Note. To make the comparisons, you should have the same number of columns and if you want to see the columns with differences next to each other, you should order it by some id that … “How to compare two tables in Snowflake”

Read More

How to delete duplicate records in snowflake

Duplicate records can be a common problem when working with large datasets in Snowflake. These duplicates can cause confusion and inaccuracies in your analysis and reporting. In this article, we will discuss a methods for identifying and deleting duplicate records in Snowflake. By the end … “How to delete duplicate records in snowflake”

Read More

How to Export/Import an Azure Data Factory ARM template

One of the first questions that we would have is what is an Azure Data Factory ARM template As Microsoft defines, it is a way to declare the objects you want, the types, names, and properties in a JSON file. This helps us to define … “How to Export/Import an Azure Data Factory ARM template”

Read More

How to create a Linked service to connect to an Azure Sql Server on Azure Data Factory

In this tutorial I am going to create a linked service to connect to an azure data Storage. Step 1. Select what kind of linked service do you want to create. On ADF there are various options to choose, we are going to select Azure … “How to create a Linked service to connect to an Azure Sql Server on Azure Data Factory”

Read More