Data Cleansing View in Snowflake

For part of one of my free ETLs I am using Zapps to transfer e-mails from Google Sheets and then Keboola to transfer the sheets into my Snowflake database. I am familiar with string searches and cleansing in Oracle and using python but have not had the chance to do this in Snowflake. I wanted to give it a go as a proof of concept if nothing else. There were some difference in functions between Oracle and Snowflake, no INSTR and using POSITION instead and some difference in working with dates / timestamps but overall it was very similar.

The code below is what I ended up using:

I think want to use this to create some overview graphics to allow me to track the success or failure of my ETLs. Assuming the aspects of Retool remain free you can see how much ETL is going on this link.

In case things aren't working, here is a table of the output I am producing.

Comments

AI News

Here’s a concise roundup of the latest AI news from the past couple of days: AI Technology: Friend or Foe? Researchers and experts continue to debate the impact of artificial intelligence. Is it a boon or a threat? The discussion ranges from AI ethics to its potential in various fields. Read more here . 5 Ways Artificial Intelligence Will Change the World by 2050 Futurists predict that AI will revolutionize our lives in the coming decades. From healthcare to transportation, AI is set to transform industries. Explore the possibilities here . How AI Will Transform Businesses in 2023 Business leaders are embracing AI to enhance efficiency, decision-making, and customer experiences. Stay updated on the latest AI trends in the corporate world here . China’s High-Level AI Modules China is pushing the boundaries of AI with modular next-generation systems. These high-level AI technologies promise breakthroughs in fields like robotics, healthcare, and smart cities. Learn more here . The Future ...

MySQL - Free

So I was looking at trying to get a cloud based database that was always on. I wanted to build some visuals over whatever data I ended up building and have the DB accessible from a cloud server seemed like the easy way. I wanted to keep it free because I hate spending when I don't need to, so that others could use it for free and because I was sure there must be options out there. In the end my life was made much easier by spending £10 but you can go with the same free option on this site. https://www.freemysqlhosting.net/ Although not super fast or super sized it gives you a free and easily accessible database. So far I have easily connected using phpAdmin, BeeKeeper Studio, Python, Google Data Studio and Keboola. I have had no issues at all unlike several other solutions I have tried including Heroku. To setup the DB you just set your location and hit start, you will then be e-mailed the connection details and then use your favourite MySQL IDE and you are in. Above i...

Gen AI News - 05-04-2024

Here are some recent developments in the field of General AI (Gen AI) : China’s Use of AI to Sow Division in the US According to a report from Microsoft’s threat centre, China is increasingly using AI-generated content and fake social media accounts to inflame division in the United States and other regions. These tactics have raised concerns about the influence of AI in shaping public discourse 1 . UN Chief Concerned About Israel’s AI Target Identification in Gaza UN Secretary-General Antonio Guterres expressed serious concern over reports that Israel is using artificial intelligence to identify targets in Gaza. The use of AI in military operations has resulted in civilian casualties, prompting global scrutiny 2 . The AI Deepfake Apocalypse Deepfake technology continues to evolve, raising ethical and security concerns. Researchers are exploring ways to combat deepfakes, but the challenge remains. Adobe’s Dana Rao emphasizes the need for combined methods to control AI-generated images ...

Gen AI Data Guy

Search This Blog