With Snowflake COPY command you can load data from staged files on internal/external locations to…
Tag: Cloud Database
Zero clone in snowflake-Independent copy of a database, table, or individual file, without duplicating the underlying data.
In Snowflake, a “zero clone” is a feature that allows users to create a new, independent copy of a database,…
How to create and delete a BigQuery dataset and table?
Creating a BigQuery dataset and table: Go to the BigQuery web UI in the Cloud Console. Click the project drop-down…
How to connect Pyspark to Google BigQuery ?
To connect PySpark to Google BigQuery, you will need to have the Google Cloud SDK and the BigQuery connector for…
What are the advantages of using snowflake over redshift ?
There are a few advantages to using Snowflake over Redshift: Scalability: Snowflake is designed to scale up and down easily,…
What are the things that you need to know on converting SQL queries from Redshift to Snowflake ?
There are a few differences between Redshift and Snowflake that you will need to take into account when converting SQL…
How to choose the right database for your service – SQL vs NoSQL – Diagrammatic explanation
Structured data is for tabular datastores. Semi-structured data is for NoSQL. Unstructured data is for Blob Storage. [ We will…
What are the Optimization Techniques that you can apply on Apache Hive ?
1. Partitioning : Partitioning works by dividing the data into smaller segments, These are created using logical grouping based on…
Why sqitch init snowflake cannot determine Snowflake account name ?
Currently supported databases by Sqitch’s database change management tool include Snowflake’s Cloud Data Warehouse as well as PostgreSQL 8.4+, SQLite…
What are the Aggregate functions in SQL ?
Aggregate functions are the function that is used to compute against a “returned column of numeric data” from your select…
How to create AWS Glue table where partitions have different columns?
AWS Glue is a serverless data integration service. There can be a condition where you can expect new column in…