November 2021 (7)
Tuesday, November 23 2021
JSON DATA PARSING IN SNOWFLAKE
Tuesday, November 23 2021. Snowflake
What is JSON? JSON (JavaScript Object Notation) is a lightweight data-interchange format. It is easy for humans to read and write. It is easy for machines to parse and generate. While it is based on a subset of the JavaScript Programming Language, Standard ECMA-262 3rd Edition - December 1999, it […]
SNOWFLAKE EXTERNAL FUNCTIONS
Tuesday, November 23 2021. Snowflake
Introduction Snowflake has recently announced external functions available in public preview. This allows developers to invoke external APIs from within their Snowflake SQL queries and blend the response into their query result, in the same way as if they were internal Snowflake functions. In this […]
HOW TO CAPTURE SNOWFLAKE USERS, ROLES, AND GRANTS INTO A TABLE
Tuesday, November 23 2021. Snowflake
In this post, I’m going to walk you through where the information lives in Snowflake and show you a couple of ways that I get the users, roles, and grants information combined that work well and make it very accessible for answering those security and audit questions. Snowflake Users and Roles via […]
Server Migration Using AWS Cloud Endure
In this article, I will walk you through steps on how to migrate windows workload from the local data centre to AWS using AWS cloud endure. Cloud endure a SAAS service offering from AWS for migrating any physical or virtual machine from the data centre, Azure, Google to AWS. Cloud endure can also be […]