Snowflake does not offer native full-text search capabilities like some other databases or specialized search engines. However, you can perform basic text-based searches using SQL functions… Read More

Snowflake does not support traditional database indexes like those found in many other relational database systems (e.g., B-tree indexes). Snowflake's architecture is designed to be fully ma… Read More

Let's go through a example of how to split a large JSON file into smaller files in Snowflake. In this example, we will:Create a sample table with JSON data.Create a Snowflake stage.Use the C… Read More

The error message "Variables may not be used here" in Terraform typically indicates that you are trying to use a variable in a context where it is not allowed. In the case of Terraform and S… Read More

Generative AI refers to a class of artificial intelligence systems that have the capability to generate content autonomously, often in the form of text, images, videos, or other types of dat… Read More

Exploring Python's standard libraries is a great way to tap into a wide range of functionalities that can simplify your coding tasks. Here are examples of how to use some commonly used stand… Read More

Tutorial 11.1 - Modules and LibrariesImporting modules and using their functions.Importing modules and using their functions is a fundamental concept in programming, especially in languages… Read More

Tutorial 10.2 - Comprehensions and GeneratorsIntroduction to generators and using the yield statementGenerators are a powerful and memory-efficient way to create iterable sequences of data i… Read More

Tutorial 10.1 - Comprehensions and GeneratorsList comprehensions, dictionary comprehensions, and set comprehensions.List comprehensions are a concise and Pythonic way to create lists based o… Read More

