PinnedSnowflake — Get Self Started!Introduction: Myself working as Architect in Cloud Data Warehouse technologies based out of India. I am Snowpro Architect, Data Engineer, Data Analyst Certified, AWS Solutions Architect — Associate, Teradata Vantage Architect & Teradata Vantage Senior Developer. *Disclaimer — We are not affiliated or endorsed by Snowflake, Inc I got introduced…Snowflake2 min readSnowflake2 min read
May 21Redundant Joins Elimination in Snowflake — The Complete Understanding GuideSNOWFLAKE only enforces NOT NULL constraint and other constraints of UNIQUE, PRIMARY KEY and FOREIGN KEY are not enforced. Many a times the question is that what is the use of them apart form logical modeling aspect and why take an effort to define them and as a user manage…Snowflake4 min readSnowflake4 min read
May 14Virtual Column in Snowflake — The Complete GuideNot much is talked about virtual column in the Snowflake documentation and it is only referenced in the topics of external tables, masking, row level security and few more. So, bringing you here the detailed guide on the same. A virtual column is a column that is not physically stored…Snowflake3 min readSnowflake3 min read
May 7Loading Files into Stage through Snowflake UI — The Complete GuideWe can now load the files into Snowflake named internal stages using Snowsight UI and here is the step by step guide how it can be done. We can view the files and use the files to load data from files into tables. 1) Creating named internal stage Create a…Snowflake4 min readSnowflake4 min read
May 2Data Loading through Snowflake UI — The Complete GuideWe can now load the data from files into Snowflake tables using Snowsight UI and here is the step by step guide how it can be done. This is very beneficial when we want to load the files data quickly in DEV or QA Snowflake environments. Logged into Snowsight UI…Snowflake4 min readSnowflake4 min read
Mar 29SnowPro Advanced: Data Analyst Certification GuidePreparation, checks and hints needed to clear SnowPro Advanced Data Analyst Certification in your 1st attempt. SnowPro Advanced: Data Analyst Certification needs hands on on knowledge as the exam assess skills through scenario-based questions and real-world examples, experienced by Data Analyst. In comparison to other SnowPro exams, I would categorize…Snowpro3 min readSnowpro3 min read
Mar 24Automating Snowflake Access Token in Azure SCIMBelow are the step by step guide to automate Snowflake Access Token to Azure AD. Without which, one need to update Azure SCIM every 6 months. Create a new Logic App in Azure portal. Add a Recurrence trigger to the Logic App that runs at the desired frequency (for example…Snowflake2 min readSnowflake2 min read
Mar 1Best Practices of Different Data Ingestion Options in SnowflakeData ingestion, the process of obtaining and importing data for immediate storage or use in a database usually comes in two flavours — data ingested in batches & data streaming. Batch data ingestion batches imports data in discrete chunks at more pre-determined time slots. …Snowflake3 min readSnowflake3 min read
Feb 11Snowflake Account Identifiers and Login URL’sLet us understand what are the different URL’s for you to connect to Snowflake UI and different account identifiers using which you can connect to Snowflake from other interfaces. Snowflake URL’s There are 3 different login URL’s using which you can login to Snowflake UI and all the 3 brings…Snowflake4 min readSnowflake4 min read
Feb 7Snowpipe setup for AWS S3Here is the step by step guide for beginners to establish snowpipe connectivity in Snowflake with AWS S3 bucket. If you are looking for navigation using AWS UI to configure the set up, then you are at a right place here. 1) Set up snowflake connectivity with AWS S3 https://snowflakewiki.medium.com/connecting-snowflake-to-aws-ef7b6de1d6aa …Snowflake3 min readSnowflake3 min read
