March 26, 2020

|

by: Renee Miller

|

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

COVID-19 has created an anxiety-ridden week. With the chaos of preparing to quarantine over (hopefully), what’s next? If you’re looking for a way to be productive at home, we have an answer - we’ve taken our canceled and postponed live events and converted them to online educational opportunities. With a worldwide pandemic at our heels, [...]

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

March 22, 2017

|

by: Phil Goerdt

|

Categories: OBIEE, Red Pill Analytics' Tips, Tips

Let’s pretend that you need to change ports within your OBIEE 12c instance due to new applications that natively install into ports that OBIEE is running. Or maybe you want to have the ports be the same as the OBIEE 11g ports. Whatever the reason, how do we go about changing the ports within the […]

January 24, 2017

|

by: Fahd Saeed

|

Categories: Red Pill Analytics' Tips, Tips

We all get by with a little help from our friends. Let us share a tech tip with you and offer you an opportunity to learn more from the Red Pill Analytics team. I came across a table with some troublesome duplicated rows and wanted to remove these dups so I used an old query of […]