There are several ways to load data into Snowflake, depending on the specific needs of…
Tag: Big Data
Explain the architecture of Snowflake and how it handles data storage and compression
Snowflake is a cloud-based data warehousing service that uses a unique architecture to handle data storage and compression. It stores…
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,…
Explain the architecture of BigQuery and how it processes ?
BigQuery is a fully managed, cloud-based data warehousing service provided by Google. It is built on top of the Google…
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…
Pyspark code to read and write data from and to google Bigquery.
Here is some sample PySpark code that demonstrates how to read and write data from and to Google BigQuery: from…
How to start a serverless spark from GCP
To start a serverless Spark job on Google Cloud Platform (GCP), you can use the Cloud Dataproc service. Cloud Dataproc…
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…
PySpark : How to read date datatype from CSV ?
We specify schema = true when a CSV file is being read. Spark determines the data type of a column…
PySpark: How to accept date in a Dataframe : DateType can not accept object ‘YYYY-MM-DD’ in type
Accepting date in a Dataframe When you define a data in a a list of tuple and trying to read…