October 11, 2017

|

by: Mike Fuller

|

Categories: Red Pill Analytics' Tips, Snowflake, Tips

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. […]

September 15, 2017

|

by: Renee Miller

|

Categories: Events, Red Pill Analytics' Tips, Red Pill News

Fall is here and that means a trip to San Francisco is on the calendar for Red Pill Analytics. Once again, we are thrilled to be joining an amazing group of presenters at Oracle’s largest conference of the year, Oracle OpenWorld/JavaOne. Red Pill Analytics has six sessions, three at Oracle OpenWorld and three at JavaOne. […]

September 14, 2017

|

by: pete.scott

|

Categories: Oracle 12c, SQL, Tips

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 […]