> ## Documentation Index
> Fetch the complete documentation index at: https://docs.blinkops.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Stream All Tables

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](https://docs.blinkops.com/docs/workflows/building-workflows/actions/utility-actions/file_system-utilities#create-working-directory) action. Then, use the [Save Output To File](https://docs.blinkops.com/docs/workflows/building-workflows/steps#save-output-to-file) feature, and finally retrieve the results with the [Get File Content](https://docs.blinkops.com/docs/workflows/building-workflows/actions/utility-actions/file_system-utilities#get-file-content) action.

<Note>
  External Documentation

  To learn more, visit the [Cyera documentation](https://api.cyera.io/docs#tag/tables/get/v1/tables/stream).
</Note>

## Basic Parameters

<div className="integrations-table">
  | 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. |
</div>

## Advanced Parameters

<div className="integrations-table">
  | 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.        |
</div>

## Example Output

```json theme={"dark"}
{
	"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](https://library.blinkops.com/workflows/stream-all-tables-with-cyera-and-send-results-via-email)

<div className="iframe-wrapper">
  <div className="iframe-media">
    <img src="https://mintcdn.com/blinkops-2/ojHYuDeYX5FWuN8a/img/Icons/play-box.svg?fit=max&auto=format&n=ojHYuDeYX5FWuN8a&q=85&s=b8af968e71438a9499c3223c9bd29fb2" alt="Workflow Library" width="16" height="16" data-path="img/Icons/play-box.svg" />

    Preview this Workflow on desktop
  </div>

  <iframe className="iframe" src="https://library.blinkops.com/workflows/stream-all-tables-with-cyera-and-send-results-via-email/canvas" />
</div>