Published in Snowflake·PinnedStreaming Data from Snowflake to Kafka️❄️ I got the news of my selection as Snowflake Data Superhero 2023! Thank you!❄️ In one of my previous blogs, I covered step-by-step how to move data from Kafka to Snowflake.Snowflake8 min readSnowflake8 min read
Published in Snowflake·PinnedLongterm Archival Strategy for Snowflake — ConsiderationsIf you are a Snowflake customer, the ease of maintenance is definitely one of the selling points. You can spin up your Snowflake instance in minutes, pay using your credit card, never worry about auto-scaling, and many other features are definitely an eye-catcher and provide a low entry barrier. But…Snowflake4 min readSnowflake4 min read
Published in Snowflake·PinnedSnowflake Task Manager using StreamlitPrelude One of the constant holdbacks to using the Snowflake Task feature is the manageability and maintainability aspect. Creating a task is not so hard (we ❤️ Snowflake). It is usually the maintenance, monitoring, etc that is a bit difficult. Few nice to have features for Snowflake Task would be: A…Snowflake6 min readSnowflake6 min read
PinnedModern Data Stack — An IntroductionThe Primary Function The primary function of IT is to serve the business. That has been a focal point since the advent of software and always will be. What really changes is the dynamic of how to serve (and who is serving, and what is served, etc..). Tracking the lineage…Snowflake6 min readSnowflake6 min read
Published in Snowflake·Mar 5Minimalist Snowflake Table Compare (using data-diff)Here is a fun little project for anyone wanting to dive deep into Streamlit and data-diff. The objective is to showcase how seamless it is to integrate any python library with Snowflake using Streamlit. Once Streamit is available natively in Snowflake, the entire ‘Data App’ will be inside Snowflake! We…Snowflake5 min readSnowflake5 min read
Feb 1Chomsky, Chess, and IntelligenceProfessor Noam Chomsky was asked about his opinion on Chess Playing Programme (I cannot date this video, but it looks like it is at least after 1997 when Garry Kasparov was in a chess tournament with Deep Blue (IBM’s supercomputing device at that time). …Chomsky4 min readChomsky4 min read
Feb 1Getting Certified Bitcoin Professional by C4Disclaimer: This is a 2017 post that I found lying around and thought of publishing it on Medium. All references points to 2017. I recently attempted and passed the Certified Bitcoin Professional examination by CryptoCurrency Certification Consortium (C4). …Bitcoin5 min readBitcoin5 min read
Published in Snowflake·Jan 26ChatGPT: Write me a blog on Data Sharing in SnowflakeDisclaimer: This entire blog was written by ChatGPT. Only the formatting is mine. I was pleasantly surprised by the accuracy and the fact that it also provided with the commands to execute. Q: Can you write a blog for me on how to do data sharing in Snowflake? Data sharing is an important aspect of any data management system, and Snowflake is no exception. Snowflake allows…Chatgpt3 min readChatgpt3 min read
Jan 20Open Port Checker using PythonDon’t want to read the blog? Here is the source code: GitHub - SudhenduP/port_checker: port_checker is a python-based code and executable to check if TCP… port_checker is a python-based code and executable to check if TCP port status for multiple servers and ports. - GitHub…github.com Problem Statement In my pre-cloud day-to-day work, I always need the check whether port access to a server is open on not. The usual way to do this is telnet. But many times, the list of server-port could get huge, and…Python2 min readPython2 min read
Oct 20, 2022Developers Guide to Snowflake’s SQL API511Brad CulbersonNice article @Brad!Nice article @Brad! Would you recommend building a full fledged API application using the Snowflake SQL API? Or should this API be used for lightweight, testing, sandbox types of application only?1 min read1 min read
