Introduction By now everybody has heard of LLMs and understands (to some degree) what they do. Given that training LLM’s is so expensive, organisations are seeking to run them effectively without incurring the high costs. So, how does an organisation gain a...
Querying JSON in Snowflake: A Color-Coded Example
Querying nested JSON can be frustrating and finding easy to use examples can be even more challenging. It is one of the most common sources of questions that I see on Stack Overflow and Snowflake Community forums. The syntax is not at all intuitive, and it will...
Finding all the Snowflake Best Practices & Recommendations
I have been reading the docs.snowflake.com site for over 4 years now. I read it when trying to get things to work, I read it as a reference book for correct syntax, and I even read it to see what’s new! Things do change fast in the Snowflake world so it’s important...
Cross Database References in Snowflake
Last week, your engineer created a Snowflake procedure (PROD_DB.SCHEMA.ADD_CUSTOMER) that inserts a new customer record into the customers table (PROD_DB.SCHEMA.CUSTOMERS). Notice that these object names are “fully qualified” with specified database, schema, and...
Mphasis Datalytyx announces Snowflake Health Check Service
Many enterprises using Snowflake are grappling with maximising the return on their investment, by using best practices to minimise costs whilst gaining as much as possible from the power of the platform. Leveraging our extensive experience as a Snowflake partner of...
Base Point Business Centre
377-399 London Rd
Camberley
GU15 3HL
+44 (0)2036 379155
info@datalytyx.com