Topic outline

• Getting Started with InterSystems IRIS Cloud Document

  Getting Started with InterSystems IRIS Cloud Document

  Content Type
  Video

  Duration
  10m

  Level
  Introductory

  See how InterSystems IRIS® Cloud Document simplifies document storage and querying by combining a flexible document model with access to SQL. Product Manager Stefan Wittmann shows how to set up a deployment of this cloud service, import data, run queries with SQL, and connect programmatically to integrate seamlessly with applications​.
• Code Used in This Video

  Code Used in This Video

  Reference	Timestamp	Code
  Query for the count of the collection	6:50	Begin code: SELECT COUNT(*) FROM JSON_TABLE(inspection FORMAT COLLECTION) End code,
  Query for contents of collection	7:30	Begin code: SELECT TOP 10 * FROM JSON_TABLE(inspection FORMAT COLLECTION, '$') End code,
  Query the collection with only certain columns	8:40	Begin code: SELECT TOP 10 * FROM JSON_TABLE(inspection FORMAT COLLECTION, '$' COLUMNS ( inspectionStartTime VARCHAR(100) PATH '$.inspectionStartTime', battery_pass VARCHAR(100) PATH '$.battery_pass', engine_pass VARCHAR(100) PATH '$.engine_pass' ) End code,
  Query the collection with only certain columns and only where battery inspection passed	10:00	Begin code: SELECT TOP 10 * FROM JSON_TABLE(inspection FORMAT COLLECTION, '$' COLUMNS ( inspectionStartTime VARCHAR(100) PATH '$.inspectionStartTime', battery_pass VARCHAR(100) PATH '$.battery_pass', engine_pass VARCHAR(100) PATH '$.engine_pass' ) WHERE battery_pass = 'yes' End code,
• What's Next?

  What's Next?
  • Explore how to connect to InterSystems Cloud Services via client languages (video, 3m).
  • Read more about InterSystems IRIS Cloud Document (documentation).