compare data between tables present in Oracle and Snowflake

Snowflake – How to compare data between tables present in Oracle and Snowflake?

There are several tools that you can use to compare data in Snowflake and Oracle. Some options include: SQL: You can use SQL queries to extract and compare data from both Snowflake and Oracle. This can be done using the SQL command line interfaces of both databases or using a SQL client tool such as...Continue reading

other cloud data platforms similar to Snowflake

Snowflake – What are other cloud data platforms similar to Snowflake?

There are several cloud data platforms that are similar to Snowflake and offer similar capabilities for storing, processing, and analyzing data in the cloud. Some examples of these platforms include: Amazon Redshift: A fully managed data warehousing service offered by Amazon Web Services (AWS). Redshift allows you to store and analyze large amounts of data...Continue reading

turning off or disabling unused tasks in Snowflake

Snowflake – Why turning off or disabling unused tasks in Snowflake is a best practice?

It is generally a good practice to turn off or disable tasks that are not being used because it can help to improve the performance and efficiency of your system. When a task is running, it consumes system resources such as CPU, memory, and storage. If a task is not being used, it is essentially...Continue reading

Why should you consider using DBeaver?

DBeaver is a free and open-source universal database management tool that has quickly become a favorite among developers. It offers a wide range of features that make it easy to work with databases, including support for various database engines and SQL and non-SQL queries. Dbeaver offers both a community edition (CE) which is free and...Continue reading

Snowflakes Limitations, challenges and weaknesses

Snowflake – What are some of the Snowflake’s Limitations?

Snowflake is undoubtedly one of the leading data warehouse technologies in today’s world and provides multiple benefits over its competitors. I have already covered the benefits of Snowflake in one of my older article. On contrary, in this article, I am going to capture the other side of the Snowflake — Limitations, challenges and weaknesses....Continue reading

Snowflake-to-Power-BI

How to Design a Power BI Dashboard Over Snowflake Data source

We are currently involved with one of our client’s ongoing Snowflake implementations, which will ultimately replace older, on-premises data marts in Oracle. Part of this engagement has included migrating Power BI data sources on top of Snowflake warehouses. The first step was to building Power BI dashboard over Snowflake is to connect to a Snowflake...Continue reading

Snowpark for Python

Snowflake – What is Snowpark for Pyhton?

In June 2022, Snowflake released the Snowpark for Python. Snowpark for Python has been designed to enable connection to Snowflake in a much more complex ways than the old Snowflake Connector for Python. Snowpark released as a new way to program data in Snowflake through a set of optimized APIs which includes native support for multiple...Continue reading

WHAT IS SNOWSQL

Snowflake – What is Snowflake SQL – SnowSQL?

SnowSQL is the Snowflake SQL command-line client that allows users to connect to Snowflake and execute Structured Query Language (SQL) queries.  Here are some facts about SnowSQL: Snowflake supports ANSI SQL, which is the most widely used standardized version of SQL. This implies that Snowflake SQL supports all of the most frequently used Data Definition Language...Continue reading

Why Alteryx

What is Alteryx?

Alteryx is a software solution that allows users to quickly access, manipulate, analyze, and output data. People typically use Alteryx to more quickly and efficiently get data processes completed and automated. This can be done in a process called a “workflow” on a recurring (daily, weekly, monthly) basis. The Alteryx workflows, is a form of...Continue reading

automated email notification when their disk space is lower than a specified threshold

How to send an email alert from MS SQL Server Instance when a given disk space is lower than a specified threshold

Several days ago, we received a request from one of our clients asking if we can set an automated email notification when their disk space is lower than a specified threshold. We learned that they run into an issue when one of their disks on the SQL Server were almost full and their nightly process...Continue reading

Scroll to top