Snowflake boasts powerful import capabilities from data files including CSV, JSON, and Parquet. What about a less frequently used file type – the fixed-width file? Yep! Snowflake can handle that with ease. A fixed-width text file is a type of data file where each line contains records of a predetermined length, with fields aligned inContinue reading “Snowflake: Loading a Fixed-Width File”
Tag Archives: Snowflake
Snowflake: Creative Create Table Tactics
During a recent build of a Snowflake data environment, I encountered a challenge while translating my SQL Server code to Snowflake. As any seasoned database developer knows, dealing with staging tables and SCD (Type-2 slowly changing dimension) tables is par for the course in data warehousing. In the realm of table creation, there’s the classicContinue reading “Snowflake: Creative Create Table Tactics”
Python Byte: Loading Data to Snowflake from SQL Server
For a recent proof of concept, I needed to transfer data from five or six relatively small tables from SQL Server to Snowflake. Normally, I would go through all the steps to set up an ingestion pipeline in Snowflake; however, for a POC, that all seemed like overkill. I simply needed to copy the dataContinue reading “Python Byte: Loading Data to Snowflake from SQL Server”
Eric Heilman 