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

File Loading Query
This is another post in our series of Datalytyx blog posts on useful diagnostic queries for Snowflake. This time round we’re looking at loading data into Snowflake and how to check for inefficiencies in data loading. TL;DR this query will help you spot inefficient...

Getting the Most Out of Snowflake
This is the first in a series of Datalytyx blog posts on useful diagnostic queries you can run in Snowflake. To get us started, we’re going to look at ‘spilling,’ which according to Snowflake’s own definition is “When Snowflake cannot fit an operation in memory, it...

Mphasis Datalytyx Sponsoring the Snowflake Partner Theatre at Big Data London 2022
Mphasis Datalytyx is proud to be sponsoring the Snowflake Partner Theatre at Big Data London. Register for Big Data London here: https://bigdataldn.com/ Big Data LDN (London) is a free to attend two-day combined conference and exhibition focusing on how to build...

Mphasis Datalytyx increases US market penetration with Snowflake to develop next gen data applications for financial services sector
Mphasis Datalytyx, a Snowflake Elite Partner, has announced its US market expansion providing services on Snowflake, helping businesses build data ecosystems and deploy applications that use all of their data. Datalytyx and Snowflake will work to modernize financial...

Mphasis Datalytyx Sponsors Snowflake Data Cloud World Tour
Elite Snowflake Partner, Mphasis Datalytyx, is excited to announce that we will be sponsoring the Snowflake Data Cloud World Tour at the London ExCel on the 11th of October 2022. The Data Cloud World Tour is making 21 stops around the globe, so you can learn about the...

Don’t try this at home: Doing something stupid with DataOps
Doing silly things There’s a time-honoured tradition of doing stupid things with powerful tools as a way of showing their capability. Notable examples include cranes, trucks, and of course robotic fruit surgery. By accomplishing something difficult but pointless in an...