Snowflake filters

Snowflake – How to filter your data?

QUALIFY clause is a powerful feature of Snowflake – SQL, which allows you to filter the results of a query based on window functions. Window functions are special functions that operate on a set of rows defined by a window or a partition. These functions can be used to calculate aggregate values, ranking, or row...Continue reading

Snowflake error

Why Snowflake throwing an error on SQL join issues – SQL compilation error: syntax error line N at position N unexpected ‘ON’?

Working with databases can be a challenging task, especially when you’re dealing with complex data queries. As data continues to grow and become more complex, companies are turning to cloud data platforms like Snowflake to help manage their data needs. Snowflake is known for its user-friendliness and ease of use, making it a popular choice...Continue reading

Reading CSV Files in Alteryx and Importing into Snowflake Tables

How to read CSV Files in Alteryx and import into Snowflake Tables?

Snowflake is a cloud-based data warehousing platform that provides fast, secure, and flexible data storage and retrieval capabilities. Alteryx , on the other hand, is a powerful data analytics and business intelligence platform that allows users to perform various operations on their data, including reading, transforming, and analyzing it. By combining these two platforms, you...Continue reading

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

Scroll to top