I came across this site with some cool Snowflake snippets that you might find helpful.

https://sql-snippets.count.co/c/snowflake-snippets/6

This one in particular, to parse the URL, is awesome! Would be great for web analytics use cases:

https://sql-snippets.count.co/t/parse-url/79

Do you know about our Generic Extractor course at the Academy yet? 

Generic Extractor is our powerful extractor framework that can connect to REST APIs without knowing how to code/script.   We highly recommend this course for our power users.

Additionally, it's important and useful in order to learn how to debug, or customize existing Extractors, to modify endpoints, change parameters, pull incrementally, etc.  We have over 20 Extractors as a part of our component catalog, that are Generic Extractor based.  Some examples include:

• Typeform
• ActiveCampaign
• Hubspot
• Asana
• BitBucket
• Paypal
• Procore
• SurveyMonkey
• Flexibee
• Stripe
• Zendesk
• Quickbooks
• and many more!

We hope you check out this course, and many others at the Academy!

One of our funnest courses at the Academy is the Common Components and Processors. Lots of great ideas for different use cases, or our most creative ways of getting data into KBC. 

Some highlights:

• Deal with non csv file formats such as JSON, avro, parquet, XML, even XLS
• Downloading data from a website, behind a login screen
• Extract data from email attachments
• Email reports, or create dynamic email content

This course is great even if you've been using KBC for awhile, hopefully it opens your eyes to possibilities beyond the typical ETL use cases. 

Hope you check out the Academy and enroll!

We are pleased to announce that we are launching our Keboola Data Academy (https://academy.keboola.com)!  Take a look around and see if any of the certification or courses are interesting for you. 

If you have any questions, feel free to comment here and we'd be happy to help.