{"repo":"chop-analytics/dbt-netezza","free":true,"listed":false,"github":"https://github.com/chop-analytics/dbt-netezza","clone":"git clone https://github.com/chop-analytics/dbt-netezza.git","description":"Netezza dbt database adapter","language":"Python","stars":13,"topics":["dbt","netezza"],"license":"BSD-2-Clause","category":"data-pipelines","readme_excerpt":"dbt-netezza The dbt-netezza package contains all of the code required to make dbt operate on a Netezza database. For more information on using dbt, consult their docs. Netezza Configurations Code and documentation inspired by the redshift dbt plugin, as Netezza and Redshift share some common architectural patterns. Performance Optimizations Tables in Netezza have an optimization to improve query performance called distribution keys. Supplying these values as model-level configurations apply the corresponding settings in the generated CREATE TABLE DDL. Note that these settings will have no effect for models set to view or ephemeral models. - dist can take a setting of random , a single column as a string (e.g. visit key ), or a list of columns (e.g. ['visit key','visit event key'] ) Dist keys can be added to the {{ config(...) }} block for a specific model .sql file, e.g.: Dist keys can also be added to the dbt project.yml file config to set a default, e.g.","default_branch":null,"files":null,"tree":[],"storefront":"/r/chop-analytics","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/chop-analytics/dbt-netezza/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."}