{"repo":"SpotOnInc/dbt_object_mgmt","free":true,"listed":false,"github":"https://github.com/SpotOnInc/dbt_object_mgmt","clone":"git clone https://github.com/SpotOnInc/dbt_object_mgmt.git","description":"dbt package to manage snowflake objects","language":"Python","stars":29,"topics":["dbt","snowflake"],"license":"MIT","category":"data-pipelines","readme_excerpt":"This dbt repo is setup to house macros of snowflake object management with dbt. Macros use a combination of snowflake put operations and stages to use local file data to create objects, with file paths set as environment variables. It contains the following macros, with example data formats in the ./snowflake folder. These macros can be installed in a current dbt project with a few lines of setup in your project files: --- create users This macro helps with the creation and management of snowflake users. Any new users that are in the users file will be created and existing will be altered. It is non-destructive and will only disable users with the disabled flag. In order to not version control / store passwords in plain text, you should also pass in the variable password which can be passed to your end users, and default to force change upon their first login. Use the included convenience script download snowflake users.py to download any existing users and setup ./snowflake/users/users.yml which you may add any new users and their attributes to. command line and file parameters ##### command line ##### file parameters - name - the username for the user - attributes - array of properties as defined in the Snowflake Documentation - roles - list of roles to grant to the user create network policies This macro helps with management of IP network policies - it will create or alter exising IP addresses with the ones provided in the corresponding files. If adding new IPs it is reco","default_branch":null,"files":null,"tree":[],"storefront":"/r/SpotOnInc","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/SpotOnInc/dbt_object_mgmt/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}