To set up your profile, copy the correct sample profile for your warehouse into your profiles.yml file and update the details as follows: Pro Tip: You may need to surround your password in quotes if it contains special characters. The credentials you need to provide in your target varies across warehouses – sample profiles for each supported warehouse are available in the Supported Adapters section. About profiles #Ī profile consists of targets, and a specified default target.Įach target specifies the type of warehouse you are connecting to, the credentials to connect to the warehouse, and some dbt-specific configurations. Most organizations only have one profile.įor information about configuring advanced options, see the profiles.yml reference page. Typically, you would have one profile for each warehouse you use. In your profiles.yml file, you can store as many profiles as you need. # example profiles.yml file jaffle_shop : target : dev outputs : dev : type : postgres host : localhost user : alice password : port : 5432 dbname : jaffle_shop schema : dbt_alice threads : 4 Copy About the profiles.yml file #
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |