Tags

Authors

Stewart Bryson
Emily Carlsen
Mike Fuller
Renee Miller
Lauren Prezby
Greg Suk

Managing Snowflake Data Warehouse Compute in OBIEE

December 10, 2018

|

by: Mike Fuller

|

Categories: Analytics, Data, OBIEE, Snowflake

How to dynamically set a Snowflake virtual warehouse Congratulations! You just configured Oracle Business Intelligence Enterprise Edition (OBIEE) to connect to your freshly loaded Snowflake Data Warehouseinstance and you’re feeling pretty good. Maybe your OBIEE dashboards are finally meeting SLAs, you’re not sitting with a DBA trying to tune SQL statements, your data is finally all in one […]

Snowflake Data Warehouse and AWS Lambda

November 12, 2018

|

by: Mike Fuller

|

Categories: AWS, Snowflake, Snowflake Computing

Serverless computing is here to stay, and while the term “serverless” is a bit of a misnomer, the concept offers many benefits. Most notably, serverless computing allows developers to focus on writing code and not concern themselves with provisioning, configuring, or maintaining servers. One such example of serverless computing is AWS Lambda. Although there are [...]

Proof that Less can be More

October 11, 2017

|

by: Mike Fuller

|

Categories: Red Pill Analytics' Tips, Snowflake, Tips

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

Big Data Tundra: Creating a Flexible Cloud Based Data Ecosystem

June 12, 2017

|

by: Lauren Prezby

|

Categories: Big Data, Cloud, Events, Snowflake

Big Data Tundra: Creating a Flexible Cloud Based Data Ecosystem

Did you miss Phil Goerdt and Mike Fuller‘s presentation about Cloud computing and storing data at MinneAnalytics #BIgDataTech last week? Let us share their presentation with you! Download it here! Cloud computing has changed how organizations use, access and store their data. While these paradigms have shifted, the traditional way of thinking about databases and data warehouses remain steadfast in […]

Modules of Knowledge

September 30, 2016

|

by: pete.scott

|

Categories: Big Data, ODI, Snowflake

Modules of Knowledge

One of the features of Oracle Data Integrator that sets it apart from other data integration tools is the use of Knowledge Modules to define how parts of the data integration process occur. The developer creates a data load mapping from sources, joins, filters and targets (and in ODI 12 even more components are available). […]

Kicking with JSON in the Snow

September 29, 2016

|

by: Mike Fuller

|

Categories: OBIEE, Snowflake, SQL

Kicking with JSON in the Snow

Employees at the Minneapolis Red Pill Analytics office recently had the luxury of sitting with Snowflake’s Steve Herskovitz for some on-site education. Among other things, one of my key takeaways from the exercise was how simple it is to query JSON data in the Snowflake Data Warehouse. The syntax is straightforward and makes the process […]

Back to the Future: Time Traveling with Snowflake

August 31, 2016

|

by: Phil Goerdt

|

Categories: OBIEE, Snowflake

Back to the Future: Time Traveling with Snowflake

In my last post, I discussed Snowflake’s unique cloud offering, and how to get it connected to OBIEE. In this post, I’ll give a brief overview of what Snowflake’s Time Travel feature is, how to use it from a query perspective, and how to integrate this feature into OBIEE. [pexyoutube pex_attr_src=”https://www.youtube.com/watch?v=fCjsUxbNmIs”][/pexyoutube]Where We’re Going… We Don’t Need […]

0
0
without
https://redpillanalytics.com/wp-content/themes/vanguarda/
https://redpillanalytics.com/
#b63524
style1
paged
No more posts to load.
Load More Posts
Loading posts...
/home/redpil9/public_html/
#
on
none
loading
#
Sort Gallery
on
yes
yes
off
Newsletter Input text
off
off