Stream All Tables - BlinkOps Documentation

Stream all tables, including metadata and Cyera findings. Required Permissions:

cyera.read.datastore
cyera.read.table
cyera.read.classification

Note: To view the output of this action, first create a working directory using the Create Working Directory action. Then, use the Save Output To File feature, and finally retrieve the results with the Get File Content action.

External DocumentationTo learn more, visit the Cyera documentation.

Basic Parameters

Parameter	Description
Infrastructure	A comma-separated list of infrastructures to filter tables by.
Provider	Filter tables by their provider.
Table Sensitivity	A comma-separated list of table sensitivity levels to filter tables by.

Advanced Parameters

Parameter	Description
Column Classification Geo Locations	A comma-separated list of column classification geo locations to filter tables by.
Column Classification Identifiability	Select a column classification identifiability to filter tables by.
Column Classification Is Identifiable	Select to only retrieve tables whose their columns have identifiable classifications.
Column Classification Is Synthetic	Select to only retrieve tables whose their columns have synthetic classifications.
Column Classification Tokenization	A comma-separated list of column classification tokenization to filter tables by.
Column Classification Uids	A comma-separated list of column classification UIDs to filter tables by.
Column Classifications	Select to only retrieve tables whose their columns have classifications.
Datastore UIDs	A comma-separated list of datastore UIDs to filter tables by.
Latest Scan After	Retrieve tables whose latest data scan occurred on or after the specified timestamp.
Latest Scan Before	Retrieve tables whose latest data scan occurred on or before the specified timestamp.
Table Classification UIDs	A comma-separated list of table classification UIDs to filter tables by.
Table Level Classifications	Select to only retrieve tables with table level classifications.
Table Sensitivity Display Name	A comma-separated list of table sensitivity display names to filter tables by.

Example Output

{
	"uid": "43cc6fc7-96ea-4f50-837b-5v8b0ecbl593",
	"name": "Servicing.DataWarehouse_History",
	"rowCount": 12467730,
	"sensitiveRecordsCount": 163661377,
	"creationDate": "2022-11-05T12:51:08.000Z",
	"tableLevelClassifications": [
		{
			"dataClassName": "Full Name",
			"classificationName": "Client Full Name, Brazil",
			"dataCategory": "Personal",
			"collections": [
				"Learned",
				"File"
			],
			"customCollections": [
				"Custom 1",
				"Custom 2"
			],
			"uid": "d0d033c7-5cca-48d2-a270-f6848443f4a6",
			"sensitivity": "VerySensitive",
			"sensitivityDisplayName": "Top Secret",
			"defaultSensitivity": "VerySensitive",
			"defaultSensitivityDisplayName": "Top Secret",
			"context": {
				"role": "Customer",
				"tokenization": "Dynamically-Masked",
				"geoLocations": [
					"EU",
					"California",
					"Brazil"
				],
				"synthetic": true,
				"dataSubjectAge": "13-15",
				"businessContext": [
					{
						"key": "string",
						"value": "string"
					}
				],
				"identified": true,
				"identifiability": "Identifier"
			},
			"frameworks": [
				"GDPR - Personal",
				"Reportable Data Breach"
			],
			"learned": true,
			"classificationLevel": "Object"
		}
	],
	"sensitivity": "VerySensitive",
	"sensitivityDisplayName": "Top Secret",
	"dbName": "Company_Data_Warehouse",
	"schemaName": "db_schema",
	"columns": [
		{
			"uid": "484a9586-e968-4ca7-b443-7ff4a0e877de",
			"name": "full name",
			"classifications": [
				{
					"dataCategory": "Personal",
					"collections": [
						"Learned",
						"File"
					],
					"customCollections": [
						"Custom 1",
						"Custom 2"
					],
					"uid": "2990c454d9eb4b098d5777db6807676ffc4eb48088dd9f7e8d4847a5a49f50bc",
					"name": "Client Full Name, Brazil",
					"dataClassName": "Full Name",
					"sensitivity": "VerySensitive",
					"recordsCount": 20,
					"context": {
						"role": "Customer",
						"tokenization": "Dynamically-Masked",
						"geoLocations": [
							"EU",
							"California",
							"Brazil"
						],
						"synthetic": true,
						"dataSubjectAge": "13-15",
						"businessContext": [
							{
								"key": "string",
								"value": "string"
							}
						],
						"identified": true,
						"identifiability": "Identifier"
					},
					"...": "[Additional Properties Truncated]"
				}
			],
			"recordsCount": 25
		}
	],
	"lastModifiedTime": "2022-11-05T12:51:08.000Z",
	"datastoreUid": "379661c3-ad91-4691-ab58-8704ff5f6a9e",
	"datastoreName": "users-bucket",
	"datastoreProvider": "AWS",
	"datastoreInfrastructure": "rds",
	"datastoreEngine": "s3",
	"cloudAccountIdentifier": "012345678901"
}

Workflow Library Example

Stream All Tables with Cyera and Send Results Via Email

Preview this Workflow on desktop

​Basic Parameters

​Advanced Parameters

​Example Output

​Workflow Library Example

Basic Parameters

Advanced Parameters

Example Output

Workflow Library Example