WHITE PAPER BEST PRACTICES FOR OPTIMIZING YOUR DBT AND SNOWFLAKE DEPLOYMENTWHITE PAPER 2 I n tr oduction 3 W ha t I s S no wflak e ? 3 Snowflake architecture 3 Benefits of using Snowflake 4 W ha t I s db t? 5 dbt Cloud 5 C ust omer U se Case 6 O p timizing S no wflak e 6 Automated resource optimization for dbt query tuning 8 - Automatic clustering 8 - Materialized views 8 - Query acceleration services 9 Resource management and monitoring 10 - Auto-suspend policies 10 - Resource monitors 11 - Naming conventions 12 Role-based access control (RBAC) 13 - Monitoring 13 - Monitoring credit usage 15 - Monitoring storage usage 15 Individual dbt workload elasticity 17

Join for free to read