Data Storage Archieven - Nimbus Intelligence

Feb 23

Leveraging Snowflake, dbt, and GitHub for Streamlined Data Operations

By Gergana Kaymakanova Data, Data Load, dbt, Fivetran, Git, github, Snowflake, Uncategorized No Comments

Given the importance of data nowdays, the ability to efficiently manage and process it can significantly impact an organization's success. Snowflake, dbt (data build tool), and GitHub have emerged as…

Nov 10

Love0

Snowflake Hybrid Tables

By Luca Balduzzi Database, Snowday, Snowflake No Comments

Hybrid Tables in Snowflake are a new type of table that can support transactional workloads. They store data in a row-oriented format, and allow fast single-row operations as well as…

May 17

Love0

Snowflake’s INFER SCHEMA

By Mario Calise Data, Data Load, Database, Pipes, Snowflake, SQL

In this blog, we are going to discuss how Snowflake allows to easily interpret semi-structured data through its Schema Detection feature. This feature helps gaining time when setting up the tables…

Apr 14

Love0

From JSON to XML: A Deep Dive into Snowflakes File Types

By Sebastian Wiesner Data Load, Snowflake

Snowflake is a cloud-based data warehousing solution that has become increasingly popular in recent years due to its scalability and ease of use. As more and more businesses adopt Snowflake…

Apr 07

Love0

Two ways to populate a table with stage data

By Niccolo Racioppi Data, Data Load, Database, Snowflake, SQL, Uncategorized

MATCH_BY_COLUMN_NAME vs Variant data type I found myself having to insert files from my device into my database.The final aim of the process was to obtain a table with the…

Apr 07

Love0

Snowflake’s Security Measures against Cyber Threats

By Sebastian Wiesner Data, Database, Snowflake

The Barrier Between Your Data and Cyber Threats Snowflake's data platform has gained popularity for its advanced security measures. Data security is becoming an ever growing concern for companies of…

Mar 23

Love0

Snowflake File Formats

By Mario Calise Data Load, Database, Snowflake, SQL

In the previous chapters of this series, we have seen how to load through staging data from foreign sources to your Snowflake account and how to do the reverse.Talking about…

Mar 22

Love0

Data Lake or Data Warehouse? When to Use Which

By Dimitris Lampriadis Snowflake

Βusinesses that are working with data must determine how to store, manage, and analyze them efficiently. Two popular options for data storage are data lakes and data warehouses. In this…

Mar 22

Love0

Streamline Workflows with Snowflake-ServiceNow Integration

By Sebastian Wiesner Snowflake

In today's data-driven world, businesses are constantly seeking new approaches to access and analyze data. Therefore, Snowflake's recent integration with ServiceNow is creating a lot of excitement. This connector is…

Mar 22

Love0

Unload data from your Snowflake account

By Mario Calise Data, Data Generation, Database, Snowflake

We have previously seen how to load data from foreign sources to your Snowflake account through staging.Particularly, we have focused on importing files from local client machines into internal stages…