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?
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.
very hepl full materials
Nice
Thanks
Brother - How to configure Matillion to Read files stored on Azure? Any inputs are apreciated
I will upload video soon!
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?
Multi-Cluster feature is available with Enterprise edition and above. Please check the edition of your Snowflake account.
why we are creating three databases what is the purpose, could you please expailn it, it would be really help full for me
we have 1 database for each environment - DEV, TST & PRD. Hope it helps!!
please share sql query to create snowflake resources
Checkout here: www.clveda.com/2021/11/08/matillion-setup-part-4-snowflake-resources/
Hi..Can you please share the scripts please, the link is invalid .
why schema is not selected, when we careted schema for this user and database and warehuse
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.
link to download script is not accessible sir