Tera-Tom

@TomCoffing@mastodon.cloud
0 Followers
6 Following
32 Posts

It is not easy to search for where columns exist in one system, but now you can see every table and view where they exist across every system in your enterprise. And the system's tree comes alive!

#snowflake #databricks #db2 #teradata #oracle #bigquery #ibm #sqlserver #synapse #postgres #vertica #greenplum #redshift #aws #googlecloud #awscloud #azurecloud #cloud #sql #etl #postgres #yellowbrick #mysql #vmware #netezza

Not only can you join data across databases, but you can join it across clouds! The sky is no longer the limit.

#snowflake #databricks #db2 #teradata #oracle #bigquery #ibm #sqlserver #synapse #postgres #vertica #greenplum #redshift #aws #googlecloud #awscloud #azurecloud #cloud #sql #etl #postgres #yellowbrick #mysql #vmware #netezza

ROW_NUMBER seems like a silly analytic, but it is one of my favorites because of the absolute power it brings me. They say absolute power corrupts, but the ROW_NUMBER erupts, absolutely!

https://coffingdw.com/row_number-analytic-across-all-databases/

#snowflake #databricks #db2 #teradata #oracle #bigquery #ibm #sqlserver #synapse #postgres #vertica #greenplum #redshift #aws #googlecloud #awscloud #azurecloud #cloud #sql #etl #postgres #yellowbrick #mysql #vmware #netezza

If you are drowning in data and must migrate thousands of tables, just breathe! Help! Someone throw them a Nexus.

#teradata #oracle #snowflake #aws #googlecloud #awscloud #azurecloud #cloud #redshift #sql #etl #postgres #yellowbrick #mysql #ibm #db2 #synapse #vertica #greenplum #vmware #sqlserver #netezza #bigquery #databricks #netezza

×

Ordered Analytics and Window functions can be confusing, but not anymore. Master them today and thank me forever! Here are examples of all the analytic functions on all systems, with easy-to-understand examples.

https://coffingdw.com/analytic-and-window-functions-for-all-systems-over-100-blogs/

#teradata #oracle #snowflake #aws #googlecloud #awscloud #azurecloud #cloud #redshift #sql #etl #postgres #yellowbrick #mysql #ibm #db2 #synapse #vertica #greenplum #vmware #sqlserver #netezza #bigquery #databricks #netezza