Marlandata

A blog to share thoughts, knowledge and techniques from the world of data.

Snowpro Advanced Architect: Data Movement

Image by Peter H from Pixabay Domain Objectives Data Loading & Data Unloading List best practices and the impact of different scenarios Formats File number File size Warehouse si...

Snowpro Advanced Architect: Connectors & Drivers

Domain Objectives Connectors Kafka Basic configuration and access privileges for the Kafka connector Drivers Identifying the various client drivers available to connect to Snowflake A data warehouse would be a very useless thing wit...

Snowpro Advanced Architect: Security

Photo by FLY:D đŸ”¶Art Photographer on Unsplash Domain Objectives Understand account parameter and the impact of settings - Explain the access control framework - Required privileges for tasks, shares, statements to research Role Based Access Contr...

Automating Table Creation from an External Stage in Snowflake

Photo by Christopher Burns on Unsplash Recently while I was readying to import some training data (I think Tableau’s Bookshop dataset they introduced alongside the relationship model is an incredibly good dataset) into Snowflake, I found myself h...