Jupyter Notebook is widely used in both large organizations/corporations, as well as in Academia – such as universities and research institutes. It is an open-source web application for interactive computing across Julia, Python, R, and many other programming languages. Being different from Integrated Development Environment (IDE), Jupyter Notebook received its popularity among Data Scientists, Data […]
Snowflake
Connecting Node JS with Snowflake
Node js connection with Snowflake could come in handy while moving data between systems where direct connections are not available and an intermediary is required. Node.js is a run-time environment that includes everything required to execute a program written in JavaScript. It is used for running scripts on the server to render content before it […]
Dealing with Unstructured Data in Snowflake
The storage of unstructured data is on the rise in modern data warehouses due to the increasing collection of text data and metadata in an unstructured format. Like most data warehousing solutions, Snowflake offers support to load and manipulate semi-structured files and data. This is essential, as, modern data warehousing systems need to store large […]
Databricks Integration with Snowflake
What is Databricks? Databricks is a unified cloud-based data platform that is powered by Apache Spark. It specializes in collaboration and analytics for big data. Databricks is a data science workspace, with Collaborative Notebooks, Machine Learning Runtime, and Managed ML flow. Collaborative Notebooks support multiple data analytics languages, such as SQL, Scala, R, Python, and […]
Creating Snowflake External Stage Using Google Cloud Storage
If you are a Google cloud platform (GCP) user and want to use GCS as the external stage to load/unload data to snowflake, this blog will help you understand the step-by-step procedures. Before going any further on unloading and loading data from GCP. Let us understand what is Load/Unload? and what are the supported cloud […]
SQL, NoSQL, and NewSQL
Traditional SQL databases and data warehouses have been around for decades and have been doing really well. However, Big Data NoSQL changed the game with big returns for big investments. Concepts like Edge Analytics have been game changers “uberizing” foundational changes in business models. I recently attended a conference hosted by Snowflake, a data warehouse […]