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
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
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
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
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,...
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
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
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
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