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
General

Teradata Type Conversion Functions and Examples

Teradata is one of the common and widely used MPP database. Just like many relational databases, Teradata supports many useful functions. You can use these functions to covert the value of one data type to another. In this article, will check commonly used Teradata type conversion functions with some examples. The type conversion functions use common calling function i.e. the first argument is the value to be formatted or converted, and the second argument is a template that defines the output or input format. These conversion functions should be used…

Continue ReadingTeradata Type Conversion Functions and Examples
Comments Off on Teradata Type Conversion Functions and Examples
November 20, 2019
General

How to Check Integer Type Values in Teradata? Example

Data validation is one of the most important task in the data warehouse environment. Data validation includes, integer type check, count check, etc. For instance, check the row count after data migration. In my other article, we have discussed how to identify the decimal type values. In this article, we will see how to check integer type values in Teradata with some example. Integer type check can also be refereed as a integer data validation. Teradata Integer Type Values Check Just like many other relational databases, Teradata also provides many…

Continue ReadingHow to Check Integer Type Values in Teradata? Example
Comments Off on How to Check Integer Type Values in Teradata? Example
November 20, 2019
General

Teradata isnumeric Function Alternatives and Examples

Teradata is one of the widely used MPP databases. It can be used to combine many data sources. When you work with heterogeneous data set, you may have to get rid of many unwanted characters such as $ in your price column. If your application requirement is of numeric type, you may get requirement to filter out non-numeric values. In this article, we will check Teradata isnumeric function alternatives with some examples. We will also see how to check if string is numeric with an example. Teradata isnumeric Function The…

Continue ReadingTeradata isnumeric Function Alternatives and Examples
Comments Off on Teradata isnumeric Function Alternatives and Examples
November 20, 2019