When working with DBT, it's important to follow best practices to ensure that your code…
Tag: Cloud Database
DBT : Dealing with single quotes in SQL statements [Escape single quotes in SQL]
DBT is a popular open-source data modeling tool that allows you to transform and analyze data using SQL. One feature…
DBT : Converting a variable into a string in DBT
Jinja’s as_text filter is a way to convert a variable into a string in Jinja. It is often used to…
Snowflake : How Snowflake handle backup and recovery?
In this article, we will discuss how Snowflake handles backup and recovery, and how these features help ensure the integrity…
Snowflake : Process of scaling and managing Snowflake clusters
Snowflake’s architecture is designed to provide virtually unlimited scale, allowing users to easily scale up or down based on their…
Snowflake : An overview of Snowflake’s Data Sharing feature
One of Snowflake’s most popular features is its data sharing capability, which allows organizations to securely share data with external…
Snowflake : DESCRIBE SEARCH OPTIMIZATION – Analyze the query plan for a specific query and identify areas for optimization
In Snowflake, the DESCRIBE SEARCH OPTIMIZATION command is used to analyze the query plan for a specific query and identify…
Redshift : Learn how to link Amazon redshift to s3 bucket
Amazon Redshift is a fully-managed, petabyte-scale data warehouse service in the cloud. It allows you to run complex analytical queries…
Redshift : Role of VACUUM and ANALYZE in Redshift
Amazon Redshift is a popular data warehousing solution that is widely used by businesses to manage and analyze large volumes…
Hive : How to load JSON and nested JSON in Hive and how to view it [Sample code with Data]
In this article, I’ll walk you through how to read JSON data from a Hive table using an example with…
Snowflake : LIMIT and FETCH of Snowflake . How it differs ? When and where its used.
In Snowflake, the LIMIT and FETCH clauses are used to limit the number of rows returned by a query. While…