The Data Warrior

Changing the world, one data model at a time. How can I help you?

Snowflake SQL: Making Schema-on-Read a Reality (Part 1) 

This is my 1st official post on the Snowflake blog in my new role as their Technical Evangelist. It discusses getting results from semi-structured JSON data using our extensions to ANSI SQL.

Schema? I don’t need no stinking schema!

Over the last several years, I have heard this phrase schema-on-read used to explain the benefit of loading semi-structured data into a Big Data platform like Hadoop. The idea being you could delay data modeling and schema design until long after the data was loaded (so as to not slow down getting your data while waiting for those darn data modelers).

Every time I heard it, I thought (and sometimes said) – “but that implies there is a knowable schema.”  So really you are just delaying the inevitable need to understand the structure in order to derive some business value from that data. Pay me now or pay me later.

Why delay the pain?

Check out the rest of the post here:

Snowflake SQL: Making Schema-on-Read a Reality (Part 1) – Snowflake

Enjoy!

Kent

The Data Warrior

Merry Christmas!

Blessings of the seasonfrom Kent GrazianoThe Data Warrior

Data Modeler 4.1.3 is OUT

New updated version of Oracle SQL Developer Data Modeler is available with some important fixes.

Helifromfinland's avatarHeliFromFinland

The development team has been busy! 4.1.3 is now out and plenty of bugs fixed.

http://www.oracle.com/technetwork/developer-tools/datamodeler/overview/index.html

Bugs fixed (from the download pages):

22350565String index out of bounds exception while importing structured type method bodies
22311829Table report generating duplicate FK columns
22350611Cannot select relationship/foreign key line
22339253Change request report does not generate data in the report
22187312Error when running design rules using Data Modeler version 4.1.2.895

View original post

Data Warrior Agenda for 2016

Hard to believe 2015 is almost over.

It was a very busy year for me:

All of that has entailed a lot of air miles! This year I have visited:

  1. Denver (several times!)
  2. Salida, Colorado
  3. Hollywood, Florida,
  4. Raleigh, NC
  5. Charlotte, NC (thanks to Lynn Winterboer for that one!)
  6. San Francisco
  7. Redwood City, California (Oracle HQ)
  8. Austin (drove this one)
  9. Minneapolis/ St Paul (thanks to Redpill Analytics mostly)
  10. Kansas City, Missouri
  11. Portland, Maine
  12. St Albans, Vermont
  13. Stowe, Vermont
  14. San Mateo, California (HQ for Snowflake Computing)

And that was just work related! Family trips took me to:

  1. Galveston (beach!)
  2. South Padre Island, TX (more beach!)
  3. Road trip to Central NY:
    1. Joplin, Missouri
    2. Hannibal, Missouri (Mark Twain museum)
    3. Chicago (to see robots at the Museum of Science and Industry)
    4. Sandusky, Ohio (just to sleep)
    5. Fulton, NY (to see my dad)
    6. Old Forge, NY (summer vacation in the mountains!)
    7. Huntsville, Alabama (NASA Rocket Center!)
  4. Who knows – the year is not over yet!

Speaking in 2016

2016 will be very busy with the new job for sure. I am already booked for a bunch of events. Here they are so far:

Data Day Texas – January 16 in Austin, TX

TDWI Webinar – Dymstyfying Elastic Data Warehousing (with Philip Russom) – January 26th

BIWA Summit – January 26-28 at Oracle HQ

RMOUG Training Days 2016 – Febuary 9-11 in Denver, CO (I have 2 hour deep dive on Feb 9th). Register early for discounts.

Enterprise Data World – April 17-22 in San Diego. Register early for discounts (by the end of the year for the best rate).

ODTUG KScope16 – June 26-30 in Chicago, IL. Register early and be sure to book the hotel!

Also likely speaking at World Wide Data Vault Consortium (WWDVC) – May 25-28 in Stowe, Vermont (TBD)

And many more to come! (watch my twitter feed for updates)

Hopefully I will see you at one or more of these events!

Wishing a safe a joyous holiday season!

Merry Christmas & Happy New Year!

Kent

The Data Warrior


 

Data Modeler 4.1.2.1.899 is out!

Attention all lovers of #SQLDevModler – there is a new version out with some major bug fixes. Get it today!

Thanks to Heli for posting this.

Helifromfinland's avatarHeliFromFinland

Data Modeler 4.1.2.1.899 is out with plenty of important bug fixes. Go and try!

http://www.oracle.com/technetwork/developer-tools/datamodeler/downloads/index.html

From the download pages:

Oracle SQL Developer Data Modeler 4.1.2.1: Bugs Fixed

Date: December 2015

This list contains only a selection of higher priority bugs, customer bugs and issues raised by the community on the OTN Forum since the release of version 4.1.2.

22109015Table structure not available in browser for versioned designs
22120662“Oracle errors to mask” tab is always disabled
22112910Table has columns with undefined security properties’ for xmltype column
22186607Constraint definition is missing in ddl when custom ddl script is used
22187312Error when running design rules using Data Modeler version 4.1.2.895

Cheers

Heli

View original post

Post Navigation