Best File Formats for Loading Data into Snowflake on Cloud


Snowflake Load Performance and File Formats Snowflake supports multiple file formats for loading data, including CSV, JSON, AVRO, ORC, PARQUET, and XML. For our benchmarking, we considered only CSV, AVRO, PARQUET, and ORC. Since our core objective was to migrate traditional warehouses which are flat in nature, it did not make sense to use JSON … Read more

Practical Challenges of Large-Scale Cloud Data Migrations

Observed Gaps in Data Migration Tools When you are assessing these tools its looks like a straightforward thing, but when you start large-scale implementations you might start observing some gaps. Some of these gaps may impact timelines, efforts, and the overall quality for your migration. Below is a listing of the gaps that we observed. … Read more

Reduce Data Latency and Refine Processes with Hadoop Data Ingestion

Hadoop data ingestion has challenges like There could be different source types like OLTP systems generating events, batch systems generating files, RDBMS systems, web based APIs, and more Data may be available in different formats like ASCII text, EBCDIC and COMPs from Mainframes, JSON and AVRO Data is often required to be transformed before persisting … Read more