Matillion Setup - Part 4 - Snowflake Resources

[@ranjeetkumaryadav5767]

very hepl full materials

[@DEwithAbhishekTripathi]

Nice

[@cloudvedaacademy]

Thanks

[@jcsajay]

Hi..Can you please share the scripts please, the link is invalid .

[@TheGreatAzhar]

Brother - How to configure Matillion to Read files stored on Azure? Any inputs are apreciated

[@cloudvedaacademy]

I will upload video soon!

[@oluwaseunladeinde6863]

Thank you for sharing. Although the user interface for Snowflakes has changed. I cannot also access the SQL queries used. I ran into an issue while creating the warehouses: SQL compilation error: invalid property 'MAX_CLUSTER_COUNT'; feature 'MULTI_CLUSTER_WAREHOUSES' not enabled. Any help here?

[@cloudvedaacademy]

Multi-Cluster feature is available with Enterprise edition and above. Please check the edition of your Snowflake account.

[@ranjeetkumaryadav5767]

why we are creating three databases what is the purpose, could you please expailn it, it would be really help full for me

[@cloudvedaacademy]

we have 1 database for each environment - DEV, TST & PRD. Hope it helps!!

[@ranjeetkumaryadav5767]

why schema is not selected, when we careted schema for this user and database and warehuse

[@cloudvedaacademy]

Schema is created by users itself when they login to the account. In that way DEV_DEVELOPER role will be the owner of schema and upper level roles should also be able to manage. If we create the schema with SYSADMIN role, we will have to grant access to DEVELOPER role which would become the lengthy process. Idea is every user should create its schema and own it with DEVELOPER role.

[@ranjeetkumaryadav5767]

please share sql query to create snowflake resources

[@cloudvedaacademy]

Checkout here: www.clveda.com/2021/11/08/matillion-setup-part-4-snowflake-resources/

[@wheelpower]

link to download script is not accessible sir