Configure dbt core collector with Elementary for Snowflake

in this tutorial, we'll guide you through the essential steps to effectively set up and configure the dbt collector with elementary data for snowflake this involves establishing connections to the snowflake table used by elementary to log the dbt artifacts, and configuring the collector, to ensure you can monitor, collect, and analyze the operations and impacts of your dbt models you will need to go through 2 steps 1 set up snowflake connection to the elementary table (estimated task time 3 minutes) 2 configuration of the dbt core collector (estimated task time 1 minute) prerequisites before you begin configuring the collector for dbt core collector with elementary for snowflake, ensure you have the following a snowflake account with administrator access or specific roles granted the necessary permissions to access elementary artifact table configuration setting up the connection the first step consist in creating a snowflake connection with the account credentials mentioned in the prerequistes 1\ navigate to your kensu hub url https //xxxxx hub kensuapp com/ https //demo hub kensuapp com/kensu hub components plugin/#/connections 2\ within the data applications collectors, locate the dbt core one and click on configure 3\ under the dependencies section, click on the configure button in the dbt core elementary snowflake cell 4\ look for the + icon clicking on this icon will open a form where you can enter the details for your new snowflake connection 5\ now, you'll need to fill out the form with specific information about your snowflake account here's what you'll need account this is your snowflake account id, which uniquely identifies your snowflake environment conn id a unique id for your connection database the name of the database you wish to connect login your snowflake login credentials (username) password your snowflake account password role the user role that you'll be using in snowflake schema the schema within the database you're connecting to warehouse the warehouse that will be used for processing queries 6\ after double checking the information you've entered, click on the submit button to finalize the connection kensu hub will process your details and establish a connection to your snowflake data source configure the collector 1\ come back to the collector page 2\ navigate to the configuration panel within the kensu hub components collector dbt core cell, click on configure 3\ click on the + icon this action will generate a new configuration file 4\ you can now edit the configuration, by adding in the specified section, choose the appropriate kensu and dbt core elementary snowflake connections for this configuration you can select the default kensu connection or create your own do not select any other connection you can identify the collector by adding a specific identifier in the id field schema must refer to the snowflake schema which contains the elementary data finally, refer to the snowflake account where the elementary table is located in the snowflake account field this step is mandatory to ensure the proper functioning of the collector all the other fields can be left blank 5\ click on submit all congratulations! you've successfully set up the collector it will be activated shortly, and you will begin monitoring your dbt models