Tutorial 9.2 - Advanced Data Structuresdefaultdict, OrderedDict in PythonIn Python, `defaultdict` and `OrderedDict` are two specialized dictionary classes provided by the `collecti… Read More

Tutorial 9.1 - Advanced Data StructuresSets and their operationsIn Python, a set is an unordered collection of unique elements. Sets are used for various purposes, including removing duplica… Read More

Tutorial 8.2 - File HandlingUsing Context Managers (with statement) for file operationsUsing context managers, implemented with the `with` statement, is the preferred way to work with files… Read More

Tutorial 8.1 - File HandlingReading and Writing filesReading and writing files in Python is essential for working with data stored in files. Let's dive into the details of how to perform fil… Read More

Tutorial 7.2 - Exception HandlingUsing finally and raising custom exceptionsLet's dive deeper into using the finally block and raising custom exceptions in Python.1. Using `finally` Blo… Read More

Tutorial 7.1 - Exception HandlingHandling errors with try and exceptIn Python, you can handle errors and exceptions using the try and except blocks. These blocks allow you to gracefully mana… Read More

Tutorial 6.2 - String ManipulationString formattingString formatting in Python is the process of creating formatted strings by inserting values into placeholders within a string. Python prov… Read More

Tutorial 6.1 - String ManipulationString operations and methodsString operations and methods in Python allow you to manipulate and work with text data. Strings are sequences of characters, a… Read More

Tutorial 5.3 - FunctionsScope and variable visibility.Scope and variable visibility in Python refer to where a variable is accessible and can be used within your code. Python has various lev… Read More

Tutorial 5.2 - FunctionsFunction parameters and return valuesFunction parameters and return values are fundamental concepts in Python programming. They allow you to pass data into functions… Read More

Tutorial 5.1 - FunctionsDefining and calling functionsLet's delve deeper into defining and calling functions in Python, exploring different aspects and features.1. Defining Functions:To defi… Read More

Tutorial 4.2 - Data StructuresAccessing, modifying, and iterating through Lists, tuples, and dictionaries.let's go into more detailed explanations of how to access, modify, and iterate throu… Read More

Tutorial 4.1 - Data StructuresLists, tuples, and dictionaries.Lists, tuples, and dictionaries are three commonly used data structures in Python for organizing and storing collections of data… Read More

Tutorial 3.2 - Control FlowLoops (for, while) and iterating through sequences.Loops are used in Python to execute a block of code repeatedly. There are two main types of loops: for loops and… Read More

Tutorial 3.3 - Control Flowrange() functionThe range() function in Python generates a sequence of numbers that you can use in various situations, such as for loops, to iterate through a spec… Read More

Tutorial 3.1 - Control FlowConditional statements (if, elif, else).Conditional statements in Python (if, elif, and else) are used to control the flow of a program based on certain conditions… Read More

Tutorial 1.3 - Introduction to PythonA step-by-step guide on how to write and run your first Python program using a simple text editor and the command line:1. Install Python:If you haven't a… Read More

Tutorial 2.2 - Python Basic OperatorsPython supports a variety of basic operators for performing arithmetic, comparison, and logical operations. Let's dive into each category with detai… Read More

Tutorial 2.1 - Python Basic ConceptsLet's dive into Python variables, data types, and type conversion with detailed examples.1. Variables:Variables are used to store data in a program… Read More

Tutorial 2.3 -  input() and print() functionsInput and output are essential for interacting with users and displaying information in Python programs. You can use the input() function to… Read More

What are the differences between Generative AI and Large Language Models (LLMs):AspectGenerative AILarge Language Models (LLMs)DefinitionAI systems that generate new data (images, text, etc… Read More

A basic example of file handling in PythonIn Python, file handling is used to manipulate and access the contents of a file. Some common operations in Python file handling include:Opening a f… Read More

What is the garbage collection in Python with example ?Python's garbage collector automatically manages memory by reclaiming objects that are no longer being used by the program. The garbage… Read More

What is Snowflake Warehouse ?Snowflake Warehouse is the core component of Snowflake's data warehousing platform. It is a cloud-based data warehousing solution that provides a flexible and sc… Read More

What are the datatypes supported for Snowflake?Snowflake supports a variety of data types to store different types of data. The following is a list of some of the commonly used data types in… Read More

Spark Vs SnowflakeApache Spark and Snowflake are both big data technologies, but serve different purposes:Apache SparkOpen-source big data processing frameworkIn-memory computing capability… Read More

What is Snowflake VARIANT data type explained with an example ?Snowflake VARIANT is a data type in Snowflake that allows you to store semi-structured data such as JSON, Avro, and Parquet wit… Read More

Python Beginners Tutorial - Zero To Hero for BeginnersWhat is Python Programming ?Python is a high-level, interpreted programming language that is widely used for web development, data analy… Read More

As we know as a developer, setting up a quick local development environment is a really important task. Snowflake recently has released its Snowpark Python / Scala / Java APIs as a comparati… Read More

How to calculating compute cost based on snowflake query id ?As we know Snowflake provides separation of compute and storage so the cost is also calculated separately.Often, we are only inte… Read More

How to Install PySpark 3 and Jypyter Notebook locally on Windows / Mac / UbuntuIn this tutorial I have explained very easy technique to install and configure PySpark and Jupyter notebookLet'… Read More

Spark Structured Streaming in Depth – Introduction Structured streaming is a new high-level streaming API It is pure declarative based on automatically incrementalizing a static relati… Read More

How to send logs from Databricks cluster to Azure Application Insights In this cloud era, there is always the case where we need to capture our application logger lo… Read More

Hello world, in this tutorial we will understand that how to install services like LAMP Stack (Apache HTTP Server, MySQL, PHP, phpMyAdmin). I am assuming you have access to Google Cloud P… Read More

Open google cloud console and Activate cloud shell and click on start cloud shell. Now run following command on cloud shell to create bucket. Note - mb is used while creating bucket Read More

In this tutorial we will understand how to create google cloud compute engine instance using gcloud command line and web gui interface. I am assuming you are singed in with valid crede… Read More

Let's understand step by step how to create google cloud bucket using web console. From the left menu go to Storage > Browser and click on Create bucket Enter bucket Name, look at the… Read More

In this tutorial we will understand how we can create Cloud SQL instance on google cloud. From the Google Cloud Console menu go to > SQL and click on Create instance Next chose the… Read More

Go to Compute Engine > VM Instances tab add the following startup detail to Startup script tabapt-get update apt-get install apache2 php php-mysql -y service apache2 restart Now c… Read More

In the previous tutorial Part 1 we have learnt how to install LAMP (PHP, MySQL, phpmyadmin etc.) using google cloud launcher. Now, Let's understand how to access phpmyadmin using putty… Read More

How to test and debug AWS Glue Job locally in PyCharm IDE - Community Edition Step 1: PyCharm Install PySpark using Make you have… Read More

How to test and debug AWS Glue Job locally with Apache Spark Recently, AWS release its glue libs on GitHub AWS Glue GitHub… Read More