Objects available via data sharing
Here's a breakdown of the different tables you can access through Sifflet's Data Sharing feature:
| Table Name | Description | Key Information |
|---|---|---|
| ALERTING_HOOK | All alerting hooks (alerting channels) | Alerting type (service), Destinations, |
| ASSET | Details on cataloged assets (tables, views, etc.) | Asset Name & Type, Datasource ID, Health Status... |
| ASSET_CUSTOM_METADATA_ENTRY | Relationship between asset and custom metadata that have been assigned to them | Asset & Custom metadata IDs |
| ASSET_DATA_PRODUCT | Relationship between data products and assets that are included in them | Asset & Data product IDs |
| ASSET_FIELD | Fields (columns) of all cataloged assets | Asset IDs, Column names... |
| ASSET_USAGE | Details on the usage of cataloged assets (computed from ingested metadata) | Asset ID, times and asset has been accessed/read... |
| ASSET_USAGE_PER_DATASOURCE_USER | Details of users' usage of the cataloged assets (usage at the user level) | User Name, Asset Access... |
| AS_CODE_WORKSPACE | All workspaces managing monitors as code | Creation & modification dates, is UI editing allows... |
| AUDIT_LOG | Detailed information on the actions done on the platform | Authentication & Action information |
| CHART | List of intermediate BI objects | Datasource & Asset ID, Title, Chart Type... |
| COLLECTION | List of intermediate BI objects | Collection Name, Type... |
| CUSTOM_METADATA | List of all custom metadata created in Sifflet | Creation information, authorized asset types... |
| CUSTOM_METADATA_ENTRY | Values allowed for each custom metadata | Type (label, user, string), values... |
| DAG | Catalogued dags | Dashboard & Datasource ID, Type, Source tags, Health Status... |
| DAG_CUSTOM_METDATA_ENTRY | Relationship between dags and custom metadata that have been assigned to them | Dag & Custom metadata IDs |
| DASHBOARD | Cataloged dashboards | Dashboard & Datasource ID, Type, Health Status... |
| DASHBOARD_CUSTOM_METADATA_ENTRY | Relationship between dashboards and custom metadata that have been assigned to them | Dashboard & Custom metadata IDs |
| DATASOURCE | All sources (native and declarative) | Creation time, Creator, Technology... |
| DATASOURCE_RUN | Full history of source runs (metadata ingestion) | Execution End, Last Status, Created By... |
| DATA_PRODUCT | All data product declared in the tenant | Name, Description, Asset inputs, Collaboration tools, SLA... |
| DATA_PRODUCT_ALERTING_HOOK | Relationship between data product and alerting hook that have been applied to them (default alerting) | Data product & Alerting Hook IDs |
| DATA_PRODUCT_DOMAIN | Relationship between data product and domain where they have been created | Data product & Domain IDs |
| DATA_PRODUCT_TAG | Relationship between data product and tags that have been applied | Data product & Tag IDs |
| DATA_PRODUCT_USER | Relationship between data product and users declared as owners | Data product & User IDs |
| DOMAIN | All domains on the tenant | Domain Name, ID, creation time... |
| INCIDENT | Incidents automatically triggered or manually created in Sifflet | Criticality, Creation time, Closure information, Impact... |
| INCIDENT_COMMENT | Relationship between incident and comments added | Incident & Comment IDs |
| INTEGRATION | All integration (native and declarative) | Creation time, Creator, Technology... |
| LINEAGE | Edges of the lineage | Downstream & Upstream IDs of a given lineage node |
| MONITOR | Details on monitors, including parameters | Monitor Names, Parameters, Criticality... |
| MONITOR_CUSTOM_METADATA_ENTRY | Relationship between monitors and custom metadata that have been assigned to them | Monitor & Custom metadata IDs |
| MONITOR_RUN | Full history of monitor executions | Monitor ID, corresponding Incident ID, time at which a monitor run, status... |
| RELATIONSHIP_ALERTING_HOOK_MONITOR | Relationship between monitors and alerting hooks that are applied | Monitors & Alerting hook IDs |
| RELATIONSHIP_ASSET_DOMAIN | Relationship between assets and assets that are included | Asset & Domain IDs |
| RELATIONSHIP_ASSET_FIELD_TAG | Relationship between fields of cataloged assets and the tags that have been assigned to them | Asset & Tag IDs |
| RELATIONSHIP_ASSET_MONITOR | Relationship between monitors and assets (tables, views) on which they are applied | Asset & Monitor ID |
| RELATIONSHIP_ASSET_TAG | Relationship between assets and the tags that have been assigned to them | Asset ID & Tag ID |
| RELATIONSHIP_DATASOURCE_TAG | Relationship between sources and the tags that have been assigned to them | Datasource & Tag ID |
| RELATIONSHIP_DOMAIN_USER | Relationship between users and domains + permissions on the domain | Domain & User ID, User Roles... |
| RELATIONSHIP_INCIDENT_MONITOR | Relationship between incidents and the corresponding monitors | Monitor & Incident IDs |
| RELATIONSHIP_INCIDENT_USER | Relationship between incidents and the users who have worked on them | Incident & User IDs |
| RELATIONSHIP_MONITOR_TAG | Relationship between monitors and the tags that have been assigned to them | Monitor & Tag ID |
| TAG | List of all tags and terms (attached to Sifflet or imported from a source) | Name, Creator, Time of Creation... |
| TRANSFORMATION | Detailed transformation catalogued | Name, Time of creation / modification / run, run information... |
| TRANSFORMATION_CUSTOM_METADATA_ENTRY | Relationship between transformations and custom metadata applied on | Transformation & Custom metadata IDs |
| USER | Details on users of the Sifflet tenant | Creation times, roles, last login... |
Updated 10 days ago