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. […]
Proof that Less can be More Read More »
Red Pill Analytics Tips, Snowflake, TipsFall 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.
To San Fran We Go! Read More »
Events, Red Pill Analytics Tips, Red Pill NewsOracle Data Integrator Cloud Service is a new-ish cloud service from Oracle that allows us to run ODI as a platform in the Oracle Cloud. There are a lot of moving parts to this cloud service, so the first part of this article will cover creating the Oracle Cloud Database, The Java Cloud Service, and
Installing Oracle Data integrator Cloud Service (ODICS) Read More »
Cloud, ODI, Red Pill Analytics Tips, TipsFor those of you in the Oracle Business Intelligence space, you have likely heard us or some one else talk about Checkmate in the past. We have several posts on our blog about Checkmate, as well as a YouTube playlist dedicated to it, so I won’t spend too much time in this article evangelizing it.
Checkmate for OBI is Now Free Read More »
Checkmate, OBIEE, Red Pill Analytics Tips, Red Pill NewsLet’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
Finding an Open Slip Read More »
OBIEE, Red Pill Analytics Tips, TipsWe 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. You spend all of this time and effort putting together an analysis to share with your users. But wait! Are your users able
Are You Getting Your Point Across? Read More »
Data Visualization, Oracle DV, Red Pill Analytics Tips, TipsWe 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
Duplicated Rows No More Read More »
Red Pill Analytics Tips, TipsWhether you are using Excel as a data source for your Business Intelligence (BI) platform, or you are doing the actual analysis within Excel, your data will need to be in a format that is queryable. Often though, the data is formatted to be read visually, whether an export from a system, or manually entered.
Preparing Excel Data For Analysis Read More »
Big Data, Business Intelligence, Excel, Red Pill Analytics Tips, Tips, VBA