This section shows the available API objects and provides more information on executing SQL to Google Data Catalog APIs.
- The cmdlet models Google Data Catalog entities like Documents, Folders, and Groups as relational views, allowing you to write SQL to query Google Data Catalog data.
- Stored procedures allow you to execute operations to Google Data Catalog
- Live connectivity to these objects means any changes to your Google Data Catalog account are immediately reflected when using the cmdlet.
Views describes the available views. Views are statically defined to model read-only entities such as Schemas, Tables, and TagTemplates.
Stored Procedures are function-like interfaces to Google Data Catalog. Stored procedures allow you to execute operations to Google Data Catalog, including downloading documents and moving envelopes.
Collaborative Query Processing
The cmdlet offloads as much of the SELECT statement processing as possible to Google Data Catalog and then processes the rest of the query in memory. API limitations and requirements are also documented in this section.
See SupportEnhancedSQL for more information on how the cmdlet circumvents API limitations with in-memory client-side processing.