Introduction to Coalesce.io: Transforming Data Integration In today's data-driven world, organizations face the challenge of integrating and managing vast amounts of data from diverse sources. Traditional methods of data integration often involve complex processes, high costs, and significant time […]
Monday, May 8 2023
A Deep Dive into Data Sharing
Monday, May 8 2023. Snowflake
Introduction: Big data refers to extremely large datasets that can be analyzed to identify patterns, trends, and associations. The analysis of big data provides insights into various fields, including business, science, and government. However, the challenge with big data is not just analyzing it, […]
Step-by-step guide on how to load an XML file into a Snowflake database in 6 steps.
Saturday, May 6 2023. Snowflake
In this articles , we will learn how to load a XML file in a snowflake database . Step 1: Convert the XML file to a compatible format As mentioned earlier, Snowflake natively supports loading and querying JSON files. Therefore, we need to first convert the XML file to a JSON file using an […]
Friday, December 9 2022
Intro to the Snowflake Data Cloud
Friday, December 9 2022. Snowflake
With data’s consistent rise in volume and velocity, organizations seek solutions to process big data and any related challenges. One of the first decisions that organizations take? Adopting a cloud-based model that offers flexibility, scalability, and high performance. Snowflake is one cloud-based […]
Saturday, October 1 2022
Change Data Capture using Snowflake Streams
Saturday, October 1 2022. Snowflake
Introduction Change Data Capture (CDC) is a process that identifies and captures changes made to data in a database and then delivers those changes in real-time to a downstream process or system. There are several proven methods through which CDC can be implemented like making use of Audit Columns […]
Working with Snowflake External Tables and S3 Examples
Saturday, October 1 2022. Snowflake
Snowflake External tables allow you to access files stored in external stage as a regular table. You can join the Snowflake external table with permanent or managed table to get required information or perform the complex transformations involving various tables. The External tables are commonly […]
Saturday, September 24 2022
STORAGE INTEGRATION
Saturday, September 24 2022. Snowflake
STORAGE INTEGRATION is a Snowflake object that stores a generated identity and access management entity for external cloud storage (Amazon S3, Google Cloud Storage, or Microsoft Azure). Cloud administrators can grant permissions on the storage locations to the generated entity. By using storage integration users need not provide credentials as open text while creating external stages or when loading data from external cloud storage.
« previous entries - page 2 of 4 - next entries »
