Snowflake

What is Snowflake Lateral Join and How to use it?

The lateral join in Snowflakes is similar to that of Hive lateral views. Lateral joins in snowflake behaves more like a correlated sub queries than normal snowflake joins. In this article, we will check what is Snowflake lateral join and how to use it. We will also check the lateral view with FLATTEN keyword and an example. What is Snowflake Lateral Join? In Snowflake, lateral keyword allows an in-line view to reference columns from a table expression that precedes that in-line view, but in some cases it may not refer…

Continue ReadingWhat is Snowflake Lateral Join and How to use it?
Comments Off on What is Snowflake Lateral Join and How to use it?
December 12, 2019
Snowflake

Different Snowflake Join Types and Examples

SQL Join is a clause in your query that is used for combining specific fields from two or more tables based on the common columns available. Snowflake joins are different from the set operators. Joins are used to combine rows from multiple tables. In this article, we will learn about different Snowflake join types with some examples. Test Data Following tables will be used to demonstrate different join types available in Snowflake cloud data warehouse system. S_STUDENTS +----+------+-----------+ | ID | NAME | CITY | |----+------+-----------| | 1 | AAA…

Continue ReadingDifferent Snowflake Join Types and Examples
Comments Off on Different Snowflake Join Types and Examples
December 11, 2019
Snowflake

Connect Snowflake using Python Pyodbc – ODBC Driver Example

Snowflake provides many connectors, you can use those to interact with Snowflake cloud data warehouse. There are many different options to connect to Snowflake. Many applications use jdbc or odbc drivers. In my other article, we have discussed how to connect Snowflake using Python and jdbc driver. In this article, we will check method on connect Snowflake using Python pyodbc and odbc driver with a working example. Snowflake ODBC Driver Snowflake data warehouse server comes with ODBC support. Before attempting to connect Snowflake from either Windows or Linux, you must…

Continue ReadingConnect Snowflake using Python Pyodbc – ODBC Driver Example
2 Comments
December 8, 2019
Snowflake

How to Access Snowflake using Aginity Pro? – Steps

There are many free and paid SQL editor tools available for Snowflake. In my other article, we have introduced best SQL editor available for Snowflake. In this article, we will check how to access Snowflake using Aginity pro. We have explained step by step process to install Aginity pro for Snowflake. About Aginity Pro Aginity Pro is relatively new SQL analysis tool. Aginity pro comes in both free and paid versions. Free version is a packed with many features and makes data engineer's life easier. Aginity Pro is an easy-to-use…

Continue ReadingHow to Access Snowflake using Aginity Pro? – Steps
Comments Off on How to Access Snowflake using Aginity Pro? – Steps
December 8, 2019
Snowflake

Best SQL Editor Available for Snowflake

Snowflake supports JDBC and ODBC connectors. There are many best, free and paid query editor tools available in the market. The widely used and popular query tool includes Aginity pro, SQuirrel SQL Client tool, SQL Workbench, etc. In this article, we will check SQL Editor Available for Snowflake. All the tools discussed in this articles are free and paid version. You can choose any tools based on your work nature and organization policies. SQL Editor Available for Snowflake Following are the list of commonly used Snowflake SQL editor tools. Aginity…

Continue ReadingBest SQL Editor Available for Snowflake
Comments Off on Best SQL Editor Available for Snowflake
December 8, 2019
Snowflake

Connect Snowflake using Python and Jdbc Driver- Example

The Snowflake provides unique, one of its kind cloud data warehouse. It is popular because of its unique architecture designed for the cloud, flexible features and benefits. Snowflake support a wide range of connectors. The JDBC driver is one of the popular connectors. You can use jdbc driver from any programming language to connect to the Snowflake data warehouse. In this article, we will check how to connect Snowflake using Python and Jdbc driver with a working example. Snowflake Jdbc Driver Snowflake provides a JDBC type 4 driver that supports…

Continue ReadingConnect Snowflake using Python and Jdbc Driver- Example
Comments Off on Connect Snowflake using Python and Jdbc Driver- Example
December 8, 2019
Snowflake

Snowflake Architecture – Cloud Data Warehouse

Snowflake is an analytic data warehouse on cloud provided as Software-as-a-Service (SaaS). Snowflake is faster, easier to use cloud data warehouse compared to other relational databases. The Snowflake database support ANSI SQL with added functionalities. In this article, we will check Snowflake architecture and how it is different from other relational databases. Snowflake Architecture Snowflake runs on the cloud such as Amazon AWS, Microsoft Azure, and Google cloud. It uses virtual compute instances for its compute needs and a storage service for persistent storage of data. As per the official…

Continue ReadingSnowflake Architecture – Cloud Data Warehouse
Comments Off on Snowflake Architecture – Cloud Data Warehouse
December 7, 2019