Alvaro ParraSnowflake — A Quick Overview of Python UDFsImagine combining the power of Python libraries and Snowflake.1d ago1d ago
Alvaro ParraSnowflake — Generating dates for a tableGenerating dates is a basic task that should be included into any user that comes into Snowflake.2d ago2d ago
Alvaro ParraSnowflake — Checking consistency in a QuerySnowflake is an ACID (Atomicity, Consistency, Isolation, and Durability) Database.2d ago2d ago
Alvaro ParraPython — Moving files from local into Azure blob StorageMoving a file to cloud is a basic operation that we should be prepare to do as Data Engineers/Analyst/Scientist, Most of the processes we…Jan 5Jan 5
Alvaro ParraSnowflake, Query to Identify Null and empty columns in a tableThere are many reasons why you would like to identify null columns, some of them are to exclude them on an ETL process or maybe to delete…Dec 29, 2023Dec 29, 2023
Alvaro ParraSnowflake — Comparing loading times on Compress vs Uncompress and splitted vs non splitted filesOn a previous post I posted that it is a good practice in Snowflake to upload files that weight less than 500 mb compressed.Sep 29, 2023Sep 29, 2023
Alvaro ParraSnowflake — Dividing and Compressing a file with Python for an efficient data processing.Snowflake is a data cloud platform that enables us to upload files in different formats as CSV, JSON and others.Sep 28, 2023Sep 28, 2023
Alvaro ParraSnowflake - Cron format conflicts and alternatives to solve themScheduling a task in Snowflake is easy, especially if you use Cron for it, but there are some cases where cron format does not work as…Sep 14, 2023Sep 14, 2023
Alvaro ParraSnowflake — How to Create tables in Python SnowparkThis could be confusing, believe me, especially if you are coming from working Stored Procedures or UDFs in JavaScript.Sep 4, 2023Sep 4, 2023
Alvaro ParraSnowflake — Naming conflicts in Snowflake between Tables and Views.While taking and failing Snowpro core certification with a grade of 695/1000, I found 3 questions related to this topic in the test. At…Aug 31, 20231Aug 31, 20231