Streamlit in Snowflake provides a Python editor in Snowsight where you can write, edit, and run code for a Streamlit app. Combining Streamlit’s component-rich, open-source Python library with the scale, performance and security of the Snowflake platform can turn data into interactive apps. Streamlit in Snowflake, a faster way to # Build — Turn python scripts into…

Modern businesses need modern data strategies built on platforms that support agility, growth, and operational efficiency. Using dbt with Snowflake, data teams can quickly and collaboratively deploy analytics code following software engineering best practices like modularity, portability, CI/CD, and documentation. The power of Snowflake’s cutting-edge platform and the seamless integration…

We can now load the data from file by creating the table on the run using Snowsight UI and here is the step by step guide how it can be done. This is very beneficial for quick data analytics and data discover without pre-creating the table. The discussed feature uses…

Snowflake data marketplace, is an online transactional location or store that facilitates the buying and selling of data. As many businesses seek to augment or enrich internal data sets with external data, here let us see how easy it is with Snowflake Marketplace to monetize data. As a data provider…

We 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…

A 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. …

In 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. …

Schema 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…

In 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…