Project Title: Automating Snowflake via Terraform.

Project Description: This Terraform module can be used to completely automate a user's Snowflake environment. I have built this in a module-wise approach namely: database, schema, roles, users, warehouse and grants. Based on the environment name and the user credentials the entire infrastruucture can be automated and built at the earliest.

Initial publish: 25/11/2022.
Author: Sayan Adhikary.
Github: https://github.com/isayan58/Terraform_3.0

Update as on 25/11/2022.

Functionalities: 1. Database creation as mention in the YAML file in database module.
2. Schema creation as mention in the YAML file in schema module.
3. Roles created. RBAC hierarchy created.
4. Users created along with roles granted to them.
5. Role-specific warehouse created.
6. Grants provided to for all the necessary database objects.

Limitations: 1. The providers are currently created in each separate module. Due to this reason the dependency cannot be created successfully. The providers should be created externally for each system roles and used as and when required.
2. The credentials are currently stored in provider.tf file. This needs to be hidden so that the credentials are never exposed to anyone.
3. This code currently has the basic items required in a Snowflake environment. Extra features need to be added and implemented successfully.

P.S.: The tables need to be created via DDLs as it is more optimal compared to table creation via Terraform.

Update as on 02/12/2022.

Limitation #1 removed. Now the providers are not created in each module. The providers are created in the root folder and then the required providers are passed to the corresponding modules. Since the provider is called from the root folder, dependencies on modules can be added as well.

Limitations as on 02-Dec-2022:

1. The credentials are currently stored in provider.tf file. This needs to be hidden so that the credentials are never exposed to anyone.
   
2. This code currently has the basic items required in a Snowflake environment. Extra features need to be added and implemented successfully.
   

P.S.: For the grants module we have to make sure that the provider has a warehouse as follows:

provider "snowsql" {
alias = "securityadmin"
username = "SAYAN"
account = ""
region = ""
password = ""
role = "SECURITYADMIN"
warehouse = "TEST_WH"
}

This is required for running the DCL commands using SnowSQL.

Update as on 06-Dec-2022.

Limitation #1 from 02/12/2022 removed. The credentials in provider.tf have been parameterized and with the variables stored in variable.tf we can connect to the Snowflake account or use any other secret to as variables without actually having to use it.

Limitations as on 06-Dec-2022:

1. This code currently has the basic items required in a Snowflake environment. Extra features need to be added and implemented successfully.