👋 my old coworker and ongoing friend @joemirizio.bsky.social!!
Story about Joe. Back in .. 2019 I think? I was crazy about this new data transformation tool dbt. But we were using Netezza and there wasn’t an adapter.
One day he said he had a present for me.
The present: github.com/chop-analyti...
Story about Joe. Back in .. 2019 I think? I was crazy about this new data transformation tool dbt. But we were using Netezza and there wasn’t an adapter.
One day he said he had a present for me.
The present: github.com/chop-analyti...
GitHub - chop-analytics/dbt-netezza: Netezza dbt database adapter
Netezza dbt database adapter. Contribute to chop-analytics/dbt-netezza development by creating an account on GitHub.
github.com
November 5, 2024 at 1:30 PM
👋 my old coworker and ongoing friend @joemirizio.bsky.social!!
Story about Joe. Back in .. 2019 I think? I was crazy about this new data transformation tool dbt. But we were using Netezza and there wasn’t an adapter.
One day he said he had a present for me.
The present: github.com/chop-analyti...
Story about Joe. Back in .. 2019 I think? I was crazy about this new data transformation tool dbt. But we were using Netezza and there wasn’t an adapter.
One day he said he had a present for me.
The present: github.com/chop-analyti...
How many folks remember, or even worked with ParAccel, Aster Data, Truviso, Greenplum, Netezza?
November 19, 2024 at 5:16 PM
How many folks remember, or even worked with ParAccel, Aster Data, Truviso, Greenplum, Netezza?
Love all the new people talking about "Postgres compatible" data warehouses vs. actually making Postgres a data warehouse.
Turns out Postgres is not new for those workloads, years ago:
Green plum
Asterdata
Netezza
ParAccel (RedShift)
Turns out Postgres is not new for those workloads, years ago:
Green plum
Asterdata
Netezza
ParAccel (RedShift)
November 5, 2024 at 4:51 PM
Love all the new people talking about "Postgres compatible" data warehouses vs. actually making Postgres a data warehouse.
Turns out Postgres is not new for those workloads, years ago:
Green plum
Asterdata
Netezza
ParAccel (RedShift)
Turns out Postgres is not new for those workloads, years ago:
Green plum
Asterdata
Netezza
ParAccel (RedShift)
🤯
Netezza and Sql server have supported R execution inside of their platforms for a while, though the implementation on the Netezza side was annoying enough that we never used it.
Love to see it!
Netezza and Sql server have supported R execution inside of their platforms for a while, though the implementation on the Netezza side was annoying enough that we never used it.
Love to see it!
November 1, 2024 at 2:30 PM
🤯
Netezza and Sql server have supported R execution inside of their platforms for a while, though the implementation on the Netezza side was annoying enough that we never used it.
Love to see it!
Netezza and Sql server have supported R execution inside of their platforms for a while, though the implementation on the Netezza side was annoying enough that we never used it.
Love to see it!
Netezza and DB2 in the multikill tier
June 28, 2025 at 11:30 PM
Netezza and DB2 in the multikill tier
Is it just the naming that bothers you? For more than a decade we did this as an ELT pattern on Netezza as landing, staging, base, where base was the final Inmon/Kimball model.
November 23, 2024 at 6:41 PM
Is it just the naming that bothers you? For more than a decade we did this as an ELT pattern on Netezza as landing, staging, base, where base was the final Inmon/Kimball model.
IBM is acquiring DataStax (Apache Casandra) and congratulations to those folks. I don’t know how it will go but I’m reminded that IBM acquired Informix and Netezza too. 🤷♂️
#databs
#databs
IBM Plans to Acquire DataStax: A New Chapter for Apache Cassandra® | DataStax
With IBM’s planned acquisition of DataStax, we’re entering a new chapter that promises even more innovation and investment in Cassandra’s future.
www.datastax.com
February 25, 2025 at 7:18 PM
IBM is acquiring DataStax (Apache Casandra) and congratulations to those folks. I don’t know how it will go but I’m reminded that IBM acquired Informix and Netezza too. 🤷♂️
#databs
#databs
We’re excited to announce the 2025.03.0 update to Posit Professional Drivers, a set of ODBC connectors for popular databases!
This update delivers expanded platform support (featuring Ubuntu 24.04), enhanced database reliability, and more.
Read the post: posit.co/blog/pro-dri...
#RStats #Python
This update delivers expanded platform support (featuring Ubuntu 24.04), enhanced database reliability, and more.
Read the post: posit.co/blog/pro-dri...
#RStats #Python
March 21, 2025 at 2:32 PM
We’re excited to announce the 2025.03.0 update to Posit Professional Drivers, a set of ODBC connectors for popular databases!
This update delivers expanded platform support (featuring Ubuntu 24.04), enhanced database reliability, and more.
Read the post: posit.co/blog/pro-dri...
#RStats #Python
This update delivers expanded platform support (featuring Ubuntu 24.04), enhanced database reliability, and more.
Read the post: posit.co/blog/pro-dri...
#RStats #Python
temp table usage was a common pattern even on platforms like Netezza and Redshift for ELT jobs
November 2, 2024 at 4:18 AM
temp table usage was a common pattern even on platforms like Netezza and Redshift for ELT jobs
Also Aginity had built in pivot tables. If @matsonj.com had only been a Netezza user and not a Sql Server junkie he would have been in love
December 10, 2024 at 1:21 AM
Also Aginity had built in pivot tables. If @matsonj.com had only been a Netezza user and not a Sql Server junkie he would have been in love
Work smart, play hard, and reunite your data.
#snowflake #databricks #oracle #ibm #db2 #bigquery #teradata #redshift #postgres #yellowbrick #mysql #synapse #vertica #greenplum #sqlserver #netezza
#snowflake #databricks #oracle #ibm #db2 #bigquery #teradata #redshift #postgres #yellowbrick #mysql #synapse #vertica #greenplum #sqlserver #netezza
July 19, 2025 at 4:11 PM
Work smart, play hard, and reunite your data.
#snowflake #databricks #oracle #ibm #db2 #bigquery #teradata #redshift #postgres #yellowbrick #mysql #synapse #vertica #greenplum #sqlserver #netezza
#snowflake #databricks #oracle #ibm #db2 #bigquery #teradata #redshift #postgres #yellowbrick #mysql #synapse #vertica #greenplum #sqlserver #netezza
We’re excited to announce the 2025.07.0 update to the Posit Professional Drivers, a set of #ODBC data connectors for some of the most popular databases.
They are free to use with other Posit professional products.
Read more: posit.co/blog/pro-dri...
They are free to use with other Posit professional products.
Read more: posit.co/blog/pro-dri...
August 22, 2025 at 2:27 PM
We’re excited to announce the 2025.07.0 update to the Posit Professional Drivers, a set of #ODBC data connectors for some of the most popular databases.
They are free to use with other Posit professional products.
Read more: posit.co/blog/pro-dri...
They are free to use with other Posit professional products.
Read more: posit.co/blog/pro-dri...
In addition to smaller acquisitions like Databand and older platforms like DB2, Netezza, Datastage, etc
December 8, 2025 at 7:31 PM
In addition to smaller acquisitions like Databand and older platforms like DB2, Netezza, Datastage, etc
I mean they got it on dbt’s website so presumably humans were involved
docs.getdbt.com/docs/core/co...
docs.getdbt.com/docs/core/co...
IBM Netezza setup | dbt Developer Hub
Read this guide to learn about the IBM Netezza setup in dbt.
docs.getdbt.com
June 4, 2025 at 12:45 AM
I mean they got it on dbt’s website so presumably humans were involved
docs.getdbt.com/docs/core/co...
docs.getdbt.com/docs/core/co...
Nothing is more important than family and joining data across all systems.
#snowflake #databricks #oracle #ibm #db2 #bigquery #teradata #redshift #postgres #yellowbrick #mysql #synapse #vertica #greenplum #sqlserver #netezza #aws #googlecloud #azurecloud #vmware #awscloud #cloud #sql #etl
#snowflake #databricks #oracle #ibm #db2 #bigquery #teradata #redshift #postgres #yellowbrick #mysql #synapse #vertica #greenplum #sqlserver #netezza #aws #googlecloud #azurecloud #vmware #awscloud #cloud #sql #etl
July 9, 2025 at 10:09 PM
Nothing is more important than family and joining data across all systems.
#snowflake #databricks #oracle #ibm #db2 #bigquery #teradata #redshift #postgres #yellowbrick #mysql #synapse #vertica #greenplum #sqlserver #netezza #aws #googlecloud #azurecloud #vmware #awscloud #cloud #sql #etl
#snowflake #databricks #oracle #ibm #db2 #bigquery #teradata #redshift #postgres #yellowbrick #mysql #synapse #vertica #greenplum #sqlserver #netezza #aws #googlecloud #azurecloud #vmware #awscloud #cloud #sql #etl
Nexus builds a visualization dashboard for every user on every system for every answer set.
#snowflake #databricks #oracle #ibm #db2 #bigquery #teradata #redshift #postgres #yellowbrick #mysql #synapse #vertica #greenplum #sqlserver #netezza #aws #googlecloud #azurecloud #vmware #awscloud #cloud
#snowflake #databricks #oracle #ibm #db2 #bigquery #teradata #redshift #postgres #yellowbrick #mysql #synapse #vertica #greenplum #sqlserver #netezza #aws #googlecloud #azurecloud #vmware #awscloud #cloud
July 24, 2025 at 4:11 PM
Nexus builds a visualization dashboard for every user on every system for every answer set.
#snowflake #databricks #oracle #ibm #db2 #bigquery #teradata #redshift #postgres #yellowbrick #mysql #synapse #vertica #greenplum #sqlserver #netezza #aws #googlecloud #azurecloud #vmware #awscloud #cloud
#snowflake #databricks #oracle #ibm #db2 #bigquery #teradata #redshift #postgres #yellowbrick #mysql #synapse #vertica #greenplum #sqlserver #netezza #aws #googlecloud #azurecloud #vmware #awscloud #cloud
A post I wrote on LinkedIn about data warehouse migrations.
Hope it's not too boring.
www.linkedin.com/posts/pascal...
Hope it's not too boring.
www.linkedin.com/posts/pascal...
Pascal Jacquemain on LinkedIn: I now have 2 experiences of the migration of a data warehouse.
One to...
I now have 2 experiences of the migration of a data warehouse.
One to Netezza that was done completely in-house.
One from Netezza (different company) that was…
www.linkedin.com
September 20, 2023 at 8:19 PM
A post I wrote on LinkedIn about data warehouse migrations.
Hope it's not too boring.
www.linkedin.com/posts/pascal...
Hope it's not too boring.
www.linkedin.com/posts/pascal...
Backstory: Some software engineers and data engineers (including me) wrote and maintained dbt-netezza starting way back on like 0.18 dbt (github.com/chop-analyti...).
The code is Apache 2.0 licensed, IBM tool ~all the adapter code and macros and moved it to github.com/IBM/nz-dbt.
The code is Apache 2.0 licensed, IBM tool ~all the adapter code and macros and moved it to github.com/IBM/nz-dbt.
June 4, 2025 at 12:30 AM
Backstory: Some software engineers and data engineers (including me) wrote and maintained dbt-netezza starting way back on like 0.18 dbt (github.com/chop-analyti...).
The code is Apache 2.0 licensed, IBM tool ~all the adapter code and macros and moved it to github.com/IBM/nz-dbt.
The code is Apache 2.0 licensed, IBM tool ~all the adapter code and macros and moved it to github.com/IBM/nz-dbt.
Indeed...
Sometimes, updates cause problems.
A company I worked for suffered from such an update and decided as a result never to update their Netezza box, leaving us with a version IBM would not support.
Sometimes, updates cause problems.
A company I worked for suffered from such an update and decided as a result never to update their Netezza box, leaving us with a version IBM would not support.
October 13, 2023 at 7:33 AM
Indeed...
Sometimes, updates cause problems.
A company I worked for suffered from such an update and decided as a result never to update their Netezza box, leaving us with a version IBM would not support.
Sometimes, updates cause problems.
A company I worked for suffered from such an update and decided as a result never to update their Netezza box, leaving us with a version IBM would not support.
* the classic @foundinblank.io piece: www.netlify.com/blog/2021/08...
I modeled a lot of principles of my last team’s migration from Informatica —> dbt and Netezza —> Snowflake on this, though we were doing 2 migrations at once so some breaking changes which complicated things
I modeled a lot of principles of my last team’s migration from Informatica —> dbt and Netezza —> Snowflake on this, though we were doing 2 migrations at once so some breaking changes which complicated things
How the Netlify Data Team Migrated from Databricks to Snowflake
Case study: How Netlify migrated their data pipelines, 500 dbt models, and reports & dashboards from Databricks to Snowflake
www.netlify.com
November 7, 2024 at 2:12 AM
* the classic @foundinblank.io piece: www.netlify.com/blog/2021/08...
I modeled a lot of principles of my last team’s migration from Informatica —> dbt and Netezza —> Snowflake on this, though we were doing 2 migrations at once so some breaking changes which complicated things
I modeled a lot of principles of my last team’s migration from Informatica —> dbt and Netezza —> Snowflake on this, though we were doing 2 migrations at once so some breaking changes which complicated things
Orbital reminds me that a decade ago we had databases touting PMML support to let you run ML models in the database via SQL. IBM Netezza even let you run R packages directly in the database via NZR.
Orbital is cool but it does make me wonder about forward progress in our industry. #databs
Orbital is cool but it does make me wonder about forward progress in our industry. #databs
At posit::conf, we introduced the orbital package, allowing you to seamlessly translate tidymodels workflows into SQL backends.
By leveraging the speed + power of your database, like Snowflake, you can perform faster, scalable predictions without needing R dependencies.
🔗 posit.co/blog/running...
By leveraging the speed + power of your database, like Snowflake, you can perform faster, scalable predictions without needing R dependencies.
🔗 posit.co/blog/running...
July 22, 2025 at 6:25 PM
Orbital reminds me that a decade ago we had databases touting PMML support to let you run ML models in the database via SQL. IBM Netezza even let you run R packages directly in the database via NZR.
Orbital is cool but it does make me wonder about forward progress in our industry. #databs
Orbital is cool but it does make me wonder about forward progress in our industry. #databs
Watch a 20-table join from 20 different systems in a single query.
#snowflake #databricks #oracle #ibm #db2 #bigquery #teradata #redshift #postgres #yellowbrick #mysql #synapse #vertica #greenplum #sqlserver #netezza
#snowflake #databricks #oracle #ibm #db2 #bigquery #teradata #redshift #postgres #yellowbrick #mysql #synapse #vertica #greenplum #sqlserver #netezza
August 11, 2025 at 11:14 AM
Watch a 20-table join from 20 different systems in a single query.
#snowflake #databricks #oracle #ibm #db2 #bigquery #teradata #redshift #postgres #yellowbrick #mysql #synapse #vertica #greenplum #sqlserver #netezza
#snowflake #databricks #oracle #ibm #db2 #bigquery #teradata #redshift #postgres #yellowbrick #mysql #synapse #vertica #greenplum #sqlserver #netezza
Watch a 20-table join from 20 different systems in a single query.
#snowflake #databricks #oracle #ibm #db2 #bigquery #teradata #redshift #postgres #yellowbrick #mysql #synapse #vertica #greenplum #sqlserver #netezza
#snowflake #databricks #oracle #ibm #db2 #bigquery #teradata #redshift #postgres #yellowbrick #mysql #synapse #vertica #greenplum #sqlserver #netezza
August 18, 2025 at 11:14 AM
Watch a 20-table join from 20 different systems in a single query.
#snowflake #databricks #oracle #ibm #db2 #bigquery #teradata #redshift #postgres #yellowbrick #mysql #synapse #vertica #greenplum #sqlserver #netezza
#snowflake #databricks #oracle #ibm #db2 #bigquery #teradata #redshift #postgres #yellowbrick #mysql #synapse #vertica #greenplum #sqlserver #netezza
Nexus builds a visualization dashboard for every user on every system for every answer set.
#snowflake #databricks #oracle #ibm #db2 #bigquery #teradata #redshift #postgres #yellowbrick #mysql #synapse #vertica #greenplum #sqlserver #netezza #aws #googlecloud #azurecloud #vmware
#snowflake #databricks #oracle #ibm #db2 #bigquery #teradata #redshift #postgres #yellowbrick #mysql #synapse #vertica #greenplum #sqlserver #netezza #aws #googlecloud #azurecloud #vmware
September 29, 2025 at 4:11 PM
Nexus builds a visualization dashboard for every user on every system for every answer set.
#snowflake #databricks #oracle #ibm #db2 #bigquery #teradata #redshift #postgres #yellowbrick #mysql #synapse #vertica #greenplum #sqlserver #netezza #aws #googlecloud #azurecloud #vmware
#snowflake #databricks #oracle #ibm #db2 #bigquery #teradata #redshift #postgres #yellowbrick #mysql #synapse #vertica #greenplum #sqlserver #netezza #aws #googlecloud #azurecloud #vmware
Watch a 20-table join from 20 different systems in a single query.
#snowflake #databricks #oracle #ibm #db2 #bigquery #teradata #redshift #postgres #yellowbrick #mysql #synapse #vertica #greenplum #sqlserver #netezza
#snowflake #databricks #oracle #ibm #db2 #bigquery #teradata #redshift #postgres #yellowbrick #mysql #synapse #vertica #greenplum #sqlserver #netezza
August 4, 2025 at 11:13 AM
Watch a 20-table join from 20 different systems in a single query.
#snowflake #databricks #oracle #ibm #db2 #bigquery #teradata #redshift #postgres #yellowbrick #mysql #synapse #vertica #greenplum #sqlserver #netezza
#snowflake #databricks #oracle #ibm #db2 #bigquery #teradata #redshift #postgres #yellowbrick #mysql #synapse #vertica #greenplum #sqlserver #netezza