Proof that Less can be More

Proof that Less can be More

Snowflake Data Warehouse release 2.11 (September 7, 2017) included the addition of an OVERWRITE parameter for the INSERT command. INSERT OVERWRITE effectively consolidates two commands, TRUNCATE TABLE and INSERT, into one. INSERT OVERWRITE also deletes the file load history and retains access control privileges on the target table; both of which are not insignificant details. […]

Read More
Joining it all up

Joining It All Up

When I start a new ETL project I often find it useful to have some idea how the source tables relate to each other. If I’m lucky there is documentation to guide me or even a diagram showing me how the tables link up (I do dream a lot). Of course, I could pull the […]

Read More
GAOUG

GaOUG Tech Days Session

GaOUG Tech Days is just around the corner: May 9-10 to be exact. We have an incredible venue in Downtown Atlanta called the Loudermilk Center with exceptional event space throughout. We have a great collection of national speakers from the Oracle Community, so the locals in Atlanta can get a feel for larger, more national conferences […]

Read More

Which Version Was It Again?

Recently I had to verify the version of an OBIEE installation for a client. As I was already ssh-ed into the Linux machine, I figured there was a way to determine the version without having to log into the presentation server. Turns out, I was right, but for thoroughness sake, I’ll cover both approaches. Using […]

Read More
Page 1 of 612345...Last »