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
3 days agoExecute SQL Statements from File in Snowflake — The Complete GuideWe can now execute the SQL statements specified in a file in a stage. The file should contain syntactically correct SQL statements or Snowflake Scripting blocks. This feature can be used as deployment mechanism to manage the objects and code in the projects that are not having CI/CD services. Create…Snowflake3 min readSnowflake3 min read
Aug 13Guide to Create Calendar Table with Date Dimensions in SnowflakeA Calendar Table, also known as a Date Dimension Table, is a specialized table in a database that contains a comprehensive list of dates with associated attributes and information. It’s a commonly used approach in data warehousing and analytics to support time-based analysis and reporting. …Snowflake3 min readSnowflake3 min read
Jul 31Decoding the SQL’s of Snowflake Account Admin UsageIn Snowflake Admin area of Snowsight UI, the Usage page provides detailed information about Snowflake consumption across all relevant services, in either credits or the appropriate currency. …Snowflake5 min readSnowflake5 min read
Jul 20Create Table in Snowflake from Files — An Artistic ApproachSchema Detection for CSV files is now a public preview feature and the best way to create snowflake tables is by using template with infer schema from the staged files. This feature was previously available for Parquet, Avro, ORC file formats and now enabled for CSV and JSON file formats…Snowflake4 min readSnowflake4 min read
Jul 2Snowflake Dynamic Tables — The Complete GuideIn continuation to previous post Snowflake Dynamic Tables — A way forward to simplify data pipelines let us deep dive into implementation aspects of creating and maintaining data pipelines using dynamic tables. Step 1) Data Preparation For this demonstration, I am using internal stage my_csv_stage to load the data into…Snowflake5 min readSnowflake5 min read
Jun 30Snowflake Dynamic Tables — A way forward to simplify data pipelinesDynamic Tables are a new table kind in Snowflake (now in public preview announced via Snowflake Summit 2023) that use simple SQL statements for building blocks of declarative data transformation pipelines. …Snowflake3 min readSnowflake3 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
