Connect Alteryx to Snowflake AzureAD

How to connect to Snowflake authenticating with Azure AD SSO from Alteryx ODBC driver

Connecting to Snowflake using Azure AD SSO (Single Sign-On) from the Alteryx ODBC driver can be a bit tricky, but with the right steps, it is definitely doable. In this blog post, we will walk through the process of setting up SSO with Snowflake and Alteryx, so that you can easily connect to your Snowflake...Continue reading

Connect DBeaver to Snowflake AzureAD

Snowflake – Azure DB – How to Connect DBeaver to Snowflake / AzureAD

DBeaver is a popular open-source database management tool that allows you to connect to various database systems, including Snowflake / AzureAD. This blog post, will show you how to connect DBeaver to Snowflake / AzureAD. Connecting to Snowflake: Launch DBeaver and click on the “New Connection” button in the toolbar. In the “New Connection” wizard,...

history data from Snowflake

Snowflake – How to fetch history data from Snowflake without using UI?

The Snowflake UI’s History tab is a great tool for basic monitoring and viewing your query history. However, if you’re looking for more detailed information, you may want to consider querying the Query_History view directly or using Snowflake‘s dedicated Information Schema table functions. These functions, known as QUERY_HISTORY_BY_*, allow you to retrieve information based on...Continue reading

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

Scroll to top