Skip to main content
Version: Next
IBM Netezza Performance Server

IBM Netezza Performance Server

https://www.ibm.com/products/netezza
IBM Netezza Performance Server is a data warehouse appliance.
Installation
Required packages: nzalchemy
Connection String
netezza+nzpy://{username}:{password}@{hostname}:{port}/{database}
Default port: 5480
Supported Features
JOINsSubqueriesDynamic SchemaCatalog SupportDynamic CatalogSSH TunnelingQuery CancellationFile UploadUser ImpersonationCost EstimationSQL Validation
Feature Score: 28/201
Time Grains
Common Time Grains:
SECONDMINUTEHOURDAYWEEKMONTHQUARTERYEAR
Extended Time Grains:
FIVE_SECONDSTHIRTY_SECONDSFIVE_MINUTESTEN_MINUTESFIFTEEN_MINUTESTHIRTY_MINUTESHALF_HOURSIX_HOURSWEEK_STARTING_SUNDAYWEEK_STARTING_MONDAYWEEK_ENDING_SATURDAYWEEK_ENDING_SUNDAYQUARTER_YEAR
Help improve this documentation by editing the engine spec: