Entities
Certain classes of objects in Datagrok have a common set of operations and features applicable to them. We call these objects entities. Here they are:
- Function
- Function Call
- Data Pipeline
- Data Connection
- Data Query
- Data Job
- DB Table Info
- DB Column Info
- User
- Group
- Model
- Notebook
- Package
- Space
- Dashboard
- Repository
- Script
- Table (dataframe)
- View Layout
The following operations can be applied to any entity:
- Getting its URL
- Referencing it in a chat, in markup, or a dashboard
- Assigning privileges, such as rights to view, edit, or share, to a particular instance
- Using it as a parameter in the audit record
- Deleting it
Metadata
Any entity can be annotated with metadata, which you can use to search entities. In Datagrok, there are three kinds of metadata:
- Tags
- Parameters
- Properties
Tags
A tag is a short string that can be associated with any entity. Use it to
organize and group different entities. For example, a #chem tag could
be used with chemical scripts, molecular datasets, or chemical database queries.
To search for tagged entities, enter #tagname in the search box.
Parameters
Each entity can be associated with a list of key-value pairs.
To search for entities with the specified parameters, use the <paramName> <op> <value> syntax, where op is an operator like > !=.
For example:
imported < 10/02/2019rows > 200author = @current
Properties
Properties are similar to parameters, but unlike parameters, properties can include nested properties. Additionally, you can't edit them directly.
Some properties are universal across all entities. Others are specific to particular entity types. Common properties include:
- ID
- name
- author
- createdOn
- updatedOn
- commentedBy
- usedBy
- starredBy
Search
You can use metadata to search for entities
Entity search
Use the search bar on top to filter the content in the Browse tree. In addition to searching by name,
you can search by the entity's metadata,
like tags,
parameters, and
properties. For example, entering
#demo shows all entities tagged with #demo, and imported < 01/01/2024
shows all entities imported before that date.
To apply multiple filters, use AND and OR operators and parentheses.
Examples
Unstructured query; looks for 'biologics' in title and description:
Biologics
Tagged as #demo:
#demo
Tagged as either either #demo or #chem:
#demo or #chem
Created in the last 7 days:
createdOn > -1w
Complex conditions:
(#demo and #chem) or author = "john@google.com"
starredBy = @current or author = @current
Created by recently joined users:
author.joined > -5d
See also: